17 databases for SQL practice and real-world case training, compiled by QA Engineer

The proposed databases, according to Anastasia, can be downloaded and used in MySQL, PostgreSQL, SQLite, SQL Server, or Oracle.

Standard test bases

These databases can be used for training and testing SQL queries:

1. Sakila Database — video rental database (MySQL).
2. Northwind Database — a database for business analytics (SQLite, SQL Server).
3. AdventureWorks is a database for testing SQL Server.
4. Chinook Database — a database for a music store (PostgreSQL, MySQL, SQLite).

Large open databases for analytics

Real data for working with SQL, machine learning and BI tools:

1. IMDb Dataset — data about movies and actors.
2. Open Data on Kaggle — thousands of ready-made databases.
3. Google BigQuery Public Datasets are large open databases in the cloud.
4. European Soccer Database — football statistics.

Thematic databases for working with real cases

1. COVID-19 Open Data — data about the pandemic.
2. New York City Taxi Dataset — taxi transactions in New York City.
3. Airbnb Open Data — information about rental housing around the world.
4. Spotify Dataset is a database with songs and ratings.
5. Wikipedia Clickstream — analysis of clicks on Wikipedia.

Where can I find even more bases?

1. Awesome Public Datasets is a large collection of open databases.
2. Google Dataset Search is a database search engine.
3. Data.gov is a database of open US government data.
4. KDNuggets Datasets — resources for machine learning and analytics.

Read the country’s main IT news in our Telegram

On the topic

Read the country’s main IT news in our Telegram

7 games and interactive resources to help improve your SQL skills

On the topic

7 games and interactive resources to help improve your SQL skills

Write SQL queries and manage databases: SoftServe launches new free course for military personnel, veterans and their families

On the topic

Write SQL queries and manage databases: SoftServe launches new free course for military personnel, veterans and their families

10 SQL courses to better understand working with big data

On the topic

10 SQL courses to better understand working with big data

How to Save Thousands of Dollars? A Developer Has Compiled a Collection of Free SQL Courses and Certifications: 12 Opportunities to Learn for Free

On the topic

How to Save Thousands of Dollars? A Developer Has Compiled a Collection of Free SQL Courses and Certifications: 12 Opportunities to Learn for Free

Підключай Megogo зі знижками за акційними тарифами.

від 99 гривень на місяць