Advanced T-SQL

Intensive course for SQL developers: Advanced Querying with T-SQL. Real-world examples, multiple solution methods, emphasis on optimal query writing. Enhance your skills and performance optimization techniques.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

This course includes:

13+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Description

Advanced Querying with T-SQL is an intensive course designed specifically for SQL developers. This course has been designed using examples from real world scenarios. In many cases the course will demonstrate the different methods to solve a particular scenario and then explain why one may be better than another due to performance reasons. The course has a heavy emphasis on writing optimal queries.

This course includes:

13+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

Advanced T-SQL - What do you need to get started

This course includes:

13+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Mitchell Pearson

Data Engineer (Azure) Trainer

Mitchell Pearson has been with Pragmatic Works for 11 years as a Data Platform Consultant, Trainer and Team Lead. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform, Microsoft Azure and Fabric.

Learn More

This course includes:

13+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

- Microsoft Windows 7, Windows 8.1, or Windows 10 - 1 GHz or faster CPU - 1 GB of available RAM (recommended 2 GB) - 20 GB of free hard drive space - SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014/2016 - SQL Server Database Engine - SQL Server Management Studio - Follow this [installation guide](https://www.youtube.com/playlist?list=PLcwrIWK7WBcRXS59lktaU9SJwb3cGgvCw) to ensure all items are installed correctly - AdventureWorks databases restored on the instance. - AdventureWorksDW database restored on the instance.

This course includes:

13+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

This course includes:

13+ hours hours of training
Access on mobile and browser
Certificate of Completion