SQLBolt
Learn SQL with simple, interactive exercises.
Interactive Tutorial Interactive Tutorial References & More More Topics
All Lessons
Introduction to SQL SQL Lesson 1: SELECT queries 101 SQL Lesson 2: Queries with constraints (Pt. 1) SQL Lesson 3: Queries with constraints (Pt. 2) SQL Lesson 4: Filtering and sorting Query results SQL Review: Simple SELECT Queries SQL Lesson 6: Multi-table queries with JOINs SQL Lesson 7: OUTER JOINs SQL Lesson 8: A short note on NULLs SQL Lesson 9: Queries with expressions SQL Lesson 10: Queries with aggregates (Pt. 1) SQL Lesson 11: Queries with aggregates (Pt. 2) SQL Lesson 12: Order of execution of a Query SQL Lesson 13: Inserting rows SQL Lesson 14: Updating rows SQL Lesson 15: Deleting rows SQL Lesson 16: Creating tables SQL Lesson 17: Altering tables SQL Lesson 18: Dropping tables SQL Lesson X: To infinity and beyond!
Additional Topics
Intermediate SQL Topics SQL Topic: Subqueries SQL Topic: Unions, Intersections & Exceptions
Intermediate SQL Topics

Before we get started, if you haven't yet completed our Interactive Tutorial or still don't feel comfortable with SQL, please complete that before continuing. The following deep-dive topics will be building on the foundation from the lessons in the tutorial by exploring more advanced SQL constructs that you might find useful when dealing with real-world data.

Core SQL

  1. Subqueries
  2. Set operations
  3. Coming soon: Foreign Keys, Dates and Times, Views, and more.

2024 © SQLBolt
Email | Twitter
Additional Courses
Interactive Regular Expressions Lessons