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.

Topics Covered

  • 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
  • Procedures
  • Functions
  • Packages
  • 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.

Furnished Materials:

  • PC Workstation for use during training
  • Student Manual

Recommended Follow-On Course


  • 2 Days


  • $990

Training Dates:

Sign Up