Guided course · Data Access in .NET
SQL Server for .NET Developers
Understand what SQL Server does with the queries your .NET code sends, and how to make them fast and correct: heaps and clustered indexes, reading actual execution plans, nonclustered and covering indexes, index design and filtered indexes, sargable predicates and implicit conversions from .NET parameters, statistics, parameter sniffing and PSP optimization, T-SQL transactions and XACTABORT, isolation levels and RCSI, locking, blocking and deadlocks, window functions and keyset pagination, CTEs and temporary tables, and a Query Store tuning workflow. 15 lessons with scripts and .NET programs run on SQL Server 2022, real output (logical reads and actual plans), a 12-problem practice set and a 25-question mock interview.
Module 1 · Foundations
2 lessons · 34 minModule 2 · Indexes and Execution Plans
5 lessons · 1 h 21 min- 03Nonclustered Indexes, Key Lookups, the Tipping Point and Covering Indexes (included with Full Access)16 min
- 04Index Design: Key Column Order, Filtered Indexes and Missing-Index Suggestions (included with Full Access)16 min
- 05Sargable Predicates: Functions on Columns, LIKE, ISNULL and Implicit Conversions (included with Full Access)15 min
- 06Statistics and Cardinality Estimates: Histograms, Stale Stats and the Ascending Key Problem (included with Full Access)16 min
- 07Parameter Sniffing, the Plan Cache and Parameter Sensitive Plan Optimization (included with Full Access)18 min
Module 3 · Transactions and Concurrency
3 lessons · 49 min- 08T-SQL Transactions and Error Handling: XACT_ABORT, TRY/CATCH, Nesting and Savepoints (included with Full Access)15 min
- 09Isolation Levels in Practice: Locking READ COMMITTED, NOLOCK, RCSI, SNAPSHOT and SERIALIZABLE (included with Full Access)18 min
- 10Locking, Blocking and Deadlocks: Reading sys.dm_tran_locks, Blocking Chains and Deadlock Graphs (included with Full Access)16 min
Module 4 · T-SQL Patterns and Tuning
3 lessons · 54 min- 11Window Functions and Pagination: Ranking, Running Totals, LAG/LEAD, OFFSET vs Keyset (included with Full Access)20 min
- 12CTEs, Recursive Queries, Temp Tables and Table Variables: When Each One Helps (included with Full Access)16 min
- 13A SQL Server Tuning Workflow: Query Store, DMVs, Wait Stats, Fix and Verify (included with Full Access)18 min