This repository contains the work completed during my summer internship at Celebal Technologies under the SQL department. Over the course of the 2-month internship, I completed 6 weekly assignments and a comprehensive project.
Data Definition Language (DDL) - Focused on creating, modifying, and deleting database objects.
Built-in Functions - Covered the use of various SQL functions for data manipulation and retrieval.
Indexes - Explored indexing techniques to optimize database performance.
Triggers - Implemented triggers to automate database tasks and maintain data integrity.
Star and Snowflake Schemas - Designed and analyzed these schema types for data warehousing.
Change Data Capture (CDC) - Learned methods for tracking and capturing changes in data.
Departmental Average Salary Analysis with Threshold Comparison: Conducted an analysis of average salaries across 10 departments, comparing them against predefined thresholds to identify discrepancies and insights.