2020
Investigated a relational database - SAKILA DVD rental database, while working with PostgreSQL. Completed the entire data analysis process, starting by posing a question, running appropriate SQL queries to answer the questions, and finishing by sharing the findings. Applied advanced topics such as advanced JOINs, Data cleaning, Performance tuning and Window functions to answer complex business problems.
2019
Queried a digital music store database that holds information regarding the store’s media, employees, and customers using SQL. Used the database to help the store gain an understanding of the types of music that are purchased, where customers live, and how the company might optimize their business practices.