Pinned Loading

1. DataScrubbing-NashvilleHousingProject DataScrubbing-NashvilleHousingProject Public

   Scripts I used to clean data with MySQL. Techniques used: updates, converts, self-joins, CTEs, substrings, parsename, charindex, case statements, and deletes of rows and columns

2. DataExploration-Covid19Project DataExploration-Covid19Project Public

   SQL Skills displayed: Joins, CTE's, Temp Tables, Windows Functions, Aggregate Functions, Creating Views, Converting Data Types, and Data validation

3. DatabaseDesign-SoccerDatabase DatabaseDesign-SoccerDatabase Public

   Project contains a word document that demonstrates some of my knowledge of MySQL. Here you can find a REPORT, a QUERY using joins, aggregates, and clauses, a VIEW with parameters, a SPROC, and a DA…