Dataset source:
ourworldindata.org
Software Used:
Microsoft SQL Server Management Studio 2019 and Visual Studio.
In this project, I performed the following:
Selecting a few columns from the table using SELECT command.
Selecting a few columns from the table using SELECT command along with the condition using WHERE command.
Ordering the data shown by a particular column using ORDER BY command.
Joining two tables by using the JOIN command, based on a related column between the two.
INSERT INTO command is used to insert data elements into the table.
Used CAST command to convert a value of any type to a specific data type.
Click here to have a look at SQL Data Exploration Commands.
Comentários