Semester 0 · Bridge
Bridge: SQL Essentials
https://epochschool.com/subjects/bridge-sql
A short bridge in tables, SELECT, filtering, sorting, joins and aggregation in SQLite, so Data Engineering & Databases for ML can start at full speed.
No graded labs; in-browser exercises check every step.
Data Engineering & Databases for ML expects you to query a database from its first chapter. This bridge gets you there in three short chapters, working in SQLite: selecting and filtering rows, summarising with aggregation, and combining tables with joins. By the end you can write a query that filters, sorts and groups a single table, and you can say exactly which rows an inner join returns and which extra rows a left join keeps. If you already write joins and GROUP BY queries without a reference open, begin Semester 1 directly.
- Prerequisites
- None
What you’ll be able to do
- LO1Read and write basic SQL queries that filter, sort and aggregate a single table.
- LO2Combine tables with inner and left joins and explain the rows each returns.
Chapters
- 01Selecting and filtering rows
- 02Summarising with aggregation
- 03Combining tables with joins
Graded labs
No graded labs. In-browser exercises check every step.
Before you start
No prerequisites. This is a good place to start.
Where it leads
How it’s taught
You read short sections written for the page. Each ends with a check, and in-browser exercises let you practise. There are no graded labs in the bridge.
No videos. No live classes. No AI tutor.