
CourseBeta
Learn SQL Intermediate
Learn intermediate SQL to combine tables, handle missing data and answer multi-step questions with queries you can trust.
Enroll for FREECourse Content
- 1.1 Welcome to SQL Intermediate
- 1.2 Warm-Up: Meet ShopEase
- 2.1 Working With NULL
- 2.2 NULL in CASE and Aggregates
- 2.3 COALESCE and NULLIF
- 2.4 Recap: NULLs and Conditional Logic
- 3.1 String Functions
- 3.2 Numeric Functions and CAST
- 3.3 Date Functions
- 3.4 Recap: Built-in Functions
- 4.1 Join Types in Pictures
- 4.2 Self Join
- 4.3 Anti-Joins
- 4.4 Multi-Table and Cross Joins
- 4.5 Recap: Advanced JOINs
- 5.1 UNION and UNION ALL
- 5.2 INTERSECT and EXCEPT
- 5.3 Recap: Set Operations
- 6.1 Correlated Subqueries
- 6.2 EXISTS and NOT EXISTS
- 6.3 Subqueries in SELECT and FROM
- 6.4 Recap: Advanced Subqueries
- 7.1 Common Table Expressions
- 7.2 Multiple CTEs
- 7.3 CTEs vs Subqueries
- 7.4 Recap: Common Table Expressions
- 8.1 Counting by Condition
- 8.2 Pivoting Data
- 8.3 Recap: Conditional Aggregation
- 9.1 Window Frames
- 9.2 Moving Windows
- 9.3 LAG and LEAD
- 9.4 Top N per Group
- 9.5 Recap: Window Functions in Depth
- 10.1 Inserting From Queries
- 10.2 Upserts
- 10.3 Updates and Deletes Using Other Tables
- 10.4 Transactions
- 10.5 Recap: Modifying Data Safely
- 11.1 Indexes
- 11.2 Reading Query Plans
- 11.3 Recap: Indexes and Query Plans
- 12.1 Capstone: ShopEase Quarterly Report
- 12.2 What's Next?
Courses similar to this
Frequently asked questions
You can start Learn SQL Intermediate with a 7-day free trial. Click "Enroll for FREE" to begin.
Learn SQL Intermediate has 12 chapters.
Learn SQL Intermediate is an Intermediate course. We recommend completing Learn SQL Basics first.
