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

Starting T-SQL Querying: Data Modifications

In this section we'll cover data modifications in T-SQL:

INSERT
Identity
Sequence
DELETE
TRUNCATE
UPDATE
MERGE
OUTPUT

14 Lessons