DVD Rental: Payments by Customer and Category
Thousands of rental payments with customer, date and film category. Practice grouping dates and finding top customers.
DownloadStart here
Lessons and reference
Look things up
Start here
SQL
Power Query
Data modeling
Power BI and DAX
Finance playbooks
Run queries
Build and check
Films, actors, categories, customers, rentals and payments for a DVD rental chain. Great for many-to-many relationships and date arithmetic.
Write each as a query in the SQL editor, or ask an AI assistant to walk you through 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.
Thousands of rental payments with customer, date and film category. Practice grouping dates and finding top customers.
Download