Welcome to my SQL Portfolio! This code repository contains examples of SQL queries I have created over time.
- During my time at Miami-Dade College, I was assigned to create additional queries, along with the queries me and my classmates made in class.
- With the ETL process I created, I was able to extract data from Yoann Cribier's SuperHero API, tranform the data to fit MySQL's format, then load it into MySQL. I have made some queries to find data on the characters within the database.
- With a dataset provided by Maven Analytics, I quantified monthly and yearly sales and identified the total number of orders being made by the year, month, and day, along with the peak hours. The data was imported into an AWS RDS for MySQL.
- SQL Murder Mystery is a game designed for both new and experienced SQL users to solve a murder mystery using SQL concepts and commands. I have solved the mystery and looked further into why the murderer did what they did. CASE CLOSED!!!