MySQL queries writing

IN PROGRESS
Bids
9
Avg Bid (USD)
$70
Project Budget (USD)
$30 - $100

Project Description:
Our MySQL (version 5) database stores information in multiple tables, which are connected by foreign keys. We need to add advanced search features to our site, based on data in this database. To do this, we would need to write several MySQL SELECT queries, joining different tables and filtering according to the required parameters. We will supply the test data (from mysql dump). We expect to receive, not only fully functional and debugged queries, but also documentation in English, in text format, explaining each query. Also, part of the work should be recommendation as to what indexes need to be added to the database in order to speed up queries. Please don't bid yet. Contact us here and we'll send you a detailed description of the table structure and the queries that we need.

## Deliverables

1) Complete and functional MySQL queries, running correctly on our test data.


2) Documentation, per query, explaining how it operates.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

MySQL 5

Skills required:
Engineering, MySQL, PHP, Software Architecture, Software Testing
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.