Learn. Build. Master.

QUICK START:HTML CSS JavaScript TypeScript Python SQL React Next.js Node.js DSA System Design DevOps Cybersecurity AI / ML

BeginnerDatabases

~24 Hours 11 Lessons100% Free

SQL & Relational Database Engineering

Master relational databases, complex queries, JOINs, indexing, transactions, and performance tuning.

Comprehensive relational database engineering: schema design, SQL CRUD operations, INNER/LEFT/FULL JOINs, aggregations, subqueries, Common Table Expressions (CTEs), ACID transactions, B-Tree indexes, and query execution plans.

What You Will Learn

Relational Schema Modeling (PK/FK Constraints, Normalization)
High-Performance SQL Queries (JOINs, GROUP BY, HAVING)
Common Table Expressions (WITH queries) & Window Functions
ACID Transactions & Concurrency Isolation Levels
Indexing Strategies (B-Tree, Hash, GIN) & EXPLAIN ANALYZE

Prerequisites & Environment

Basic data concept familiarity.

Complete Course Curriculum (11 Modules)

11 In-Depth Lessons

Module 01

Module 1: Relational Database Concepts & ACID

1 Lessons

RDBMS architecture, tables, columns, rows, primary keys, and ACID guarantees.

1.1Relational Database Fundamentals & SQL

Module 02

Module 2: Data Definition (CREATE, ALTER, DROP) & Data Types

1 Lessons

Table schema creation, column data types (VARCHAR, UUID, TIMESTAMP), and constraints.

2.1DDL: CREATE TABLE, Constraints & Data Types

Module 03

Module 3: Data Manipulation (INSERT, UPDATE, DELETE)

1 Lessons

Modifying records, batch insertions, UPSERT (ON CONFLICT), and DELETE safety.

3.1DML: INSERT, UPDATE, DELETE & UPSERT

Module 04

Module 4: Querying Data with SELECT, WHERE & ORDER BY

1 Lessons

Filtering with AND/OR, LIKE/ILIKE, IN, BETWEEN, NULL handling (IS NULL), and pagination.

4.1Advanced WHERE Filters, Pattern Matching & Pagination

Module 05

Module 5: Aggregate Functions & GROUP BY / HAVING

1 Lessons

COUNT, SUM, AVG, MIN, MAX, GROUP BY multi-column, and HAVING post-aggregation filters.

5.1Aggregate Functions (COUNT, SUM, AVG) & HAVING

Module 06

Module 6: Relational JOINs (INNER, LEFT, RIGHT, FULL)

1 Lessons

Combining normalized tables, foreign key matching, self joins, and cross joins.

6.1Relational JOINs (INNER, LEFT, RIGHT, FULL)

Module 07

Module 7: Subqueries & Common Table Expressions (CTEs)

1 Lessons

Subqueries in WHERE/FROM, correlated subqueries, and readable WITH clauses (CTEs).

7.1Common Table Expressions (WITH) & Subqueries

Module 08

Module 8: Window Functions (ROW_NUMBER, RANK, LEAD, LAG)

1 Lessons

OVER (PARTITION BY ... ORDER BY ...), ROW_NUMBER, DENSE_RANK, LEAD, LAG, and running totals.

8.1Window Functions (ROW_NUMBER, RANK, LEAD, LAG)

Module 09

Module 9: Indexing Strategies (B-Tree, Hash, GIN) & EXPLAIN

1 Lessons

B-Tree index structure, composite indexes, GIN index for JSONB, and reading EXPLAIN ANALYZE.

9.1B-Tree Indexes & Query Execution Plans (EXPLAIN ANALYZE)

Module 10

Module 10: Transactions, Isolation Levels & Row Locks

1 Lessons

BEGIN, COMMIT, ROLLBACK, dirty reads, isolation levels (Read Committed, Serializable), and row locking.

10.1ACID Transactions, Row Locks & Isolation Levels

Module 11

Module 11: Database Normalization & Schema Architecture

1 Lessons

1NF, 2NF, 3NF normalization, foreign keys, junction tables, and deliberate denormalization.

11.1Database Normalization (1NF, 2NF, 3NF) & Schema Design