SQL Data Exploration - Covid

This is an SQL data exploration performed in SSMS (SQL Server Management Studio) on a data set from ourworldindata.org

Through experience and training in SQL, I can manipulate data in multiple versions of SQL to perform the complex functionality of the software. Techniques used to work this data include creating a new database, creating tables within that database, and coding in JOINS to query tables for increased accuracy and usability. Changing data types of various fields through CONVERT and CAST functions. Coding around discrepancies in the data results with WHERE, LIKE, and IS NOT NULL along with the NULLIF function. PARTITION was also used for better recognition and understandability of running totals in the data over time.

For a full look at the code written for this exploration, please view my git hub link.

https://github.com/DataDoneByMark/SQL-Covid-Data-Exploration/blob/main/Covid%20Portfolio%20Project%20Data%20Exlporation%20Queries.sql

To see the results of this data manipulation, please see the related post for Tableau Covid Data Visualization.