/SQL-Projects

During my Summer Internship at Celebal Technologies, I worked on SQL projects to improve data management and search processes for a particular client. The main goal of these projects was to optimize database queries and ensure effective information retrieval.

Primary LanguageTSQL

SQL Projects

Table of Contents

Project Overview

The "SQL Projects" repository includes various SQL tasks and projects completed during the Celebal Technologies Summer Internship. This repository demonstrates the practical application of SQL to address real-world scenarios, including data manipulation, querying, and stored procedure implementation using the Microsoft's Adventure Works Database 2022.

Installation

To explore or run the SQL queries and stored procedures:

  1. Clone or download the repository to your local machine.

         https://github.com/jaiswalchitransh/SQL-Projects.git

  2. Open the SQL scripts in your preferred SQL Environment, such as Microsoft SQL Server Management Studio (SSMS) or Azure Data Studio.

  3. Connect to the Microsoft's Adventure Works Database 2022 with the SQL Environment. You can download the AdventureWorks2022.bak OLTP or Online Transaction Processing from microsoft.com.

  4. Execute the SQL scripts and stored procedures as described in each task.

Usage

The repository contains various SQL tasks and implementations:

  • Project-1: Calculated the total work hours of employees based on their check-in and check-out times.
  • Project-2: Implemented a stored procedure to assign students to subjects based on a predefined workflow.
  • Project-3: Implemented a stored procedure to insert requested subjects as valid records in the SubjectAllotments Table according to the specified workflow.
  • Project-4: Executed different queries on the Microsoft's Adventure Works Database 2022.
  • Project-5: Executed queries using Stored Procedures, Functions, Views, and Triggers on the Microsoft's Adventure Works Database 2022.
  • Project-6: Executed queries according to specific tasks assigned.

Features

  • Comprehensive SQL Queries: Various queries to interact with and manipulate data in the Microsoft's Adventure Works Database 2022.
  • Stored Procedures: Implementation of stored procedures to handle complex operations and workflows.
  • Database Tasks: Includes calculations, data retrieval, and management tasks relevant to real-world scenarios.
  • Database Schema: Utilizes the Microsoft's Adventure Works Database 2022 schema for demonstrating SQL capabilities.

Contribution

I, Chitransh Jaiswal developed this Project Individually. I was responsible for all aspects of the project, including design, development, testing, and documentation. Contributions to improve the efficiency, readability, or functionality of the code are welcome. To contribute:

  1. Fork the repository.
  2. Create a new branch (git checkout -b feature/your-feature).
  3. Make your changes.
  4. Commit your changes (git commit -am 'Add some feature').
  5. Push to the branch (git push origin feature/your-feature).
  6. Create a new Pull Request.

Please ensure your contributions adhere to the coding standards and follow the existing style and structure.

Thank you for your interest in the SQL Projects!