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.
Course Outline
Introduction to PL/SQL Language
- Execution environment
- Comparison between SQL and PL/SQL
- Language characteristics and lexical units
- Structure of PL/SQL blocks
- Anonymous blocks versus stored subroutines
- Program execution process
Scalar Variables
- Declarations
- Data types
- Lifetime, scope, and initialization
Controlling Instruction Execution Order
- Decision-making logic
- Loop structures
SQL Commands within PL/SQL
- DML commands
- DDL commands and dynamic SQL
- TCL commands and transaction control
- Simplified SELECT command integration
Cursor Handling
- Record types
- Static cursors
- Cursor loops
Error and Exception Handling
- Names, codes, and messages
- Exception handling sections and propagation
- Application-specific errors
Creating Stored Procedures and Functions
- Compilation, object status, and source code management
- Parameterization
- Invocation methods
Collections
- Associative tables (index-by) and nested tables
- Attributes, handling, initialization, and memory allocation
Mass Operations on Collections
- Mass queries (BULK COLLECT)
- Bulk DML operations (FORALL)
- Exception handling in bulk operations
- Array and stream functions
Elements of SQL Command Execution Performance
- SQL command execution process and goal setting
- Acquisition and analysis of execution plans
- Controlling the cost optimizer
- Full table scans versus index scans
- Tips and best practices
Suggested pre-training
ORA_SA1 or ORA_S1
Suggested follow-up training courses
ORA_SA2
Requirements
Foundational knowledge of relational databases and proficient use of the SELECT statement, including projection, selection, joins, and subqueries.
21 Hours
Testimonials (2)
Greg was very patient and helpful
Chris Havel - Encyclopaedia Britannica
Course - ORACLE SQL Fundamentals
presentation skills, prompt answers to all questions
