Downloads
Rental store

DVD Rental

Films, actors, categories, customers, rentals and payments for a DVD rental chain. Great for many-to-many relationships and date arithmetic.

dvdrentalSQL ServerMariaDB 16 tables
rentalcustomerpaymentinventoryfilm

Good for

Many-to-many joinsDate functionsTop N customers

Questions to try

  • Which film categories earn the most?
  • Which customers rent the most?
  • What is the average rental length by category?

Write each as a query in the SQL editor, or ask an AI assistant to walk you through it.

Connect to it

Server learnsql.cpetoday.com,1433, database dvdrental, in Excel or Power BI (Import mode) or DBeaver. In queries use the schema-qualified name shown for each table (for example dvdrental.actor).

Download the Excel connection (.odc)

How to use it: download the file and open it. Excel opens it as a connection to dvdrental and asks for the SQL Server username and password from your CPE Today course. The file holds no password. The first table is selected by default, and you can pick others from the Data window. Setup details for other tools are on Connect.

Tables (16)

Click a table to preview it in the Playground.

Practice files for this database

Intermediate391 KB

DVD Rental: Payments by Customer and Category

Thousands of rental payments with customer, date and film category. Practice grouping dates and finding top customers.

Download

← All databases