Duration
40 hours, 5-day training workshop
Description
Extend the functionality of the SQL language with PL/SQL to write application codes.
Course Outcome
Trainees shall be able to realize the full benefit of utilizing Oracle best practices in a company or in an organization.
Course Content
- Introduction to PL/SQL
- Declare PL/SQL Identifiers
- Write Executable Statements
- Interaction with the Oracle Server
- Control Structures
- Composite Data Types
- Explicit Cursors
- Exception Handling
- Stored Procedures
- Stored Functions and Debugging Subprograms
- Packages
- Deploying Packages
- Implement Oracle-Supplied Packages in Application Development
- Dynamic SQL
- Design Considerations for PL/SQL Code
- Triggers
- Creating Compound, DDL, and Event Database Triggers
- PL/SQL Compiler
- Manage PL/SQL Code
- Manage Dependencies