Classic sample database Sakila
Sakila is a sample MySQL database that models a DVD rental business. It contains 16 tables, 7 views, 3 stored procedures, 3 stored functions, and 6 triggers, making it useful for exploring joins, relationships, and database objects.
Start by installing Sakila, then browse the database structure and ER diagram or open the guides to stored procedures, functions, views, and triggers.
-
Download and Install the MySQL Sakila Sample Database
-
Sakila Database Structure
- The actor table
- The address table
- The category table
- The city table
- The country table
- The customer table
- The film table
- The film_actor table
- The film_category table
- The film_text table
- The inventory table
- The language table
- The payment table
- The rental table
- The staff table
- The store table
- Views
- Stored Procedures
- Stored Functions
- Triggers