Project database

Project: Advanced SQL Functions & Data Transformation (ITI Database)

This project focuses on building advanced SQL Server functions to handle data transformation, validation, and dynamic data retrieval within the ITI database.

I implemented multiple types of user-defined functions (UDFs), including scalar functions, inline table-valued functions, and multi-statement table-valued functions, to solve real-world data problems.

Key Features:

* Created a scalar function to extract and return the month name from a given date.

* Developed a table-valued function to generate a sequence of even numbers between two values using looping logic.

* Built functions to retrieve and format student data, including:

* Full student information (name and department)

* Validation messages for missing first or last names using ISNULL

* Implemented a dynamic function to return student names (first, last, or full name) based on user input.

* Designed an analytical function to display course performance, including:

* Student grades

* Leading and lagging students using window functions (FIRST_VALUE)

Technical Highlights:

* Used advanced SQL concepts such as:

* User-Defined Functions (Scalar, Inline, Multi-Statement)

* Window Functions (FIRST_VALUE)

* Conditional logic (CASE, IF)

* NULL handling with ISNULL

* Applied clean and reusable design to make functions flexible and scalable.

Technologies Used:

* SQL Server

* T-SQL

* Data Transformation & Validation

This project demonstrates my ability to write modular, reusable SQL code and handle complex data logic efficiently, which is essential for backend development and data engineering tasks.