Courses

This 2-day course is intended for students who have taken the “Microsoft SQL Server Introduction to Querying” * course, or possess equivalent knowledge gained in the workplace or elsewhere. It may also prove beneficial to delegates wanting to refresh their current knowledge of the subject matter.

This 4-day course is intended for IT professionals, business analysts, and developers who need to implement data transfer, or ETL (Extract, Transform, and Load), solutions by using Microsoft SQL Server 2016 or 2017 Integration Services. Students will learn about the SQL Server Data Tools (SSDT) development environment to create SSIS projects and packages, work with Control Flow Tasks, and design Data Flows using a variety of transformations and data sources/destinations (including SQL Server databases, flat files, and Excel). Delegates will also learn about SSIS project and package management, deployment, debugging, error handling, and logging techniques. The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises.

This 2-day course is intended for students who are new to querying data stored in either a Microsoft SQL Server or database, and who need a measured and relatively gentle introduction to the subject. It could also prove beneficial to delegates wanting to refresh their existing querying skills.

This 5-day course is intended for students new to querying and programming with Microsoft SQL Server products who need a total immersion in the subject on a SQL Server 2016 or 2017 platform. This is a very comprehensive and intensive course with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience.

This 3-day course is intended for students who need to familiarise themselves with the various querying techniques available to retrieve data from a Microsoft SQL Server database in a report authoring environment, whether that be through an implementation of Microsoft SQL Server Reporting Services or similar reporting tool. No previous knowledge of the SQL language is assumed as the course is designed from the ground up, starting with basic queries and advancing to more complex querying methods.

This 4-day course is intended for students who need to learn and understand the full reporting lifecycle of designing, managing, and accessing reports in a Microsoft SQL Server environment.

This 3-day course is intended for students who need to learn the essential skills necessary to maintain a Microsoft SQL Server system infrastructure. Being concise and hands-on, it is aimed at quickly getting students familiar with the Microsoft SQL Server administration concepts, tools, and utilities. The installation of SQL Server, covered in the first module of the course, is optional and can be omitted to free up time for other topics if desired.