SQL

Curriculum

8 chapters, each with a tutorial, a live example, a quiz, an exercise, a challenge, and class practice.

1. 1

   Introduction to SQL

   SELECT, filtering, and aggregation basics.

   preview
2. 2

   Filtering with WHERE

   Comparison operators, AND/OR, and IN.

3. 3

   Joins

   INNER, LEFT, and combining multiple tables.

4. 4

   Aggregate Functions

   SUM, COUNT, AVG, MIN, and MAX.

5. 5

   Subqueries

   Queries nested inside other queries.

6. 6

   Indexes

   Speeding up lookups on large tables.

7. 7

   Views

   Saving a query as a reusable virtual table.

8. 8

   Transactions

   COMMIT, ROLLBACK, and data integrity.