Advanced T-SQL

$95.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

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.


Duration: 12:53:50
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.
Advanced T-SQL - What do you need to get started
Module 00 - Advanced T-SQL Introduction
04:57
Module 01 - Execution Plan Basics
Module 02 - Working with NULLS
19:08
Module 03A - Window Functions (Ranking Functions)
21:59
Module 03B - Window Functions (Aggregate Function)
14:15
Module 03C - Window Functions (Framing)
25:44
Module 03D - Window Functions (Alternative Methods)
10:26
Module 03E - Window Functions (Analytical Functions)
21:12
Module 04A - Working with Sets (EXCEPT)
24:08
Module 04B - Working with Sets (INTERSECT and UNION)
12:00
Module 05A - Advanced Joins (Self Joins)
25:55
Module 05B - Advanced Joins (NON-EQUI, CROSS and OUTER Joins)
27:18
Module 06A - Functions (Scalar Functions)
23:21
Module 06B - Functions (Table-Valued Functions)
35:57
Module 07A - Apply Operator (Introduction to Apply)
18:07
Module 07B - Apply Operator (Apply for Performance)
23:24
Module 08A - Pivot and UnPivot (PIVOT)
17:13
Module 08B - Pivot and UnPivot (UNPIVOT)
11:49
Module 09 - Subqueries
21:30
Module 10A - CTEs, Temp Tables and Derived Tables (Introduction to CTEs)
24:29
Module 10B - CTEs, Temp Tables and Derived Tables (Simplifying Complex Problems)
15:09
Module 10C - CTEs, Temp Tables and Derived Tables (Derived Tables)
24:49
Module 10D - CTEs, Temp Tables and Derived Tables (Recursion and Modifying Data)
28:31
Module 10E - CTEs, Temp Tables and Derived Tables (Temp Tables)
18:59
Module 11 - HASHBYTES and CHECKSUM
20:37
Module 12 - IF.. ELSE and EXISTS
30:04
Module 13 - Merge
14:48
Module 14A - Miscellaneous Functions
32:08
Module 14B - Miscellaneous Functions (SQL Server 2016 New Features)
26:04
Module 15 - Dynamic SQL
38:13
Module 16 - Cursors and While Loop
29:04
Module 17A - XML (XML RAW)
14:09
Module 17B - XML (XML AUTO)
16:20
Module 17C - XML (XML PATH)
16:13
Module 17D - XML (XML Shredding)
21:33
Module 17E - XML (XQUERY)
17:19
Module 17F - XML (XML PATH - Comma Delimited List)
08:33
Module 18 - Transactions
18:25
Module 19 - Error Handling
Class Survey

 

System Requirements

  • SQL Server 2005 or greater