Skip to content

README.md

Latest commit

 

History

History
35 lines (25 loc) · 1.69 KB

README.md

File metadata and controls

35 lines (25 loc) · 1.69 KB
Raw

SQL Projects

License: MIT

Welcome to my repository of SQL projects. This collection showcases my skills in database querying, data analysis, and extracting insights from complex datasets.

Projects

This repository contains the following projects:

1. AdventureWorks 2022 Analysis

  • Folder: [AdventureWorksDW2022 SQL Queries](AdventureWorksDW2022%20SQL%20Queries)
  • Description: This project involves a series of SQL queries written for the AdventureWorksDW2022 database. 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.

Technologies Used

  • 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.

How to Use

  1. Clone the repository: 
    git clone [https://github.com/Sahil-Patel180/SQL_Projects.git](https://github.com/Sahil-Patel180/SQL_Projects.git)
  2. Navigate to a project folder: 
    cd SQL_Projects/AdventureWorksDW2022 SQL Queries
  3. Use the Queries:
    • You will need access to the database that these queries were written for (e.g., the AdventureWorksDW2022 database).
    • Open the .sql files in a database management tool like SQL Server Management Studio (SSMS), Azure Data Studio, or DBeaver.
    • Run the queries to see the analysis.