Oracle 11g PL/SQL Training: Beginning Oracle 11g PL/SQL
Free

Introduction
This Oracle 11g PL/SQL training teaches attendees beginning and advanced Oracle PL/SQL database programming skills. This course is 60% hands-on, 40% discussion, with the longest discussion segments lasting 20 minutes.
Audience
Prior Oracle SQL experience is presumed.
At Course Completion
After completing this course, students will be able to:
- Understand the environment and context in which PL/SQL operates.
- Consider the advantages and benefits of PL/SQL within a database environment.
- Declare program variables and complex data types.
- Develop logic within PL/SQL program blocks.
- Fetch data from the database into program variables.
- Return program output to users.
- Handle program exceptions.
- Use explicit and implicit database cursors.
- Maintain and implement triggers.
Prerequisites
Prior Oracle SQL experience is presumed.
Course Materials
All students receive comprehensive courseware and a related textbook.
-
MODULES
- Choosing a SQL & PL/SQL Interface
- Language Features
- Declare Clause
- Begin Clause
- Exception Clause
- Explicit Cursors
- Introducing Database Program Units
- Creating Stored Procedures & Functions
- Maintaining Stored Procedures & Functions
- Creating & Maintaining Packages
- Advanced Cursor Techniques
- Using System-Supplied Packages
- Creating Database Triggers
- Maintaining Database Triggers
- Implementing System Event Triggers
- Nicosia
City
Dates and Times
Duration (Hours)
- 20 Louki Akrita street,
2064 Strovolos
(behind Kykko secondary schools)
Location
- Limassol
City
Dates and Times
Duration (Hours)
- 22 Griva Digeni Avenue, 3106 Agios Nikolaos
(200 m. from the roundabout, near Agios Nikolaos church)