Oracle PL/SQL Training
PL/SQL is Oracle's extension language for standard SQL.
In this PL/SQL training class, students who already know SQL learn to use PL/SQL to write sophisticated queries against an Oracle database.
Public Classes: Delivered live online via WebEx and guaranteed to run . Join from anywhere!
Private Classes: Delivered at your offices , or any other location of your choice.
- Learn what PL/SQL is.
- Learn how to declare, name, assign and output variables in PL/SQL.
- Learn about data types in PL/SQL.
- Learn about the main features of PL/SQL.
- Learn how to write a simple block of PL/SQL code.
- Learn about subprograms in PL/SQL.
- Learn to create and call procedures.
- Learn to create and call functions.
- Understand BOOLEAN values and expressions.
- Learn to write IF conditions.
- Learn to use the CASE statement.
- Learn to handle exceptions in PL/SQL.
- Learn about how cursors works.
- Learn to use implicit cursors.
- Learn to use explicit cursors.
- Learn to use packages to group related PL/SQL objects.
- Learn to use triggers for validating data and auditing changes to the database.
- PL/SQL Basics
- What is PL/SQL?
- Outputting Information
- Variables and Constants
- Data Types
- Naming Variables and Other Elements
- Embedding SQL in PL/SQL
- SELECT...INTO and RETURNING...INTO
- PL/SQL Features
- Introduction to Subprograms
- Variable Declarations
- Dropping a Procedure
- Parameters with Default Values
- Parameter Modes
- IN Mode
- OUT Mode
- IN OUT Mode
- Named Notation
- Using SQL in a Subprogram
- Using PL/SQL Functions in SQL Queries
- Conditional Processing
- Conditions and Booleans
- IF-ELSIF-ELSE Conditions
- BOOLEAN Values and Standard SQL
- The CASE Statement
- CASE Expressions
- Introduction to Exceptions
- Predefined Exceptions
- The EXCEPTION Part of the Block
- User-defined Exceptions
- User-defined Exceptions in Subprograms
- Re-raising Exceptions
- Naming Unnamed Predefined Exceptions
- WHILE Loops
- When to Use Exceptions
- Implicit Cursors
- Explicit Cursors
- Explicit Cursor Use Case
- Cursor FOR LOOP
- Cursor Parameters
- Package Basics
- The Package Specification
- The Package Body
- Building an Employee Package
- Overloading Subprograms
- Validation Procedures
- Package Cursors
- Benefits of Packages
- What are triggers?
- Trigger Parts
- Validation Triggers
- The WHEN Clause
- Audit Triggers
- Statement-level Triggers
- Compound Triggers
- Trigger Warning
Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.
Courses that can help you meet these prerequisites: