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

Блоки

Учебный путь

Перейдите сразу к нужному модулю. Каждая карточка ведет к выбранному блоку. Каждая статья и блок будет обновляться по мере выхода актуальной информации и технологий

STEP 1

SQL and Databases

Учебный путь

Stage 1: Relational Model Fundamentals

Stage 2: ER Diagrams Basics

Stage 3: SELECT, Filtering, and Sorting

Stage 4: JOIN Fundamentals

Stage 5: GROUP BY and HAVING

Stage 6: Indexes and Access Patterns

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

Stage 8: Transactions and ACID

Stage 9: Isolation Levels and Concurrency

Stage 10: EXPLAIN and Query Optimization