Find Jobs
Hire Freelancers

Simple T-SQL queries for Data copying and cleanup

$15-25 USD / hour

Cerrado
Publicado hace más de 4 años

$15-25 USD / hour

Azure SQL Database. Connection string and credentials will be provided when hired. As well as a discussion of the details. I have a restaurant app that has menus and products that need to be cleaned up. There are many products that only have a few fields filed in and no related records. I would like to copy from the few records that I have where all the details are completed. After writing the basic scripts, they should be run against many items in the database. Typical copy script will have approximately 5 tables and not more than 100 fields. You must be able to look at data to see how it can be best organized. This is simple T-SQL but it requires data intelligence to understand what needs to be copied where. Tiny database (hundreds of rows) less than 40 tables. Additional T-SQL scripts for importing data and other tasks will be needed I suspect this is a short job, but if the job is done well. there will be opportunity for more work in the future. I know T-SQL, I just have not had the time to get it done. The person selected, if a great job is done, may also get an opportunity to work on some significant reporting, data migration and integration work coming in the soon (days to weeks).
ID del proyecto: 23451704

Información sobre el proyecto

38 propuestas
Proyecto remoto
Activo hace 4 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
38 freelancers están ofertando un promedio de $21 USD /hora por este trabajo
Avatar del usuario
i am a lead .NET software engineer and responsible for creating a web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck
$15 USD en 40 días
4,8 (66 comentarios)
6,7
6,7
Avatar del usuario
Hello, I can help you to create T-SQL queries for Data copying and cleanup I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$20 USD en 40 días
4,9 (28 comentarios)
6,1
6,1
Avatar del usuario
Hi there, I am interested in your project. This is what I understand from the project description: You have a separate database of products with complete details; and There is a restaurant app with a separate database So you wanted to run a matching of your database against the app database. And the end result will be is the app database will contain data from your database. Please let me know if my understanding is correct. Thanks, Danniel F.
$15 USD en 40 días
5,0 (63 comentarios)
5,8
5,8
Avatar del usuario
Hello! I am a Computer Engineer, MBA, MCSA SQL Server, and MCSE Data Mgmt and Analytics, with 14 years of experience in Data Engineering projects and tasks. I am a near-native English speaker, currently available, and results-oriented. I have plenty of experience working with Azure and T-SQL, including reporting, migrations and optimization. I can provide you with valuable information, experiences and best practices regarding Azure and SQL. Also, I have plenty of experience writing SQL code. I can help you writing robust, efficient, and easy-to-understand SQL code. We can discuss details over chat if you need it. Thanks! Sergio
$25 USD en 40 días
4,9 (25 comentarios)
5,9
5,9
Avatar del usuario
Hi, My name is Ali and I can work on it with immediate availability. You said rightly that it is small job but technical and delicate and I am expert in this kind of work. Let's have quick discussion so I can work on it.
$20 USD en 40 días
5,0 (43 comentarios)
5,2
5,2
Avatar del usuario
Proposal - I have gone through your project details. You can expect any kind of work on SQL/SSIS/SSRS from me. Let me know if you want to discuss further. I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database/Datawarehouse - SQL Server, Oracle, MySQL BI - Microsoft MSBI and Informatica ETL Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... Cloud - Azure (Paas and IaaS) My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
$20 USD en 40 días
5,0 (31 comentarios)
5,0
5,0
Avatar del usuario
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 assortment of technologies MS SQL Server 2000/2005/2008/2012/2014/2016/2017, SAN Storage and Backup Solutions Thank you for your time and consideration. Best Regards, Shaker
$15 USD en 40 días
5,0 (21 comentarios)
4,7
4,7
Avatar del usuario
Hi, I am very interested to work on your project. I have 17+ years experience in Web Development using a large variety of programming languages, frameworks, database architecture, APIs, CRMs, ERPs, mobile development, web design, development tools. There are more then 1000 projects(small/medium/high complexity) successfully implemented and few of them related with yours can be seen on my freelancer.com portfolio. * * Note that my bid is relative and will be adjusted after detailed estimation of implementation effort/coast ** Let's start our collaboration by sending me all details in a written document which will be used as reference during project implementation Thank you! AdiC
$27 USD en 40 días
5,0 (2 comentarios)
3,6
3,6
Avatar del usuario
I am interested in this project. I have plenty of experience working with data and database table structure. I'd like to discuss this project with you. Thanks!
$22 USD en 40 días
5,0 (4 comentarios)
3,5
3,5
Avatar del usuario
Hi, I am a SQL developer and BI specialist with over a decade in the industry. I can assist you with your queries and design of the underlying data structures. please let me know if you require my assistance. kind regards, Tom.
$16 USD en 40 días
5,0 (4 comentarios)
3,3
3,3
Avatar del usuario
Hi. I  have more then 10 years of experience in SQL Server databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performance tuning. I am also good for BI part like SSIS, SSRS and SSAS. I have attached my profile.  I am immediate available to join. Thanks Anil Patel
$16 USD en 40 días
5,0 (6 comentarios)
3,3
3,3
Avatar del usuario
Hi, I am proffessional developer with 8+ years experience in SQL, I have Microsoft SQL Certificate and also have experience with Azure
$22 USD en 20 días
5,0 (2 comentarios)
3,3
3,3
Avatar del usuario
hi i have reviwed your project description. i have 12 years experience in sql server quries. message me for further discussion
$22 USD en 30 días
5,0 (1 comentario)
2,4
2,4
Avatar del usuario
Hi, Thank you for sharing your requirements. I hope you are doing good and having a nice day. I read your project details carefully. I'm available to start work on your project immediately let us discuss more over chat. I will design your website according to your requirements. I have 6+ years of Microsoft technology (.Net), SQL Server 2008 R2 and above, javascript, jQuery. I have good experience in SQL complex queries. Thanks Kamal Bhagat
$20 USD en 35 días
5,0 (2 comentarios)
2,1
2,1
Avatar del usuario
Hello, I read your project description and understand all. I have 20 years in Database development, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Excel, VBA VB6, Vb.net, and MS SQL server I will make the perfect product what you want. I promise to complete your project within your time and budget beyond your expectations. I am willing to work at lower pay. Let me know when we can discuss and share all.
$15 USD en 40 días
5,0 (3 comentarios)
2,2
2,2
Avatar del usuario
Hi Greetings of the Day, I am interested in this task, I am full time freelancer carrying 15 yrs of experience in Web and Windows development and Mobile development using ASP.Net, C#, WPF, SQL server, Xamarin, WebAPI, VB6, ASP , XML, Cr Reports etc. I have 4 years experience as well in remote working (as freelancer) for Overseas clients. Please feel free to contact me. Thanks
$20 USD en 40 días
5,0 (4 comentarios)
2,1
2,1
Avatar del usuario
Hi I have 5+ years of experience in working with Oracle\PL SQL and also 4+ years of experience in working with Mssql. I think I can to make it.
$20 USD en 40 días
5,0 (1 comentario)
1,0
1,0
Avatar del usuario
Hi, I am a Bangladesh based freelancer. I am working in ERP industry for almost 4 years. So these types of requirements are very common for us. Let me know, if you need my assistance. Regards- N. A. Nahin
$16 USD en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I have reviewed your project posting, seems to be an easy job and would be much more interested in long term association with you. Looking forward to hear from you soon. Regards
$15 USD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, Im a dba and I worked previosly on Data warehouse, BI and analytics teams. Right now Im working with sql server and AWS
$15 USD en 20 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Lakeville, United States
5,0
4
Forma de pago verificada
Miembro desde dic 18, 2019

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.