TOIT Training

Log in

Menu
Contact Sales
Roadmap

Advanced T-SQL

Last updated: May 6, 2026

Overview

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.

Curriculum

  • 39 Sections
  • 0 Lessons
  • 14 Hours
Expand all sectionsCollapse all sections
  • 01. Advanced T-SQL Introduction
    0
    • 02. Execution Plan Basics
      0
      • 03. Working with NULLS
        0
        • 04. Window Functions (Ranking Functions)
          0
          • 05. Window Functions (Aggregate Function)
            0
            • 06. Window Functions (Framing)
              0
              • 07. Window Functions (Alternative Methods)
                0
                • 08. Window Functions (Analytical Functions)
                  0
                  • 09. Working with Sets (EXCEPT)
                    0
                    • 10. Working with Sets (INTERSECT and UNION)
                      0
                      • 11. Advanced Joins (Self Joins)
                        0
                        • 12. Advanced Joins (NON-EQUI, CROSS and OUTER Joins)
                          0
                          • 13. Functions (Scalar Functions)
                            0
                            • 14. Functions (Table-Valued Functions)
                              0
                              • 15. Apply Operator (Introduction to Apply)
                                0
                                • 16. Apply Operator (Apply for Performance)
                                  0
                                  • 17. Pivot and UnPivot (PIVOT)
                                    0
                                    • 18. Pivot and UnPivot (UNPIVOT)
                                      0
                                      • 19. Subqueries
                                        0
                                        • 20. CTEs, Temp Tables and Derived Tables (Introduction to CTEs)
                                          0
                                          • 21. CTEs, Temp Tables and Derived Tables (Simplifying Complex Problems)
                                            0
                                            • 22. CTEs, Temp Tables and Derived Tables (Derived Tables)
                                              0
                                              • 23. CTEs, Temp Tables and Derived Tables (Recursion and Modifying Data)
                                                0
                                                • 24. CTEs, Temp Tables and Derived Tables (Temp Tables)
                                                  0
                                                  • 25. HASHBYTES and CHECKSUM
                                                    0
                                                    • 26. IF.. ELSE and EXISTS
                                                      0
                                                      • 27. Merge
                                                        0
                                                        • 28. Miscellaneous Functions
                                                          0
                                                          • 29. Miscellaneous Functions (SQL Server 2016 New Features)
                                                            0
                                                            • 30. Dynamic SQL
                                                              0
                                                              • 31. Cursors and While Loop
                                                                0
                                                                • 32. XML (XML RAW)
                                                                  0
                                                                  • 33. XML (XML AUTO)
                                                                    0
                                                                    • 34. XML (XML PATH)
                                                                      0
                                                                      • 35. XML (XML Shredding)
                                                                        0
                                                                        • 36. XML (XQUERY)
                                                                          0
                                                                          • 37. XML (XML PATH - Comma Delimited List)
                                                                            0
                                                                            • 38. Transactions
                                                                              0
                                                                              • 39. Error Handling
                                                                                0

                                                                                Instructor

                                                                                User Avatar
                                                                                ToIT
                                                                                2 Students
                                                                                1351 Courses
                                                                                course thumbnail
                                                                                Free
                                                                                Student:
                                                                                0 Students
                                                                                Lesson:
                                                                                0 Lessons
                                                                                Duration: 14 Hours
                                                                                Quiz:
                                                                                0 Quizzes
                                                                                Level: Expert