Stage 7 of 9 · 6 lessons · ~2 weeks
Columnar databases and warehouses
Reports over millions of rows need a different kind of database. Learn OLTP versus OLAP, why columnar storage is fast for analytics, and where BigQuery, Snowflake, Redshift, ClickHouse and DuckDB fit.
7 more stages, 44 more topics, free with an account.
You have seen the open stages of the Choosing the right database roadmap. Every topic it covers is listed above, and an account opens the rest: what each topic means, a question to check yourself, the courses, the practice and Tauseef's advice for every stage. Early access is open: sign up and your account is active shortly after.
Everything here is free to learn from. A few things, like adding a roadmap, keeping a cheat sheet or asking Tauseef a question, use credits. You get 15 when you join, your first roadmap is free, and if you are learning seriously and run out, you can ask for more. Credits only make sure the platform goes to people who are actually learning.