Oracle PL/SQL Fundamentals
This hands-on course introduces the Oracle PL/SQL programming language. Students will learn critical aspects of PL/SQL including language basics, if statements, cursors, loops, stored program units and error handling.
- What is PL/SQL?
- PL/SQL block structure
- Declaring local variables
- Scope of local variables
- Conditional control using the IF and CASE statements
- Loop constructs
- Implicit and explicit cursors
- Cursor attributes and cursor parameters
- Error handling
- Stored program units
- Database Triggers
Oracle application developers
Oracle SQL Fundamentals or equivalent experience
Students will be able to code PL/SQL programs that include common programming constructs such as data-typing, variable assignment, flow control, array-like processing and error handling.
- PC Workstation for use during training
- Student Manual
- Oracle Advanced SQL
- Oracle Advanced PL/SQL
- Oracle Forms
- Oracle Reports
No Reviews found for this course.