Skip to content

Repository files navigation

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 :

  1. Remove Duplicates
  2. Standardization
  3. Removing nulls and blanks
  4. 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.

About

Learning mysql

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors