Module 02 of 10

Querying Data with SQL

Lessons

About This Module

With PostgreSQL installed, it's time to start talking to it. SQL (Structured Query Language) is the language you use to ask a relational database for data and to change what it stores, and it is the single most useful skill in this course.

You'll start with what SQL is and how it fits into a database, then learn to read data with SELECT: picking columns, filtering rows with WHERE, sorting results, and summarising them with aggregates and GROUP BY. From there you'll learn to change data with INSERT, UPDATE, and DELETE.

With the basics of querying in place, you'll be ready for the next module, Data Types & Table Design, where you decide how that data should be structured in the first place.

Lessons

3 videos
01

SQL Explained in 100 Seconds

A quick introduction to Structured Query Language, covering what SQL is, how tables and queries work, and the core commands you will use to work with data.

02

What is SQL? [in 4 minutes for beginners]

A short, beginner-friendly explanation of what SQL is, how databases store information in tables, and how queries retrieve exactly the data you ask for.

03

SQL Tutorial

A longer, step-by-step beginner tutorial that walks through writing real queries, from SELECT and filtering to changing data. Watch it alongside your own PostgreSQL setup and try each example.