Downloads
Bicycle retailer (order entry)

Xtreme

A compact order-entry model with customers, orders, order detail, products, suppliers and employees.

xtremeSQL Server 12 tables
Orders DetailOrdersCustomerProductSupplier

Good for

A first star schemaJoins and aggregatesCrystal-style reporting

Questions to try

  • Which customers spend the most?
  • Which products sell best?
  • What are orders by employee?

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 xtreme, in Excel or Power BI (Import mode) or DBeaver. In queries use the schema-qualified name shown for each table (for example xtreme.Credit).

Download the Excel connection (.odc)

How to use it: download the file and open it. Excel opens it as a connection to xtreme 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 (12)

Click a table to preview it in the Playground.

← All databases