PinnedLoading

1. DataScrubbing-NashvilleHousingProjectDataScrubbing-NashvilleHousingProjectPublic

   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-Covid19ProjectDataExploration-Covid19ProjectPublic

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

3. DatabaseDesign-SoccerDatabaseDatabaseDesign-SoccerDatabasePublic

   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…