Welcome to my repository of SQL projects. This collection showcases my skills in database querying, data analysis, and extracting insights from complex datasets.
This repository contains the following projects:
- Folder:
[AdventureWorksDW2022 SQL Queries](AdventureWorksDW2022%20SQL%20Queries) - Description: This project involves a series of SQL queries written for the
AdventureWorksDW2022database. The AdventureWorks database is a sample data warehouse from Microsoft, designed to demonstrate data warehousing and business intelligence solutions. - Focus: The queries in this project likely analyze sales, products, customers, and other business performance metrics to answer key questions and identify trends.
- SQL: The primary language used across all projects.
- Transact-SQL (T-SQL): Specifically for the AdventureWorks project, as this is the SQL dialect used by Microsoft SQL Server.
- Clone the repository:
git clone [https://github.com/Sahil-Patel180/SQL_Projects.git](https://github.com/Sahil-Patel180/SQL_Projects.git) - Navigate to a project folder:
cd SQL_Projects/AdventureWorksDW2022 SQL Queries - Use the Queries:
- You will need access to the database that these queries were written for (e.g., the
AdventureWorksDW2022database). - Open the
.sqlfiles in a database management tool like SQL Server Management Studio (SSMS), Azure Data Studio, or DBeaver. - Run the queries to see the analysis.
- You will need access to the database that these queries were written for (e.g., the