SQL Projects
COVID Analysis T-SQL
This analysis is part of a dual project. The query outputs were transferred to Tableau to generate a dashboard. See Tableau projects for more detail.
Dataset Size: 180k rows
Data Last Updated: 2022-21-04
Skills Displayed: Joins, CTE's, Temp Tables, Windows Functions, Aggregate Functions, Creating Views, Converting Data Types, T-SQL in SQL Server Management Studio
Click here for code
Housing Data Analysis
Analysis of Nashville housing. The primary focus was cleaning and transforming the data.
Dataset Size: 56k rows
Skills Displayed: Modifying DateTime Columns, Updating Tables, Handling Null Values, Splitting Columns, Case Statements, CTE's, Removing Duplicates, and Dropping Columns, T-SQL in SQL Server Management Studio
Click here for code
Movie Rental Franchise Data Analysis
Analysis of a movie rental organization as an analyst answering questions for the business owner's interested buyer for the company.
Dataset Size: 19 table model
Skills Displayed: multi-table joins, aggregate functions, concatenations, formatting fields, unions, and pivoting tables
Click here for code
Movie Rental Franchise Database
Administration
In this project, I was provided a 'master' table that was not normalized. I took this table and created a new database from the ground up as shown in the photos to the right to be put into production for a movie rental company.
Dataset Size: 1 table with 1,984 rows
Skills Displayed: mySQL, database administration, creating schemas, inserting data, creating models, assigning data types, data migration
Click here for code
Database Creation for Fictional Baby Merchandise Company
This project demonstrates the creation of a database from scratch that contains 4 tables for a fictional baby merchandise company that specializes in baby booties.
Skills Displayed: database administration, schema design, assigning datatypes, creating tables, removing columns, and creating foreign and primary key relationships
Click here for code
