Can I download a dataset as SQL?

Yes. SQL is one of the download formats, alongside CSV, Excel, JSON, Parquet, JSONL, TSV and XML, so you can load a table without writing an import script.

Are there multi-table datasets for practising joins?

These ready-made datasets are one table each, and several have keys that join back into the same table. For a proper multi-table schema, describe it in GoMask Data Factory and it generates related tables with foreign keys that match.

Which database should I use?

Any of them. The data is plain tables, so it works in PostgreSQL, MySQL, SQLite, SQL Server, DuckDB or BigQuery.

Datasets by tool

SQL Practice Datasets

Tired of Northwind? These tables are realistic enough that your queries return answers worth reading. Each has a primary key, dates to filter and bucket, categories to group by and numbers to aggregate, and several have IDs that point back into the same table. Download any of them as SQL INSERT statements or CSV and load them into Postgres, MySQL, SQLite or SQL Server.

GROUP BY and aggregates

Transactions and counts built for aggregation: sales by product and store, bank transactions by category and merchant, defects by line and shift, pharmacy purchases by product form. Practise GROUP BY with HAVING, CASE inside SUM, and percentage-of-total calculations.

E-commerce13 cols · 200 rows

Sales Transactions

This dataset provides granular, line-item records of point-of-sale transactions, including product details, quantities, pricing, discounts, payment methods, and references to customers and store locations. It is ideal for retail analytics, sales performance tracking, and customer behavior analysis, enabling businesses to optimize inventory, marketing, and operational strategies.

product_name	quantity	payment_method
Standard Widget	2	credit_card
Promo Mug	1	cash
Premium Headphones	1	debit_card

transaction_idtransaction_datetimecustomer_id+7 more

Finance17 cols · 200 rows

Bank Transaction Categorization Sample

This dataset contains labeled bank transaction records, including detailed transaction metadata, merchant information, and manually or automatically assigned expense categories. It is ideal for developing, training, and benchmarking automated expense categorization models for personal finance, budgeting, and regulatory compliance applications.

merchant_name	amount	category
Whole Foods Market	-95.32	groceries
ACME Corp	2500	income
Netflix	-56.8	entertainment

posting_dateis_recurringmerchant_category_code+11 more

Manufacturing9 cols · 200 rows

Manufacturing Line Defect Counts

This dataset provides detailed, shift-level defect counts for each product type and manufacturing line, enabling granular quality control analysis and predictive modeling. With fields for defect categories, production volumes, and calculated defect rates, it supports both operational monitoring and advanced AI-driven analytics to improve manufacturing processes.

shift	defect_type	defect_rate
Morning	Surface	0.01
Afternoon	Mechanical	0
Night	Electrical	0.12632

production_lineproduct_typetotal_units_produced+3 more

Healthcare25 cols · 200 rows

Pharmacy Retail Purchase Events

This dataset provides detailed, line-level records of pharmacy retail purchase events, including both over-the-counter and prescription medications. Each record captures transaction details, customer demographics (where available), product specifics, payment method, and prescription information, enabling comprehensive analysis of purchasing patterns, health trends, and market basket behaviors.

store_name	product_name	product_category
RxMart Downtown	Vitamin D3 Gummies	supplement
CareFirst Pharmacy	Ibuprofen Tablets	analgesic
MediQuick Central	Metformin HCl	antidiabetic

transaction_idtransaction_datetimestore_id+19 more

Dates, durations and window functions

Tables where the order of events matters. Compare scheduled and actual arrival times, measure ticket resolution times, follow stock levels before and after each movement, and track subscription renewals. Good ground for LAG, LEAD, running totals and date_trunc.

Logistics25 cols · 200 rows

Logistics Shipment Delay Prediction

This logistics shipment delay prediction dataset provides granular details on shipments, including route information, carrier performance, weather conditions, and both predicted and actual delays. Designed for supply chain managers and analysts, it enables proactive scheduling, risk assessment, and service optimization by offering actionable insights into delay patterns and their causes.

carrier_name	route_type	vehicle_type
SwiftLine Logistics	highway	truck
EuroFreight GmbH	rail	train
Pacific Transport	highway	truck

shipment_idscheduled_departure_datetimeactual_departure_datetime+19 more

