This repository contains a collection of hands-on SQL practice exercises completed using Microsoft SQL Server Management Studio (SSMS). These labs demonstrate my understanding of SQL fundamentals, database design, and query development.
- Basic SQL Queries (SELECT, WHERE)
- Sorting and Filtering Data
- GROUP BY and Aggregate Functions
- SQL Joins
- Constraints
- Temporary Tables
- Variables
- Built-in Functions
- User-Defined Functions (UDFs)
- Stored Procedures
- Views
- Triggers
- Microsoft SQL Server
- SQL Server Management Studio (SSMS)
- T-SQL
SQL-Labs/
├── Basic_Queries.sql
├── Limiting_and_Sorting_Data.sql
├── Grouping_Data.sql
├── Joins.sql
├── Constraints.sql
├── Temp_Table_Structures.sql
├── Variables_and_Functions.sql
├── User_Defined_Functions.sql
├── Stored_Procedures_Part1.sql
├── Stored_Procedures_Part2.sql
└── Views_and_Triggers.sql
This repository was created to strengthen my SQL skills through hands-on practice. It demonstrates my ability to write queries, manage database objects, and work with common SQL Server features used in data analytics and database development.
Esther Koffi
Bachelor of Science in Mathematics & Statistics Aspiring Data Analyst | Business Intelligence | Data Engineering