Loading Course Schedule...
PT20408
Training Summary
This course provides a complete, hands-on, comprehensive introduction to PL/SQL including the use of both SQL Developer and SQL*Plus. This coverage is appropriate for both Oracle11g and higher.
Prerequisites
Before taking this course, Oracle12c SQL or higher or equivalent experience is required.
Duration
5 Days/Lecture & Lab
Audience
This course is appropriate for anyone needing to understand Oracle’s proprietary programming language. That would include end users, business analysts, application developers, and database administrators.
Course Topics
- PL/SQL Program Structure
- PL/SQL Flow Control
- SQL Developer and PL/SQL
- SELECT INTO
- The PL/SQL Cursor
- Optimization
- PL/SQL Exception Handling
- Stored Procedures
- Creating Functions in PL/SQL
- Packages
- Creating DML Triggers
- Advanced Concepts
- File Operations
- Communications
- Security
- Scheduling
- Miscellaneous Packages
- Database Triggers
- Collections
- Bulk Operations
- Cursor Variables
- Dynamic SQL
- Large Objects
- Object-Oriented Programming
- Java and Other Languages