Find Jobs
Hire Freelancers

Create a User defined functions (UDF) on MYSQL

$10-30 USD

Cancelado
Publicado hace alrededor de 7 años

$10-30 USD

Pagado a la entrega
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;
ID del proyecto: 13886003

Información sobre el proyecto

13 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
13 freelancers están ofertando un promedio de $39 USD por este trabajo
Avatar del usuario
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 en 1 día
4,9 (98 comentarios)
6,8
6,8
Avatar del usuario
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 en 1 día
4,9 (23 comentarios)
5,2
5,2
Avatar del usuario
Hello There, I think I can help you out to achieve this task. Please provide the details over PM. Thanks,
$35 USD en 1 día
5,0 (32 comentarios)
5,2
5,2
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
0,3
0,3
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
* 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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$15 USD en 4 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de BRAZIL
Rio de Janeiro, Brazil
5,0
2
Forma de pago verificada
Miembro desde mar 11, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.