This project was completed as part of a technical interview assignment to demonstrate SQL database design, data population, and querying skills.
The project includes:
- Designing and creating a normalized database structure
- Populating tables with test data
- Creating primary and foreign key relationships
- Updating calculated fields (order totals, item totals)
- Writing various SQL queries for data selection, aggregation, filtering, joins, and reporting
- Demonstrating deduplication logic using SQL CTE
- Microsoft SQL Server 2022
- Azure Data Studio (for database management)
- Docker (for running SQL Server)
- T-SQL
Pavlína Pírek