Find Jobs
Hire Freelancers

i need a help for my sql project

$30-250 USD

Closed
Posted about 1 year ago

$30-250 USD

Paid on delivery
Convert your ER diagram to a relational schema. ( ➢ Underline all key attributes in your relations. ➢ Specify all functional dependencies for each relation. (Mapping) - Use Oracle to create the normalized tables. - Populate your tables with 5 rows at least. - Design and implement at least 4 queries. As specified below Data Retrieval Queries with Select (total of 4 Queries) ➢ Where ➢ Order By ➢ Group By ➢ Aggregate functions ➢ Subquery ➢ Join query - Note: ➢ You are free to mix between all those clauses in one or more query, but you have to use them all so the total number of queries for Data Retrieval Queries with Select in the end will be 4. ➢ Using select all (*) is NOT accepted. - Design two stored procedures as the following ➢ Create a PARAMETER based SELECT QUERY stored procedure which return records based on parameters? ➢ Create an UPDATE query based stored procedure
Project ID: 35878638

About the project

37 proposals
Remote project
Active 1 yr 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
37 freelancers are bidding on average $158 USD for this job
User Avatar
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. 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
$220 USD in 4 days
4.9 (42 reviews)
6.4
6.4
User Avatar
i need a help for my sql project Hi, hope you are doing well, I am free nowadays and can start your work. For my experience kindly once have a look on my profile and check my work samples which I attached on my profile. Send me a text for further discussion and for creating long term business relationship. Thank you for your time and consideration.
$190 USD in 3 days
5.0 (13 reviews)
5.2
5.2
User Avatar
Hello, Thanks for job posting. I read your project description . I have extensive experience in SQL server DBA and development. I am one of Microsoft certified SQL server DBA. I specialized in SQL server and Azure. Provided DBA services to many clients. Contact me and let's talk together about project details. Thanks
$80 USD in 7 days
5.0 (17 reviews)
5.2
5.2
User Avatar
I'm a UK based database developer/designer with over 18 years of experience in various databases, including Oracle, SQL Server, PostgreSQL and MySQL. I'm also an Azure certified data engineer with experience in the ETL process. I can certainly help you with this project. Regards, Kam
$100 USD in 7 days
5.0 (23 reviews)
4.9
4.9
User Avatar
Hi There, hope you having good day. I am glad to offer my services for "Sql Project". I have 15+ years of experience in Oracle Databases. Designing Schema, SQL Programming , Creating Procedures/ Functions for Data Retrieval , updation . My experience makes me confident to assure you 100 percent accurate solution according to your requirement. ======My clients reviews are proof of my commitment and support ===== Looking forward to discuss details. Thanks for your time. Regards Saima
$150 USD in 5 days
5.0 (23 reviews)
4.6
4.6
User Avatar
Hi I have 15 years of experience in Sql server database development, mysql database development, postgresql database development. Expert in data analysis. Reporting using power Bi. Programming using C#and sql server. Expert in data engineering. I will be able to help you with the project. Please ping me offline to discuss further.
$500 USD in 6 days
4.9 (12 reviews)
4.5
4.5
User Avatar
Can do this. Results will be delivered as schema file , and set of queries. Everything will be well tested.
$140 USD in 4 days
5.0 (2 reviews)
3.8
3.8
User Avatar
SQL expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
$240 USD in 4 days
4.4 (27 reviews)
3.9
3.9
User Avatar
Hi there, we are experts in SQL, Database Programming, Database Development, Oracle, MySQL and PostgreSQL. Please, send me a message to discuss the work on the project. Thanks Ashish.
$250 USD in 12 days
5.0 (2 reviews)
3.1
3.1
User Avatar
♦ PL/SQL Expert ♦ Database Expert ♦ Immediate Start ♦ I’m a Software Engineer with 9+ years of experience in database development. I’m expertise in multiple databases Oracle, Snowflake, PostgreSQL, MSSQL, and MYSQL. I would be the right person for this project because I have hands-on and real-time experience in multiple databases. Kindly feel free to get in touch to discuss further details on this project. Thank you.
$150 USD in 7 days
5.0 (1 review)
3.2
3.2
User Avatar
Hello there, I have read your requirements and am confident I am the right candidate for the job. Among other things, I have over ten years of experience in Oracle PLSQL, PostgreSQL, MySQL, MS SQL, and others NoSQL. Furthermore, I am available 24x7 to answer any questions you may have about the requirements. I am looking forward to hearing from you as soon as possible. I would appreciate it if you would click the chat button for me if you are interested. Thanks a lot. Best regards. Courser Xu
$140 USD in 7 days
5.0 (5 reviews)
3.1
3.1
User Avatar
I have more than 12 years of experience in Oracle/ SQL/ MySQL/ PostGre Server database modelling, design, development, and Administration. I have worked for database designing and modelling of complex business an efficient way. I have very good experience in TSql, writing complex scripts, complex stored procedures, functions, triggers etc. I am good with performance tuning which includes Index and its usages, JOINS, dynamic queries, CTE, Temp tables, Table variable, and all its usages. I am also good and working with big clients for BI part like SSIS, SSRS and SSAS. Created different workflow PACKAGES and reports for clients. I also involved in Data warehouse design form OLTP systems. I have worked with medium to large mission critical databases. Worked as DBA for 24*7 support environment. Involved in activities like Performance monitoring, Log file maintenance, deadlocks and blocking handling, disk space management, Job monitoring and failure handling, Backup and recovery process for disaster management
$50 USD in 1 day
4.9 (10 reviews)
2.9
2.9
User Avatar
Hi, I have 7+ years of experience in SQL and PL/SQL development, and I understood your requirement I am sure that I will complete it in an efficient way. I have done this before with ERD into rational schema, Normalization, writting sql table structrure, Procedure , functions kindly contact me to start work on it Thanks
$250 USD in 5 days
5.0 (4 reviews)
3.0
3.0
User Avatar
Hello I have a lot of experience with Oracle pl/sql I am available ....
$140 USD in 7 days
5.0 (2 reviews)
3.0
3.0
User Avatar
Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Kind Regards Arun
$80 USD in 1 day
5.0 (3 reviews)
2.7
2.7
User Avatar
Hello, I am an UML and Database designer. I design class diagrams and data models. For databases, I create ER diagrams and also provide SQL scripts to create the tables, constraints, triggers, objects, cursors, stored procedures, functions. I have delivered several database assignments successfully especially to students taking DB exams and also helping them in their assignments. My proposal also includes a revision of my work. I will deliver in milestones. And after every milestone I get my deliverable reviewed, and if there are issues, I will fix them. I also provide SQL tuning services. So, I can tune existing SQL queries, correct them for proper joins and indexed execution. I am from Belgium and I work in Central European timezone. All my communications are carried out via the portal. My deliverables are always on schedule. I hope I have provided you the information that you need to decide on if you would award this project to me. If you assign this project to me, I would expect you to provide me clear documents/requirements indicating what data model you would need. Depending on the size of the model, the cost can vary. We can establish the milestones accordingly. Hope to hear from you soon. Kind Regards Paul
$250 USD in 5 days
5.0 (5 reviews)
2.7
2.7
User Avatar
Hi there, How are you? I have gone through your project details. I would like to tell you that l have a great bunch of experience in Database Development, SQL, Database Administration, Oracle and Database Programming. For that I would require from your end to start a chat with me to discuss about i need a help for my sql project. You can check my profile that I have 100% completion rate on my projects, so it would be my pleasure to build long term relationship with you. All my skills are related to this particular project. Hoping to hear from you soon. Cheers. Rashid Amjad.
$250 USD in 8 days
5.0 (1 review)
2.5
2.5
User Avatar
Hello, Have almost 15+ years experience working with SQL. Can do this for you with utmost accuracy and generate most efficient queries for the mentioned requirement. Can complete this in less than a day.
$140 USD in 1 day
4.2 (8 reviews)
2.9
2.9
User Avatar
Hi, I read the complete description of the project mentioned. I can work on this project and deliver it within the given deadline. Please share the ER diagram so we can go ahead with the next steps. I am available for any further discussion right away. Looking forward to hearing from you. Thank you!
$99 USD in 2 days
5.0 (1 review)
2.2
2.2
User Avatar
Hi There, Good day! Hope you are doing fine. I gone through requirement still want to ask few questions to start your project now. ⭐ I will work with milestone only and release money as per good work progress. ⭐ I have gone through your initial project requirement and understand your project details.⭐ ⭐ I would like to ask question before start your work then we will decide budget and deadline.⭐ Let's have a quick conversation on the details to proceed further with this project. We look forward to work with you:)
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SAUDI ARABIA
Jeddah, Saudi Arabia
0.0
0
Member since Jan 31, 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.