This project showcases my ability to design, manage, and analyze databases using SQL.
It demonstrates a complete workflow — from database creation and data manipulation to querying, procedures, and data integrity checks — all centered around an employee dataset.
The project helped strengthen my SQL problem-solving and analytical skills, aligning with my continuous growth as a data analyst.
- Database Creation & Schema Design
CREATE DATABASE,CREATE TABLE, data types, and relationships
- Data Manipulation
INSERT,UPDATE,DELETE, and data validation
- SQL Operators
AND,OR,IN,BETWEEN,LIKE
- Constraints
NOT NULL,UNIQUE,PRIMARY KEY,FOREIGN KEY,CHECK
- Aggregate & Built-in Functions
COUNT,MIN,MAX,AVG
- Stored Procedures
- Automating tasks and reusable queries
- Data Backup & Recovery
- Using backup commands and recovery simulations
- Database System: MySQL / SQL Server
- Query Editor: SQL Server Management Studio (SSMS), Azure Data Studio, or MySQL Workbench
- File:
SQL_scratch_project.sql
To deepen my understanding of relational databases and strengthen my ability to perform complex data queries, maintain data integrity, and apply SQL in real-world data analysis projects.
- Clone this repository:
git clone https://github.com/<yourusername>/SQL-Employee-Data-Analysis-Project.git
Open the SQL file (SQL_scratch_project.sql) in your SQL environment.
Execute the queries step by step to observe database creation, manipulation, and analysis.
Oluwasegun Adelaja
Data Analyst | Agricultural & Resource Economics Graduate
