Datasets

SQL Habit has 6 datasets. The main course is based on the Bindle dataset – a data warehouse of a fictional startup. The Practice section exercises are based on several different datasets listed here.

Bindle dataset

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.

E-commerce dataset

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.

Finance dataset

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.

Live dataset

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.

NBA dataset

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!

Movies dataset

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!