How to Create AdventureWorks Database Using T-SQL Scripts

AdventureWorks is a sample database provided by Microsoft that contains information on products, customers, and employees. It is a valuable resource for developers, testers, and data analysts who want to learn about SQL Server databases or test their applications using a real-world example.

In this article, we will explore how to create the AdventureWorks database using T-SQL scripts. We will also cover the process of restoring and downloading the database.

The latest version of the AdventureWorks database is AdventureWorksDW2019, which is specifically designed for data warehouse workloads. Microsoft provides sample databases for different types of workloads, such as OLTP (Online Transactional Processing) and data warehousing.

To create the AdventureWorks database using T-SQL scripts, you will need to execute a series of SQL statements in the following order:

1. Create the employees table: This table stores employee information, including employee number, name, department, and salary.

2. Create the departments table: This table stores department information, including department ID and name.

3. Create the customers table: This table stores customer information, including customer ID, name, and address.

4. Create the suppliers table: This table stores supplier information, including supplier ID, name, and address.

Here is an example of how to create the employees table:

```

CREATE TABLE employees (

employee_id INT PRIMARY KEY,

employee_name VARCHAR(50) NOT NULL,

department_id INT,

salary DECIMAL(10, 2)

);

```

In this example, we have created a table called employees with four columns: employee_id, employee_name, department_id, and salary. The employee_id column is the primary key of the table.

To create the departments table:

```

CREATE TABLE departments (

department_id INT PRIMARY KEY,

department_name VARCHAR(50) NOT NULL

);

```

In this example, we have created a table called departments with two columns: department_id and department_name. The department_id column is the primary key of the table.

To create the customers table:

```

CREATE TABLE customers (

customer_id INT PRIMARY KEY,

customer_name VARCHAR(50) NOT NULL,

address VARCHAR(100)

);

```

In this example, we have created a table called customers with three columns: customer_id, customer_name, and address. The customer_id column is the primary key of the table.

To create the suppliers table:

```

CREATE TABLE suppliers (

supplier_id INT PRIMARY KEY,

supplier_name VARCHAR(50) NOT NULL,

address VARCHAR(100)

);

```

In this example, we have created a table called suppliers with three columns: supplier_id, supplier_name, and address. The supplier_id column is the primary key of the table.

By following these steps, you can create the AdventureWorks database using T-SQL scripts. You can also restore and download the database from Microsoft's website.

In this article, we have covered how to create the AdventureWorks database using T-SQL scripts. We have also explored the process of restoring and downloading the database. The AdventureWorks database is a valuable resource for developers, testers, and data analysts who want to learn about SQL Server databases or test their applications using a real-world example.

Adventureworks sample database 2012