Course Description
Module 01: Logical Query Processing
- Logical Query Processing Order
- Logical Query Processing Example
- Phase Details
Module 02: Query Tuning
- Internals and Index Tuning
- Cardinality Estimations
- Temporary Tables
- Sets vs. Cursors
- Query Tuning with Query Revisions
Module 03 - Multi-Table Queries
- Subqueries, Table Expressions and Recursive Queries
- 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 (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 Tasks
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 Modules
- 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
- SQL Graph
LAB A
Module 01: Logical Query Processing
- Logical Query Processing Order
- Logical Query Processing Example
- Phase Details
Module 02: Query Tuning
- Internals and Index Tuning
- Cardinality Estimations
- Temporary Tables
- Sets vs. Cursors
- Query Tuning with Query Revisions
Module 03 - Multi-Table Queries
- Subqueries, Table Expressions and Recursive Queries
- 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 (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 Tasks
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 Modules
- 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
- SQL Graph
LAB A
Agenda
Module 01: Logical Query Processing
- Logical Query Processing Order
- Logical Query Processing Example
- Phase Details
Module 02: Query Tuning
- Internals and Index Tuning
- Cardinality Estimations
- Temporary Tables
- Sets vs. Cursors
- Query Tuning with Query Revisions
Module 03 - Multi-Table Queries
- Subqueries, Table Expressions and Recursive Queries
- 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 (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 Tasks
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 Modules
- 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
- SQL Graph
LAB A