Chapter 1

Database Management Systems (DBMS)

Relational data model concepts (Tables, Attributes, Tuples)

medium • 1 min read

Entity-Relationship (ER) diagrams and modeling

medium • 2 min read

Primary keys, Foreign keys, and Integrity constraints

medium • 3 min read

Normalization (1NF, 2NF, 3NF, BCNF) and Denormalization

medium • 4 min read

RDBMS architectures and ACID properties

medium • 5 min read

Chapter 2

SQL Fundamentals

Data Definition Language (CREATE, ALTER, DROP)

medium • 1 min read

Data Manipulation Language (INSERT, UPDATE, DELETE)

medium • 2 min read

Basic SELECT statements and filtering (WHERE, LIKE, IN)

medium • 3 min read

Sorting and limiting results (ORDER BY, LIMIT)

medium • 4 min read

Handling NULL values and built-in functions

medium • 5 min read

Chapter 3

Advanced SQL Queries

Aggregate functions (SUM, AVG, COUNT, MIN, MAX)

medium • 1 min read

Grouping data (GROUP BY, HAVING)

medium • 2 min read

Table joins (INNER, LEFT, RIGHT, FULL OUTER, CROSS)

medium • 3 min read

Subqueries and Correlated Subqueries

medium • 4 min read

Set operations (UNION, INTERSECT, EXCEPT)

medium • 5 min read

Chapter 4

SQL for Data Analysis

Window functions (ROW_NUMBER, RANK, DENSE_RANK)

medium • 1 min read

Aggregate window functions and moving averages

medium • 2 min read

Common Table Expressions (CTEs) using WITH clause

medium • 3 min read

String manipulation and date/time functions

medium • 4 min read

Pivoting Data and Case Statements

medium • 5 min read

Chapter 5

Data Warehousing and NoSQL

OLTP versus OLAP systems

medium • 1 min read

Data Warehouse architecture (Star and Snowflake schemas)

medium • 2 min read

ETL (Extract, Transform, Load) pipelines

medium • 3 min read

Introduction to NoSQL databases (Document, Key-Value, Graph)

medium • 4 min read

Overview of MongoDB and JSON document structures

medium • 5 min read