MySQL: SQL Statement Help for Deduping, Merging Records, CSV Import

$10-30 USD

Zaprt

Objavljeno

pred skoraj 6 leti

$10-30 USD

Plačilo ob dostavi

I have a rough MySQL DB schema designed and need help with writing SQL statements to: 1. Create tables 2. Upload CSV data (thousands of records) 3. Dedupe the uploaded data 4. Merge records based on rules 5. Provide the SQL Statements and help implementing for uploading more data at a later time I have MySQL server running with Workbench on a local computer, so I can test your work on larger data sets. But you'll need your own dev environment. Sample input data file, DB schema, and notations with sample data will be provided to winning bidder.

Database Administration

Database Programming

MySQL

SQL

ID projekta: 17372596

Več o projektu

22 ponudb

Projekt na daljavo

Aktivno pred 6 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

22 freelancerjev je oddalo ponudbo s povprečno vrednostjo $51 USD za to delo

@softcarve

Hi, I would like to 1. create your table structure. 2. clean data to remove the duplicates. 3. sql to upload the data later. Get in touch to discuss more. Available to start now. Regards, Manish

$444 USD v 15 dneh

4,9

(77 ocen)

5,6

@seamantopcoder

MYSQL EXPERT HERE. Hi sir, i have developed my own sql called - YSQL from mysql opensource. So i have many experiences with sql and i am very interested in your project. Please let me discuss more and thanks.

$29 USD v 1 dnevu

1,6

(4 ocen)

3,3

@yassinekhaidouch

Hi friend I can do this work for you . we can discuss more over chat . I need to know more details about your mysql server ... for start working ...

$25 USD v 1 dnevu

5,0

(2 ocen)

1,2

@lemarin68

Experienced DBA using SQL Server, PostgreSQL,Db2, Oracle, Mysql 8 years in a row. I have workked with phpadmin, Mysql Workbench, Mysql CLI,no problem to build a self working environment.

$25 USD v 2 dneh

5,0

(2 ocen)

1,2

@sunilmudunuri

I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design. Here is few technologies I have mastered since last 9 years and can deliver the best solutions if you get me hired. 1) Sql Server 2005/2008/2012 2) MYSQL, MS Access 3) Oracle (PL/SQL), 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS.

$25 USD v 1 dnevu

0,0

(0 ocen)

0,0

@saroeunsaing

I want work as database design. i am strongly on database design an dot net framework . and i hope we will be able work together.

$25 USD v 1 dnevu

0,0

(0 ocen)

0,0

@sunishee3

As per the requirements of the project will complete the work in the given schedule. Have worked extensively in SAP Fieldglass on backends , transformation scripts and Sql Server DBs. Earlier worked with Oracle too.

$25 USD v 1 dnevu

0,0

(0 ocen)

0,0

@Tolfordtech

I am assuming that the csv upload piece is done and that all you need is to have the result of that de-duplicated. I live and work in the US. I'm available in the afternoon/evening of EST. I'm currently working at a temporary contract job and writing sql is my primary job at my current position, so I'll have no issue completing the task quickly. Please let me know if you have any questions for me.

$30 USD v 1 dnevu

0,0

(0 ocen)

0,0

@hfakoor22

Hi, I regularly perform complex T-SQL, MYSQL scripts for deduping, merging large datasets. I also modify large dat filed (used for uploads) using complex queries. Currently I'm an e-Discovery Analyst doing data mining for phone records and emails used for litigation. Previously I've developed small scale databases for a bulk mailer. I believe I fit your needs, and can help you obtain a deep understanding of the queries and what's going on in the background process.

$30 USD v 1 dnevu