Investigated a relational database - SAKILA DVD rental database, while working with PostgreSQL. Completed the entire data analysis proces...
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.
Git
PostgreSQL
Tableau
View more
Git
PostgreSQL
Tableau
View more
Queried a digital music store database that holds information regarding the store’s media, employees, and customers using SQL. Used the d...
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.