Programming with PL/SQL - 2 day course
Can't see a suitable date or location?
Click here to register your interest in this course and we will
keep you informed when any new dates are added.
Synopsis
This course will give you an introduction to Oracle Corporation’s proprietary procedural extension to the SQL database language, PL/SQL. PL/SQL (Procedural Language/Structured Query Language) is embedded in the Oracle Database, and allows the creation of powerful programming blocks - procedures and functions - which interact with SQL to dramatically increase the functionality of your Oracle database.
Duration
2 days
Cost
£595
Prerequisites
A basic level of
SQL knowledge, and some understanding of
relational database (
RDBMS) concepts is assumed. For students who do not have experience in these areas the
Introduction to SQL class is recommended.
Detailed course contents
Introduction to PL/SQL
- Relation between SQL and PL/SQL
- Advantages of PL/SQL
- A Simple PL/SQL Block
- Declaration using attributes
- Loop Statements
- Displaying the user messages on screen
Cursors and Error Handling
- Cursors
- Using the Explicit Cursors
- Explicit Cursor Attributes
- Implicit Cursor Attributes
- Example of an Explicit Cursor and Attribute
- Error handling in PL/SQL
- Stored Procedures, Functions and Packages
Stored Procedures
- Stored Procedures
- How Oracle creates a Procedure?
- Advantages of Procedures
- Deleting the Procedure
Functions
- Stored Functions
- How Oracle creates a Function?
- Advantages of Functions
- Creating a Function
- Deleting a Function
Triggers
- Use of Database Triggers
- Applying a Database Trigger
- Types of Triggers
- Before Vs After Triggers
- Creating a Trigger
- Deleting a Trigger
Can't see a suitable date or location?
Click here to register your interest in this course and we will
keep you informed when any new dates are added.