Close
87
Oracle Database
30 Hours
30 Hours
2 Years
Oracle PL SQL Training
Date : 21 December 2017
Time : 1:30 AM
Quick Enquiry
Instructor-LedSelf-Paced





Oracle PL SQL Training at SMC will help you with comprehensive understanding of Oracle Technologies in general and PL/SQL Languages in specific. Participants will learn how to use PL/SQL language to interact with Databases and PL/SQL to write more complex and data intensive programs. PL/SQL is the entry point to start your career on Oracle Technologies. This course also serves as the basis for other Oracle technology courses like Oracle DBA, Oracle Developer, and Oracle Applications Technical Consultant etc

Who all Can Benefit from Oracle PL SQL Training
  • Database Administrators
  • System Analysts
  • Forms Developer
  • Technical Consultant
  • Portal Developer
  • PL/SQL Developer

Detailed Course Content for Oracle PL SQL Training

1. Introduction to PL/SQL

  • PL/SQL Overview
  • Structure Of PL/SQL
  • Benefits of PL/SQL Subprograms
  • Overview of the Types of PL/SQL blocks
  • Create a Simple Anonymous Block
  • Generate Output from a PL/SQL Block

2. PL/SQL Identifiers

  • List the different Types of Identifiers in a PL/SQL subprogram
  • Usage of the Declarative Section to define Identifiers
  • Use variables to store data
  • Identify Scalar Data Types
  • The %TYPE Attribute
  • What are Bind Variables?
  • Sequences in PL/SQL Expressions

3. Write Executable Statements

  • Describe Basic PL/SQL Block Syntax Guidelines
  • Comment Code
  • Deployment of SQL Functions in PL/SQL
  • How to convert Data Types?
  • Nested Blocks
  • Identify the Operators in PL/SQL

4. Interaction with the Oracle Server

  • Invoke SELECT Statements in PL/SQL to Retrieve data
  • Data Manipulation in the Server Using PL/SQL
  • SQL Cursor concept
  • Usage of SQL Cursor Attributes to Obtain Feedback on DML
  • Save and Discard Transactions

5. Control Structures

  • Conditional processing Using IF Statements
  • Conditional processing Using CASE Statements
  • Use simple Loop Statement
  • Use While Loop Statement
  • Use For Loop Statement
  • Describe the Continue Statement
  • Describe the GOTO Statements

6. Composite Data Types

  • Use PL/SQL Records
  • The %ROWTYPE Attribute
  • Insert and Update with PL/SQL Records
  • Associative Arrays (INDEX BY Tables)
  • Examine INDEX BY Table Methods
  • Use INDEX BY Table of Records

7. Explicit Cursors

  • What are Explicit Cursors?
  • Declare the Cursor
  • Open the Cursor
  • Fetch data from the Cursor
  • Close the Cursor
  • Cursor FOR loop
  • Explicit Cursor Attributes
  • FOR UPDATE Clause and WHERE CURRENT Clause

8. Exception Handling

  • What is Exception
  • Understand Exceptions
  • Handle Exceptions with PL/SQL
  • Trap Predefined Oracle Server Errors
  • Trap Non-Predefined Oracle Server Errors
  • Trap User-Defined Exceptions
  • Propagate Exceptions
  • The SQLCODE and SQLERRM in PL/SQL
  • RAISE_APPLICATION_ERROR Procedure

9. Stored Procedures and Functions

  • What Is Procedure and Function
  • Understand Stored Procedures and Functions
  • Differentiate between anonymous blocks and subprograms
  • Create a Simple Procedure
  • Create a Simple Procedure with IN parameter
  • Create a Simple Procedure with OUT parameter
  • Create a Simple Procedure with IN OUT parameter
  • Create a Simple Function
  • Execute a Simple Procedure
  • Execute a Simple Function

