• Course Introduction - 6 minutes

• Environment Setup - 6 minutes

• Reference Script Explanation - 7 minutes2

• 01 Course Instructions.sql

• 03 Common T-SQL Usage And Functions.sql

• 02 Common T-SQL Conventions.sql

• 04 Data Storage.sql

Starting T-SQL Querying: Reading Data

• SELECT FROM WHERE: Lecture - 11 minutes

• SELECT FROM WHERE: Demos - 16 minutes2

• SELECT FROM WHERE.sql

• WHERE, HAVING, and Conditional Aggregates - 18 minutes2

• WHERE and Having.sql

• Join Introduction: Lecture - 8 minutes

• Join Introduction: Demos - 15 minutes

• 00 Joins.sql

• Cross Join Basics: 10 minutes

• 01 Cross Joins.sql

• Inner Joins Basics - 17 minutes2

• 02 Inner Joins.sql

• Outer Join Basics: 23 minutes

• 03 Outer Joins.sql

• Apply Basics: Introduction and TOP N Per Group - 20 minutes2

• Apply Basics: The VALUES Clause - 12 minutes

• APPLY.sql

• DISTINCT - 26 minutes

• DISTINCT.sql

• Group By Part 1 - 17 minutes

• Group By Part 2 - 15 minutes

• GROUP BY.sql

• Order By Introduction - 15 minutes

• ORDER BY.sql

• Order By and Index Design - 15 minutes

• 02 Index Sortables.sql

• TOP and OFFSET FETCH - 31 minutes

• TOP and OFFSET FETCH.sql

• CASE Expressions - 26 minutes

• 00 CASE Expressions.sql

• Defensive CASE Expressions - 21 minutes

• 01 Defensive CASE Expressions.sql

• Subqueries - 21 minutes

• Subqueries.sql

• EXISTS and NOT EXISTS - 25 minutes

• EXISTS and NOT EXISTS.sql

• Derived Tables - 18 minutes

• Derived Tables.sql

• Common Table Expressions - 26 minutes

• Common Table Expressions.sql

• Recursive Common Table Expressions - 23 minutes2

• Recursive Common Table Expressions.sql

• Window Function Basics - 35 minutes

• Window Functions.sql

• Window Functions: Solving Common Problems - 25 minutes

• Window Function Problem Solvers.sql

• Grouping Sets, Cube, and Rollup - 20 minutes

• Grouping Sets, Cube, Rollup.sql

• Pivot and Unpivot - 22 minutes

• Pivot and Unpivot.sql

• Union and Union All - 15 minutes

• 01 The Unions.sql

• Intersect - 19 minutes

• 02 INTERSECT.sql

• Except - 14 minutes

• 03 EXCEPT.sql

• Distinct From - 21 minutes

• 04 DISTINCT FROM.sql

• NULLs and Datatypes - 27 minutes

• NULLs, Data Types.sql

• SARGability - 18 minutes

• SARGability.sql

Starting T-SQL Querying: Data Modifications

• Insert Basics - 21 minutes

• 01 Insert.sql

• Identity Basics - 24 minutes1

• 02 Identity.sql

• Sequences Basics - 16 minutes

• 03 Sequences.sql

• Delete and Truncate Basics - 18 minutes

• 01 Delete and Truncate.sql

• Update Basics - 20 minutes

• 01 Update.sql

• Merge Basics - 20 minutes

• 01 Merge.sql

• Output Basics - 23 minutes2

• 01 Output.sql

Starting T-SQL Querying: Transactions and Isolation Levels

• A.C.I.D. Basics - 15 minutes

• 00 A.C.I.D..sql

• Transaction Basics - 20 minutes2

• 01 Transactions.sql

• Isolation Level Basics (Lecture) - 22 minutes

• 02 Isolation Levels.sql

• Serializable Basics - 13 minutes

• 03 Serializable.sql

• Deadlocks Lecture - 10 minutes

• Deadlock Demos - 22 minutes

• 05 Deadlocks.sql

• Read Uncommitted and NOLOCK - 21 minutes

• 06 Read Uncommitted.sql

• Locking vs Row Versioning Read Committed - 16 minutes

• 07 Locking vs Versioning.sql

• Read Committed Inconsistencies Part 1 - 10 minutes

• Read Committed Inconsistencies Part 2 - 15 minutes

• 07a Read Committed Iconsistency.sql

• Selects That Block and Deadlock - 24 minutes

• 07b Read Committed Blocking and Deadlocking.sql

• Read Committed Concurrency Phenomena - 13 minutes

• 07c Read Committed Oddity.sql

• RCSI and Modifications - 17 minutes

• 07d Read Committed Snapshot Isolation.sql

Starting T-SQL Querying: Programmability

• 00 Programmability.sql

• Declared Variables - 21 minutes

• 01 Declared Variables.sql

• Control Flow Logic - 14 minutes

• 02 Control Flow.sql

• WHILE Loops - 15 minutes

• 03 While Loops.sql

• Cursor Basics - 21 minutes

• 04 Cursors.sql

• Dynamic SQL Basics - 31 minutes

• 05 Dynamic SQL.sql

• Temporary Objects - 31 minutes

• 06 Temporary Tables.sql

• Error and Transaction Handling Basics - 28 minutes

• 07 Error Handling.sql

• Views and Indexed Views - 32 minutes

• 08 Views and Indexed Views.sql

• Triggers - 25 minutes2

• 09 Triggers.sql

• Scalar UDFs - 25 minutes

• 10 Scalar UDFs.sql

