Premium
SQL from Zero → Analyst
Complete path from SELECT basics to window functions. Preparation for data analyst role.
57 tasks~20 h6 modules
Structured paths from beginner to advanced — pick the track for your role, clear modules in order, stack Power.
Complete path from SELECT basics to window functions. Preparation for data analyst role.
SQL for server development: CRUD, query optimization, transactions.
Practical SQL for manual QA: DB checks, fixture seeding and cleanup, cross-table validations and typical QA scenarios.
Schemas and DDL, window functions, CTEs and complex subqueries — what data marts and denormalised layers are built on.
Tasks from real technical interviews: Google, Microsoft, Amazon, LinkedIn, Yandex, Sberbank and more.
Practical formats: debugging, data quality, indexes, EXPLAIN, transactions, migrations, schema design.