This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and more.
Learning Objectives:
- Introduction to PL/SQL
- Declaring PL/SQL Variables
- Writing Executable Statements
- Using SQL Statements Within a PL/SQL Block
- Writing Control Structures
- Working with Composite Data Types
- Using Explicit Cursors
- Handling Exceptions
- Introducing Stored Procedures and Functions
- Packages
- Deploying Packages
- Implement Oracle-Supplied Packages in Application Development
- Dynamic SQL
- Design Considerations for PL/SQL Code
- Creating Compound, DDL, and Event Database Triggers
- PL/SQL Compiler
- Manage Dependencies
Learn more about Oracle Database: Program With PL/SQL Ed 2 at NetCom Learning.
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.