How long is SQL and Data for AI?

10 hours of recorded sessions across 5 modules, taken at your own pace. 5 of the modules end in work Nova grades.

Is SQL and Data for AI live or self-paced?

Self-paced. The sessions are recorded by an instructor who does this work, and Nova, Square 1's AI tutor, grades every checkpoint and project against a rubric you can read.

How much does SQL and Data for AI cost?

A$45 for the founding intake, paid once; the standard price is A$90. It is the same price in every country. Founding students keep their founding price on any second programme.

What will I build in SQL and Data for AI?

3 deployed projects: An analytical query set, A modelled schema and A reporting layer. Each is graded against a published rubric and kept on a record an employer can open at /verify.

What skills does SQL and Data for AI teach?

SQL, data modelling and data quality. It prepares you for roles such as Data analyst (entry) and Analytics engineer (entry).

Does SQL and Data for AI guarantee a job?

No. No placement rate is published because there are no graduates to count yet. What you leave with is graded, deployed work on one record an employer can open and run, and a hiring plan you keep with the career agent.

On demandRecorded by an instructor, graded by Nova

SQL and Data for AI

Name: SQL and Data for AI
Price: 45.00 AUD
Availability: PreOrder

Query, shape and check the data your models eat.

SQL and Data for AI is a self-paced online course: 10 hours of recorded sessions across 5 modules, with 5 graded by Nova, Square 1's AI tutor. The founding price is A$45, down from A$90. Start any time and keep your own pace.

Taught with

PostgreSQLPythonpandasJupyter

Not sure it is for you?Take the free Data Science skill check

Module by module

Module 1SQL from the first select120 min · graded
Module 2Joins, aggregates, windows120 min · graded
Module 3Modelling and quality120 min · graded
Module 4Data for ML and RAG120 min · graded
Module 5Project: a reporting layer120 min · graded

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

SQLdata modellingdata quality

1
The recorded sessions
Taught by an instructor, 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.

Select, where, order
Graded queries
Reading a schema

The projects.

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

Project 1
An analytical query set
Using a public retail sales dataset loaded into a database, answer twenty business questions in SQL, from monthly revenue by region to each customer's running total. Joins, group by and window functions do the work; every result is checked against expected answers.
You hand in
- Twenty SQL queries
- Query results
- Notes on tricky cases
The rubric requires
Results match the expected set.
Project 2
A modelled schema
A fictional online bookshop keeps orders, customers and stock in one flat spreadsheet. Model it as tables with proper keys, normalised as far as is practical, and write quality checks that catch bad rows before they reach anything downstream.
You hand in
- Schema definition script
- Quality check queries
- Short design rationale
The rubric requires
The checks catch the seeded bad rows.
Project 3
A reporting layer
Build a reporting layer of views over the bookshop schema that answers the owner's weekly questions, and deploy it on a hosted database. Reports must return correct figures within the time budget, checked against hand-calculated answers.
You hand in
- Reporting views in a repository
- Deployed reporting layer
- Correctness and timing report
The rubric requires
Reports are correct and run within the stated 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 AIExample

Project
An analytical query set
Results match the expected set.
Graded
Project
A modelled schema
The checks catch the seeded bad rows.
Graded
Project
A reporting layer
Reports are correct and run within the stated 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

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. Reserving a spot holds the founding price.

Pre-order

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.

The course booklet

The whole plan on a few pages: the parts, the projects, the gates and the price. We email it to you.

Get the booklet

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.

Questions people ask.

About SQL and Data for AI, answered from the plan on this page.

Founding spots are open. Hold yours.

Recorded by an instructor who does this work, graded by Nova. Spot holders hear the opening date first, and nothing is charged before you confirm.

SQL you can use in any data or AI role
Three graded projects on your record

A$45~~A$90~~