02 Identity.sql
02 Identity.sql
Learn T-SQL With Erik
Buy now
Learn more
Course Introduction - 6 minutes
Environment Setup - 6 minutes
Reference Script Explanation - 7 minutes
2
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
2
SELECT FROM WHERE.sql
WHERE, HAVING, and Conditional Aggregates - 18 minutes
2
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
2
02 Inner Joins.sql
Outer Join Basics: 23 minutes
03 Outer Joins.sql
Apply Basics: Introduction and TOP N Per Group - 20 minutes
2
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
2
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
1
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
2
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
2
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
2
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 minutes
4
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 minutes
2
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
Preview unavailable
You must log in or sign up to view this lesson.
Login
Sign up
Learn T-SQL With Erik
Buy now
Learn more
Course Introduction - 6 minutes
Environment Setup - 6 minutes
Reference Script Explanation - 7 minutes
2
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
2
SELECT FROM WHERE.sql
WHERE, HAVING, and Conditional Aggregates - 18 minutes
2
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
2
02 Inner Joins.sql
Outer Join Basics: 23 minutes
03 Outer Joins.sql
Apply Basics: Introduction and TOP N Per Group - 20 minutes
2
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
2
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
1
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
2
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
2
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
2
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 minutes
4
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 minutes
2
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