Northwind sample database

    The Northwind database is a sample database that was originally created by Microsoft and used as the basis for their tutorials in a variety of database products for decades. The Northwind database contains the sales data for a fictitious company called “Northwind Traders,” which imports and exports specialty foods from around the world. The Northwind database is an excellent tutorial schema for a small-business ERP, with customers, orders, inventory, purchasing, suppliers, shipping, employees, and single-entry accounting. The Northwind database has since been ported to a variety of non-Microsoft databases, including PostgreSQL.

    The Northwind dataset includes sample data for the following.

    • Suppliers: Suppliers and vendors of Northwind
    • Customers: Customers who buy products from Northwind
    • Employees: Employee details of Northwind traders
    • Products: Product information
    • Shippers: The details of the shippers who ship the products from the traders to the end-customers
    • Orders and Order_Details: Sales Order transactions taking place between the customers & the company

    The Northwind sample database includes 14 tables and the table relationships are showcased in the following entity relationship diagram.

    Follow the steps here to download and install the Northwind sample database.

    1. Download the SQL scripts

    You can download the Northwind database files, which are compatible with YugabyteDB, from the . Here are the two files you’ll need.

    • northwind_ddl.sql — Creates tables and other database objects
    • — Loads the sample data

    To open the YSQL shell, run the ysqlsh command from the YugabyteDB root directory.

    1. Type "help" for help.
    2. yugabyte=#

    3. Create the Northwind database

    To create the Northwind database, run the following CREATE DATABASE statement.

    Confirm that you have the Northwind database by listing out the databases on your cluster.

    Northwind list of databases

    1. yugabyte=# \c northwind
    1. You are now connected to database "northwind" as user "yugabyte".
    2. northwind=#

    To build the tables and database objects, execute the northwind_ddl.sql SQL script.

    You can verify that all 14 tables have been created by running the \d command.

    5. Load the sample data

    To load the northwind database with sample data, run the \i command to execute commands in the northwind_data.sql file.

    1. northwind=# \i share/northwind_data.sql

    To verify that you have some data to work with, you can run a simple SELECT statement to pull data from the customers table.