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

Audience:

     Oracle application developers

Prerequisites:

     Oracle SQL Fundamentals or equivalent experience

Benefits:

     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:

  • Student Manual

Recommended Follow-On Course

Length:

  • 2 Days

Price:

  • $990

Training Dates:

Sign Up