← All 186 courses
AI-105 AI & Data

SQL & Data Foundations for AI Teams

Give AI practitioners production-grade SQL: modeling, querying, joining and optimizing against real warehouse-scale tables, plus the data-contract thinking that keeps ML pipelines from silently breaking. Closes with feature-extraction queries feeding a live model.

B2Foundation
5modules
34skill atoms
5role journeys
Curriculum

What this course covers.

5 modules, 34 named skill atoms. Expand any module to see them.

1Relational Thinking7 skill atoms
schemaskeysnormalization vs analytics shapesprimary & foreign keysstar schemafact vs dimensiongrain definition
2Query Craft7 skill atoms
joinsaggregationCTEswindow functionsleft vs inner semanticsROW_NUMBER & LAGNULL-safe comparisons
3Performance Basics7 skill atoms
indexesquery plansanti-patternsEXPLAIN readingcovering indexesfunction-wrapped predicatespartition pruning
4Data Contracts7 skill atoms
schema evolutionfreshnessquality gatesbackward-compatible columnsstaleness SLAnot-null & range assertionsrow-count reconciliation
5SQL → Features Lab6 skill atoms
feature queriespoint-in-time correctnessas-of joinsrolling aggregates in SQLlabel leakage checksfeature table materialization
Where it fits

AI-105 in the role journeys.

This course appears in 5 of our 45 role journeys. Here is what a learner takes immediately before and after it in each.

Data Scientist

Foundation stage
AI-104AI-105AI-101

Data Platform Engineer

Foundation stage
starts hereAI-105CL-101

Data Engineer

Foundation stage
AI-102AI-105AI-104

Data / BI Analyst

Foundation stage
AI-101AI-105AI-104

Data Cloud Engineer (Snowflake)

Foundation stage
CL-101AI-105CL-224

Roles this course serves

The capability ladder

This course is authored to band B2.

Every course we run is written to one rung of the CASI ladder, so a plan can be assembled to take a team from where they are to where they need to be.

What do B1–B6 mean?The CASI Capability Ladder — click to expand

Every course targets a band on the CASI Capability Ladder — our six-band proficiency scale, anchored to open standards (O*NET, ESCO, NICE, NIST AI RMF, Bloom's). A band tells you how deep a course goes, and what evidence proves it.

What the learner can doTypical evidence
B1
AwareUnderstands concepts and vocabulary; uses tools with guidance
Knowledge checks
B2
FoundationPerforms standard tasks correctly in familiar contexts
Guided labs, autograded exercises
B3
PractitionerDelivers complete pieces of work independently
Scenario labs, proctored hands-on exams
B4
ProfessionalHandles production-grade complexity, trade-offs and failure modes
Break-fix drills, design defenses
B5
AdvancedEngineers systems end-to-end under constraints; leads others
Rubric-scored capstones, vivas
B6
ExpertSets direction; recognised authority across teams
Portfolio + panel evaluation

A note on B6. Courses in this catalog target B1–B5. B6 is not taught — it is recognised, through a portfolio and a panel, once someone is setting direction for others. Every journey here is built to land a learner at B5.

Next step

Run AI-105 for your team.

This course runs at several lengths depending on how deep you need to go and how much of it your people already have. Tell us who is being trained and we will scope it.

Add it to a training plan Talk to our team Check your team’s level free