Data Foundations & SQL
The bedrock of every analytics career: how data is stored, queried, and shaped. Master relational thinking, SQL from basics to window functions, and the data-wrangling habits every later programme assumes.
Why foundations come first
It is common to start a data career with a tool, a dashboard app, a Python notebook, and pick up the fundamentals later, or never. The result is analysts who can follow a recipe but stall the moment something unexpected happens, because they never learned how data is really structured underneath. This programme refuses that shortcut. It starts with how data is organized and queried, so that the tools you learn later are things you understand rather than things you copy.
The payoff is leverage. Someone who thinks relationally and writes SQL fluently learns business intelligence, data science, and every applied programme faster, because those disciplines all sit on top of querying and shaping data. Time invested in foundations is not time away from the exciting material; it is what makes the exciting material stick.
The practical proof of a foundation is independence: when something breaks or a question is unusual, you can reason from how data actually works rather than waiting for a recipe. That self-reliance is exactly what employers notice in an analyst, and it is what a tool-first education never quite delivers.
The full syllabus
Four modules of five chapters each, sequenced so the material builds cumulatively. The brochure carries a note on what each chapter teaches.
M1 How data is organized Ch 1-5 · 5 chapters
- Rows, columns, tables, and relational thinking
- Primary keys, foreign keys, and relationships
- Data types and why they matter
- Normalization and when to break it
- Reading an entity-relationship diagram
M2 SQL from the ground up Ch 6-10 · 5 chapters
- SELECT, WHERE, and filtering rows
- ORDER BY, LIMIT, and shaping output
- Aggregations with GROUP BY and HAVING
- Joins: inner, left, right, and full
- Subqueries and common table expressions
M3 Analytical SQL Ch 11-15 · 5 chapters
- Window functions and running totals
- Ranking, partitioning, and lag/lead
- Date and time handling
- CASE logic and conditional aggregation
- Query performance and reading a plan
M4 From raw data to clean data Ch 16-20 · 5 chapters
- Profiling a dataset and spotting problems
- Handling missing and duplicate data
- Reshaping: pivoting and unpivoting
- Combining sources and reconciling keys
- Building a clean, analysis-ready table
Three ways to take Data Foundations and SQL
| Feature | Self-paced | Cohort | Enterprise |
|---|---|---|---|
| Format | Written chapters, video explainers and podcasts | Everything in self-paced, plus scheduled live sessions | Everything in cohort, delivered privately to your team |
| Live sessions | None | Scheduled, instructor-led | Scheduled, instructor-led, private |
| Mentorship | Not offered | Not offered | Not offered |
| Access | Lifetime | Lifetime | Lifetime for every enrolled seat |
| Pace | Entirely your own | Guided schedule with a peer group | Agreed with your desk |
| Tailoring | Fixed curriculum | Fixed curriculum | Sequenced to your markets, systems and governance |
| Best for | Individuals learning around a job | Individuals who want structure and deadlines | Desks building the same capability together |
Get the programme guide
The full chapter list, what each module covers, and how the tiers compare - sent to your inbox as a PDF.
Run this for my desk
Private delivery for your desk, sequenced to your markets and systems. Tell us the team and we will scope it.
Run this for my deskBring this to your desk
Download the full curriculum, or talk to us about running it for a team.