top of page
Search
Jeremy Lepage

Collection of Sample Databases

Updated: 17 hours ago

In this post, I've compiled a comprehensive collection of sample databases, conveniently categorized by provider, to make it easier for you to find the right dataset for your needs. Whether you're looking for structured data for prototyping, experimenting with new metrics, or evaluating product performance, this collection offers a variety of real-world examples.


Microsoft SQL Server


  • AdventureWorks (71 Tables): Scenarios include Manufacturing, Sales, Purchasing, Product Management, Contact Management, and Human Resources.

  • Northwind (13 Tables): Product Management and Orders.

  • Stack Overflow Database (9 Tables): Public Stack Overflow data export.

  • Movies (17 Tables): Database of movies, cast and crew, production information and genres.

  • Video Games (8 Tables): Data about video game and sales.

  • Bookstore (15 Tables): Books Management and Orders.

  • Olympic Games (11 Tables): Database of Olympic games, competitors, events, and results.

  • Superheroes (10 Tables): Database of superheroes from several sources, their powers, and their attributes..

  • University Rankings (6 Tables): Database that includes a list of universities in many countries, different ranking systems, and how each university ranks in those systems.

  • Sakila Database (15 Tables): Normalised database modelling a DVD rental store.

  • Chinook Database (11 Tables): Alternative to the Northwind database, being ideal for demos and testing ORM tools.


MySQL


  • Employees (6 Tables): Provides a combination of a large base of data (approximately 160MB) spread over six separate tables and consisting of 4 million records in total.

  • Classicmodels (8 Tables): The classicmodels database is a retailer of scale models of classic cars. It contains typical business data, including information about customers, products, sales and orders.

  • Movies (17 Tables): Database of movies, cast and crew, production information and genres.

  • Video Games (8 Tables): Data about video game and sales.

  • Bookstore (15 Tables): Books Management and Orders.

  • Olympic Games (11 Tables): Database of Olympic games, competitors, events, and results.

  • Superheroes (10 Tables): Database of superheroes from several sources, their powers, and their attributes..

  • University Rankings (6 Tables): Database that includes a list of universities in many countries, different ranking systems, and how each university ranks in those systems.

  • Sakila Database (15 Tables): Normalised database modelling a DVD rental store.

  • Chinook Database (11 Tables): Alternative to the Northwind database, being ideal for demos and testing ORM tools.


Oracle


  • Sample Schemas (34 Tables): Human Resources (HR), Order Entry (OE), Product Media (PM), Information Exchange (IX), Sales History (SH) and Customer Orders (CO).

  • Movies (17 Tables): Database of movies, cast and crew, production information and genres.

  • Video Games (8 Tables): Data about video game and sales.

  • Bookstore (15 Tables): Books Management and Orders.

  • Olympic Games (11 Tables): Database of Olympic games, competitors, events, and results.

  • Superheroes (10 Tables): Database of superheroes from several sources, their powers, and their attributes..

  • University Rankings (6 Tables): Database that includes a list of universities in many countries, different ranking systems, and how each university ranks in those systems.

  • Sakila Database (15 Tables): Normalised database modelling a DVD rental store.

  • Chinook Database (11 Tables): Alternative to the Northwind database, being ideal for demos and testing ORM tools.


IBM Db2


  • db2sampl (24 Tables): Project Management, Product Management and Orders.

  • Books (6Tables): Books Management.

  • Sakila Database (15 Tables): Normalised database modelling a DVD rental store.

  • Chinook Database (11 Tables): Alternative to the Northwind database, being ideal for demos and testing ORM tools.


SQLite


  • Cars Company (10 Tables): Operations of a major car company. It provides functionality to view the transactions of dealers, track car inventory, and maintain the models and avaliable options of cars.

  • Northwind (8 Tables): Product Management and Orders.

  • Movies (17 Tables): Database of movies, cast and crew, production information and genres.

  • Video Games (8 Tables): Data about video game and sales.

  • Bookstore (15 Tables): Books Management and Orders.

  • Olympic Games (11 Tables): Database of Olympic games, competitors, events, and results.

  • Superheroes (10 Tables): Database of superheroes from several sources, their powers, and their attributes..

  • University Rankings (6 Tables): Database that includes a list of universities in many countries, different ranking systems, and how each university ranks in those systems.

  • Sakila Database (15 Tables): Normalised database modelling a DVD rental store.

  • Chinook Database (11 Tables): Alternative to the Northwind database, being ideal for demos and testing ORM tools.

  • Chinook Database (Other source) (11 Tables): Alternative to the Northwind database, being ideal for demos and testing ORM tools.


PostgreSQL


  • Northwind (14 Tables):  Product Management and Orders.

  • MusicBrainz Database (24 Tables): Free collection of music metadata

  • DVD Rental (15 Tables): Represents business processes of a DVD rental store.

  • SportsDB (203 Tables): Sports statistics.

  • Movies (17 Tables): Database of movies, cast and crew, production information and genres.

  • Video Games (8 Tables): Data about video game and sales.

  • Bookstore (15 Tables): Books Management and Orders.

  • Olympic Games (11 Tables): Database of Olympic games, competitors, events, and results.

  • Superheroes (10 Tables): Database of superheroes from several sources, their powers, and their attributes..

  • University Rankings (6 Tables): Database that includes a list of universities in many countries, different ranking systems, and how each university ranks in those systems.

  • Sakila Database (15 Tables): Normalised database modelling a DVD rental store.

  • Chinook Database (11 Tables): Alternative to the Northwind database, being ideal for demos and testing ORM tools.



To easily populate your test database using custom forms or browse your data, explore DeliaWeb, a rapid builder for .NET web applications. This free tool features a powerful page editor, enabling you to quickly design and deploy functional web pages tailored to your needs.



501 views
bottom of page