The GoldStandardAn independent Australian digital newspaper and school.Wednesday 9 September · evening edition · closes 10pm AEST.
Text size

Lessons

An introduction to writing SQL

SQL · Introductory. Ten lessons. Open-book quizzes. Lesson 1 free.

10 lessons · The Host · Lesson 1 free

Pass all ten lessons for the certificate. Sample · Claim

  1. SELECT and FROM

    Lesson 1 · On the house

    SELECT and FROM

    Read rows from a table.

  2. WHERE filters

    Lesson 2

    WHERE filters

    Keep only matching rows.

  3. ORDER BY and LIMIT

    Lesson 3

    ORDER BY and LIMIT

    Sort and take a page.

  4. INSERT rows

    Lesson 4

    INSERT rows

    Add data.

  5. UPDATE rows

    Lesson 5

    UPDATE rows

    Change existing data.

  6. DELETE rows

    Lesson 6

    DELETE rows

    Remove data.

  7. Aggregates

    Lesson 7

    Aggregates

    COUNT, SUM, AVG, MIN, MAX.

  8. GROUP BY

    Lesson 8

    GROUP BY

    Aggregate per group.

  9. JOIN basics

    Lesson 9

    JOIN basics

    Combine related tables.

  10. A small query

    Lesson 10

    A small query

    Filter, join, and aggregate.

Sample certificate

Certificate of completion

Sign in to claim your certificate of completion.

Certificate

Finish all ten lessons, then sign in

Pass every lesson on this device (quizzes and checks). Then sign in or create an account to type your name and download the JPG.

Sign inCreate account

All lessons

An introduction to writing SQL — The Gold Standard