I've created an Excel workbook with sample data for practicing the SQL scenarios.
You can use this dataset to practice:
- Joins
- Subqueries
- Window Functions
- Ranking
- Running Totals
- LAG/LEAD
- Duplicate Detection
- Customer & Sales Analytics
- ETL Validation Scenarios
Employee
Department
Customer
Orders
Sample file
ReplyDelete