Data Warehousing Concepts vs Learn SQL

Data Warehousing Concepts is a focused practice tool for analytics engineers, BI developers, and students learning how enterprise data warehouses are designed and operated. This app drills the specific patterns that show up in real warehouse work: choosing between star and snowflake schemas, modeling slowly changing dimensions (SCD Type 1/2/3), reasoning about fact-vs-dimension grain, deciding when an OLAP cube beats a flat table, and untangling ETL versus ELT trade-offs in modern stacks like Snowflake, BigQuery, and Redshift. What you will practice - Dimensional modeling: fact tables, conformed dimensions, surrogate keys, role-playing dimensions - ETL/ELT pipelines: staging layers, incremental loads, CDC, idempotency, late-arriving facts - OLAP operations: roll-up, drill-down, slice, dice, pivot, MOLAP vs ROLAP - Common pitfalls: chasm and fan traps, junk dimensions, additive vs semi-additive measures, grain mismatches - Advanced concepts: data vault, lakehouse architecture, columnar storage, partitioning, materialized views How you study - 160 multiple-choice questions across 4 difficulty tiers - Every question includes a detailed explanation of why the right answer is right and why the distractors are wrong - FSRS spaced-repetition schedules the next review based on your recall strength - Weak-point heatmap shows which topic areas need more work - Daily challenge keeps a steady review cadence - Mock exam mode times you against the full question pool - Fully offline after install, no account, no tracking, no in-app purchases Who this is for Data analysts moving into engineering, BI developers preparing for technical interviews, students taking a database systems course, and self-learners filling gaps before stepping into a warehouse role. Independent study app for Data Warehousing Concepts practice. Not affiliated with, endorsed by, or sponsored by Snowflake, Google, Amazon, Microsoft, Oracle, Kimball Group, or any vendor, certification body, or exam operator. All trademarks belong to their respective owners.

Open the case file. The evidence is in the database. Learn SQL for free through 100 authored leads and 10 complete investigations. Read the brief, inspect the schema, write a real query, and use the returned rows to prove what happened. Each lead gives you a question and a working dataset. Run your SQL, study the result, revise your approach, then verify the finding when the evidence fits. Every investigation is authored, so the clues, datasets, and conclusions belong to a complete case. WORK 100 AUTHORED LEADS Ten investigations take you from the foundations to advanced analysis: • SELECT, WHERE, ORDER BY, and LIMIT • COUNT, SUM, AVG, GROUP BY, and HAVING • INNER JOIN and LEFT JOIN • Subqueries and CASE expressions • Window functions and common table expressions BUILD PRACTICAL SQL JUDGEMENT • Turn a case objective into a query • Explore tables and relationships through the schema • Read returned rows instead of guessing from syntax • Use clear feedback to correct a failed investigation • Reopen filed leads and improve your solution START WHERE YOUR SKILLS FIT New to SQL? Begin with Case 001 and learn the query desk step by step. Already comfortable with the basics? Choose a later investigation and meet a harder set of evidence. Archie, your SQL Case Guide, can offer a focused hint when you are stuck. Academy field guides explain the underlying concepts, while the Skill Map shows how each investigation builds your SQL toolkit. THE CURRICULUM STAYS FREE All 100 authored leads and the complete SQL learning route are free. There is no subscription. Start without an account, and keep your learning progress and settings on your device. Analytics can be disabled in Settings. Query verification, Archie guidance, verification links, and purchase restoration require an internet connection. An optional one-time Supporter purchase helps fund future investigations. It never limits the curriculum. Your first case is waiting.