SQL Roadmap
Step by step guide to becoming an Android developer.
Ask AI about SQL Roadmap
Legend
Propose
Alternatives
Options
1 SQL Basics
What is SQL?
SQL vs NoSQL
Setup a DBMS
Basic Data Types
2 DDL - Data Definition Language
CREATE DATABASE / TABLE
ALTER TABLE
DROP / TRUNCATE TABLE
3 DML - Data Manipulation Language
INSERT INTO
UPDATE
DELETE
4 DQL - Basic Data Querying
SELECT, FROM
WHERE Clause
ORDER BY
LIMIT / TOP
DISTINCT
5 Joins & Unions
INNER JOIN
LEFT, RIGHT, FULL JOIN
UNION and UNION ALL
6 Subqueries & CTEs
Subqueries
Correlated Subqueries
Common Table Expressions
Recursive CTEs
7 SQL Functions
Aggregate Functions
GROUP BY and HAVING
String Functions
Numeric Functions
Date Functions
8 Indexes & Constraints
What are Indexes?
Types of Constraints
9 Transactions & Concurrency
ACID Properties
BEGIN, COMMIT, ROLLBACK
Isolation Levels
10 Window Functions
OVER() Clause
PARTITION BY
ROW_NUMBER, RANK
LAG() and LEAD()
11 Stored Procedures & Triggers
Stored Procedures
User-Defined Functions
Triggers
12 Performance Tuning
Execution Plan
Query Optimization
Using EXPLAIN
Denormalization