Technology17 cols · 200 rows

Customer Support Ticket Resolution

This dataset provides comprehensive logs of customer support tickets, including detailed issue descriptions, resolution times, outcomes, agent involvement, and customer satisfaction ratings. It enables analysis of support process efficiency, identification of bottlenecks, and development of NLP models for automated ticket classification and resolution prediction.

customer_name	ticket_status	issue_category
Javier Martinez	open	billing
Samantha Lee	resolved	account
Ahmed Al-Sayed	pending	billing

ticket_idcustomer_idcustomer_email+11 more

Logistics17 cols · 200 rows

Warehouse Inventory Movement Dataset

This dataset provides detailed, timestamped logs of warehouse inventory movements, capturing item identifiers, source and destination locations, movement triggers, and inventory levels before and after each event. It enables comprehensive analysis for process optimization, loss prevention, and predictive modeling in warehouse operations.

item_name	from_location_name	to_location_name
UltraSoft Bath Towels	Central Warehouse	Retail Store Downtown
Premium Liquid Soap	Central Warehouse	Outlet Store West
Ceramic Flower Vase	Retail Store Downtown	Returns Processing

movement_iditem_idsku+11 more

Finance19 cols · 200 rows

Subscription Billing

This dataset provides a comprehensive view of recurring subscription billing records, including detailed information on customer accounts, subscription plans, payment cycles, renewal schedules, payment failures, and retention status. It enables robust analysis of customer lifetime value, churn prediction, and revenue forecasting for subscription-based businesses.

plan_name	payment_status	retention_status
Monthly Basic	success	retained
Quarterly Premium	failed	at-risk
Yearly Enterprise	success	retained

subscription_idcustomer_idcustomer_email+13 more

Keys and self-joins

Employee tables where manager_id points back to employee_id, orders with line items, and purchase orders with suppliers. Practise self-joins, recursive CTEs for reporting lines, and splitting a wide table into normalised ones.

Human Resources26 cols · 202 rows

Employee Records

This dataset provides a comprehensive view of employee records, including personal information, job roles, departmental assignments, salary details, employment history, and performance metrics. It is designed to support workforce management, HR analytics, and organizational planning, making it ideal for data-driven decision-making in human resources.

first_name	last_name	job_title
Isabella	Martinez	Lead Software Engineer
Aditya	Singh	Financial Analyst
Sophie	Durand	Marketing Director

employee_iddate_of_birthemail+20 more

Human Resources26 cols · 200 rows

Employee Attrition Prediction Dataset

This dataset provides detailed HR records for employees, including demographics, job history, satisfaction, performance, and attrition status. It is ideal for building predictive models to identify turnover risks, analyze workforce trends, and inform retention strategies. Rich features enable advanced analytics for HR decision-making and organizational planning.

first_name	last_name	marital_status
Riya	Patel	Married
Carlos	Dominguez	Single
Aisha	Okafor	Widowed

employee_idgenderdate_of_birth+20 more

E-commerce23 cols · 200 rows

Order History

This dataset provides a detailed record of customer purchase histories, including order metadata, item-level details, shipping and tracking information, and customer lifetime value metrics. It enables comprehensive analysis of purchasing behavior, order fulfillment, and customer value for e-commerce businesses. The data is structured for easy integration with analytics platforms and supports advanced segmentation and forecasting.

order_status	currency	item_name
delivered	USD	Wireless Mouse
shipped	CNY	Smartphone Stand
delivered	EUR	Yoga Mat

order_idcustomer_idcustomer_email+17 more

Logistics23 cols · 200 rows

Purchase Orders

This dataset provides comprehensive B2B purchase order records, including supplier details, product line items, quantities, pricing, delivery schedules, and fulfillment status. It enables detailed tracking of procurement activities, supplier performance, and order fulfillment, supporting analytics for supply chain optimization and financial planning.

supplier_name	supplier_contact_name	product_name
Alpine Foods Ltd	Maria Svensson	Organic Rye Flour
GlobalTech Ltd.	–	Thermal Sensors Type-B
Sunrise Textiles	Ravi Kumar	Cotton Yarn 40s

purchase_order_idorder_datesupplier_id+17 more

Every dataset in this collection

12 datasets