Tech Stack: SQL(formerly SEQUEL) Tools Used: MySQL, MS-EXCEL
About Sakila Database:
- The Sakila sample database is a fictitious database designed to represent a DVD rental store it is a is a nicely normalized schema modelling a DVD rental store, featuring things like films, actors, film-actor relationships and a central inventory table that connects films, store, rentals and payments
- Detailed information about the database can be found on the MySQL website: https://dev.mysql.com/doc/sakila/en/
Entity Relationship Diagram(ERD):
Topics Covered in the SQL Analysis
- DDL
- CREATE
- ALTER
- CREATE
- DROP
- DML
- INSERT
- UPDATE
- SELECT
Other Commands and Functions:
- WHERE Clause
- GROUP BY Clause
- HAVING Clause
- CASE Statements
- Datatime functions
- Joins - Inner & Outer
- RUNNING TOTAL
Note: The database has solely used just for learning and educational purpose and not for commercial purpose.