This project shows a relational database built to store client and transaction data, along with SQL queries used to organize and summarize the information.
I created the database structure, connected the tables, and wrote queries to review the data. The goal was to keep the data organized and use SQL to generate simple reports.
- Created tables with primary and foreign keys
- Connected the tables through relationships
- Wrote JOIN queries to combine data
- Used GROUP BY, SUM, and COUNT for reporting
I also added a separate queries.sql file with extra queries for reporting and data review.
It includes queries for:
- Joining clients with their orders
- Counting total orders per client
- Calculating total spending
- Filtering records by date
- Understanding of relational database structure
- Ability to work with connected tables
- Experience using SQL for reporting and analysis
- MySQL
- SQL