Create a User defined functions (UDF) on MYSQL

$10-30 USD

İptal edildi

İlan edilme:

yaklaşık 7 yıl önce

$10-30 USD

Teslimde ödenir

I have a query that run over MYSQL and i need to create a User defined functions (UDF) to optimize my work. the query runs over two tables: repository_clinicaltrial and repository_institution ###Query select distinct state as estado, (select count(id) from repository_clinicaltrial where primary_sponsor_id in (select id from repository_institution where state = estado)) as qty, (select count(id) from repository_clinicaltrial where primary_sponsor_id in (select id from repository_institution where state = estado) and is_observational = 1) as observacional, (select count(id) from repository_clinicaltrial where primary_sponsor_id in (select id from repository_institution where state = estado) and is_observational = 0) as intervencional, (select count(id) from repository_clinicaltrial where primary_sponsor_id in (select id from repository_institution where state = estado) and trial_id like "RBR%") as aprovados from repository_institution order by qty desc;

C Programming

MySQL

Software Architecture

Proje No: 13886003

Proje hakkında

13 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 7 yıl önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

13 freelancer bu proje için ortalama $39 USD teklif veriyor

@hbxfnzwpf

I am very proficient in c and c++. I have 16 years c++ developing experience now, and have worked for more than 7 years. My work is online game developing, and mainly focus on server side, using c++ under Linux environment. I made many great projects using c++, for example, I made the tools which could convert java codes into c++ scripts, of course garbage collection included, this was very similar to a compiler, and was very complex. I also made our own mobile game using c++, I can show you the demo of client, if you like. I am very proficient in java also. I have a very good review on Freelancer.com, I never miss a project once I accept the job, you can check my review. Trust me, please let expert help you.

$100 USD 1 gün içinde

4,9

(98 değerlendirme)

6,8

@kmpal

Hi, I am an experienced developer with vast experience in .NET, MVC and SQL available for this project. I am full time freelancer available 10 hours daily. Thanks and best regards Khalid

$35 USD 1 gün içinde

4,9

(23 değerlendirme)

5,2

@luminous15

Hello There, I think I can help you out to achieve this task. Please provide the details over PM. Thanks,

$35 USD 1 gün içinde

5,0

(32 değerlendirme)

5,2

@alenkopic

Hi, I'm SQL developer with 3+ years of professional work experience. Why do you think that UDF functions would optimize your code.?They would just make it more readable, but not necessarily faster. Please, feel free to contact me. Best regards, Alen

$10 USD 1 gün içinde

5,0

(1 değerlendirme)

0,3

@lalitatmt

Hello Sir/Madam, I am having around 13 years of experience in mobile & .NET technologies(C#/VB). I am expert in asp.net MVC, Cordova, Xamarin, Android, IPhone, Web API, asp.net, WPF, AngularJs, TypeScript, ExtJS, YUI, JQuery, Bootstrapper frameworks. I have gone through your requirement & it exactly match with my skills. Looking forward a positive response from your end

$55 USD 1 gün içinde

0,0

(0 değerlendirme)

0,0

@biderme

A proposal has not yet been provided

$25 USD 1 gün içinde

0,0

(0 değerlendirme)

0,0

@mkvaish10

Hi Regarding this project, I have got lots of experince and confident to give you fast results. Though new to Freelancer, but i have got good amount of experience of working on more than 50 APIs stimulated projects and thus giving me enough confidence to fulfill the requirements of your project. Through my professional journey I have got more than 4 years of experience working with latest APIs (e.g. Ebay, Amazon, DHL, UPS, FedeX, Quickbooks, Myob, Yahoo Finance, social APIs, bestbuy, champslog, Dwolla, e-conomic, all popular Google and social APIs and many more),CRMs(SugarCRM,Zoho,SalesForce,Vtiger etc.) and technologies such as PHP | MySql | WORDPRESS | JOOMLA |CODEIGNITER | CakePHP and more. I feel self-motivated, an adaptable person having good interpersonal, time management, project management and problem-solving skills with high work ethics. Please give me a chance to serve you. Thanks

$35 USD 1 gün içinde

5,0

(1 değerlendirme)

0,0

@Trinadhkunuku123

A proposal has not yet been provided

$25 USD 1 gün içinde

0,0

(0 değerlendirme)

0,0

@Pranjspyer

5+ years of Experience on MySQL, MS SQL Server2008, 2012. Worked as a SQL Trainer for Analytics firm. I guess due to some issues, I could not see your attachment. Approach : 1. Understanding your requirement 2. Optimizing your current query Feel free to connect me for further discussion

$27 USD 1 gün içinde

0,0

(0 değerlendirme)

0,0

@milindsrivastava

* Expert in Database Designing, Database Modelling & Database Architecture * Extremely competent with Linux, UNIX, MySQL, PostgreSQL, MongoDB & AWS Database Services (RDS and DynamoDB). * Proficiency in managing configuration, maintenance, migrations of large scale engineering systems and application software & hardware devices with a focus on database administration * Expertise in assessing and mapping business requirements and translating these requirements into techno-functional specifications, designing custom/latest solutions associated to database development and design * Enhanced database performance, performed restores, implemented recovery procedures, managed performance tuning and conducted regular system backups to safeguard the businesses at critical times * Experience in excellently managing the complex security design, configuration, deployment, administration, management and troubleshooting complex security configurations associated with databases. * Comfortable with Cloud Environments such as AWS VPC, AWS EC2, AWS S3 and the database service in AWS i.e. RDS and Dynamo DB. * Written migrations and multiple re-engineering implementations using stored procedures and stored functions in MySQL/PostgreSQL.

$25 USD 1 gün içinde