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 program 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 program 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 program 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.
Relational thinking and SQL
The program begins with how data is organized: rows and columns, keys and relationships, data types, and the normalization that keeps data consistent. Reading an entity-relationship diagram and understanding why tables are shaped the way they are is the mental model that makes SQL make sense, rather than feeling like arbitrary syntax to memorize.
Then it builds SQL deliberately, from SELECT and WHERE through joins and subqueries up to the analytical SQL that separates a beginner from a professional: window functions, running totals, ranking, and partitioning. By the end you can express a real business question directly as a query, which is the single most useful skill in analytics and the one most self-taught analysts are shakiest on.
SQL fluency in particular is a career-long asset because it barely changes and applies everywhere. The window functions and joins you learn here will still be current in a decade, across every database and warehouse, which makes this one of the highest-return skills in the entire track.
From raw to analysis-ready
Real data is messy, and the final module confronts that directly. You learn to profile a dataset and spot its problems, handle missing and duplicate values, reshape data by pivoting and unpivoting, and combine sources while reconciling keys that never quite match. These are the unglamorous skills that consume most of an analyst's real time, and doing them well is what makes downstream analysis trustworthy.
The habits built here, checking data before trusting it, documenting what you did, producing a clean and reproducible table, are the professional foundation the rest of the track assumes. They are also exactly the habits that distinguish an analyst whose numbers can be relied on from one whose work quietly has to be redone.
The data-cleaning discipline is where trust is built or lost, and the program treats it as seriously as the querying. An analyst whose cleaned data can be relied on becomes the person a team trusts with the important questions, which is a far better position than being fast but occasionally wrong.
See the method, not just the topic
A representative worked example from the program, so you can see the level of concreteness the curriculum works at.
-- Monthly revenue per region, plus each month's running total
-- and its rank within the region.
SELECT
region,
month,
revenue,
SUM(revenue) OVER (
PARTITION BY region ORDER BY month
) AS running_total,
RANK() OVER (
PARTITION BY region ORDER BY revenue DESC
) AS month_rank
FROM monthly_sales
ORDER BY region, month;
-- PARTITION BY resets the window per region; ORDER BY defines
-- the running sequence. One query answers "how are we tracking"
-- and "which months were best" at the same time.The full syllabus
Four modules of five chapters each, sequenced so the material builds cumulatively. Each chapter carries a note on what it teaches.
Module 1How data is organized
- 01Rows, columns, tables, and relational thinkingHow tables, rows, and columns model the real world. You stop seeing spreadsheets and start seeing structured data.
- 02Primary keys, foreign keys, and relationshipsKeys are what let separate tables connect meaningfully. Relationships are what turn separate tables into a model.
- 03Data types and why they matterChoosing the right data type prevents whole classes of bugs. A date stored as text will haunt you; you learn to avoid it.
- 04Normalization and when to break itNormalization keeps data consistent, and you learn when to relax it. You learn the trade-off between purity and practicality.
- 05Reading an entity-relationship diagramAn ER diagram is a map you learn to read at a glance. Diagrams become the fastest way to understand a new database.
Module 2SQL from the ground up
- 06SELECT, WHERE, and filtering rowsSELECT and WHERE are the two verbs you will use most. Filtering precisely is the foundation of every query.
- 07ORDER BY, LIMIT, and shaping outputOrdering and limiting turn a raw result into a readable one. Small clauses make the difference between usable and unusable output.
- 08Aggregations with GROUP BY and HAVINGGROUP BY is where SQL starts answering business questions. Aggregation is where raw rows become insight.
- 09Joins: inner, left, right, and fullJoins are the skill that separates confident SQL users from stuck ones. Once joins click, most of SQL opens up.
- 10Subqueries and common table expressionsSubqueries and CTEs let you build complex logic in readable steps. Readable queries are maintainable queries.
Module 3Analytical SQL
- 11Window functions and running totalsWindow functions are the professional's tool for running calculations. This is the skill most self-taught analysts are missing.
- 12Ranking, partitioning, and lag/leadRanking and partitioning answer 'top N per group' cleanly. You can answer 'best per category' without contortions.
- 13Date and time handlingDate handling is deceptively tricky and worth learning properly. Time-based analysis depends on getting dates right.
- 14CASE logic and conditional aggregationCASE logic brings conditional thinking into a query. Conditional logic lives inside the query, not a spreadsheet.
- 15Query performance and reading a planReading a query plan is how you make slow queries fast. Understanding the plan turns guesswork into engineering.
Module 4From raw data to clean data
- 16Profiling a dataset and spotting problemsProfiling a dataset is the first thing a professional does with it. You never fully trust a dataset until you have profiled it.
- 17Handling missing and duplicate dataMissing and duplicate data are handled deliberately, not ignored. Deliberate handling beats silently dropping rows.
- 18Reshaping: pivoting and unpivotingPivoting reshapes data into the form your analysis needs. The shape of data determines what analysis is even possible.
- 19Combining sources and reconciling keysCombining sources means reconciling keys that never quite match. Reconciliation is where real-world data work actually happens.
- 20Building a clean, analysis-ready tableThe output is a clean, documented, analysis-ready table. A documented clean table is a gift to your future self.
How the program is taught
The program is built around doing, not watching. Each concept comes with lab briefs and datasets so you write real SQL against real data rather than only reading about it, because querying is a skill that only develops through practice. The recommended path is to work every exercise yourself and to keep rebuilding queries until the patterns, especially joins and window functions, become automatic.
The sequencing is deliberate: structure before syntax, basic queries before analytical ones, clean querying before messy real-world data. Following that order matters, because each stage assumes the last, and skipping ahead is exactly how self-taught analysts end up with gaps. Taking the foundations in order is what makes everything afterward feel solid.
Where these foundations lead
Strong SQL and data fundamentals are the entry ticket to essentially every data role, from analyst to engineer to scientist. Because the skills are universal and durable, they open the widest range of next steps of anything in the track, and they make each of those next steps faster to reach.
Within the journey, this program is the base the others assume. Business intelligence, data science, and the applied finance programs all query and shape data constantly, so the fluency built here pays off immediately and repeatedly. It is the least glamorous program and quite possibly the highest-leverage.
What makes this program different
Most data education starts with a tool and hopes the fundamentals arrive later; this program starts with the fundamentals on purpose. That inversion is its distinguishing feature, and it is why its graduates can reason about unfamiliar situations rather than only following familiar recipes.
The other distinction is its insistence on the unglamorous middle of the work, profiling, cleaning, reconciling, that consumes most of an analyst's real time. Treating that as a core skill rather than a nuisance is what produces analysts whose results can actually be trusted.
What you will be able to do
- Think relationally about how any dataset is structured
- Write SQL from simple filters to window functions confidently
- Profile, clean, and reshape messy real-world data
- Answer business questions directly in SQL
- Build the data habits every later program relies on
Who should take it
- Anyone starting a data career from scratch
- Analysts who learned tools but never the fundamentals
- Professionals moving into a data-facing role
- Teams standardizing on shared SQL and data habits
Tools and how they are used
The program is tool-light on purpose, centering on SQL and relational databases because those transfer everywhere rather than locking you into one product. The goal is understanding that applies across any database or warehouse you later encounter, from a local database to Snowflake or Databricks.
Data profiling and wrangling are taught as habits rather than features of a specific tool, so the skills survive whatever stack an employer uses. This portability is deliberate: foundations should make you adaptable, not dependent on one vendor's buttons.
Common questions and how to prepare
A frequent question is whether SQL is still worth learning deeply in an era of drag-and-drop tools and AI assistants. The answer is emphatically yes: those tools generate and depend on SQL, and being able to read, verify, and fix it is what keeps you in control rather than at the mercy of a black box.
To prepare, the most useful mindset is patience with the fundamentals and a commitment to practicing queries rather than only reading them. No prior experience is required, and comfort with basic spreadsheets is enough to begin; the willingness to build the querying habit is what matters.
How it fits the wider track
This is the on-ramp. Everything else in the Data Science, Analytics & BI track assumes you can query and shape data, so starting here makes the whole journey smoother and faster. Skipping it is possible for those who already have the skills, but for anyone unsure, it is the right first step.
Beyond this track, the fundamentals connect to the firm's broader data-engineering and governance programs, which build on exactly this relational and data-quality thinking. Foundations laid here are foundations for far more than analytics alone.
What you build and keep
Take a messy, multi-table raw dataset and turn it into a clean, documented, analysis-ready table: profile it, fix quality problems, join the sources, and write a set of analytical SQL queries that answer real business questions, with the queries and a short data-quality note as your deliverable.
Format: Self-paced with lab briefs and datasets; the recommended first step in the track.
Run this program for your team
Every program can be delivered as a private, tailored cohort for your organization, aligned to your systems, policies, and career frameworks.
Scope a corporate cohortFrequently asked questions
What is the Data Foundations & SQL program?
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 program assumes.
Who is this program for?
It suits anyone starting a data career from scratch, along with others described on this page.
How is it delivered?
Self-paced with lab briefs and datasets; the recommended first step in the track.
Is there a project or capstone?
Take a messy, multi-table raw dataset and turn it into a clean, documented, analysis-ready table: profile it, fix quality problems, join the sources, and write a set of analytical SQL queries that answer real business questions, with the queries and a short data-quality note as your deliverable.
How does this fit the wider journey?
This is the first program in the journey and the recommended starting point for anyone without a solid SQL base. Every later program, BI, data science, and the applied finance tracks, assumes the querying and data-shaping skills built here.
Can my organization run this as a private cohort?
Yes. Every program can be delivered as a tailored corporate cohort. Contact us to scope it.