SQL Databases & Servers Courses

Windows and Exchange Server training throughout the UK, including Manchester, Leeds, Birmingham, York, Carlisle, Newcastle, Sheffield, Glasgow, Edinburgh, Aberdeen, Derby, Norwich, Portsmouth, Swansea, Cardiff, Chester.  For overseas training and contracts, please call to discuss your requirements.

Designing Business Intelligence Solutions with Microsoft SQL Server

After completing this course, students will be able to:

  • Plan the components of a BI solution.

  • Plan a BI infrastructure.

  • Design a data warehouse.

  • Design an ETL solution.

  • Plan analytical data models.

  • Plan a BI delivery solution.

  • Design a Reporting Services solution.

  • Design an Excel reporting solution.

  • Plan a SharePoint Server BI solution.

  • Monitor and optimize a BI solution.

  • Plan for BI operations.

Implementing Data Models and Reports with Microsoft SQL Server

After completing this course, students will be able to:

  • Describe the components, architecture, and nature of a BI solution.

  • Create a multidimensional database with Analysis Services.

  • Implement dimensions in a cube.

  • Implement measures and measure groups in a cube.

  • Use MDX Syntax.

  • Customize a cube.

  • Implement a Tabular Data Model in SQL Server Analysis Services.

  • Use DAX to enhance a tabular model.

  • Create reports with Reporting Services.

  • Enhance reports with charts and parameters.

  • Manage report execution and delivery.

  • Implement a dashboard in SharePoint Server with PerformancePoint Services.

  • Use Data Mining for Predictive Analysis.

Administering Microsoft SQL Server Databases

After completing this course, students will be able to:

  • Describe core database administration tasks and tools.

  • Install and configure SQL Server 2014.

  • Configure SQL Server databases and storage.

  • Plan and implement a backup strategy.

  • Restore databases from backups.

  • Import and export data.

  • Monitor SQL Server.

  • Trace SQL Server activity.

  • Manage SQL Server security.

  • Audit data access and encrypt data.

  • Perform ongoing database maintenance.

  • Automate SQL Server maintenance with SQL Server Agent Jobs.

  • Configure Database Mail, alerts and notifications.

Querying Microsoft SQL Servers

After completing this course, students will be able to:

  • Describe the basic architecture and concepts of Microsoft SQL Server 2014.

  • Understand the similarities and differences between Transact-SQL and other computer languages.

  • Write SELECT queries

  • Query multiple tables

  • Sort and filter data

  • Describe the use of data types in SQL Server

  • Modify data using Transact-SQL

  • Use built-in functions

  • Group and aggregate data

  • Use subqueries

  • Use table expressions

  • Use set operators

  • Use window ranking, offset and aggregate functions

  • Implement pivoting and grouping sets

  • Execute stored procedures

  • Program with T-SQL

  • Implement error handling

  • Implement transactions

Updating Your Skills to SQL Server 2017

After completing this course, students will be able to:

  • Describe key capabilities and components of SQL Server 2017

  • Describe new and enhanced features in SQL Server Performance, Availability, and Scalability 

  • Describe new and enhanced features in SQL Server data access 

  • Describe new and enhanced features in SQL Server reporting and BI 

  • Describe new and enhanced features in SQL Server OLAP 

  • Describe new and enhanced data analytics features 

  • Describe new and enhanced features in SQL Server Cloud deployments

  • Describe SQL Server on Linux functionality

Analyzing Data with SQL Server Reporting Services

After completing this course, students will be able to:

  • Describe reporting services and it’s components

  • Describe reporting services data sources

  • Implement paginated reports

  • Work with reporting services data

  • Visualize data with reporting services

  • Aggregate report data

  • Share reporting services reports

  • Administer reporting services

  • Expand and integrate reporting services

  • Describe mobile reports

  • Develop mobile reports.

 

 

Performance Tuning and Optimizing SQL Databases

After completing this course, students will be able to:

  • Describe the high level architectural overview of SQL Server and its various components.

  • Describe the SQL Server execution model, waits and queues.

  • Describe core I/O concepts, Storage Area Networks and performance testing.

  • Describe architectural concepts and best practices related to data files for user databases and TempDB.

  • Describe architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking.

  • Describe architectural concepts of the Optimizer and how to identify and fix query plan issues.

  • Describe architectural concepts, troubleshooting scenarios and best practices related to Plan Cache.

  • Describe architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.

  • Explain data collection strategy and techniques to analyze collected data.

  • Understand techniques to identify and diagnose bottlenecks to improve overall performance.

 

Introduction to SQL Databases

After completing this course, students will be able to:

  • Describe key database concepts in the context of SQL Server 2016

  • Describe database languages used in SQL Server 2016

  • Describe data modelling techniques

  • Describe normalization and denormalization techniques

  • Describe relationship types and effects in database design

  • Describe the effects of database design on performance

  • Describe commonly used database objects

Securing SQL Server Databases

After completing this course, students will be able to:

  • Consequences for not properly handling untrusted data such as denial of service, cross-site scripting, and injections

  • Test databases with various attack techniques to determine the existence of and effectiveness of layered defenses

  • Prevent and defend the many potential vulnerabilities associated with untrusted data

  • Concepts and terminology behind supporting, designing, and deploying secure databases

  • Problems associated with data security and the potential risks associated with those problems

  • Best practices for supporting the many security needs of databases.

  • Vulnerabilities associated with authentication and authorization within the context of databases and database applications

  • Detect, attack, and implement defenses for authentication and authorization functionality

  • Dangers and mechanisms behind Cross-Site Scripting (XSS) and Injection attacks

  • Detect, attack, and implement defenses against XSS and Injection attacks

  • Concepts and terminology behind defensive, secure coding

  • Using Threat Modeling as a tool in identifying software vulnerabilities based on realistic threats against meaningful assets

  • Perform both static reviews and dynamic database testing to uncover vulnerabilities

  • Design and develop strong, robust authentication and authorization implementations

  • Fundamentals of Digital Signatures as well as how they can be used as part of the defensive infrastructure for data

  • Fundamentals of Encryption as well as how it can be used as part of the defensive infrastructure for data