SQL-Data-Analysis-for-Sakila-DB

Tech Stack: SQL(formerly SEQUEL) Tools Used: MySQL, MS-EXCEL

About Sakila Database:

1. 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
2. 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

1. DDL
1. CREATE
2. ALTER
3. CREATE
4. DROP
2. DML
1. INSERT
2. UPDATE
3. SELECT

Other Commands and Functions:

1. WHERE Clause
2. GROUP BY Clause
3. HAVING Clause
4. CASE Statements
5. Datatime functions
6. Joins - Inner & Outer
7. RUNNING TOTAL



Note: The database has solely used just for learning and educational purpose and not for commercial purpose.