loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Professional Training on Oracle PL/SQL

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

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

Connect With 3RI Technologies

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 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

Share

Professional Training on Oracle PL/SQL

Professional Training on Oracle PL/SQL

Pimple Saudagar, Pune

3 Reviews
0 Interested

About the Course


Our faculty is a well known name in the industry, he is working as a PL/SQL developer in IT Industry and he is sharing his expertise with our students to give them a fair idea, that how to use the actual database concept in the real time environment.

Topics Covered

1. PL/SQL Structure
• Variables
• Data type
2. Creating the Executable Section
• Comments6
• Literals
• Operator
• Output Statement
• Accepting input from user
• Variable scope
• Function
• Programs using SQL Statements in PL/SQL
3. Writing Control Structures
• If statement in PL/SQL
• If...else statement in PL/SQL
• Else if ladder statement in PL/SQL
• LOOPs in PL/SQL
4. Working with Composite Data Types
• PL/SQL Records
• Collections
5. Cursors
• PL/SQL Attributes Cursor Attributes
• Using cursor with for …loop
6. Exception Handling
• What is an Exception?
• How to handle Exception?
• Predefined Exception
• Get information about error with –SQLCODE and SQLERRM
• Non Predefined Error
• User Defined Exception
7. Stored Procedures
• Advantages of procedures
• Creating procedure
• Formal and actual parameters in procedure
• Using Anonymous block to invoke a procedure
• Default option for parameters
• Using Sub Procedures
• Calling procedure from another procedure
• Handled and Unhandled Exception when procedure called
• Delete procedure
8. Functions
• Advantages of Functions
• Calling function in SQL statement
• Restriction on calling function in SQL statement
• Deleting a Function
• Difference between function and procedure
9. Packages
• Advantages of packages
• Package Structure
• Executing the procedure and function
• Removing package
10. Triggers
• Creating a trigger
• Accessing a column using row trigger
• Using Statement trigger
• Modifying a Trigger
• Enabling and Disabling a trigger
• Dropping a trigger
11. Oracle Architecture- Complimentary Session

Who should attend

• Aspirants who have a good knowledge in DBMS concept and are looking for a good course stuff to get more involvement into their current role.
• people who want to make their career as a database developer.

Pre-requisites

• Oracle SQL
• RDBMS knowledge.

What you need to bring

We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course.""

Key Takeaways

• Good technical real time environmental knowledge.
• RDBMS complete course with full of practical implementation to provide the best results at the time of solving a problem.
Reviews

Recommendations & reviews from previous Customers:

Rahul Magar

"Trainer Snehal Mam was excellent in teaching. Administration dept is having scope for improvements. Batch timings need to be planned. "

attended Professional Training on Oracle PL/SQL


Sarika Walase

"One of the best training institute in Pimple Saudagar area. Mr. Ritesh Sharma Sir helped me a lot to boost my career and clear all Oracle SQL doubts. He has the quality & potential of delivering training from basic to advance level. "

attended Professional Training on Oracle PL/SQL


Shantanu

"Since I am a working professional I wanted to become an expert in Oracle SQL and PLSQL because of its necessity in day to day life, I inquired approximately 7-8 institute's and taken demo classes over there, finally I joined 3RI Technologies because of its uniqueness in the terms of complete project based learning, time flexibility, makeup classes and complete hands on experience based on industry processes and implementation part covered very beautifully, I would recommend this to my friends also. "

attended Professional Training on Oracle PL/SQL


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


Recommendations & reviews from previous Customers:

Rahul Magar

"Trainer Snehal Mam was excellent in teaching. Administration dept is having scope for improvements. Batch timings need to be planned. "

attended Professional Training on Oracle PL/SQL


Sarika Walase

"One of the best training institute in Pimple Saudagar area. Mr. Ritesh Sharma Sir helped me a lot to boost my career and clear all Oracle SQL doubts. He has the quality & potential of delivering training from basic to advance level. "

attended Professional Training on Oracle PL/SQL


Shantanu

"Since I am a working professional I wanted to become an expert in Oracle SQL and PLSQL because of its necessity in day to day life, I inquired approximately 7-8 institute's and taken demo classes over there, finally I joined 3RI Technologies because of its uniqueness in the terms of complete project based learning, time flexibility, makeup classes and complete hands on experience based on industry processes and implementation part covered very beautifully, I would recommend this to my friends also. "

attended Professional Training on Oracle PL/SQL


Date and Time

Not decided yet.

About the Trainer


We have almost 25 trainers with us for all different technologies, we have associated with so many people in the IT industry who actually works on the real time projects have may years of expertise experience, they share their knowledge as a KT sessions or visiting faculty.
Seats Left-

Students Interested 0

Course Id: 14445