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