Search

Microsoft SQL Server Reporting Services 4 Days

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.

Microsoft SQL Server Relational Database Design and Querying Fundamentals 2 Days

Microsoft SQL Server Querying Data for Report Developers 3 Days

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.

Microsoft SQL Server Programming 5 Days

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.

Microsoft SQL Server Integration Services 4 Days

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.

Microsoft SQL Server – Advanced Querying 2 Days

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.

Microsoft SQL Server System Administration Fundamentals 3 Days

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.

Microsoft SQL Server Introduction to Querying 2 Days

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.

A Practical Guide to DAX for users of Power BI, Excel Power Pivot, SQL, SSAS tabular DURATION: 2 days

INTRODUCTION: This course is aimed at existing users of Power BI, Excel Power Pivot, or SQL Server Analysis Services (SSAS) Tabular, who need to take their data analysis skills to the next level. COURSE AIMS: You will learn how to mine and expose hidden information with the DAX (Data Analysis eXpressions) language. Common business scenarios are covered, highlighting useful DAX patterns that can be implemented and adapted to solve a variety of simple and complex calculations. The theory behind the concepts of DAX will be emphasised through practical examples.

Updating Your Skills to SQL Server 2016 Duration3 Days

This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.

Querying Data with Transact-SQL Duration: 5 Days

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.

Developing SQL Databases Duration 5 Days

Special Notices This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.