need some database expert to do this

₹100-400 INR / hour

Closed

Posted

over 7 years ago

₹100-400 INR / hour

Create a database in MySQL that contains monthly visitors to three web sites over a two year period. Two of the web sites are in California, and the other web site is in New York. You’ll need to insert 72 (2 years x 12 months x 3 web sites) rows of “made up” data into your MySQL table(s). Your deliverable here is all of the SQL code required to create and populate the tables, and to then create the .CSV file that Tableau will ingest (Tableau can connect to MYSQL databases, but to avoid the need to replicate local permissions,)

Database Administration

Project ID: 12325747

About the project

13 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

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

13 freelancers are bidding on average ₹327 INR/hour for this job

@point5nyble

Hello, I have been working with a MNC based company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: Expert in SQL Server, Oracle and MS Access Databases Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script Expert in excel Macro Expert in C & C ++ Programming I have experience in all the above areas which I have gained during execution of project work As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Point5Nyble

₹388 INR in 40 days

4.8

(41 reviews)

5.0

@testotorko

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. I am an experienced Web Developer and Web Designer, and have worked with wide variety of skills like PHP, MySQl, jQuery / Prototype, Javascript, HTML, CSS and more for many years. I also have worked over many Wordpress projects. Have good communication skills and great responsibility.

₹277 INR in 40 days

5.0

(12 reviews)

3.9

@rreddi

Sql certified professional here. worked 8years on various DB. I can do this job and also can advice you on how your db should integrate with other 3rd party systems too. let me know if interested. Thanks, Raj

₹400 INR in 40 days

5.0

(2 reviews)

3.3

@shivang28

Hi, I have been working on JAVA projects as an IT professional, I would like to work on your project. I hope my skill set help you achieve desired results. Looking forward towards working with you.

₹277 INR in 40 days