All courses
· beginner

SQL Foundations

Ask a database questions and understand the answers. Read rows, filter them and summarise them, with every query built against real tables you can see.

Pathaxis · Original content

Written in house, from the work rather than from a syllabus. Every example is one we would use ourselves, and every exercise is checked against the same engine that grades your answer.

54 min 4 lessons 10 quiz questions 5 exercisesStart course

What you’ll learn

  • Read rows and columns out of a table with SELECT
  • Filter rows precisely with WHERE, including NULL handling
  • Summarise data with COUNT, SUM and AVG
  • Group rows and know which columns GROUP BY permits

Before you start

  • · No prior SQL needed
  • · Comfort reading a table of data

Syllabus

01

Reading data

Getting rows out of a table, then narrowing them down.

02

Summarising data

Turning many rows into the few numbers you actually wanted.