SQL and Data for AI

Query, shape and check the data your models eat.

recorded hours: 10
modules, in order: 5
deployed projects: 3
graded checkpoints: 5

Who it is for, and what you receive.

Beginners who want the SQL and data skills every data and AI role assumes.

Before you start

None.

Skills

SQL
data modelling
data quality

1
The recorded sessions
Taught by an instructor who does the work, taken in order at your own pace, yours for twelve months.
2
Graded work after every module
Exercises and projects marked by Nova against a rubric you can read, with what you did well and what to fix.
3
The projects
Deployed and graded, each one on your record with its repository.
4
Your hiring plan
The same six-part plan the bootcamps use, run with the career agent.
5
The record and the certificate
Every grade at square1ai.com/u/{handle}; a credential ID that resolves at square1ai.com/verify.
6
Nova as your tutor
Help that is about your actual work, because it has read all of it.

The content plan, module by module.

10 recorded hours from an instructor, taken in order at your own pace. Nova grades the work at the end of each module.

1
SQL from the first select
- Select, where, order
- Graded queries
- Reading a schema
Graded
Queries graded against expected results
120 min
2
Joins, aggregates, windows
- Joins
- Group by
- Window functions
Graded
An analytical query set
120 min
3
Modelling and quality
- Tables and keys
- Normalisation, practically
- Quality checks
Graded
A modelled schema with checks
120 min
4
Data for ML and RAG
- Training sets from SQL
- Retrieval corpora
- Leakage
Graded
A training or retrieval dataset built with SQL
120 min
5
Project: a reporting layer
- Design
- Build
- Deploy
Graded
The layer, deployed
120 min

The projects.

Each is deployed and graded by Nova against a rubric you can read before you start.

1
An analytical query set
Twenty questions answered in SQL.
You hand in
- Queries
- Results
The rubric requires
Results match the expected set.
2
A modelled schema
A schema with checks.
You hand in
- Schema
- Checks
The rubric requires
Checks catch seeded bad rows.
3
A reporting layer
Reports over the schema, deployed.
You hand in
- Reporting layer
- Deployment
The rubric requires
Reports correct and within a time budget.

What you can do at the end.

SQL you can use in any data or AI role, and three graded projects on your record.

1
Write SQL from a first select to joins, aggregates and windows.
2
Model a schema and check data quality.
3
Build datasets for machine learning and retrieval.
4
Deploy a reporting layer.

Roles this prepares you for

Data analyst (entry)
Analytics engineer (entry)

No placement rate is shown, because there are no graduates to count yet. The roles above are what the projects are built for.

Your record at the end.

Every exercise and project is graded by Nova against a rubric you can read, and every grade is kept on one page an employer can open and run. This is what the programme writes to it.

Graded, line by line: Nova reads every submission against the brief and the rubric and returns a score, what you did well and what to fix.
Module by module: Each module ends in graded work; the next opens when you are ready, on your own schedule.
Nova remembers: Help is about your actual work, because the tutor has every submission and every failed exercise of yours.
One page an employer can run: Every grade and project at /verify. An employer opens it and runs the code.

Record, SQL and Data for AI

Example

Project
An analytical query set
Results match the expected set.
Graded
Project
A modelled schema
Checks catch seeded bad rows.
Graded
Project
A reporting layer
Reports correct and within a time budget.
Graded
Every module
5 graded checkpoints
Each module ends in work Nova grades line by line against a rubric you can read.
Graded
After
Your hiring plan
Target roles, the gap map, the proof to send, weekly actions and an interview log.
Kept

The entries, not the grades: those are yours to earn. The page lives at /verify and an employer needs no account to open it.

5 entries, at your own pace. One email when this course opens.

How we help you find a job.

Proof, not a certificate: the projects you deployed are the thing you show, and the tools below are yours to use.

1
Your hiring plan
The same six-part plan the bootcamps use: target roles, the gap map, the proof to send, weekly actions, an interview log, the outcome. You run it with the career agent.
2
A record an employer can run
Your graded projects on /verify. An employer opens it and runs the code.
3
The career agent
Paste a real job posting at /career and it maps the role to your graded work and what to do next.
4
The roles directory
Every role we prepare people for, what it pays and what it asks, at /roles.
5
A path to the live cohort
If you want the instructor, the gates and the hiring sprint, the bootcamp on the same subject is one waitlist away.

One email when this course opens.

Recorded by an instructor who does this work, graded by Nova. The waitlist hears the date and the price first, and nothing is charged before it exists.