Professional course on Oracle PL/SQL: 3RI Technologies,Pune

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.