SQL & Databases for Beginners
Read and write real SQL queries against a relational database. By the end you'll be able to select and filter data, combine tables with JOINs, summarise with GROUP BY, and work through a full data-exploration project you can show someone.
Every lesson comes with written notes, a practice task and a knowledge check.
Watch the first lesson free
What a Database Is and Why SQL Matters — Start with the opening chapters ("What is a Database?" and "Tables & Keys") of this full course — the rest is a useful reference to return to later.
Create a free account to watch it. No payment needed.
On a limited data plan? Tap the gear icon (⚙️) in the video player and choose 480p or lower — standard-definition video uses a fraction of the data HD does and still looks fine on a phone.
Level 1 — Foundations
Start from zero: what this skill is, the tools you need, and how to get set up.
Module 1 — Getting Started
- Lesson 1 — What a Database Is and Why SQL Matters· 4h 21m· ~1877 MB
Start with the opening chapters ("What is a Database?" and "Tables & Keys") of this full course — the rest is a useful reference to return to later.
- Say what a database gives you that a spreadsheet does not
- Read a table in terms of rows, columns, keys and relationships
- Start practising without installing anything
- Lesson 2 — SELECT Basics: Retrieving Data· 6 min· ~45 MB
Your first real queries — SELECT and FROM, and reading what comes back.
- Write and read a basic SELECT query
- Know the order the database actually processes a query in
- Limit what you pull back, for speed and for data cost
Module 2 — How Data Is Actually Stored
- Lesson 1 — Tables, Keys and How Data Relates· 4h 21m· ~1877 MB
What a table actually is, and how primary and foreign keys connect one table to another — the idea that makes JOINs make sense later.
- Describe a table in terms of rows, columns and data types
- Explain what a primary key is and why every table needs one
- Explain how a foreign key links one table to another
- Lesson 2 — Making Your Own Database to Practise On· 4h 21m· ~1877 MB
Creating tables and putting rows into them — so you have data of your own to query instead of only reading someone else's examples.
- Create a table with appropriate columns and data types
- Insert rows into a table you made
- Explain why practising on your own data beats following along with a sample database
Level 2 — Core Skills
The hands-on skills that make up the day-to-day of this work.
Module 3 — Core Skills in Practice
- Lesson 1 — Filtering Data with WHERE· 8 min· ~57 MB
Narrowing a result set down to just the rows you actually want.
- Filter rows with comparisons, AND, OR and parentheses
- Handle empty values correctly, which is where beginners get wrong answers
- Check a destructive change before you make it
- Lesson 2 — JOINs: Combining Data Across Tables· 35 min· ~255 MB
INNER, LEFT, and RIGHT joins — pulling related data out of separate tables.
- Join two tables on a key and read the result
- Choose between an inner join and a left join deliberately
- Recognise the two join mistakes that produce wrong numbers
Level 3 — Professional Practice
Work the way professionals do, and take on real projects and clients.
Module 4 — Working Like a Pro
- Lesson 1 — Grouping and Sorting: GROUP BY and ORDER BY· 8 min· ~59 MB
Aggregate functions, grouping rows into summaries, and ordering the output.
- Summarise rows into counts, totals and averages
- Use HAVING and WHERE in the right places
- Sort and take the top results correctly
- Lesson 2 — A Full SQL Data Exploration Project· 1h 17m· ~555 MB
Working through a real dataset end to end — the kind of project that belongs in a portfolio.
- Explore an unfamiliar dataset in a deliberate order
- Check your own findings before you report them
- Turn the work into something an employer can look at
Spin for a discount
One spin, one discount on this Learning Path.
Reviews
No reviews yet.