Open the app
CoursesFeaturesFAQAbout
Open the app Get the Android app
All courses

Course

Learn SQL

Ask questions of your data. 8 units that take you from your first program to the language's advanced features.

Start learning Get the Android app
Units
8
Topics
37
Questions
187
Challenges
23
1

Unit 1

Querying

SELECT, WHERE and NULL

  1. SELECT
  2. Filtering with WHERE
  3. Pattern matching with LIKE
  4. NULL
  5. Unit quiz and coding challenge
2

Unit 2

Shaping results

Sorting, distinct values, CASE and functions

  1. Sorting with ORDER BY
  2. Limiting rows with LIMIT
  3. DISTINCT
  4. CASE expressions
  5. Text functions
  6. Number functions
  7. Dates
  8. Unit quiz and coding challenge
3

Unit 3

Aggregation

Aggregate functions, GROUP BY and HAVING

  1. Aggregate functions
  2. GROUP BY
  3. HAVING
  4. Unit quiz and coding challenge
4

Unit 4

Joins

Combining tables

  1. INNER JOIN
  2. LEFT JOIN
  3. CROSS JOIN
  4. Self joins
  5. Combining results with UNION
  6. Unit quiz and coding challenge
5

Unit 5

Subqueries and CTEs

Queries inside queries

  1. Subqueries
  2. Correlated subqueries
  3. EXISTS
  4. WITH (CTEs)
  5. Recursive CTEs
  6. Unit quiz and coding challenge
6

Unit 6

Changing data

INSERT, UPDATE, DELETE and transactions

  1. INSERT
  2. UPDATE
  3. DELETE
  4. Transactions
  5. Unit quiz and coding challenge
7

Unit 7

Designing tables

CREATE TABLE, constraints, indexes and views

  1. CREATE TABLE
  2. Changing tables
  3. Constraints
  4. Foreign keys
  5. Indexes
  6. Views
  7. Unit quiz and coding challenge
8

Unit 8

Advanced SQL

Window functions, design and safety

  1. Window functions
  2. Designing a schema
  3. Parameters and SQL injection
  4. Unit quiz and coding challenge

Finale

Course exam

100 items from the whole course: 50 questions with choices, 35 typed answers and 15 coding challenges that mix topics.

More courses

Keep going.

PythonJavaScriptTypeScriptJavaCC++GoRustDartPHPRuby