Duration
40 hours, 5-day training workshop
Delivery
Face to face training or online training
Course Inclusive
Description
The course introduces PL/SQL programming language basics, including the basic programming block structure, conditional statements, looping constructs, and additional functionality to extend the use of SQL.
Course Content
- Overview of PL-SQL
- Entering and running PL/SQL Code
- PL/SQL Block Structure
- Variables and Identifiers
- Using %TYPE and %ROWTYPE
- PL/SQL Control Structures
- Using Local PL/SQL Procedures and Functions
- Using Cursor Variable to Retrieve Data
- Working with PL/SQL Data Structures
- Handling PL/SQL Errors
- Overview of Procedures, Functions and Packages
- Managing Stored Procedures and Functions
- Managing Packages
- Overview of Triggers
- Designing Triggers
- Managing Triggers in a Database
- Manipulating Large Objects