Introduction to databases and persistence

The Relational Model

SQL Basics, DDL, and DML

Querying Data

Advanced Concepts

Sqlite

Glossary of Database Terms

Practice

Assignment

• Teachers

Core program

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

1. Warmup: The Todo List.
2. Core: The School Database (Queries & Joins).
3. 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/*

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