Databases & SQL
Beginner · 34 lessons · PostgreSQL, MongoDB, Redis
Query, design and manage databases using real e-commerce data. Every query is tested, every dataset is downloadable. From SQL history to PostgreSQL power features, MongoDB documents, and Redis caching — with fictional brands QuickCart, ShopStream, FreshBasket and NovaPay.
What is a Database?
History, mental model, setup, DDL, DML basics. Primary DB: PostgreSQL.
Querying Data
Reading data — from simple SELECT to window functions. Dataset: ShopStream marketplace.
PostgreSQL Power Features
Production-grade Postgres skills. Dataset: NovaPay payment gateway.
MySQL & SQLite
Other relational databases and migration patterns.
Why NoSQL & MongoDB
Document databases, when and why. Dataset: FreshBasket grocery catalog.
Redis
In-memory data, caching, real-time patterns. Dataset: ShopStream real-time features.
Capstones
End-to-end portfolio projects using all databases.
Ready to go further?
Our full program adds mentorship, real projects, a certificate, and job placement support.