MySQL Query Writing & Database Optimization
Budget: ₹600 – ₹1,500 INR
I need a proficient MySQL expert to write custom queries for my existing database. The task involves:
- Writing various types of MySQL queries, including data retrieval (SELECT statements), data modification (UPDATE, DELETE statements), and aggregated data queries (SUM, AVG).
- Proposing necessary changes to the database schema for efficiency, which may include adding new columns or tables.
- Converting the provided PostgreSQL schema to MySQL.
- Creating a sample dataset of 1000 staff members and simulating 60 transactions per day for two months.
- Implementing and demonstrating all queries on phpMyAdmin.
Queries to write :
I want to know at the End of Each Day Total transactions done by staff/store/vendor
I want to know at the End of Each Day Cash balance at staff/store/vendor
I want to know at the End of Each Day e balances at staff/store/vendor
I want to know at the End of Each Day difference between audited balance and actual balance at staff/store
I want to know at the End of Each Day attendance time of all staff
Please don't forget to check the attached SQL schema for reference.
- Writing various types of MySQL queries, including data retrieval (SELECT statements), data modification (UPDATE, DELETE statements), and aggregated data queries (SUM, AVG).
- Proposing necessary changes to the database schema for efficiency, which may include adding new columns or tables.
- Converting the provided PostgreSQL schema to MySQL.
- Creating a sample dataset of 1000 staff members and simulating 60 transactions per day for two months.
- Implementing and demonstrating all queries on phpMyAdmin.
Queries to write :
I want to know at the End of Each Day Total transactions done by staff/store/vendor
I want to know at the End of Each Day Cash balance at staff/store/vendor
I want to know at the End of Each Day e balances at staff/store/vendor
I want to know at the End of Each Day difference between audited balance and actual balance at staff/store
I want to know at the End of Each Day attendance time of all staff
Please don't forget to check the attached SQL schema for reference.