Skip to main content

Databases & SQL

8 Topics • 22 Lessons

A step-by-step introduction to databases and SQL - tables, queries, and CRUD - for people building with AI in automotive.

Course Contents

Start Here

1 lesson

Welcome & How to Use This Course

What a Database Is

3 lessons

Why Not Just Use a Spreadsheet?

Relational Databases, Tables, and the Source of Truth

Check Yourself

Tables, Schema & Keys

3 lessons

Columns, Data Types, and Schema

Primary Keys, Foreign Keys, and a Worked Schema

Check Yourself

SELECT: Reading Data

3 lessons

SELECT and WHERE: Pick and Filter

ORDER BY and LIMIT: Sort and Cap

Check Yourself

Filtering & Aggregating Data

3 lessons

Filtering Rows with WHERE

Aggregating with COUNT, SUM, GROUP BY & HAVING

Check Yourself

Joining Tables

3 lessons

Why Tables Are Split & the INNER JOIN

LEFT JOIN & Reading the Result

Check Yourself

Changing Data: CRUD

3 lessons

Creating Rows with INSERT

Updating and Deleting - Mind the WHERE

Check Yourself

SQL vs NoSQL & In Practice

3 lessons

SQL vs NoSQL, and Migrations

Connecting an App - Credentials & Safe Queries

Check Yourself