Teachers

Week 12 Overview

This course is designed to demystify databases for developers who are comfortable with code but new to persistence and SQL. We focus on Relational Databases as they are the foundation of most industrial software.

The curriculum is split into the following modules:

Introduction to databases and persistence

What are databases?
Persistence vs. Memory.
Types of Database Systems (Relational, Document, Graph, etc.).

The Relational Model

Tables, Rows, and Columns.
Primary and Foreign Keys.
Relationships (1:1, 1:N, N:M).
Normalization (Why we split data).

SQL Basics, DDL and DML

What is SQL?
Creating Tables (DDL).
Inserting, Updating, and Deleting Data (DML).
Basic SELECT.

Querying Data

Sorting (ORDER BY) and Limiting (LIMIT).
Aggregating (COUNT, SUM, AVG).
**JOINS** (Inner vs. Left).

Advanced Concepts

Transactions (ACID compliance).
Indexes (Performance).
Views.
Debugging (EXPLAIN QUERY PLAN).

SQLite Specifics

Serverless architecture.
The sqlite3 CLI tool.
Dot commands (.tables, .schema).

Practice

Warmup: The Todo List.
Core: The School Database (Queries & Joins).
Design: The Recipe App (Many-to-Many Schema Design).

External Resources

Documentation & References

SQLite Documentation - The official manual.
The wikipedia page on SQL
SQL Zoo - Interactive SQL exercises.
Use The Index, Luke - Everything you need to know about database performance and indexing. If you want to geek out on databases this is for you. Beyond the very basics that primary keys are automatically

The HackYourFuture curriculum is licensed under CC BY-NC-SA 4.0 *https://hackyourfuture.net/*

CC BY-NC-SA 4.0 Icons

Built with ❤️ by the HackYourFuture community · Thank you, contributors

Found a mistake or have a suggestion? Let us know in the feedback form.