12  Example database schemas

12.1 Example Schema Chinook

Chinook will be used in most examples. The Chinook sample database github repository has necessary scripts for a lot different databases. Necessary files for sqlite, oracle and SQL server will be provided in the course github repository.

Chinook schema by tool schemaspy

12.2 Example Schema Student Information System

Example Schema Student Information System

12.3 Example Schemas Stack Overflow

https://www.brentozar.com/archive/2018/02/gentle-introduction-stack-overflow-schema/

12.4 Examples schema from database vendors

There are some well known sample databases that was provided by database vendors like Oracle and Microsoft. Some of these samples are discontinued due to bad practices in them. Nonetheless, we will learn about them even though, we may not run any queries in these example schemas. It is necessary to know about them since they are used in a lot of examples.

12.4.1 Oracle

Oracle sample schemas documentation.

  • Oracle HR

Oracle HR Schema
  • Oracle Scott

12.4.2 Microsoft

The most well known is Northwind. Since Chinook is very similar to it, we will use Chinook. But we will look at the tables.

  • SQL Server 2000
    • Northwind
    • Pubs
  • SQL Server 2005
    • AdventureWorks
  • SQL Server 2016
    • Wide World Importers