This repository documents my journey of learning SQL Topics covered so far SELECT, WHERE, ORDER BY GROUP BY, HAVING, Aggregate functions JOINs (INNER, LEFT, RIGHT, SELF) CASE statement LIMIT + ALLIASING CTEs STORED PROCEDURES STRING FUNCTIONS SUBQUERIES TEMP TABLES TRIGGERS AND EVENTS UNION WINDOW FUNCTIONS
Main topics are covered
Repo also contains data cleaning project on data obtained from kaggle. Main 4 tasks performed in this project are :
- Remove Duplicates
- Standardization
- Removing nulls and blanks
- Remove unnecessary rows and columns
After cleaning data i performed exploratory data analysis on the same data Found largest layoffs by company, industry, location and stage Looked at some progressions over years then rolling layoffs by month
Note This is a practice/learning repository, not a final project. Check my pinned repos for more complete, project-based work as I build them.