SQL Server Database Management — Advanced SQL Queries and Data Manipulation

Completed a SQL Server assignment using the DEPI_System database to practice advanced SQL querying and database management techniques. The project covers ranking functions such as DENSE_RANK(), ROW_NUMBER(), and NTILE(), along with Common Table Expressions (CTEs) for ranking and deleting records.

It also demonstrates schema creation and management using IF NOT EXISTS and ALTER SCHEMA, conditional logic using CASE statements, and salary updates based on specified conditions. Additionally, the assignment explores table variables, data insertion, and table duplication using SELECT INTO to copy both table structures and data or create an empty table structure.

This project strengthened my practical skills in SQL Server, data manipulation, database organization, conditional processing, and advanced querying techniques.