Beginner 2h estimated 4 modules 13 lessons

SQL Basics

Learn to read and modify data with SQL — SELECT, WHERE, sorting, aggregates, GROUP BY, JOINs, and INSERT/UPDATE/DELETE — starting from installing SQLite on your own computer.

Skills covered

SQLDatabasesSQLiteQueryingJoins

What you'll learn

Install and run SQLite on your own computer

Write SELECT queries with WHERE filtering

Sort results and use aggregate functions (COUNT, SUM, AVG)

Group data with GROUP BY and HAVING

Combine tables using INNER JOIN and LEFT JOIN

Insert, update, and delete data safely

Create a table with CREATE TABLE

Start course

Getting Started with SQL

4 lessons

Sorting, Aggregating & Grouping

3 lessons

Combining Tables

3 lessons

Modifying Data

3 lessons