Learn SQL - Master SQL Fundamentals to Advanced Techniques
From your first SELECT to recursive CTEs and window functions — structured, practical, and built for real-world use.
Everything you need
Oracle SQL
From SELECT basics to performance tuning — the complete Oracle SQL path
Foundations
Introduction to SQL, basic SELECT queries, filtering with WHERE, and essential operators.
Core Queries
Aggregate functions, joins, and subqueries — the building blocks of every SQL statement.
Data Management
Constraints, DDL, DML, views — defining and manipulating the structure of your database.
Indexes & Optimization
Index types, query plans, hints, and strategies for writing high-performance SQL.
Advanced SQL
Window functions, CTEs, stored procedures, performance tuning, and interview mastery.
PostgreSQL 🐘
JSONB, MVCC, index types, PL/pgSQL — deep PostgreSQL mastery
Getting Started
PostgreSQL intro, psql CLI, and the full range of native data types including arrays.
Querying & Analytics
SELECT with LATERAL joins, subqueries, CTEs, window functions, and set operations.
Data Manipulation
DML with RETURNING, UPSERT (ON CONFLICT), transactions, schemas, and sequences.
Database Design
Index types (B-Tree, GIN, BRIN), EXPLAIN plans, views, and materialized views.
Performance & Internals
VACUUM, ANALYZE, JSONB operations, arrays, triggers, and PL/pgSQL procedures.
PL/SQL 🔶
Oracle's procedural extension — packages, cursors, triggers, BULK COLLECT
PL/SQL Basics
Block structure, variables, constants, conditional logic, and loop constructs.
Cursors & SQL
Embedding SQL, implicit cursors, explicit cursors with FOR UPDATE, and REF cursors.
Collections & Bulk Ops
Records, collections (nested tables, varrays), BULK COLLECT, and FORALL for performance.
Modular Code
Stored procedures, functions, packages, and structured exception handling.
Advanced PL/SQL
Triggers, dynamic SQL, autonomous transactions, object types, pipelined functions, and built-in packages.
Code Management & Security
Invoker vs definer rights (AUTHID), conditional compilation, compiler warnings, dependency management, and code wrapping.
SQL Server 🟦
Microsoft T-SQL — APPLY, MERGE, CTEs, execution plans, and more
T-SQL Foundations
SQL Server intro, SSMS tooling, data types, SELECT with TOP and OFFSET-FETCH.
Querying & Analytical SQL
Joins with APPLY, subqueries, CTEs, window functions, and set operations.
Data Operations
DML with OUTPUT, MERGE statement, transactions, schemas, constraints, and IDENTITY.
Programmability
Variables, TRY/CATCH, stored procedures, UDFs, triggers, views, and JSON/XML.
Performance & Features
Index strategies, execution plans, query tuning, statistics, and maintenance tasks.
SQL*Loader 📦
Oracle bulk-load utility — control files, direct path, LOBs, external tables
Getting Started
Architecture, the sqlldr CLI, control file structure, and LOAD DATA basics.
Loading Techniques
Field specs, record formats, conventional path, and direct path loading modes.
Advanced Loading
Load modes, CSV/TSV, fixed-width, date formats, LOBs, WHEN clause, and multi-table loads.
Optimization & Integration
NULLIF/FILLER, SQL functions, BAD/DISCARD files, performance tuning, and external tables.
IBM DB2 🔷
Enterprise SQL on IBM DB2 — OLAP, XML, optimization, and administration
DB2 Fundamentals
DB2 architecture, data types, DDL, and essential SELECT query patterns.
Advanced Queries
Joins, subqueries, CTEs, window functions, OLAP extensions, and grouping sets.
Programmability
DML operations, stored procedures, user-defined functions, triggers, and XML support.
Performance & Admin
Indexes, EXPLAIN, RUNSTATS, transactions, security, partitioning, and DB2 cheatsheet.
Ready to start?
Pick up from the beginning or jump to any topic