Sakila Database Querying

This project is a an exhibition of my skills and knowledge in using programming languages like SQL and Python simultaneously to connect to a database, query it, analyze and visualize. Using SQL to query the database for information and reading the output of the query into pandas dataframe and visualization with python libraries.

The Sakila database is a nicely normalized schema modeling a DVD rental store, featuring things like films, actors, film-actor relationships, and a central inventory table that connects films, stores, and rentals. It contains 16 tables of which some are rental, store, actor, payment, and customer table.

Tools and programming languages used: Python, SQL, Jupyter Notebook.

Link to project documentation on GitHub: https://github.com/richmond-yeboah/Sakila-database-querying Link to project codes (SQL, Python): https://github.com/richmond-yeboah/Sakila-database-querying/blob/main/Analyzing%20the%20sakila%20database.ipynb