This project contains a set of SQL exercises focused on database creation, data manipulation, queries, joins, and aggregation. All examples are implemented in MySQL 8.0 and tested in MySQL Workbench.
This file contains:
- Database creation
- Table creation
- Insert statements
- Update & delete operations
- Select queries
- Joins
- Grouping & aggregation
The project demonstrates key SQL concepts:
- Creating databases and tables
- Inserting, updating, and deleting data (DML)
- Selecting and filtering data (DQL)
- Pattern matching with LIKE
- Inner and left joins
- Aggregation with COUNT
- Grouping with GROUP BY
- Grouping combined with joins
- Open MySQL Workbench
- Open the file Excercises11-MYSQL.sql
- Run the script step‑by‑step or all at once
- Verify tables and results in the SCHEMAS panel
✔️ Requirements
- MySQL 8.0
- MySQL Workbench
- (Optional) Docker for running MySQL locally