10. Create Stored Procedures

  • Create a Modularized and Layered Subprogram Design
  • Modularize Development With PL/SQL Blocks
  • Describe the PL/SQL Execution Environment
  • Identity the benefits of Using PL/SQL Subprograms
  • List the differences Between Anonymous Blocks and Subprograms
  • Create, Call, and Remove Stored Procedures Using the CREATE Command and SQL Developer
  • Implement Procedures Parameters and Parameters Modes
  • View Procedures Information Using the Data Dictionary Views and SQL Developer

11. Create Stored Functions

  • Create, Call, and Remove a Stored Function Using the CREATE Command and SQL Developer
  • Identity the advantages of Using Stored Functions in SQL Statements
  • List the steps to create a stored function
  • Implement User-Defined Functions in SQL Statements
  • Identity the restrictions when calling Functions from SQL statements
  • Control Side Effects when calling Functions from SQL Expressions
  • View Functions Information

12. Create Packages

  • Identity the advantages of Packages
  • Describe Packages
  • List the components of a Package
  • Develop a Package
  • How to enable visibility of a Package’s components?
  • Create the Package Specification and Body Using the SQL CREATE Statement and SQL Developer
  • Invoke Package Constructs
  • Private and Public Package Level
  • Calling Package Functions and Procedures
  • View PL/SQL Source Code Using the Data Dictionary

13. Packages

  • Overloading Subprograms in PL/SQL
  • Use the STANDARD Package
  • Use Forward Declarations to Solve Illegal Procedure Reference
  • Implement Package Functions in SQL and Restrictions
  • Persistent State of Packages
  • Persistent State of a Package Cursor
  • Control Side Effects of PL/SQL Subprograms
  • Invoke PL/SQL Tables of Records in Packages

Certification Process

  • Once you are successfully through the project, you will be awarded with SM Consultant's Oracle PL SQL Training Completion Certificate.
  • SM Consultant certification has industry recognition and we are the preferred training partner for many organization's.

Frequently asked questions (FAQ'S)

You will never lose any lecture. You can choose either of the two options:
  • View the recorded session of the class available in your LMS.
  • You can attend the missed session, in any other live batch.
SM Consultant is committed to provide you an awesome learning experience through world-class content and best-in-class instructors for Oracle PL SQL Training. We will create an ecosystem through this training, that will enable you to convert opportunities into job offers by presenting your skills at the time of an interview. We can assist you in resume building and also share important interview questions once you are done with the training. However, please understand that we are not into job placements.
We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrolment is not possible. However, you can go through the sample class recording or scheduled demo sessions and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.
At SM Consultant, we pride ourselves on hiring and retaining the most qualified and experienced instructors in the industry. All of our instructors are certified professionals in their respective subjects. Our instructors typically have 15 or more years of real-world experience working for leading companies, allowing them to apply current trends and relevant examples to help students relate to the course material and retain more information.
You can Call us at our US Number +1.650.585.2312 OR India Number +91.8019490782 OR Email us at contact@smconsultant.com . We shall be happy to assist you.

Oracle PL/SQL Training Reviews

Click here to submit your review.

Overall learning experience:

Quality Of Course Content:

Quality Of Training Session:

Duration Of Training:

Trainers Technical Knowledge:

Trainers Presentation Skill:

Punctuality Of Trainer:

Quality Of Practice Exercises:

Response To Queries:

Submit your review
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
Excellent Very Good Good Fair Poor
* Required Field
Vamsi rated Oracle PL/SQL Training : 4 Stars out of 5 Stars on Nov 30, 2017
Overall learning experience:

Quality Of Course Content:

Quality Of Training Session:

Duration Of Training:

Trainers Technical Knowledge:

Trainers Presentation Skill:

Punctuality Of Trainer:

Quality Of Practice Exercises:

Response To Queries:

Oracle PL/SQL Training Review

Comments: Roopak is good trainer, he explains basic stuff that you should know and really helps at client place. Overall training was good and meets the expectations.
All of topics were covered and they have shown us with real examples

Official Response: Thanks Vamsi

service 0.3

4.0 4.0 1 1 Roopak is good trainer, he explains basic stuff that you should know and really helps at client place. Overall training was good and meets the expectations. All of topics were co Oracle PL/SQL Training
ENROLL NOW