Skip to main content

CourseBeta

Learn SQL Intermediate

Learn intermediate SQL to combine tables, handle missing data and answer multi-step questions with queries you can trust.

  • Level: Intermediate
  • Quizzes: 80+
Enroll for FREE

Course 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?
Start this Course
Get Certified

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.