Find Jobs
Hire Freelancers

SQL Query for Repeat Status Logic

$30-250 USD

Closed
Posted 5 months ago

$30-250 USD

Paid on delivery
Project Description: I am looking for a SQL expert who can help me retrieve correct values from a Google Big Query database on a daily basis. The purpose of the SQL query is to retrieve repeated data. Skills and Experience: - Strong proficiency in SQL and experience with Google Big Query - Ability to write efficient and optimized SQL queries - Knowledge of data analysis and data manipulation techniques - Familiarity with working with large datasets - Attention to detail to ensure accurate results The ideal candidate should have a good understanding of SQL and experience with Google Big Query. They should be able to write efficient queries to retrieve repeated data from the database on a daily basis. Attention to detail is important to ensure accurate results.
Project ID: 37456086

About the project

30 proposals
Remote project
Active 4 mos 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
30 freelancers are bidding on average $167 USD for this job
User Avatar
Hi there, ★★★ Database Design & Development Expert ★★★ 8+ Years of Experience ★★★ I've read requirements and ready to retrieve correct values from a Google Big Query database on a daily basis.. I have completed multiple projects across various domains like Manufacturing, Inventory Management and Vehicle Monitoring System. I do have strong SQL and Excel expertise, through which I will be able to provide you standard and professional way of solutions to your requirements. Services I offer: ✔️ ER, EER Diagrams ✔️ Database creation(Tables, Views, etc) ✔️ Database Design(Normalization, Constraints, etc) ✔️ Programming(Joins/Triggers/Sub queries/Functions/Operators/Views/Sequence) ✔️ Database Modeling, Standardisation ✔️ Bug Detection & Fixing ✔️ Data Security ✔️ Group and sort ✔️ Excel macros, formula ✔️ Data import/export/backup/restore (any format) Databases I work on: ✔️ Oracle ✔️ MySQL ✔️ MS SQL Server ✔️ MS Access ✔️ Sqlite ✔️ NoSQL ✔️ MongoDB As the requirements on project are not complete and need discussion so i placed tentative bid. To provide you the best quote, let's have a chat! Best Regards, TechPlus Team
$250 USD in 1 day
4.9 (138 reviews)
7.7
7.7
User Avatar
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of 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. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$180 USD in 3 days
4.9 (68 reviews)
6.8
6.8
User Avatar
Hello! I took a delightful dive into your project description, and boy oh boy, it seems like my skills are a perfect match for this gig! I am an expert which have many years of experience on SQL, MySQL, Database Programming, BigQuery Quickly come hop into chat and chat it up to unravel more awesomeness! Let's bring your vision to life. Regards ,Christopher
$80 USD in 5 days
5.0 (13 reviews)
5.6
5.6
User Avatar
Hello, I have read your project description about Database Design. I am an expert in database systems and I have developed many database systems including but not limited to a database system for a School, County Bursary, Pos System and Sacco system. I have used tools such as SQL Developer, SQL Plus, SQLYog, MySQL Workbench, SSMS etc. Am confident I can handle your project. Kindly open a discussion with me so that we talk the best way to work. If you award me the project I will work closely with you throughout the whole project life span, communicating continuously at every stage with updates until the project comes to fruition, in perfect condition, and ready for submission. Hope to work with you soon! Thanks Nyaronyari
$80 USD in 3 days
5.0 (38 reviews)
5.0
5.0
User Avatar
Hi. I'm Kundan Bihari. I've checked the attached document, and I'd like to express my interest in helping you to write the SQL Script to get the Loan Status as per your business needs. Thank you
$150 USD in 2 days
5.0 (33 reviews)
5.1
5.1
User Avatar
Hello there! My name is Saima and I am an experienced freelancer with a wide array of skills that can be used to help you with your project. I specialize in database design, complex SQL scripting, data analytics and more. I understand you are looking for a SQL expert who can help you retrieve correct values from a Google Big Query database on a daily basis. My expertise includes SQL and working with relational databases which makes me the perfect fit for this project. I have extensive experience in SQL and Google Big Query which makes it possible for me to efficiently write optimized queries to retrieve repeated data from the database on a daily basis. Additionally, attention to detail is important for me to ensure accurate results. If you would like more information or need me to start work on your project please don't hesitate to reach out!
$140 USD in 4 days
5.0 (27 reviews)
4.9
4.9
User Avatar
Proposal - I can help you to write query in SQL OR GCP BigQuery. But you need to design the dag process to store the data into file or somewhere else. Let me know if you want to discuss further. I am a database / Business Intelligence / solution architect. I have more than 17 years of experience in various technologies as mentioned below: Database/Datawarehouse - SQL Server, Oracle, MySQL -- Proficiency (P4) NoSQL Database - cosmos -- Proficiency(P4) BI - Microsoft MSBI and Informatica ETL -- Proficiency (P4) Dotnet - C# (core) for Azure functions and API development -- Proficiency (P2) My Technical background • A goal-oriented professional with more than 17+ years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • 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;
$200 USD in 7 days
5.0 (28 reviews)
4.9
4.9
User Avatar
Hi there! I understand you are looking for a SQL expert to help you retrieve correct values from a Google Big Query database on a daily basis. I am confident that my skills and experience make me the perfect fit for this project. With 15 years of database development and web development experience using SQL Server and ASP.Net, I am well-versed in SQL Server programming, SQL Server query performance tuning as well as exposure to SQL Server 2012, 2014, 2016, 2019. I have extensive experience working with large MNCs and have worked in the banking and trading domain. If you give me the opportunity to join your team, I will guarantee that any data analysis or data manipulation required will be done with precision and accuracy so that you receive exactly what you need every time. Endlessly grateful for your consideration!
$300 USD in 7 days
4.9 (12 reviews)
4.5
4.5
User Avatar
Hello, We are expert in scalable database architecture design, stored procedures, normalization, and conceptual and logical design. We can deploy multiple types of database integrity such as entity, referential, structural etc. We also expert in building database triggers and constraints to ensure accuracy and consistency of data stored . We possess in-depth SQL knowledge to understand and review SQL and host language programs and can recommend changes for optimization. Also, dealing with performance problems is usually the biggest post-implementation nightmare. We're able to proactively monitor the database environment and to make changes to data structures, SQL, application logic or the DBMS subsystem to optimize performance. Procedural skills: We are skilled in design, debug, implement, and maintain stored procedures, triggers, and user-defined functions We are expert at collecting, storing, managing, and enabling query of the organization's metadata. Without metadata, the data stored in databases lacks true meaning. I look forward to discuss further in detail. Thanks, Ashish
$140 USD in 7 days
5.0 (2 reviews)
3.7
3.7
User Avatar
Hello sir, Hope you are doing great! I have seen your attachment and ready to start work on your project( Repeat Status of Loan in Tunaiku - Amar Bank).I have read all the things you mentioned in the attachment like background , Goals, Condition, Status and everything. #>>Please share the sample data..? I can assist You with the following terms in the database:- ============================================== **Database Optimization: I will start by conducting a thorough analysis of your existing MySQL database, including the table with 10 million entries. **SQL Query Improvement: I will review the SQL queries used in the Laravel Admin Panel, identify and eliminate any redundant or inefficient queries, and restructure them using best practices. **Scalability: It is a critical aspect of any database optimization project. . **Admin Panel Performance: The Laravel Admin Panel operates efficiently and responds promptly to user requests, I will focus on optimizing the application's business logic, minimising data loading times. I am Raj and I am a SQL expert with 10+ years of programming experience. I understand your project to retrieve correct values from a Google BigQuery database on a daily basis. I have the necessary skills and experience to help you complete this project. My expertise includes strong proficiency in SQL and experience with Google BigQuery. Lets get connected for further discussion. Regards, Raj T.
$250 USD in 5 days
5.0 (3 reviews)
3.2
3.2
User Avatar
Hello, my name is Basanta Kumar and I am a native of Odisha, India. I have extensive experience in the field of database programming, MySQL, SQL and other related technologies. From my career, I have worked in several large companies such as IBM, Accenture, Amazon and Google. I understand that you are looking for a SQL expert who can help you retrieve correct values from a Google Big Query database on a daily basis. My skillset includes strong proficiency in SQL and experience with BigQuery. Additionally, I have the ability to write efficient and optimized SQL queries that will delivery accurate results. Moreover, my attention to detail ensures that your repeated data is retrieved accurately every day. I believe that my expertise make me the ideal candidate for this project. Please feel free to reach out if you would like more information or an opportunity to discuss further how I can help you reach your goals for this project.
$30 USD in 1 day
4.8 (5 reviews)
3.1
3.1
User Avatar
Hello there I'm a data engineer with 3 years experience in bigquery and 8 years experience in SQL. Let's discuss more in details thanks
$250 USD in 7 days
5.0 (1 review)
2.7
2.7
User Avatar
Dear , After a comprehensive review of your project SQL Query for Repeat Status, I warmly invite you to explore my profile. Take a moment to assess my skill set, browse through my extensive portfolio, and peruse testimonials from highly satisfied clients. This overview aims to instill confidence in my suitability for the role. Let me showcase my expertise: Equipped to handle a range of projects, including web and mobile app development (Andriod & IOS), ESM solutions, e-learning platforms, online stores, API configurations, UI/UX design, and quality assurance. With over 13 years of industry experience in Database Programming, MySQL, SQL and BigQuery, I've built a reputation by successfully delivering 300+ projects on various Freelance Platforms. My commitment revolves around adhering to project timelines, maintaining quality, and consistently exceeding customer expectations. Eagerly anticipating your response. Warm regards, Faisal Hussain
$250 USD in 5 days
5.0 (1 review)
1.9
1.9
User Avatar
Hello Recruiter,

 I hope this message finds you well. I recently thoroughly reviewed your job description and fully comprehend your requirements. I am eager to express my interest in the position and am prepared to commence work immediately if given the opportunity.
 With over 7 years of experience as a Senior Software Development Engineer, I have successfully completed numerous projects similar to the one you've outlined.

