Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Oracle PL/SQL Training (Basic + Advanced)

No Reviews Yet

Mahadevapura, Bangalore

Course ID: 45873

Mahadevapura, Bangalore

Students Interested 0 (Seats Left 0)

No Reviews Yet

About the Course

This Course is for those who know SQL and some knowledge of Oracle database and want to learn and understand PL/SQL using Oracle database basic and advanced. At the end of each lesson, the students will be provided with hands-on exercises which will help increase their learning and analytical skills. I can assure that after completing this course, students can feel confident on writing simple as well as complex PL/SQL queries and how to approach in understanding the requirements of any data related operation within databases which is to be implemented and approach for the coding logic.


 


Students need to bring their laptops for hands-on exercises.


 


What You will learn at the end of this Course?

1. Explain the benefits of PL/SQL
2. Explain the need for PL/SQL
3. Identify the different types of PL/SQL blocks
4. Output messages in PL/SQL
5. Recognize valid and invalid identifiers
6. List the uses of variables
7. Declare and initialize variables
8. List and describe various data types
9. Identify the benefits of using the %TYPE attribute
10. Declare, use, and print bind variables
11. Identify lexical units in a PL/SQL block
12. Use built-in SQL functions in PL/SQL
13. Describe when implicit conversions take place and when explicit conversions have to be dealt with
14. Write nested blocks and qualify variables with labels
15. Write readable code with appropriate indentation
16. Use sequences in PL/SQL expressions
17. Determine the SQL statements that can be directly included in a PL/SQL executable block
18. Manipulate data with DML statements in PL/SQL
19. Use transaction control statements in PL/SQL
20. Make use of the INTO clause to hold the values returned by a SQL statement
21. Differentiate between implicit cursors and explicit cursors
22. Use SQL cursor attributes
23. Identify the uses and types of control structures
24. Construct an IF statement
25. Use CASE statements and CASE expressions
26. Construct and identify loop statements
27. Use guidelines when using conditional control structures
28. Create user-defined PL/SQL records
29. Create a record with the %ROWTYPE attribute
30. Create an INDEX BY table
31. Create an INDEX BY table of records
32. Describe the differences among records, tables, and tables of records
33. Distinguish between implicit and explicit cursors
34. Discuss the reasons for using explicit cursors
35. Declare and control explicit cursors
36. Use simple loops and cursor FOR loops to fetch data
37. Declare and use cursors with parameters
38. Lock rows with the FOR UPDATE clause
39. Reference the current row with the WHERE CURRENT OF clause
40. Define PL/SQL exceptions
41. Recognize unhandled exceptions
42. List and use different types of PL/SQL exception handlers
43. Trap unanticipated errors
44. Describe the effect of exception propagation in nested blocks
45. Customize PL/SQL exception messages
46. Differentiate between anonymous blocks and subprograms
47. Create a simple procedure and invoke it from an anonymous block
48. Create a simple function
49. Create a simple function that accepts a parameter
50. Differentiate between procedures and functions
51. REF Cursors
52. Working with Collections
53. Performance Tuning of PL/SQL codes.

Date and Time

Not decided yet.

About the Trainer

Avinash Kumar picture

Avg Rating

0 Reviews

0 Students

2 Courses

Avinash Kumar

B.tech in Electronics and communication Engineering

7 years of experience with Oracle SQL PL/SQL and JDA supply chain modules working as techno-functional consultant.

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for PL/SQL Classes Post your requirement now

Enquire

Submit your enquiry for Oracle PL/SQL Training (Basic + Advanced)

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Avinash

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more