Логотип Workflow

Databases

SQL and Databases

Practical SQL course: relational model, ER design, query composition, joins, aggregations, indexing, normalization, transactions, isolation levels, and query-plan optimization.

Difficulty
Beginner to Intermediate
SQL and Databases

Blocks

Learning path

Jump straight into any module. Each card brings you to the selected block. Each article and block will be updated as relevant information and technologies become available.

STEP 1

Stage 1: Relational Model Fundamentals

start
STEP 2

Stage 2: ER Diagrams Basics

start
STEP 3

Stage 3: SELECT, Filtering, and Sorting

start
STEP 4

Stage 4: JOIN Fundamentals

start
STEP 5

Stage 5: GROUP BY and HAVING

start
STEP 6

Stage 6: Indexes and Access Patterns

start
STEP 7

Stage 7: Normalization (1NF, 2NF, 3NF)

start
STEP 8

Stage 8: Transactions and ACID

start
STEP 9

Stage 9: Isolation Levels and Concurrency

start
STEP 10

Stage 10: EXPLAIN and Query Optimization

start