The GoldStandardAn independent Australian digital newspaper and school.Sunday 6 September · evening edition · closes 10pm AEST.
Text size
Sign inA$5 a month

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. Lesson 1 · On the house

    SELECT and FROM

    Read rows from a table.

  2. Lesson 2

    WHERE filters

    Keep only matching rows.

  3. Lesson 3

    ORDER BY and LIMIT

    Sort and take a page.

  4. Lesson 4

    INSERT rows

    Add data.

  5. Lesson 5

    UPDATE rows

    Change existing data.

  6. Lesson 6

    DELETE rows

    Remove data.

  7. Lesson 7

    Aggregates

    COUNT, SUM, AVG, MIN, MAX.

  8. Lesson 8

    GROUP BY

    Aggregate per group.

  9. Lesson 9

    JOIN basics

    Combine related tables.

  10. 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