Lesson 0: How to read a table

Lessons

0 of 22 lessons done

0How to read a table
🔒SELECT, columns, DISTINCT
🔒WHERE with numbers: AND, OR, BETWEEN
🔒WHERE with text, ORDER BY, LIMIT
🔒Review: The Sneaker Store
🔒NULL values, calculations, AS
🔒Text and date functions
🔒CASE WHEN: making categories
🔒Review: The Delivery App
🔒COUNT, SUM, AVG, MIN, MAX
🔒GROUP BY: summarising each group
🔒HAVING, and the order SQL runs things in
🔒Review: The Player Report
🔒INNER JOIN basics
🔒JOINs with filters and grouping
🔒LEFT JOIN: finding what's missing
🔒Joining three tables
🔒Review: The Game Store Report
🔒Subqueries: a query inside a query
🔒WITH (CTEs): breaking big queries into steps
🔒Changing data: INSERT, UPDATE, DELETE
🔒Final Case Study: The Campus Merch Shop

Lessons

0 of 22 lessons done

0How to read a table
🔒SELECT, columns, DISTINCT
🔒WHERE with numbers: AND, OR, BETWEEN
🔒WHERE with text, ORDER BY, LIMIT
🔒Review: The Sneaker Store
🔒NULL values, calculations, AS
🔒Text and date functions
🔒CASE WHEN: making categories
🔒Review: The Delivery App
🔒COUNT, SUM, AVG, MIN, MAX
🔒GROUP BY: summarising each group
🔒HAVING, and the order SQL runs things in
🔒Review: The Player Report
🔒INNER JOIN basics
🔒JOINs with filters and grouping
🔒LEFT JOIN: finding what's missing
🔒Joining three tables
🔒Review: The Game Store Report
🔒Subqueries: a query inside a query
🔒WITH (CTEs): breaking big queries into steps
🔒Changing data: INSERT, UPDATE, DELETE
🔒Final Case Study: The Campus Merch Shop

Before we write any code, let's learn to read a table. A table is just data in a grid, like a spreadsheet. Hover over each part to see what it's called.

Hover over the table name, a column name, a row number, a value, and a blank (NULL) value.

Table
Column
Row
Value
NULL value

← All SQL lessons

Lesson 0: How to read a table

Lessons

0 of 22 lessons done

0How to read a table
🔒SELECT, columns, DISTINCT
🔒WHERE with numbers: AND, OR, BETWEEN
🔒WHERE with text, ORDER BY, LIMIT
🔒Review: The Sneaker Store
🔒NULL values, calculations, AS
🔒Text and date functions
🔒CASE WHEN: making categories
🔒Review: The Delivery App
🔒COUNT, SUM, AVG, MIN, MAX
🔒GROUP BY: summarising each group
🔒HAVING, and the order SQL runs things in
🔒Review: The Player Report
🔒INNER JOIN basics
🔒JOINs with filters and grouping
🔒LEFT JOIN: finding what's missing
🔒Joining three tables
🔒Review: The Game Store Report
🔒Subqueries: a query inside a query
🔒WITH (CTEs): breaking big queries into steps
🔒Changing data: INSERT, UPDATE, DELETE
🔒Final Case Study: The Campus Merch Shop

Lessons

0 of 22 lessons done

0How to read a table
🔒SELECT, columns, DISTINCT
🔒WHERE with numbers: AND, OR, BETWEEN
🔒WHERE with text, ORDER BY, LIMIT
🔒Review: The Sneaker Store
🔒NULL values, calculations, AS
🔒Text and date functions
🔒CASE WHEN: making categories
🔒Review: The Delivery App
🔒COUNT, SUM, AVG, MIN, MAX
🔒GROUP BY: summarising each group
🔒HAVING, and the order SQL runs things in
🔒Review: The Player Report
🔒INNER JOIN basics
🔒JOINs with filters and grouping
🔒LEFT JOIN: finding what's missing
🔒Joining three tables
🔒Review: The Game Store Report
🔒Subqueries: a query inside a query
🔒WITH (CTEs): breaking big queries into steps
🔒Changing data: INSERT, UPDATE, DELETE
🔒Final Case Study: The Campus Merch Shop

Before we write any code, let's learn to read a table. A table is just data in a grid, like a spreadsheet. Hover over each part to see what it's called.

Hover over the table name, a column name, a row number, a value, and a blank (NULL) value.

Table
Column
Row
Value
NULL value