This is a data exploration exercise I worked on in order to reinforce the basic SQL concepts. I divied into 2 sections:

Data Exploration Exercise

Starting from scratch, I installed the following:

• SQL Server Management Studio: https://docs.microsoft.com/en-us/sql/...
• SQL Server: https://www.microsoft.com/en-us/sql-s...

When going through this exercise I worked on the following statements:

• Basic
  • Installing MSMM & SQL
  • CREATE Statements
  • INSERT Statements
  • SELECT & FROM Statements
  • TOP, DISTINCT, COUNT, AS, MAX, MIN, AVG Statements
  • WHERE Statements
  • GROUP BY Statements
• Intermediate
  • Inner/Outer Joins | Use Cases
  • Unions | Union Operator
  • Having Clause
  • Updating/Deleting Data
  • Aliasing
  • Partition By
• Advanced
  • CTE (Common Table Expression)
  • Temp Tables
  • String Functions + Use Cases
  • Stored Procedures + Use Cases
  • Subqueries

Starting a Portfolio Project

First I imported data from: https://ourworldindata.org/covid-deaths

I Used data from the first available date.

I had some problems with installation so I had to Google the main issues

• Troubleshooting the installation of missing features required the following:

  • Download the Developer Edition
  • Microsoft® ODBC Driver 11 for SQL Server

  When I finally had the server operational I looked up ways on how to import data. I Follow the screen flow below:

  1- Import the data by using the SQL Server Import and Export Wizard

  2- Use this path as the destination instead of the “SQL Server Native Client” provided in the tutorial

  3 - Use the Tasks sub-men inside a new Database inside the Object Explorer. Select Import Data

  

  

  

I finally manage to sucessfulyy access the raw data inside SQL Server Manager