SQL Project: Optimizing Data Access with Procedures and Views

Sakila Database

Used the Sakila sample database to practice stored procedures and views.

Created stored procedures to automate tasks such as retrieving customer rental history and listing films by category.

Designed views to simplify complex queries, including most rented films, active customers, and revenue by category.

Improved query reusability and database efficiency through procedural logic.

Gained practical experience in data organization, automation, and analysis within SQL.