This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. 

• 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

• Oracle Database 11g: Introduction to SQL (combination of Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II)

Suggested Prerequisites:

• Previous programming experience