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.
Overview
COURSE DIFFICULTY
COURSE DURATION
14h 2m
Skills Learned
After completing this online training course, students will be able to:
Write T-SQL queries for data retrieval and manipulation
Optimize query and server performance
Database Administrators, SQL Developers
Foundational SQL Server knowledge
01. Advanced T-SQL Introduction
02. Execution Plan Basics
03. Working with NULLS
04. Window Functions (Ranking Functions)
05. Window Functions (Aggregate Function)
06. Window Functions (Framing)
07. Window Functions (Alternative Methods)
08. Window Functions (Analytical Functions)
09. Working with Sets (EXCEPT)
10. Working with Sets (INTERSECT and UNION)
11. Advanced Joins (Self Joins)
12. Advanced Joins (NON-EQUI, CROSS and OUTER Joins)
13. Functions (Scalar Functions)
14. Functions (Table-Valued Functions)
15. Apply Operator (Introduction to Apply)
16. Apply Operator (Apply for Performance)
17. Pivot and UnPivot (PIVOT)
18. Pivot and UnPivot (UNPIVOT)
19. Subqueries
20. CTEs, Temp Tables and Derived Tables (Introduction to CTEs)
21. CTEs, Temp Tables and Derived Tables (Simplifying Complex Problems)
22. CTEs, Temp Tables and Derived Tables (Derived Tables)
23. CTEs, Temp Tables and Derived Tables (Recursion and Modifying Data)
24. CTEs, Temp Tables and Derived Tables (Temp Tables)
25. HASHBYTES and CHECKSUM
26. IF.. ELSE and EXISTS
27. Merge
28. Miscellaneous Functions
29. Miscellaneous Functions (SQL Server 2016 New Features)
30. Dynamic SQL
31. Cursors and While Loop
32. XML (XML RAW)
33. XML (XML AUTO)
34. XML (XML PATH)
35. XML (XML Shredding)
36. XML (XQUERY)
37. XML (XML PATH - Comma Delimited List)
38. Transactions
39. Error Handling
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Write T-SQL queries for data retrieval and manipulation
Optimize query and server performance
WHO SHOULD ATTEND
Database Administrators, SQL Developers
PREREQUISITES
Foundational SQL Server knowledge
COURSE OUTLINE
01. Advanced T-SQL Introduction
02. Execution Plan Basics
03. Working with NULLS
04. Window Functions (Ranking Functions)
05. Window Functions (Aggregate Function)
06. Window Functions (Framing)
07. Window Functions (Alternative Methods)
08. Window Functions (Analytical Functions)
09. Working with Sets (EXCEPT)
10. Working with Sets (INTERSECT and UNION)
11. Advanced Joins (Self Joins)
12. Advanced Joins (NON-EQUI, CROSS and OUTER Joins)
13. Functions (Scalar Functions)
14. Functions (Table-Valued Functions)
15. Apply Operator (Introduction to Apply)
16. Apply Operator (Apply for Performance)
17. Pivot and UnPivot (PIVOT)
18. Pivot and UnPivot (UNPIVOT)
19. Subqueries
20. CTEs, Temp Tables and Derived Tables (Introduction to CTEs)
21. CTEs, Temp Tables and Derived Tables (Simplifying Complex Problems)
22. CTEs, Temp Tables and Derived Tables (Derived Tables)
23. CTEs, Temp Tables and Derived Tables (Recursion and Modifying Data)
24. CTEs, Temp Tables and Derived Tables (Temp Tables)
25. HASHBYTES and CHECKSUM
26. IF.. ELSE and EXISTS
27. Merge
28. Miscellaneous Functions
29. Miscellaneous Functions (SQL Server 2016 New Features)
30. Dynamic SQL
31. Cursors and While Loop
32. XML (XML RAW)
33. XML (XML AUTO)
34. XML (XML PATH)
35. XML (XML Shredding)
36. XML (XQUERY)
37. XML (XML PATH - Comma Delimited List)
38. Transactions
39. Error Handling
