Peruttu

Data Base Updates via MySQL Queries

Background:

I have an existing Codeigniter/Fusion Charts based website which displays charts of sales performance data to users. The users review the charts and use this and other data to prepare sales improvement plans. The charts are in two broad categories: Sales Charts and AMG Charts, each served by its own data base

Data Base Updates: There are five data fields with incomplete or inaccurate data for each of the two data bases. These data fields hold 3-digit numerical information in the form, for example, 25.5 or 0.22. The data fields hold actual year on year growth rates for the same period in the previous year for month, quarter and year. In other words Quarter 2 2016 would be compared with Quarter 2 2015. The data fields hold benchmark growth rates for quarter and year for the same period.

The task is to:

a. Run MySQL queries provided by the client and, using data supplied by the client, fill the empty data fields with correct data.

This is a task for a freelancer or small team with MySQL knowledge who can:

 Identify the missing or incorrect data in the database for all countries, years, quarters and months in both data sets

 Run MySql update queries for each country in each data set for each month, quarter and year so that all of the five fields are populated with the correct data. The correct values for each month, quarter and year will be provided by the client

 To test a sample of each country and data set to ensure that the data has been uploaded and is correct

 The project has a guideline budget not exceeding $75 - $100

Taidot: MySQL, PHP

Näytä lisää: hierarchical data queries mysql, mysql script retrieving data web, mysql import tab data, mysql import large data xml, mysql load large data files, freelancing sites home base data encoding, php mysql insert user data, worker ssl data entry 3000 words, php mysql real estate data, mysql display show data starting letter, write queries mysql, mysql php plot data timeline, google base data feed xml format, mysql dump import data, create mysql table form data, joomla mysql php enter data, mysql import delimited data, simple mysql php show data dropdown, php mysql sort form data

Tietoa työnantajasta:
( 32 arvostelua ) OXFORD, United Kingdom

Projektin tunnus: #13103006

35 freelancers are bidding on average $135 for this job

graphicaa

To run the mysql queries and fill the data into the data fields with correct data. To find the missing data in both datasets. To run update queries to populate the the correct data. To test the correctness of the da Lisää

89 $ USD 2 päivässä
(460 arvostelua)
8.5
sismaster

Hello sir, Greetings !! I have 6+ YEARS of experience in Wordpress, Core PHP, Magento,iPhone, Android, Joomla & eCommerce. development. I have reviewed and analyzed your requirement . It would be nice if we h Lisää

100 $ USD 5 päivässä
(298 arvostelua)
7.0
sunsoftpro

First, I am sunsoftpro, I from VietNam. Nice to meet you! I have read your description and been interested in your project. I'm ready to discuss and do hard working so that complete great job. Please discuss requi Lisää

220 $ USD 3 päivässä
(109 arvostelua)
6.8
AltiuseCreaton

Hi, I can do your job but need to make a short chat discussion with you. let me know if possible for you. please let me know. You can check my profile and feedbacks of clients which itself I got from them . Hope the Lisää

277 $ USD 7 päivässä
(54 arvostelua)
6.8
avinashjain09

Hello, I have expertise in mysql. I can handle your work. I have read your requirements. Can we have more discussion. I have 5 years of experience in php,mysql,codeigniter,wordpress,payment gateway,API integra Lisää

80 $ USD 2 päivässä
(105 arvostelua)
6.4
prakash2813

Hi there, I am java developer. I have read the details and it looks very easy for me. I can develop a desktop tool for automating such tasks like identifying incorrect data, inserting data, updating data into databa Lisää

200 $ USD 3 päivässä
(13 arvostelua)
4.8
avi2105

Hi, Hope you doing good? I am experienced PHP developer having expertise in e-commerce domain using Zen Cart, Wordpress, Codeigniter, OsCommerce, CreLoaded, MVC framework, Prestashop, Opencart, HTML5, Bootstrap, Lisää

111 $ USD 5 päivässä
(43 arvostelua)
4.9
webcraft1

Hi Yes we can Run MySQL queries Coding Standards: We Use all guidelines and ethics of MVC Pattern, follow all rules as needed. Even with Plugin development for any opensource CMS we give a very strong and secure p Lisää

277 $ USD 15 päivässä
(12 arvostelua)
5.0
shukaibzafar

Hello Hiring Manager, i will use the client queries to fill the columns in database tables.i will also identify the missing columns data as well. I will also run the update query provided by the data values by the cli Lisää

100 $ USD 3 päivässä
(50 arvostelua)
5.1
imphasys

Hi there, I’d like to be considered for your job position. I’m a Software Developer with a strong background team for developing android, web application, SEO & Social media marketing. I can turn your requirement in a Lisää

155 $ USD 3 päivässä
(39 arvostelua)
5.0
techcristaglobal

on what parameter need to verify that data is correct and update . and what data is incorrect need to update it .

100 $ USD 3 päivässä
(22 arvostelua)
5.0
nileshbakotiya

Hello I have specialized programmers for various php frame works. So we are comfortably accommodating wide range of programming systems. With our 6 year experience, we understand clients and their Business needs b Lisää

116 $ USD 5 päivässä
(39 arvostelua)
5.0
kawalecove

Hello, We Believe in Quality and Delivering a Quality Product Thanks for your post on freelancer! Ecove Solutions is a trusted, global provider of digital marketing Services and IT Services; our clients rely us due to Lisää

111 $ USD 3 päivässä
(26 arvostelua)
5.0
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Lisää

100 $ USD 3 päivässä
(8 arvostelua)
4.3
usha12345

Hello, I have 4+year of experience in MySql and codeigniter so, i can do this job. I read project description and i am ready to start this work as soon as. Please share more information with me. Looking fo Lisää

83 $ USD 3 päivässä
(12 arvostelua)
4.5
Lesiasmith

Hi, Your job posting has caught my attention and I am keenly considering your job post. I have excellent experience in Mentioned skills. *******NO UPFRONT REQUIRED ,PAY ME WHEN YOU SATISFY WITH MY WORK********** Lisää

133 $ USD 3 päivässä
(7 arvostelua)
4.5
208 $ USD 3 päivässä
(18 arvostelua)
4.3
111 $ USD 3 päivässä
(42 arvostelua)
5.0
sheikDev

Hello, I'm interested to work on this. I'm good in my sql and can do the job effectively. Thanks,. Sheik

80 $ USD 4 päivässä
(20 arvostelua)
4.5
softgen01

Hi I am Anu, Having Good experience in Hybrid and Native Mobile Development & website develooment. I Read your Requirement and happy to inform you we are able to fulfill all your Need according to you, so can we discus Lisää

155 $ USD 3 päivässä
(7 arvostelua)
4.0