Find Jobs
Hire Freelancers

Design, create MySQL DB and import CSV files with Stored Procedures normalized

€30-250 EUR

Completed
Posted over 5 years ago

€30-250 EUR

Paid on delivery
Hello Could YOU help me creating a mysql database? - Design & Create MySQL DB - Importing CSV files - Stored Procedures (with loop) to store the imported data normalized -- Its important that it's everything imported with a stored procedure, because this data updates daily and I need to upload it to the database. It's all for financial stock data. //Build the index of all stocks with metadata 1. import tickers_fin.csv. This is the primary list (symbol = primary key) of all i need. 1a. import to db with Stored Procedure 2. import [login to view URL], [login to view URL], NYSElist_fin.csv. If the symbol matches, overwrite the Name from this files, otherwise use the Name from tickers_fin.csv. All symbols which don't not exist in [login to view URL] should not be imported. 2a. use a separate field for AMEX(=NYSEMKT), NASDAQ and NYSE, don't overwrite or replace the data from [login to view URL] 2b. save also the sector and industry group in a separate field. 2c. import to db with Stored Procedure //Import Fundamentals and Technicals 3. import [login to view URL] 3a. import to db with Stored Procedure 4. import [login to view URL] 4.a import to db with Stored Procedure //Dimensions [login to view URL] (26 columns) [login to view URL] (72 columns) [login to view URL] (159 columns) [login to view URL] (6 columns) [login to view URL] (6 columns) [login to view URL] (6 columns) If you like to know more about the csv files, I can send you some samples via direct messaging. Best regards, Patrick
Project ID: 18279838

About the project

24 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello Patrick, Thanks for the detailed specs - this makes it extremely easy for me to estimate and quote. I am a veteran (25+ years) database developer with real industry experience in MySQL (v4.x thru 8.x), Oracle (v6 thru 12c) and SQL Server (v7 thru 17). Over these years, apart from SQL and procedural SQL, I have been routinely involved in transferring data up and down from/to databases using various formats CSV,TSV,XML,JSON etc. I have worked with Citibank, Deutsche Bank previously (over 10 years). Also worked in HealthCare. I communicate near-natively in English. No-tall-talk - simple delivery of code as per specs given (once again, thanks). I look forward to hearing from you. Best Regards Kashi
€155 EUR in 5 days
5.0 (14 reviews)
4.8
4.8
24 freelancers are bidding on average €140 EUR for this job
User Avatar
Hello, Hope you are doing well. I have 6 years of experience in Linux and Mysql. I will help you to upload frequently csv to Database with cron I'm ready to start Regards. VishnuLal
€100 EUR in 1 day
5.0 (277 reviews)
6.9
6.9
User Avatar
hi i have 4 years experience in web development so i can do this task easily ,hi i have 4 years experience in web development so i can do this task easily
€111 EUR in 3 days
5.0 (48 reviews)
5.6
5.6
User Avatar
Hi there, I have strong expertise in database relation and management, plsql, dynamic queries, pivot tables, uml diagrams like class, ER, activity, database normalization, stored procedures, functions, triggers and more. I just read the details, this is an easy job for me. You can view similar projects I've completed on my profile past work with reviews. Message me, I would like to discuss further over chat.
€200 EUR in 2 days
5.0 (34 reviews)
5.7
5.7
User Avatar
I m a database administrator with 8 years of experience in this industry. I read your project details and attached files and I understood your needs ,I can do what you want in the deadline just contact me and we can discuss more about the project.
€30 EUR in 10 days
5.0 (17 reviews)
5.4
5.4
User Avatar
Hello I read your job description carefully and understood what you want As you can see my profile, I have some experiences in web development. So I am familiar with Mysql and various languages. If you want, I can build simple interface for this work. Looking forward to interview with you. Thanks
€150 EUR in 3 days
5.0 (13 reviews)
5.2
5.2
User Avatar
Hi, I read carefully your project, and I wanna do it for you. If you wanna work together, send me a message to discuss details.
€30 EUR in 3 days
5.0 (36 reviews)
4.9
4.9
User Avatar
Hello Nice to meet you. I'm full stack developer with 4 years experience in sql programming. Please contact me if you are looking for a sql expert. But i think read the csv file in the stored procedure is not simple, maybe we need to import in the temp table and process that. I can start work right now. Thanks
€200 EUR in 3 days
4.9 (9 reviews)
4.3
4.3
User Avatar
Please pingme if u interested to work with freelancer and also let me know how many cdv files to import
€222 EUR in 6 days
4.5 (5 reviews)
3.1
3.1
User Avatar
Hello, Hope you are doing well. Kindly share the project detail so that we can discuss and move further.. Thanks & Regards, Aklesh S. Singh
€100 EUR in 3 days
5.0 (3 reviews)
2.5
2.5
User Avatar
Hello? I am fullstack developer. I have read your requirement in detail. As you can see my profile,I am one of top 1% mobile/website developer who has 10+ years of experience. I had finished completely a similar project before and I have finished a lot of project like this. Working with me, you will have a good experience and good friend and save more time and money. Best Reguard!!!.
€155 EUR in 3 days
5.0 (3 reviews)
2.4
2.4
User Avatar
Hello patrick, i saw the csv files you want to import and store them into mysql db using store procedure. According to the description i will import the data using store procedure and all conditions will follow like data need to replace if condition follow otherwise create new field. If you can tell me number of tables will be required and their names then it would be great, if you can also show the structure how the database will look like after import or number of tables then we can do this quicker. Send me personal message so we can discuss more about this and start work on it. Thanks Roopesh
€111 EUR in 5 days
5.0 (1 review)
1.2
1.2
User Avatar
Hello sir i can help you in creating a mysql database.i can import your files too. i am website Designer and Developer and I have 4 years of hands-on experience efficiently coding websites, plugin Development and applications using Wordpress, Php, Laravel, Drupal, modern HTML, CSS, and JavaScript. Message me so we can make more discussion on your project and can start it asap.
€55 EUR in 1 day
5.0 (2 reviews)
0.4
0.4
User Avatar
I read the task description and I can do it.I have worked on many such projects.I can work on urgent basis and for a reasonable rate..Contact me so we can discuss further
€30 EUR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, nice to meet you. I’d like to be considered for your proposed problem. I'v checked your requirements carefully. I'v rich experience in Mysql database . I am rated in this field as the Veteran. I can start work immediately now for you and can provide you perfect result for your requirements. I have no experience working with other employers, but I think they are the best fit for my ability. I am sure I can satisfy you surely and complete in a short time. Thank you for spending your valuable time on my reporter.
€155 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can help you in this since I worked on ssis tool and quite sql and stored procedures
€155 EUR in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am expert in wordpress and I have deployed various website from PSD to wordpress. I create my own theme and html to incorporate psd to wordpress I am expert in full-fledged plugin Creation. I follows RWD(Responsive Web Design) I create plugin with standardised and open code.
€155 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have an software development experience around 6 years and have working experience with MySql. View my profile for more information.
€111 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey I have experience with CSV file read in Java, Python also have good experience with mysql. But the work you need to be done is not clear if you can clarify it a bit more it'd be great. Looking forward to work with you.
€155 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have experiences on mysql especially database design and migration. i have worked database for reports, business inteligence, erp systems. your database will have millions of records and a suitable structure needs to be considered carefully.
€222 EUR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi. I'm available right now to do this project. Just contact me and we'll talk about it. Regards...
€144 EUR in 4 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SWITZERLAND
Appenzell, Switzerland
5.0
3
Payment method verified
Member since Jul 8, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.