Find Jobs
Hire Freelancers

SQL database set up with daily routines. requires audit table.

$30-250 USD

Closed
Posted about 5 years ago

$30-250 USD

Paid on delivery
I am scraping some data from online and would like to store that information in a database. I will be refreshing the data extraction multiple times a day and need an audit table to see changes to the data over time. I have 64 data tables with over 200 records each. the database must union these tables and compare the the final agregated values to the previous version of the file. That said, I would need the following tables, 1 table identifying any new items, 1 table identifying any items that disappeared, 1 table to identify if any one field in a record changes. There are approx 26 fields (if text in a field changes, I want the database to pick it up).
Project ID: 18499939

About the project

32 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
32 freelancers are bidding on average $172 USD for this job
User Avatar
⭐⭐⭐⭐ i am Full stack developer. ⭐⭐⭐⭐⭐⭐ I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. * 4+ years experience in web design and development and site build. If you hire me, you will get all what you want, Timely delivery 24 hours communication Hope to get your early response Thanks
$155 USD in 3 days
4.9 (79 reviews)
6.9
6.9
User Avatar
Hello, Hope you are doing well. I can help with you in your project SQL database set up with daily routines. requires audit table. I can assure you the quality job. I have good experience in Database Administration, Database Development, Database Programming, MySQL, SQL. We have worked on several similar projects before! We have worked on 425+ Projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. Thanks,
$200 USD in 3 days
4.9 (75 reviews)
6.9
6.9
User Avatar
yes sure I can help you.
$156 USD in 1 day
4.9 (88 reviews)
6.0
6.0
User Avatar
Hello How are you I have read your job description in detail . I am Xu please check my profile and you will understand I am a correct candidate It is a piece of cake Please contact me and Let's discuss more thanks for your posting . hope to hear from you .
$155 USD in 3 days
4.9 (65 reviews)
6.1
6.1
User Avatar
Hi, I have 14 years of database management experience in addition to software development. I can write an app to capture data differences in each table and create 3 audit tables from it. Lets talk about the details. Regards Fatih.
$250 USD in 7 days
5.0 (18 reviews)
5.9
5.9
User Avatar
Hi. I'm Enkhbayar B in Japan. I have read your description in detail and have interests in your project. I have many experiences that have ever done what is similar to your project. As a solution, I have a good idea to build your project perfectly I would like to have a discussion with chat to get more about your project. Thanks.
$155 USD in 3 days
4.9 (36 reviews)
5.3
5.3
User Avatar
hello kindly check my profile n lets discuss here i am ready to start now and work alone himanshu mishra
$155 USD in 3 days
5.0 (33 reviews)
5.1
5.1
User Avatar
Hi i am expertise in sql querying please let me know if u need it and also elaborate more info ao that it would be easy
$500 USD in 20 days
4.8 (19 reviews)
4.5
4.5
User Avatar
Hello, I am experienced sql/c# expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards
$222 USD in 3 days
5.0 (12 reviews)
4.1
4.1
User Avatar
I am an expert DBA with more than 10 years of experience. I will be able to resolve your project as per your requirement. Please feel free to discuss. Regards
$250 USD in 3 days
4.9 (8 reviews)
3.6
3.6
User Avatar
Hello, Need Web Development or Business Growing? My experiences range from building responsive software design that works well cross-browser to Business Goal. I am glad to provide a full solution for you. We Are in House of Php Web and App Developers. I have many experiences with Wordpress Blog+Woocommerce, Laravel Shop and Travel Website Development. ⭐ CMS(Wp Plugin and Theme Development&Update, All section of WP) ⭐ Website built(NodeJS, ReactJS,Vuejs, D3js, Redux, Laravel, Codeigniter) ⭐ Web Design( Wp visual composer and Html5, PHP, CSS) ⭐ Web service(Web Scraping and Crawling, SEO, Server Management and Migration) Thanks, Regards. Vikas Singh.
$200 USD in 3 days
5.0 (4 reviews)
3.3
3.3
User Avatar
I can help you with your db design/implimentation I can also help you write the code to produce a change audit of what is happening. this could almost be done more easily by using diff .. probably not but .. we could go over the design.. for example, it might be easier to just scan each item, if it exist in last scan then its not new and does not need to pop up with a data of 'first seen' and same with missing ones if they exist previously but do not exist in the new data they can be marked with a 'disapeared on' date, and then added to the audit report as an item that disapeared the audit report can be refected on a web site showing either new items, or discontinued items, depending on your view selection, and then you can see when each item becomes availbel, or became discontinued this script can run as often as you normally run it
$172 USD in 3 days
5.0 (1 review)
1.5
1.5
User Avatar
7+ years of Experience in software development with World's best companies IBM and Infosys. Received best employee award in IBM. Best work: Completed a project work $60K on unknown JIVE technology within 2 weeks. I am a highly motivated individual with excellent expertise in software development. Why me? Having huge work experience in big companies, I know how to do work which will be security proof, easy to enhance in future and which does not fail after 100 user hits on your site. Most developers build and deliver cheaper and earlier but their code might not run for more than a month or two and your server will soon be overloaded and site will become extremely slow to browse. So choose fairly.
$111 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I am having 5 years of experience and I do queries in my every day life. looking forward to work with you.
$222 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have more than 5 years of experience in SQL and MySQL. I can work for your request and provide the result as planned. As new to freelancer I am looking for the opportunity.
$100 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have been using sql from past 6 years now. Creating tables and validating all this data will not be a difficult task once we know the data. Timeline we can negotiate once we know the data and urgency.
$166 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hello, you didn't mentioned what environment you have for your database. but i think the job can be done as you described in 3tables.
$111 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I'm interested in your project. Your project fits the exact thing what I'm looking for to gain experience and to put something on my resume. I'm currently an aspiring data scientist and have quite a experience in sql queries and databases. Matter of fact you don't even need to pay me as I'm simply looking for projects/opportunities to work on. If you are interested in my proposal, I would love to hear about this task more. Thank you Gurbaj
$30 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i ' d like to considered for your project . we are a team of developers with a strong background developing skills, including project of various categories. we are master in writing database sql query. i had gone through your requirement and i know that it can be solve through plsql code using database trigger
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am familiar in sql,database development.i can do this using join and subquery concept.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Montclair, United States
0.0
0
Member since Aug 5, 2010

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.