Downloads
Data

The sample databases

Recognizable business data, all synthetic and read-only. Pick a topic that matches your work, then open one to see its tables, sample questions, and the practice files built from it. Most databases exist on both SQL Server and MariaDB.

Not sure? Start here

Pick the goal closest to yours. Each link opens the database that fits it best.

Learn SQL from zero

Clean keys, familiar business data and few tables. Start here if SELECT, JOIN and GROUP BY are new.

Sales, customers and orders

Where revenue comes from: orders, order lines, products and customers. Good for margin, mix and top-N questions.

Accounting and bookkeeping

The ledgers behind the books: invoices, bills, payments, journal entries and receivables aging. Start here if you close, reconcile or report.

Professional firms and nonprofits

A CPA firm's billing, realization and WIP, and a nonprofit's donors, grants and fund accounting.

invoice_linesinvoicesclientsengagementstime_entries
Practice managementSQL ServerMariaDB34 tables

CPA Firm

A small-business CPA firm: clients, engagements, tax returns, time entries, invoices, payments, retainers, a balanced general ledger and document tracking. About 1,000 clients, six years of history, a client map and a July-June fiscal calendar.

Realization, WIP and AR agingStaff utilizationMapping clients and visitsFiscal-year and tax-season reporting
giftsconstituentsfundsgrantsgl_journal_lines
Donors, grants and fund accountingSQL ServerMariaDB49 tables

Nonprofit

A regional nonprofit: donors, gifts, pledges, campaigns and events, grants and proposals, fund accounting with a general ledger, payroll by fund, volunteers, program sites and a mobile food market. Donor map and a July-June fiscal calendar.

Donor retention and campaignsGrant budgets and reportingFund accounting and functional expensesMapping donors and the mobile market

Government and utilities

Municipal and utility operations: 311 requests, dispatch, parcels and budgets, or work orders, assets and purchasing.

service_requestsparcelscad_callstot_filingsgl_journal_lines
Municipal government dataSQL ServerMariaDB61 tables

Big Bear Lake (city)

Big Bear Lake is a small mountain resort city in California, and this is municipal-style operating data for it, the way a city manager, finance director or public works superintendent would see it: 311 requests, snow plow operations, fire and sheriff dispatch, building permits and code enforcement, a city-run water utility, the lodging tax on short-term rentals, parcels and owners, fund accounting with budgets, and council agendas and votes. The records are invented; the place and the kind of work are real. July-June fiscal year, with coordinates on almost everything.

Local-government analyticsMapping 311, dispatch and parcelsBudget versus actual and fund accountingSeasonality, weather and tourism
WorkOrdersAssetsEmployeesMonthlyBillsPurchaseOrders
Work orders, assets, purchasing and billingSQL ServerMariaDB13 tables

Field Operations (utility)

A water and electric utility's field operations in six regions: assets and their condition, 25,000 work orders with labor and materials, vendors with purchase orders and invoices, customer accounts with a year of monthly bills, and service interruptions. Lookup tables are unique and every relationship is a declared key.

Work order and maintenance analysisProcurement and invoice agingBilling and seasonal usageReliability measures such as customer-minutes

Data warehouses and Power BI models

Stars, snowflakes and big fact tables: the shapes you build a semantic model on in Power BI or Excel.

fact_salesdim_productdim_customerdim_storedim_date
Dimensional modelingSQL ServerMariaDB25 tables

Retail Data Warehouse

A retail data warehouse built to teach modeling: a star schema with snowflaked product and store dimensions, customers that change over time (type 2), a price history, a month-end inventory snapshot, an order pipeline with a date for each stage, a factless promotion table, four currencies with daily exchange rates, and budgets at a different grain.

Star and snowflake schemasSlowly changing dimensionsSnapshots and semi-additive measuresModeling in Power BI and Excel
order_linesdim_customerdim_productbomdim_plant
25 million rows, almost no diskSQL ServerMariaDB9 tables

Manufacturer Orders (big data)

A manufacturer's order history: 25 million order lines to wholesalers, retail chains and retailers, plus a three-level bill of materials and a customer hierarchy. On SQL Server it is a compressed columnstore table; on MariaDB the same rows are computed on the fly, so nothing large sits on disk.

Querying very large tablesColumnstore and batch modeBill of materials and hierarchiesAggregations for Power BI

Power Query and messy data

Deliberately untidy tables, one technique each: promoted headers, unpivots, JSON, fuzzy merges and geocoding.

Sensors, maps and reference data

Time-series readings from a connected home, and countries and cities with coordinates for maps and pure SQL.

readingsdevicessensor_channelsroomsevents
IoT and household dataSQL ServerMariaDB39 tables

Smart Home

One connected family home: 83 devices in 12 rooms, 13 months of sensor readings, solar, battery and EV energy, automations, alerts, security cameras, weather, utility bills, sleep, trips and a floor plan. October-September fiscal year.

Time-series and sensor dataEnergy, solar and billsMaps, trips and a floor planWater-year reporting

Want a path instead of a list?

Follow a learning path, or try the Power BI connection guide to pull any of these into Power BI Desktop.