Learn T-SQL With Erik
- Buy now
- Learn more
- Discussions
  Jul 22
- Course Introduction - 6 minutes
- Environment Setup - 6 minutes
- Reference Script Explanation - 7 minutes
- 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 minutes
SELECT FROM WHERE.sql
WHERE, HAVING, and Conditional Aggregates - 18 minutes
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 minutes
02 Inner Joins.sql
Outer Join Basics: 23 minutes
03 Outer Joins.sql
Apply Basics: Introduction and TOP N Per Group - 20 minutes
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 minutes
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 minutes
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 minutes
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 minutes
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 minutes
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

Learn T-SQL With Erik

This course is all about T-SQL. You'll learn how to write queries that return correct results, and don't make the server break down when they run. This material spans beginner to advanced, and includes concepts applicable to transactional and reporting workloads. Whether you're designing the next super high concurrency application, or working as a data scientist, engineer, or analyst, this course is for you.