Link Search Menu Expand Document

Investigate a Database

image

The Sakilla DVD Rental ERD

image

Investigate the Sakilla movie database while working with PostgreSQL. This project requires 4 unique SQL queries that provides an answer to a posed question. The entire data that will be used in the visualization must be ready to export and no data cleaning or sorting should be done after. Export the data to create data visualization using Excel.

Final deliverables are:

SQL queries that was used to pull data that answers the question.

View the SQL query txt file.

Data visualization in slides.

View the pdf file.

Download the project files.