Data cleaning in SQL

In this project, we clean a dataset related to housing in SQL Server.

This is a dataset related to housing on Nashville. Here we are cleaning it using SQL in SQL Server Management Studio.

The operations that I performed go as following:

- Putting the date data in standard form.

- Populating proper address data.- Breaking out Address into individual columns (Address, City, State).

- Change Y and N to Yes and No in "Sold as Vacant" field.

- Removing Duplicates.- Deleting Unused Columns.

The code for the project can be found on my github, here: https://github.com/ReDK121/PortfolioProjects/blob/main/DataCleaningProject.sql