Dataset source:
Nashville Housing Data
Software Used:
Microsoft SQL Server Management Studio and Visual Studio
In this project, I performed the following:
Selecting a few columns from the table using SELECT command.
Applying various conditions using WHERE command.
Changing the datatype of items present in the table using CONVERT command.
Ordering the data shown by a particular column using ORDER BY command.
Joining two tables using the JOIN command, based on a related column between the tables.
INSERT INTO command is used to insert data elements into the table.
Adding/removing columns from the table using ALTER TABLE command.
Click here to have a look at SQL Data Cleaning Commands.
Comments