SQL

I have a strong command of essential SQL operations such as CREATE, INSERT, SELECT, WHERE, GROUP BY, ORDER BY, HAVING, and LIMIT. My expertise extends to more advanced concepts like JOINS, UNIONS, STRING FUNCTIONS, CASE STATEMENTS, SUBQUERIES, and WINDOW FUNCTIONS. I also work with CTEs (Common Table Expressions), Temporary Tables, Stored Procedures, Triggers, and Events to efficiently manage and manipulate data. With these skills, I can query large datasets, optimise data retrieval, and perform complex data transformations, all while ensuring performance. These techniques allow me to extract insights and build scalable solutions for data-driven decision-making.

Please find my SQL projects below:

Exploratory Data Analysis
World Layoff Data

World Layoffs EDA

KEY SKILLS: CTEs, Window Functions, Data Aggregation, Data Type Conversion

The project focuses on exploratory data analysis of layoff data to identify key trends and insights regarding workforce reductions across various companies and industries.

Data Cleaning
World Layoff Data

World Layoffs Cleaning

KEY SKILLS: Queries, Data Manipulation, Aggregation Functions, Trend Analysis

The project focuses on cleaning and preparing world layoff data using SQL to ensure accurate analysis and reporting. It involves removing duplicates, standardising formats, and handling null values.