SQL Tutorial

Data sits behind almost every application. Learn how to query, filter, join, and shape information with SQL, and build the confidence to work with real databases.

All SQL lessons

30 lessons, in the order we recommend taking them.

Start with lesson 1
  1. 1Getting Started
  2. 2Data Types
  3. 3Create Database & Table
  4. 4Constraints
  5. 5Insert, Update, Delete
  6. 6Select Statement
  7. 7Where Clause & Operators
  8. 8Order By, Limit & Offset
  9. 9Aggregate Functions
  10. 10Group By & Having
  11. 11Joins
  12. 12Union & Set Operations
  13. 13Subqueries
  14. 14Common Table Expressions
  15. 15Case Expressions
  16. 16String Functions
  17. 17Date & Time Functions
  18. 18Numeric Functions
  19. 19Window Functions
  20. 20Views
  21. 21Indexes
  22. 22Stored Procedures, Functions & Triggers
  23. 23Transactions & ACID
  24. 24Design & Normalization
  25. 25Security & Permissions
  26. 26Query Optimization
  27. 27Advanced Concepts
  28. 28SQL for Data Analysis
  29. 29Common SQL Problems
  30. 30Interview Questions

Keep going