Module 01: Logical Query Processing
- Logical Query Processing Order
- Logical Query Processing Example
- Phase Details
- Quiz
Module 02: Query Tuning
- Internals and Index Tuning
- Quiz
- New Cardinality Estimator
- Temporary Tables
- Sets vs. Cursors
- Query Tuning with Query Revisions
Module 03 – Multi-Table Queries
- Subqueries and Table Expressions
- APPLY Operator
- Joins
- Set Operators
- LAB 03
Module 04: Grouping, Pivoting and Windowing
- Window Functions
- Pivoting and Unpivoting Data
- Custom Aggregations
- STRING_AGG
- Grouping Sets (bonus self-study unit)
- LAB 04
Module 05: TOP and OFFSET-FETCH
- TOP
- OFFSET-FETCH
- Top N Per Group
- LAB 05
Module 06: Data Modification
- Inserting Data
- Sequences
- Deleting Data
- Updating Data
- Merging Data
- The OUTPUT Clause
- LAB 06
Module 07 – Working with Date and Time
- Date and Time Datatypes
- Date and Time Functions
- Date and Time Challenges
- System-Versioned Temporal Tables
- Date and Time Querying Problems
- LAB 07
Module 08: Programmable Objects
- Dynamic SQL
- User Defined Functions
- Stored Procedures
- Triggers
- Transactions and Concurrency
- Exception Handling
- LAB 08
Module 09: In-Memory OLTP
- Intro to In-Memory OLTP
- Architecture
- Memory Optimized Tables and Indexes
- Natively Compiled Procedures
- Transaction Semantics
- LAB 09
Appendix A: Graphs and Recursive Queries (Bonus Self-Study Material)
- Graphs, Described
- Materialized Paths
- Custom
- Using the HIERARCHYID datatype
- Nested Sets
- Nested Iterations
- Loops
- Recursive Queries
- SQL Graph
- LAB A