Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 21 hours
Course Outline
Introduction to the PL/SQL Language
- The execution environment
- Comparison of SQL and PL/SQL capabilities
- Language characteristics and lexical units
- Structural components of PL/SQL blocks
- Distinction between anonymous blocks and stored subroutines
- Program execution mechanics
Scalar Variables
- Variable declarations
- Data type specifications
- Lifetime, scope, and initialization rules
Controlling the Order of Instruction Execution
- Decision-making logic
- Loop structures
SQL Commands in PL/SQL
- Data Manipulation Language (DML) commands
- Data Definition Language (DDL) commands and dynamic SQL
- Transaction Control Language (TCL) commands and transactivity
- Simplified SELECT command usage
Cursor Handling
- Record types
- Static cursors
- Cursor loops
Error and Exception Handling
- Error names, codes, and messages
- Exception handling section and propagation mechanisms
- Application-level errors
Creating Stored Procedures and Functions
- Compilation, object status, and source code management
- Parameterization techniques
- Methods for invoking procedures and functions
Collections
- Associative arrays (index by) and nested tables
- Collection attributes, handling, initialization, and memory allocation
Mass Operations on Collections
- Mass queries using BULK COLLECT
- Bulk DML using FORALL
- Exception handling in bulk operations
- Array and stream functions
Elements of SQL Command Execution Performance
- SQL command execution process and performance goal setting
- Acquisition and analysis of the command execution plan
- Controlling the operation of the cost optimizer
- Full table scans versus index-based access
- Best practices and optimization techniques
Suggested prerequisite training
ORA_SA1 or ORA_S1
Suggested follow-up training courses
ORA_SA2
Requirements
Demonstrated knowledge of relational databases and proficient use of the SELECT statement, including projection, selection, joins, and subqueries.
Testimonials (2)
Greg was very patient and helpful
Chris Havel - Encyclopaedia Britannica
Course - ORACLE SQL Fundamentals
presentation skills, prompt answers to all questions
