Completed

SQL Guru needed

Job Description:

I have a text field in a SQL database that has data with html code in the format:

<br>Year - <b>title</b>, venue, city, comments

For example:

<b>Group Exhibitions:</b>

<br>2022 - <b>Heysen Prize for Landscape</b>, Hahndorf Academy, Hahndorf, SA, finalists exhibition

<br>2022 - <b>GreenWay Art Prize</b>, Art Est. Art School and Gallery, Sydney, finalists exhibition

<br>2022 - <b>Swell Sculpture Festival</b>, Currumbin, Qld, finalists exhibition

<br>2022 - <b>North Queensland Ceramic Awards</b>, Perc Tucker Regional Gallery, Queensland, finalists exhibition

and I need these parsed and placed as individual rows in another table within the db. However, there is an authority list as a table in the same db that needs to match the title (data with the <b>xxx</b> tags) reliably.

The output should match this:

id artist_id name artprizes_id year matchedTitle confidence

6589727 26487 Lea Kannar-Lichtenberger 583 2022 GreenWay Art Prize 100

6589728 26487 Lea Kannar-Lichtenberger 44 2022 Swell Sculpture Festival 100

6589729 26487 Lea Kannar-Lichtenberger 934 2022 North Queensland Ceramic Awards 100

6589730 26487 Lea Kannar-Lichtenberger 684 2022 Wyndham Art Prize 100

etc..

Issues:

At the moment the first row in the source is not being matched (Heysen Prize for Landscape).

And it takes > 4hrs to process the script.

Delivery

It must match the title string >99% and it should if possible process more efficiently (faster) than the current script.

Payment

I will only contact freelancers with a rating >4.8 and who accept that payment for the milestone will only be made on successful completion of the project. I will make the tables available to the successful freelancer.

Thank you for your time

Skills: SQL, Database Administration

About the Client:
( 19 reviews ) Balaclava, Australia

Project ID: #35420714

Awarded to:

noureen23

Hi There, Just went through your requirement "SQL Guru needed to". I am Senior Database Developer with 15+ years of experience in database development using complex SQL queries. === Advanced and nested sub queries === More

$100 AUD in 4 days
(19 Reviews)
4.0

35 freelancers are bidding on average $146 for this job

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am a More

$140 AUD in 7 days
(32 Reviews)
6.0
tutulsoft

*** TRUE SQL GURU *** I read your full description and well understood the full requirements , i can do it perfectly with faster query execution and exact output as desired. we can talk to start , thank you

$190 AUD in 3 days
(34 Reviews)
5.7
bitnetservices

I am based in Sydney and very well versed with the scripts stored as data values. Do let me know. I am pretty much available for rest of the day and can do it in day. Thanks Jag

$250 AUD in 7 days
(6 Reviews)
6.1
bhupen2606

Hi, i have extensive experience in query development and performance tuning of queries. Let me have a go at your issue. i've broadly understood it and would like to attempt it. Please share the table and query details. More

$50 AUD in 2 days
(44 Reviews)
4.9
freelancepraful

I can help you with sql server queries , please ping/connect me now I am available. Please check my reviews and project which I have completed. I can create sql queries for sql server database as per design, let me kno More

$30 AUD in 1 day
(6 Reviews)
4.4
Shakerfawzy

Hi, I can help you I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions in SQL Server environments. Proficient in an as More

$140 AUD in 3 days
(15 Reviews)
4.3
bizmanas

Hi i have 15 years of experience in sql server. Development, Mysql development, postgresql development. Expert in database designing and performance tuning sql queries. Helped build lot of reporting using power bi. Sol More

$300 AUD in 3 days
(12 Reviews)
4.5
Nidhijain123

Hi, I've gone through your requirement and i am very much interested to work on this task. I can start the work immediately and complete as soon as possible. Please respond to me so that we can discuss it in detail. L More

$250 AUD in 7 days
(2 Reviews)
4.0
escajedajavier20

Hello Martin! Here is an expert who you are looking for. I have rich experience in database management and can help you with my best skills. Please contact me.

$140 AUD in 7 days
(2 Reviews)
3.2
vincentgrerry

Hi there.. I'm personal freelancer and interesting with your project are offering and also already read your project description.. so hopefully could help you to debug and solve the query issue and provide some corre More

$30 AUD in 1 day
(6 Reviews)
3.1
ShakeelASESE

I am working as a Developer, Programming Expert, Data Scientist and expert in ->Python, Tensor Flow Framework, C, C++, C#, VB, Visual Studio, Online Scrapping, ->Analysis and Modeling MATLAB, Predictive Modelling, St More

$30 AUD in 7 days
(2 Reviews)
2.9
lalitdeveloper7

I can Let me know more about it I am a freelancer with having 6 years of experience. I've gone through your project. I have read your requirements completely and. I am very much sure that. I can do this with full of h More

$140 AUD in 1 day
(5 Reviews)
2.9
aaldanawg

❤️Warm greeting❤️ I have just checked your job detail. I have more than 6 years of experience in this field. I am confident I can deliver you perfect result with my skills and experience. Looking forward your posit More

$200 AUD in 7 days
(1 Review)
0.0
Work12345x

Hello there! I am a software developer with 6+ years of experience in developing custom software solutions for businesses. My specialties include web development, database management, and software maintenance. I have More

$140 AUD in 3 days
(0 Reviews)
0.0
josvald

Hello. SQL expert is here. I can do it perfectly on time. Josue.

$100 AUD in 2 days
(0 Reviews)
0.0
DanielCatalani

Hi there. Expert in SQL based languages such as MySQL and SQLite. I've been backend developer for about 8 years now specializing in PHP and MySQL, I could implement this logic as requested and analyze why your current More

$140 AUD in 7 days
(0 Reviews)
0.0
Noman4077

I have experience and good grip on MySQL, PHP, HTML ,CSS, JavaScript , Bootstrap and .I can do your task quickly and in smart budget. I have a little question could we please have a chat? Also i can show you my some p More

$30 AUD in 1 day
(0 Reviews)
0.0
tsmcguinness

hello. i am sql expert having rich experience for 6+ years. i can improve your script. i'd like to see you on chatbox. we can discuss details. please contact me. i provide the best solution. thanks.

$150 AUD in 7 days
(0 Reviews)
0.0
rabindratandukar

Hi Client, I want to help you with this. I have been working as SQL programming and make sure I will be the perfect resource for this job. Please text me so we can go further with this task.

$30 AUD in 2 days
(1 Review)
0.0
DenisGlushko

Hello, I will do my best for your project! Please send me your message and let's discuss more detail. Thanks.

$200 AUD in 7 days
(0 Reviews)
0.0