Data Analysis on DVD Rental Database

Whatever way of learning we choose, we have to get our hands dirty and code.

In this Project, i use PostgreSQL Database, its free open-source relational database. Using SQL queries i analyze the sales and customer rental behavior.

There were 15 tables in this database.

DVD Rental Database is the sakira database which was originally created by MySQL. It represents the business data from from the DVD rental store, including the information of films, stores and rentals.

Using SQL retrieve the below queries.

Retrieve data from specific tables.

Filter rows and get the desire observation from the analysis.

Advance filter function that include pattern matching.

Order and sort the output based on desire coloumn.

Summarize data by performing data aggregation.

How to structure the data for data analysis.

Data cleaning such as extracting a subset of the string from the left, right, and middle.