SQL Habit has 2 main parts:
The aim of the Practice section is to deepen your SQL and Data Analysis knowledge. You'll apply everything you've learned in different contexts and truly become an Expert when it comes to answering questions with data.
Practice exercises have 4 difficutly levels, so you can solve some of them as you go through the main course.
Often, SQL Habit students use the Practice section to prepare for a job interview. You can also solve Practice exercises in the "Mock Interview" mode – you'll be given 2 random exercises and a 45 min timer.
This data warehouse belongs to a fictional startup named Bindle. Bindle is a web and mobile app for reading books, it has subscription business model. The SQL Habit Course is based on Bindle’s story.
Bindle’s data warehouse contains everything needed to run a modern Internet company – web and mobile analytics, marketing data, AB-test data, etc.
This data warehouse is inspired by an E-commerce website like Amazon.
Our E-commerce website allows vendors to sell items in multiple categories. Users can add as many items as they want to a cart and then purchase a cart with/without a discount code. Users also can return items and leave reviews.
This data warehouse simply contains all company’s financial transactions.
If the company paid for something – there’s a debit transaction with negative amount. If someone paid the company – it’s a credit transaction with positive amount.
The Live dataset contains data of a meditation mobile app with subscription business model.
The data is updated daily. You can run queries to calculate metrics for the past 24h, week, month, etc. and build dashboards as if you were actually working for that company.
The NBA dataset contains stats of NBA games since 1949. It is regularly updated.
The dataset contains aggregated game stats (team_game_stats table) and individual player stats per quarter or overtime period (player_period_stats).
Have a ball!
The Movies dataset contains data from some of the best films released since the 1990s.
It includes information on actors, directors, and key movie statistics like budget and revenue. The most interesting part is probably the ratings
table. Please note that the ratings were artificially generated, so the final movie scores only partially correlate with real IMDb data.
Enjoy the show!