Advanced T-SQL

£395.00

What Will You Learn?

  • How to write queries that involve multiple tables and summary queries
  • How to modify data and understand the logical programming aspects of T-SQL

Category:

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.

INSTRUCTOR

MITCHELL PEARSONMITCHELL PEARSON

BI Consultant and Trainer
As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.

 

WHAT TO KNOW BEFORE THE CLASS

A basic understanding of T-SQL is required prior to taking this course.

SYSTEM REQUIREMENTS

  • SQL Server 2005 or greater