Databases & Storagev1.0.0
SQL & Relational Databases
Relational Schemas, Window Functions & Indexing
Comprehensive relational database engineering: 3NF schema design, complex joins, CTEs, Window Functions, B-Tree indexes, and ACID transactions.
#sql#rdbms#postgres#sqlite#indexing#transactions#ctes
Initialize Workspace
$ trak init db/sql
Creates ./learn-sql in current directory
Curriculum Modules (18)
Module 001 of 18
Setup & Relational Foundations
RDBMS architecture, Tables, Rows, Columns, Primary & Foreign Keys
Topics Covered in this Module:
rdbmsprimary-keyforeign-key
Generated File Structure:
├── 00-setup---relational-foundations
├── README.md (Comprehensive Guide & Cheatsheet)
└── main (Hands-on Source Code Exercises)