01
Relational DB Fundamentals
// ...Database concepts
Tables & relationsNormalizationKeys
UNITS
11 LESSONS
02
PostgreSQL Setup
// ...Local and cloud setup
Installationpsql CLIGUI tools
03
Schema Design Patterns
// ...Effective data modeling
1:1, 1:N, N:MDenormalizationSoft deletes
04
SQL Queries & Joins
// ...Writing efficient queries
SELECT, INSERT, UPDATEJOIN typesSubqueries
05
Prisma ORM Deep Dive
// ...ORM mastery
Schema syntaxRelationsQuery API
06
Migrations & Seeding
// ...Database versioning
Migration workflowSeed scriptsRollbacks
07
Indexes & Optimization
// ...Query performance
Index typesEXPLAIN ANALYZECommon patterns
08
Transactions
// ...ACID and concurrency
Transaction basicsIsolation levelsDeadlocks
09
Redis Fundamentals
// ...Key-value store basics
Data typesCommandsExpiration
10
Caching Strategies
// ...Application caching
Cache-asideWrite-throughInvalidation
11
Rate Limiting
// ...API protection
Sliding windowToken bucketRedis implementation
PROJECTS
2 BUILDS
URL Shortener
10hDB + cache + rate limiting
PostgresRedisPrisma
REQUIREMENTS
- Shorten URLs
- Analytics
- Rate limiting
- Cache layer
Analytics Engine
8hEvent tracking and aggregation
SQLIndexesPerformance
REQUIREMENTS
- Event ingestion
- Time-series queries
- Dashboard aggregates
INTERACTIVE
2 TOOLS
SQL Query Builder
Visual query composer
20 minERD Designer
Interactive schema designer
20 min