🔄 SQL & Databases

SQL & Database Management

From SELECT to stored procedures. Master relational databases, write complex analytics queries, design normalized schemas, and tune performance — fully hands-on.

15

Lessons

2

Projects

20h

Content

Beginner

Starting Level

Advanced

Ending Level

Phase 1

Foundation

Database fundamentals, SQL syntax, and core data manipulation

Introduction to Databases

Filtering & Sorting

Data Types & CREATE TABLE

Phase 2

Querying

Aggregation, grouping, joins, and multi-table queries

Aggregation & GROUP BY

JOINs — INNER, LEFT, RIGHT

Advanced JOINs & UNION

INSERT, UPDATE & DELETE

Phase 3

Advanced SQL

Subqueries, CTEs, window functions, and complex analytics

Subqueries & Nested Queries

CTEs & WITH Clause

Window Functions

Phase 4

Design & Performance

Schema design, normalization, indexes, views, and stored procedures

Database Design & ERDs

Normalization: 1NF, 2NF, 3NF

Indexes, Views & Performance

Stored Procedures, Functions & Transactions

Projects

Build Real Projects

Portfolio-ready projects applying everything you've learned

School Database Analytics

PROJECTINTERMEDIATE

E-Commerce Database

🕑 90-120 min

PROJECTADVANCED

What You'll Be Able to Do

Write complex SELECT queries with multiple JOINs

Use window functions for rankings and running totals

Design normalized databases with ERDs

Build CTEs for readable, maintainable analytics

Tune query performance with EXPLAIN and indexes

Create views and stored procedures

Write ACID-compliant transactions

Model one-to-many and many-to-many relationships

Apply 1NF, 2NF, and 3NF normalization rules

Build a portfolio-ready analytics project