Solving-Business-Queries-of-AdventureWorks-Database

Prerequisites

1. MS SQL SERVER

2. adventureworksdatabase.bak file

MS SQL Server

Microsoft SQL Server is a relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. Microsoft SQL Server is one of the three market-leading database technologies, along with Oracle Database and IBM's DB2.

Like other RDBMS software, Microsoft SQL Server is built on top of SQL, a standardized programming language that database administrators (DBAs) and other IT professionals use to manage databases and query the data they contain. SQL Server is tied to Transact-SQL (T-SQL), an implementation of SQL from Microsoft that adds a set of proprietary programming extensions to the standard language.

Adventure Works Database

From the data in adventureworks2022.bak it can be known that it's a database of a company named Adventure Works which focuses on selling and manufacturing cycles, it's related components, and accessories. The company has 290 employees and purchases materials from various vendors and uses them for production. It sells the products all over the world and maintains necessary details through the below-listed schema,

1. Human resources -Adventure Works company's Employee details

2. Person - Name, Address, and basic details of customers, vendors, and employees

3. Production - Details of manufactured Products, work orders, and inventory of the company

4. Purchasing - Details of materials, transactions and purchase details from vendors

5. Sales - customer and sales-related data which includes the details about category, sales transaction, and sales orders.