Databases

Learn SQL and Drizzle ORM. You'll go from SELECT queries to full relational schemas, running real queries against a real SQLite database right in the browser. Follow the ideas in small steps: first understand the concept, then practice it in the browser, and finally connect it to a realistic coding problem. Each lesson builds on the previous one so the track becomes a skill you can explain and use, not just a list of terms.

180 interactive lessons across 6 units · 36+ hours · beginner level

What you will learn

Build practical skills in SQL, SQLite, Drizzle ORM, Databases through browser-based coding exercises, guided feedback, unit quizzes, a debugging challenge, and a final project.

Course access

Unit 1, including its first 30 lessons and unit quiz, is free. The remaining 5 units require a CodeLearning365 Pro subscription.

View Pro access options

Databases curriculum

The curriculum progresses from foundations to applied practice and mastery. Representative topics from every unit are listed below.

Unit 1: Foundations

30 lessons covering topics such as Why Databases?, CREATE TABLE & Data Types, INSERT INTO — Adding Rows, SELECT & WHERE — Filtering Rows, UPDATE & DELETE.

  • Why Databases?
  • CREATE TABLE & Data Types
  • INSERT INTO — Adding Rows
  • SELECT & WHERE — Filtering Rows
  • UPDATE & DELETE

Unit 2: Core Concepts

30 lessons covering topics such as Power Up 031: Subqueries, Power Up 032: Indexes — Making Queries Fast, Power Up 033: Foreign Keys & Relationships, Power Up 034: Transactions — All or Nothing, Power Up 035: Drizzle ORM — Setup & Schema.

  • Power Up 031: Subqueries
  • Power Up 032: Indexes — Making Queries Fast
  • Power Up 033: Foreign Keys & Relationships
  • Power Up 034: Transactions — All or Nothing
  • Power Up 035: Drizzle ORM — Setup & Schema

Unit 3: Building Skills

30 lessons covering topics such as Power Up 061: Why Databases?, Power Up 062: CREATE TABLE & Data Types, Power Up 063: INSERT INTO — Adding Rows, Power Up 064: SELECT & WHERE — Filtering Rows, Power Up 065: UPDATE & DELETE.

  • Power Up 061: Why Databases?
  • Power Up 062: CREATE TABLE & Data Types
  • Power Up 063: INSERT INTO — Adding Rows
  • Power Up 064: SELECT & WHERE — Filtering Rows
  • Power Up 065: UPDATE & DELETE

Unit 4: Applied Practice

30 lessons covering topics such as Power Up 091: Subqueries, Power Up 092: Indexes — Making Queries Fast, Power Up 093: Foreign Keys & Relationships, Power Up 094: Transactions — All or Nothing, Power Up 095: Drizzle ORM — Setup & Schema.

  • Power Up 091: Subqueries
  • Power Up 092: Indexes — Making Queries Fast
  • Power Up 093: Foreign Keys & Relationships
  • Power Up 094: Transactions — All or Nothing
  • Power Up 095: Drizzle ORM — Setup & Schema

Unit 5: Projects

30 lessons covering topics such as Power Up 121: Why Databases?, Power Up 122: CREATE TABLE & Data Types, Power Up 123: INSERT INTO — Adding Rows, Power Up 124: SELECT & WHERE — Filtering Rows, Power Up 125: UPDATE & DELETE.

  • Power Up 121: Why Databases?
  • Power Up 122: CREATE TABLE & Data Types
  • Power Up 123: INSERT INTO — Adding Rows
  • Power Up 124: SELECT & WHERE — Filtering Rows
  • Power Up 125: UPDATE & DELETE

Unit 6: Mastery

30 lessons covering topics such as Power Up 151: Subqueries, Power Up 152: Indexes — Making Queries Fast, Power Up 153: Foreign Keys & Relationships, Power Up 154: Transactions — All or Nothing, Power Up 155: Drizzle ORM — Setup & Schema.

  • Power Up 151: Subqueries
  • Power Up 152: Indexes — Making Queries Fast
  • Power Up 153: Foreign Keys & Relationships
  • Power Up 154: Transactions — All or Nothing
  • Power Up 155: Drizzle ORM — Setup & Schema

Compare all coding tracks