Home / Database

/database · TRACK

The Database track.

SQL, NoSQL, database design, indexing, transactions and query optimisation. Built as a curriculum — 17 chapters, recommended spine if you're new, side-quests when you're ready.

⏱ ~16h 13m total 41 beginner · 55 intermediate · 43 advanced 📚 139 topics

You'll cover: SQL Basics, SQL Advanced, NoSQL — then go deeper.

Start here: Introduction to SQL → SQL CREATE TABLE and Data Types → SQL INSERT UPDATE DELETE →

Continue from Introduction to SQL → Complete Database guide

Your progress 0 / 139 topics

Read

Chapters done

Time invested

🔥 Start your streak today

CURRICULUM

17 chapters · 139 topics

SQL Basics

SPINEBeginner

16 topics · ~1h 52m · 0/16 read

Introduction to SQL SQL CREATE TABLE and Data Types SQL INSERT UPDATE DELETE SQL SELECT Statement SQL WHERE Clause and Filtering+11 more

SQL Advanced

SPINEAdvanced

16 topics · ~1h 52m · 0/16 read

SQL Indexes SQL Views SQL Stored Procedures SQL Triggers SQL Transactions and ACID+11 more

NoSQL

SPINEIntermediate

15 topics · ~1h 45m · 0/15 read

Introduction to NoSQL Databases MongoDB Basics MongoDB CRUD Operations MongoDB Aggregation Pipeline MongoDB Indexing+10 more

Database Design

SPINEAdvanced

16 topics · ~1h 52m · 0/16 read

Database Normalization 1NF 2NF 3NF Explained ER Diagrams Primary Key and Foreign Key Database Relationships+11 more

ORM

SPINEIntermediate

7 topics · ~49m · 0/7 read

What is an ORM Hibernate ORM Basics JPA — Java Persistence API Sequelize ORM for Node.js Prisma ORM Basics+2 more

MySQL & PostgreSQL

SPINEAdvanced

13 topics · ~1h 31m · 0/13 read

MySQL vs PostgreSQL MySQL Installation and Setup PostgreSQL Installation and Setup MySQL Stored Functions PostgreSQL JSON Support+8 more

PL/SQL

SPINEIntermediate

27 topics · ~3h 9m · 0/27 read

Introduction to PL/SQL PL/SQL Variables, Constants and Data Types PL/SQL Control Structures — IF, LOOP, WHILE PL/SQL Cursors Explained PL/SQL Stored Procedures and Functions+22 more

Cassandra

SPINEBeginner

4 topics · ~28m · 0/4 read

Introduction to Apache Cassandra Cassandra Data Model and Keyspaces CQL — Cassandra Query Language Basics Cassandra vs MongoDB — When to Use Which

Neo4j

SPINEBeginner

3 topics · ~21m · 0/3 read

Introduction to Graph Databases and Neo4j Cypher Query Language Basics Neo4j Use Cases — When to Use a Graph Database

Vectors

SPINEIntermediate

1 topics · ~7m · 0/1 read

pgvector Postgres Vector Search Guide

OLAP

Beginner

1 topics · ~7m · 0/1 read

DuckDB Embedded Analytics

SQL

Intermediate

3 topics · ~21m · 0/3 read

SQL UPDATE from SELECT Statement SQL ALTER TABLE Add Column SQL Top N per Group Greatest N per Group

PostgreSQL

Intermediate

3 topics · ~21m · 0/3 read

PostgreSQL psql Introspection and Top N per Group Postgres Relation Does Not Exist Fix Postgres Too Many Clients Fix

MySQL

Beginner

7 topics · ~49m · 0/7 read

MySQL 1045 Access Denied Fix MySQL Lock Wait Timeout Fix MySQL Incorrect String Value Fix MySQL Too Many Connections Fix MySQL 1062 Duplicate Entry Fix+2 more

Oracle

Beginner

5 topics · ~35m · 0/5 read

ORA-00904 Invalid Identifier Fix ORA-01722 Invalid Number Fix ORA-01400 Cannot Insert NULL Fix ORA-02291 Integrity Constraint Fix ORA-01555 Snapshot Too Old Fix

MongoDB

Beginner

1 topics · ~7m · 0/1 read

MongoDB E11000 Duplicate Key Fix

Redis

Intermediate

1 topics · ~7m · 0/1 read

Redis MISCONF RDB Snapshot Fix

The Database track.

Database interview prep

17 chapters · 139 topics

SQL Basics

SQL Advanced

NoSQL

Database Design

ORM

MySQL & PostgreSQL

PL/SQL

Cassandra

Neo4j

Vectors

OLAP

SQL

PostgreSQL

MySQL

Oracle

MongoDB

Redis

SQL Basics