SQL is the foundation of my data analysis work. I use SQL to extract, clean, and analyse data from relational databases to support dashboards and business insights.
Core Skills
Query Writing — SELECT, WHERE, ORDER BY, GROUP BY, HAVING
Joins — INNER, LEFT, RIGHT, FULL
Aggregations — SUM, AVG, COUNT, MIN, MAX
Data Cleaning — filtering, deduplication, formatting
Views & Subqueries — reusable logic for reporting
Performance — indexing basics, optimised queries
Database Tools — Azure SQL, PostgreSQL, MySQL,
Goal: Analyse customer behaviour and product performance.
Key Queries Used:
Customer purchase totals using SUM()
Age‑based segmentation using CASE WHEN
Product category performance using GROUP BY
High‑value customer identification using nested logic
Correlation preparation using SQL aggregations