All Tracks
🗄️

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.

34 of 34 lessons available100%
A

What is a Database?

History, mental model, setup, DDL, DML basics. Primary DB: PostgreSQL.

B

Querying Data

Reading data — from simple SELECT to window functions. Dataset: ShopStream marketplace.

C

PostgreSQL Power Features

Production-grade Postgres skills. Dataset: NovaPay payment gateway.

D

MySQL & SQLite

Other relational databases and migration patterns.

E

Why NoSQL & MongoDB

Document databases, when and why. Dataset: FreshBasket grocery catalog.

F

Redis

In-memory data, caching, real-time patterns. Dataset: ShopStream real-time features.

G

Capstones

End-to-end portfolio projects using all databases.

Extras

Ready to go further?

Our full program adds mentorship, real projects, a certificate, and job placement support.

Apply Now →