learn-sql - dksingh

Advanced SQL

Database, Analytics & DBA Mastery

MODULE 1

Database Fundamentals

RDBMS

DBMS vs RDBMS
Relational model
Keys
Schema

MODULE 2

SQL Basics

DDL

CREATE
Constraints
Types

MODULE 3

DML

Data

INSERT
UPDATE
DELETE

MODULE 4

SELECT

Queries

WHERE
ORDER
LIMIT

MODULE 5

Functions

Expressions

String
Date
CASE

MODULE 6

Joins

Relations

INNER
LEFT
SELF

MODULE 7

Aggregation

GROUP

COUNT
GROUP BY
HAVING

MODULE 8

Subqueries

Nested

Scalar
Correlated
EXISTS

MODULE 9

Set Ops

UNION

UNION
INTERSECT
EXCEPT

MODULE 10

Views

Virtual

CREATE VIEW
Materialized
Security

MODULE 11

Indexes

Performance

B-tree
Composite
Plans

MODULE 12

Transactions

ACID

COMMIT
ROLLBACK
Isolation

MODULE 13

Constraints

Integrity

PK/FK
CHECK
Cascade

MODULE 14

Procedures

SP

Stored proc
Functions
Flow

MODULE 15

Triggers

Events

BEFORE
AFTER
Audit

MODULE 16

Advanced Queries

Window

Window
Ranking
CTE

MODULE 17

CTE

Recursive

Recursive
Hierarchy
Graphs

MODULE 18

Warehousing

OLAP

Star
Fact
BI

MODULE 19

Design

Schema

Normalization
Keys
Partition

MODULE 20

Big Data SQL

Distributed

Sharding
Columnar
Lakes

MODULE 21

DBA

Admin

Backup
Replication
HA

MODULE 22

Security

Roles

Roles
RLS
Audit

MODULE 23

Tuning

Perf

Plans
Stats
Cache

MODULE 24

Internals

Engine

Optimizer
MVCC
Storage

MODULE 25

Projects

SQL

Warehouse
Analytics
Optimization

MODULE 26

Career

Paths

SQL Dev
Analyst
DBA