My expertise spans a wide range of technologies, including Java, C++, C, Python, Golang, Data Structures, Algorithms, Data Extraction, Database Management System, System Design, Kafka, Rest API, Microservice Architecture, and SQL and NoSQL databases such as MySQL, Postgres, Redis, Aerospike, Hbase, Cassandra, MongoDB, Amazon S3, Hadoop, and Elastic Search. I am confident in my ability to deliver high-quality work, ensuring your satisfaction with the results.
 Additionally, my proficiency in competitive coding on platforms such as HackerEarth, SPOJ, CodeForces, and CodeChef. I am dedicated to providing you with the best service and will go the extra mile to meet your expectations. Please feel free to reach out for further details or to discuss how my skills align with your needs. Thank you for considering my application. I look forward to the possibility of contributing to your project.
 Best regards, Kalpesh Prajapati
$140 USD in 7 days
5.0 (1 review)
0.2
0.2
User Avatar
Hello, my name is DEEPAK and I am excited to help you with your repeat status query. With more than 15 years of experience in various fields such as business consulting, internet marketing, sales and software testing, I am confident that I can provide the best solution for your project. I have strong proficiency in SQL and experience with Google Big Query which would be perfect for this project. My skills include attention to detail to ensure accurate results. Additionally, I have the ability to write efficient and optimized SQL queries which would be necessary for your query to run successfully on a daily basis. I understand the importance of ensuring accurate results when it comes to retrieving repeated data so I will do my best to deliver accurate results. If you feel my skillset and experience are exactly what you're looking for then please don't hesitate to reach out with any further questions or requests for further information.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Ramgopal, My name is Ramgopal and I'm the CEO of MP, India. We specialize in providing database, web, WordPress, e-commerce and mobile app development services. I noticed that you are looking for a SQL expert who can help you retrieve correct values from a Google Big Query database on a daily basis. Specifically, you want the SQL query to retrieve repeated data. With my team's experience in SQL and experience with Google Big Query, we are confident that we can provide the best solution for this project. We have the necessary skills to write efficient and optimized SQL queries that will reliably retrieve repeated data from the database on a daily basis. Additionally, we take pride in our attention to detail when working with large datasets so we can ensure accurate results. If you're interested in discussing further how we can help you with this project please don't hesitate to reach out!
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, my name is Aziz and I'm a full-time WordPress developer & Graphic designer with 4+ years of freelancing experience. I've worked with hundreds of clients in diverse industries throughout the U.S. I specialize in WordPress, eCommerce CMS websites along with expertise in logo designing and have extensive experience in graphics and illustrations. I'm excited to hear about your project for SQL Query for Repeat Status! I have strong proficiency in SQL and experience with Google BigQuery which would be perfect for this job. My skillset includes data analysis and data manipulation techniques as well as familiarity with working with large datasets. Additionally, I'm an expert at attention to detail so you can rest assured that accurate results will be achieved every time. If you're looking for an experienced freelancer who can help you retrieve correct values from a Google BigQuery database on a daily basis, then please don't hesitate to reach out to me! I look forward to hearing more about this project and working together on it in the future.
$120 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Dear, I understand from your description that you are looking for a SQL expert who can help you retrieve correct values from a Google Big Query database on a daily basis. My skillset include strong proficiency in SQL and experience with Google Big Query which make me the perfect fit for this project. Additionally, I have the ability to write efficient and optimized SQL queries as well as knowledge of data analysis and data manipulation techniques which will ensure accurate results. I believe that my attention to detail and accuracy is best suited for this job as I do not want to incur any further costs or delay your project unnecessarily. Please feel free to reach out if you have any questions or would like me to provide more information about myself or my services. Thank you for considering me for this position! Best Regards Syed Mohsin Ali
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Certainly, I have extensive experience in SQL and am well-versed in working with Google Big Query. I can efficiently write queries to retrieve repeated data from your database on a daily basis. My attention to detail ensures accurate and reliable results. Let's discuss the specifics of your project to ensure I tailor my expertise to your exact needs. Looking forward to the opportunity to work with you. Best regards, sabir
$120 USD in 4 days
0.0 (1 review)
0.0
0.0
User Avatar
I have 2 years of experience in working with SQL. I have worked with all advanced concepts in sql like CTE's, subquiries, triggers, stored procedures, window functions and optimizations also. I have worked with bigdata technologies like hadoop, spark and hive. I have a year of experience as Data Engineer. Though I'm a data engineer, I'm interested on Exploratory Data Analysis(EDA). So I have a good grip on writing SQL queries.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDONESIA
Jakarta, Indonesia
0.0
0
Member since Nov 20, 2023

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.