Database EngineeringBeginner → AdvancedNEW

SQL & NoSQL Databases: Complete Guide

Master every major database used in production — PostgreSQL, MySQL, SQL Server, MongoDB, Redis, Cassandra, DynamoDB, and cloud-managed services on Azure, AWS, and GCP. Learn when to use SQL vs NoSQL, how to design schemas, optimize queries, and pick the right database for every access pattern.

4.9rating0 students9h total9 lessons

1 Projects

What you'll learn

Understand when to use SQL vs NoSQL — with a clear decision framework

Master PostgreSQL — JSONB, indexing, window functions, partitioning, cloud options

Use MongoDB for flexible document storage with aggregation pipelines

Use Redis as a full data platform — sessions, queues, leaderboards, pub/sub

Design Cassandra tables for time-series and IoT at petabyte scale

Build with DynamoDB single-table design and Global Secondary Indexes

Choose between Azure SQL, Cosmos DB, AWS RDS, DynamoDB, and GCP services

Design normalized schemas, choose the right indexes, and fix slow queries

Build a multi-database e-commerce backend combining all four databases

Final Project

Production multi-database e-commerce backend — PostgreSQL for orders, MongoDB for catalog, Redis for cart, Elasticsearch for search

Course Contents

9 lessons · 9h

SQL vs NoSQL — When to Use Which

PostgreSQL: The Developer's Complete Guide

MySQL, MariaDB & SQL Server

MongoDB: Document Databases Deep Dive

Redis: Beyond Caching

Cassandra & DynamoDB: Wide-Column at Scale

Cloud Databases: Azure, AWS & GCP Map

Database Design, Indexing & Query Optimization

Project: Multi-Database E-commerce Backend

Course Info

Lessons9 lessons

Total time9h

LevelBeginner → Advanced

Students0

Rating4.9 / 5.0

Start Course — Free