Name: Oracle Database 11g: Program with PL/SQL
Course Code: OR49992
Duration: 5
Scheduled Dates for OR49992
This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions.
Students learn to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions. Students are introduced to the utilization of some of the Oracle-supplied packages.
Target Audience
Database Administrators
Forms Developer
Portal Developer
Developer
Technical Consultant
System Analysts
Application Developers
PL/SQL Developer
Key Topics
- Introduction
- Introduction to PL/SQL
- Declaring PL/SQL Identifiers
- Writing Executable Statements
- Interacting with the Oracle Server
- Writing Control Structures
- Working with Composite Data Types
- Using Explicit Cursors
- Handling Exceptions
- Creating Stored Procedures
- Creating Stored Functions
- Creating Packages
- Working With Packages
- Using Oracle-Supplied Packages in Application Development
- Using Dynamic SQL
- Design Considerations for PL/SQL Code
- Creating Triggers
- Creating Compound, DDL, and Event Database Triggers
- Using the PL/SQL Compiler
- Managing PL/SQL Code
- Managing Dependencies
Objectives
- Manage dependencies between PL/SQL subprograms
- Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code
- Create and use stored procedures and functions
- Design and use PL/SQL packages to group and contain related constructs
- Create overloaded package subprograms for more flexibility
- Use the Oracle supplied PL/SQL packages to generate screen output, file output, and mail output
- Write dynamic SQL for more coding flexibility
- Describe the features and syntax of PL/SQL
- Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
- Handle runtime errors
- Describe stored procedures and functions
- Design PL/SQL code for predefined data types, local subprograms, additional pragmas and standardized constants and exceptions
- Create triggers to solve business challenges
- Design PL/SQL anonymous block that execute efficiently
Required Skills/Experience
- Oracle Database 11g: SQL Fundamentals I
- Oracle Database 11g: SQL Fundamentals II
- Oracle Database 11g: SQL Fundamentals II
- Oracle Database 11g: SQL Fundamentals I
Suggested Next Course(s)
- Oracle Database 10g: Advanced PL/SQL
- Oracle Database 10g: SQL Tuning Workshop
Fee: $3,000.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC
