Overview
This hands-on course covers Sequences, Triggers, Customer Functions, Stored Procedures, and Customer Data Types. The focus of this course is on practical skills, and the underlying technology enabling the students to design, code, and implement PL/SQL code in an Oracle database.
Audience
This course is designed for experienced SQL Developers who are moving into PL/SQL coding.
Length
2 days
Outline
Upon completion, participants will be able to design, code, and implement PL/SQL code in an Oracle database.
Topics:
- Introduction
- PL/SQL Basics
- Language Fundamentals
- Control Structures
- Collections
- Error Management
- Functions
- Stored Procedures
- Packages
- Large Object Handling
- Triggers
- Sequences
- Dynamic SQL
- PL/SQL Built-In Packages
- PL/SQL Built-In Data Types
- Summary