Find Jobs
Hire Freelancers

i need a help for my sql project -- 2

$30-250 USD

Đã đóng
Đã đăng vào khoảng 1 năm trước

$30-250 USD

Thanh toán khi bàn giao
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
Mã dự án: 35878639

Về dự án

20 đề xuất
Dự án từ xa
Hoạt động 1 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
20 freelancers are bidding on average $150 USD for this job
Avatar người dùng
i need a help for my sql project -- 2 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 trong 2 ngày
5,0 (13 nhận xét)
5,2
5,2
Avatar người dùng
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 trong 7 ngày
5,0 (15 nhận xét)
5,0
5,0
Avatar người dùng
Hi I have read your description carefully. I have rich experiences in ⭐ ER diagram, SQL, database, RMDB. ⭐ I worked on many similar projects. I can guarantee the quality of the job. Please kindly message me. Thank you.
$50 USD trong 2 ngày
4,9 (10 nhận xét)
4,7
4,7
Avatar người dùng
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 trong 7 ngày
4,9 (12 nhận xét)
4,5
4,5
Avatar người dùng
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 trong 5 ngày
5,0 (23 nhận xét)
4,2
4,2
Avatar người dùng
Hello Client ! I am a skilled full stack developer. Having rich experience in Java , Python , C , C++ , C# , Mysql , Sql , Oracle , Object Oriented Programming , Data Structure , Algorithms . I have a perfect grip on “Database Administration” , and work in “Oracle” Mysql”. I want to assure you that these are my areas of expertise and I can do any work related. Here I am also assuring you that the quality of work will not be compromised . I am able for work full time on your time zone and start work right now . Please send me a message for further Details . Thanks and Best Regards
$40 USD trong 7 ngày
5,0 (10 nhận xét)
3,2
3,2
Avatar người dùng
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 trong 1 ngày
4,9 (10 nhận xét)
2,9
2,9
Avatar người dùng
✅ ⭐✅ ⭐✅ ⭐✅ ⭐✅ These are the recent projects solved https://www.freelancer.com/projects/statistics/Statistics-29769906/details https://www.freelancer.com/projects/vb-net/Use-simple-dll-net https://www.freelancer.com/projects/excel/conversion-rate-formulas https://www.freelancer.com/projects/excel/need-excel-expert-28639993 www.freelancer.com/projects/pdf/Create-page-pdf-fillable-Form/reviews www.freelancer.com/projects/research/Lead-sources/details www.freelancer.com/projects/business-plans/Design-company-profile-english-arabic/reviews ✅ ⭐✅ ⭐✅ ⭐✅ ⭐✅ I have been working here since the last year ,Thanks for posting and sharing your project.I have experience in this work ,let be handle this task to me ,i am willing to start Now Just contact/Text☎ Why you Choose me On time On Desire On Solution Thanks Muzammal Hussain Hello I am sure I can deleiver well your project.
$140 USD trong 7 ngày
2,3 (3 nhận xét)
4,7
4,7
Avatar người dùng
Hi, there I have checked your project description carefully and I think that I can help you to complete this project 100% perfectly sure to satisfy your requirement. I have more than 7 years of experience in Mysql/ SQL Server/Access 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 Sql/t-sql, writing complex scripts, complex stored procedures, functions, triggers etc. I am good with erformance tuning which includes Index and its usages, JOINS, dynamic queries, CTE, Temp tables, Table variable, and all its usages. My code is going to be clean and neat with good understanding. I am willing to take a technical interview, technical test, or trial project, to verify myself. I'd like to have a brief chat, call to discuss further details about your project soon. Looking forward to working with you together on this project. Thanks!
$120 USD trong 3 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
"I am a Full stack web front-end /back-end Developer here for you" Hello, Warm Greetings !! Yes, This job matches my skill set.I would like to let you know that I have experts and commercial experience in this category. So I feel that I am the best match with your requirements I would be glad to cater to your needs by providing my services to you. I will surprise you by creating a refreshing and enchanting result with a delicacy and high service. I have over 6 years experiences of web development, I have complete expertise in frontend & Backend developer and fully expertise in VueJ.S, React/Redux-Saga, React-Hook, Angular JS, NodeJS, PHP/MySQL,html5/css3, javascript, jquery, ajax, AWS,GIT,RSS feed, Photoshop, twitter bootstrap, psd slicing, C# programing, Unity 3D game development, I am seasoned professional UI/UX designer illustrator, landing page designing with responsive design. My designs are professional,sleek, clean,modern and user-friendly. I have previously built so many custom websites and also modified the existing sites as per client requirement and expert in bug fixing and troubleshooting in many websites. I am looking forward positively to work on your project and will not disappoint you in terms of quality of work, deadline and communication. Thanks & Regards.
$150 USD trong 7 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
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 SQL, Oracle, Database Administration, Database Development 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 -- 2. 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 trong 8 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
At the university, I studied computer science in addition to its theoretical and practical applications. Computer science applies principles of mathematics, engineering, and logic to a wide number of jobs, including algorithm formulation, software and hardware development, and artificial intelligence.
$140 USD trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
Hi I had a PhD in computer science. My area of expertise is database. I think I can help you. Contact me.
$200 USD trong 3 ngày
0,0 (0 nhận xét)
0,5
0,5
Avatar người dùng
hello again, I am a weblogic/oracle 12c database Administrator with more than 6 years of experience creating schema files, PL/SQL scripts and packages. I can help you with the task in hand to convert the ER diagram and can provide more than Oracle schema file. that contains queries to create the schema and the tables. It will also contain the PL/SQL package with all the necessary queries. Which oracle database version are you using? Do you have a running database that we can configure or do you want me to use local instances ?
$170 USD trong 4 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
Have 6+ years of experience in Oracle database. Good in standalone, RAC and dataguard. Installed and configured Oracle databases on multiple environments using manual and DBCA  method Administrating Oracle databases (10g, 11g ,12c and 19c) on Linux  platforms. • Performing Re-org for better performance and optimization of space. • Monitored & troubleshoot all database issues in Standalone and RAC  environments.  • Set up database users, manage database permissions and setup database  roles • Implement and maintain Oracle Dataguard Physical and Logical standby  databases for disaster recovery. Ensure that standby database is always in  Sync with production database by checking archive logs and copying missing  ones over to the standby database when required. • Good experience on RMAN configuration and performing RMAN Backup,  Restore and recovery. Performed database refreshes and database cloning • Good experience on managing ASM storage environments. • Knowledge and Experience on applying Patch. • Knowledge on UNIX Scripting (Used to write shell scripts & implemented  Using cronjob for day to day activities. • Good experience on Database and schema level refreshes as well as object  level export/import using both data pump as well as traditional export. • Good experience on configuring alert monitoring for both Standalone and  RAC environments using crontab. • Good experience on OEM installation and Configuration
$140 USD trong 2 ngày
0,0 (0 nhận xét)
0,3
0,3
Avatar người dùng
Hello Sir, I am writing in response to your advertisement for a “Data Entry". After carefully reviewing the experience requirements of the job description, I feel that I am a suitable match for the job. I’ve held several data entry positions that entail inputting customer requests, inquire, and tracking codes of products I also perform administrative duties including copying and faxing documents, answering telephones, transferring data, web research and reports to immediate supervisor. I feel that I can add professionalism and accuracy to your current team of professionals. With extensive experience supporting all levels of a department and working directly with external vendors, I take direction well and can complete a heavy workload and complete projects under minimal supervision. If you feel there is a mutual interest, I would welcome the opportunity to meet with you to learn more about your company, the requirements of the position, and how my qualifications would be a good fit. Thank you in advance for your time and consideration. I look forward to Hiring from you soon. Nurul Balqis Binti Mohammed Raziff
$140 USD trong 7 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
Hello, the requirements are clear, to do the following (1) Covert ERD to scripts and displayed the keys (PK, FK and Unique constraints) (2) create 5 quiries to reterive data needed (3) create 2 SP to acheive the needed. I have extensive experiences more 20 years in Oracle DBA , Oracle development , Oracle DBA RAC, OCP i do appreciate to share the sizing of ERD ! best regards
$150 USD trong 7 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
I have 2 years experience in SQL, Oracle database, I will help you finish this project clearly. You can ask me whenever you need. I support with all the responsibility.
$140 USD trong 7 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
I work with same tasks for years, so writing advanced sql scripts is my strongest side and I'll try my best to help you
$140 USD trong 7 ngày
0,0 (0 nhận xét)
0,0
0,0

Về khách hàng

Cờ của SAUDI ARABIA
Jeddah, Saudi Arabia
0,0
0
Thành viên từ thg 1 31, 2023

Xác thực khách hàng

Các công việc khác từ khách hàng này

i need a help for my sql project
$30-250 USD
Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.