• Multi-Statement Functions - 16 minutes

• 11 Multi-Statement Functions.sql

• Inline Table Functions - 24 minutes

• 12 Inline Functions.sql

• Stored Procedures - 30 minutes

• 13 Stored Procedures.sql

Advanced T-SQL Querying

• Advanced Course Introduction - 15 minutes4

• 00 Intro.pdf

Execution Plan Red Flags

• Query Plans - 21 Minutes

• 01 Query Plans.sql

• Local Variables - 23 minutes

• 01 Local Variables.sql

• Table Variables - 22 minutes

• 02a Table Variables.sql

• 02b Table Variables.sqlplan

• Multi-Statement Table Valued Functions - 9 minutes

• 03 MSTVFs.sql

• Scalar User Defined Functions - 24 minutes

• 04a UDFs.sql

• 04b UDFs.sqlplan

• Eager Index Spools - 23 minutes

• 05 Eager Index Spool.sql

• Common Table Expressions - 18 minutes

• 06 CTEs.sql

• Join On OR Clause - 29 minutes

• 07 Joins On Or.sql

• Left Join vs Not Exists - 28 minutes

• 08 Left Join vs Not Exists.sql

• Join on ROW_NUMBER - 24 minutes

• 09a Join With Row Number.sql

• 09b Big Grant String Columns.sqlplan

• Top Above Scan - 11 minutes

• 10 TOP above Scan.sql

Data Storage

• Heaps - 22 minutes

• 01 Heaps.sql

• 01a Votes Loads MAXDOP 1.sqlplan

• 01a Votes Loads.sqlplan

• Clustered Tables - 16 minutes

• 02 Clustered Tables.sql

• Nonclustered Indexes - 23 minutes

• 03 Nonclustered Indexes.sql

• Column Store Indexes Intro - 23 minutes

• Column Store Modifications - 21 minutes

• 04 Column Store.sql

• Row Store Partitioning - 22 minutes

• 05 Partitioning.sql

• 05a Partitioning View.sql

• Column Store Partitioning - 22 minutes

• 06 Partitioning and Column Store.sql

• 07 Partitioned Views.sql

• Partitioned Views - 21 minutes

Filtered Indexes, Computed Columns, and Indexed Views

• Filtered Indexes: 28 minutes

• 01 Filtered Indexes.sql

• Computed Columns - 35 minutes

• 02 Computed Columns.sql

• Indexed View Maintenance: 23 minutes

• 03 Indexed View Maintenance.sql

• Indexed View Matching: 24 minutes

• 04 Indexed View Matching.sql

• Indexed View Creation: 12 minutes

• 05 Indexed View Creation.sql

• 05a Indexed Views Slow With No Indexes.sqlplan

• 05b Indexed Views Slow With Indexes.sqlplan

• 05c Slow Index Create.sqlplan

• Indexed View Locking: 11 minutes

• 06 Indexed View Locking.sql

Index Design

• Index Search and Sort: 37 minutes2

• 01 Index Search And Sort.sql

• Memory Grants: 23 minutes

• 02 Memory Grants.sql

• Equality, Sort, Range Indexing: 33 minutes

• 03 Align and Design an Index.sql

• Top N Per Group Strategies: 13 minutes

• 04 Align and Design a Query.sql

• Gatekeeper Index Columns: 17 minutes

• 05 Align and Design Hard Mode.sqlplan

• 05 Align and Design Hard Mode.sql

• Dealing With Lookups: 27 minutes

• 06 Align and Design Lookups.sql

• Optimizer Nudging Strategies: 21 minutes

• 07 Align and Design Optimizer Nudging.sql

• Missing Index Requests: 14 minutes

• 08 Missing Index Nonsense.sql

Working With Dates and Time Zones

• Introduction To Date Handling: 26 minutes

• 01 Date Work.sql

• Date Filtering Part One: 17 minutes

• 02 Date Math Filtering Part One.sql

• Date Math Filtering Part 2: 26 minutes

• 03 Date Math Filtering Part Two.sql

• Time Zones: 40 minutes

• 04 Time Zones.sql

Query Optimization

• Early Aggregates: 22 minutes

• 01 Early Aggregates.sql

• Multiple Distinct Aggregates: 23 minutes

• 02 Multiple Distinct Aggregates and Batch Mode.sql

• 02 Multiple Distinct Aggregates and Batch Mode.sqlplan

• Nested Loops Prefetching: 22 minutes

• 03 Nested Loops Prefetching.sql

• 03 Nested Loops Prefetching.sqlplan

• Distinct Aggregate Limitations: 15 minutes

• 04 Counting Distinct Groups.sql

• Implied Predicate: 11 minutes

• 05 Implied Predicates.sql

• Multi Seeks: 20 minutes

• 06 Slow Multi Seeks.sql

• Union vs Union All: 21 minutes

• 07 U vs U All.sql

• Lazy Table Spools: 23 minutes

• 08 Table Spools.sql

• CASE Expressions: 27 minutes

• 09 Case Expressions.sql

• 09 Case Expressions.sqlplan

• 10a Serially Parallel Seriously Skewed.sqlplan

• 10 Serially Parallel.sql

• 10b Serially Parallel Exchange Spill.sqlplan

• Parallel Skew: 45 minutes

• How To Think Like A Batch Mode: 35 minutes

• 11 Think Like a Batch.sql

• Row Goal Intro: 26 minutes

• 12 Row Goal Intro.sql

• 13 Row Goal Action.sql

• Row Goals In Action: 30 minutes