Home : Directions : Hotels : Contact Us : About : e-mail : Login
Oracle PL/SQL Programming
     
     This hands-on course introduces the Oracle 9i 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.
Covered Topics:
  • 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
Prerequisites:
  • Oracle SQL Fundamentals or equivalent experience
Audience:
     Oracle application developers
Course 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.
Materials Furnished:
Recommended Follow-On Course:
  • Oracle 9i Advanced SQL
  • Oracle 9i Advanced PL/SQL
  • Oracle Forms 9i
  • Oracle Reports 9i
Course Length: Two Days
Public Course Price: $990.00
On-Site Price:
Please contact Euler Solutions for details
Home : Directions : Hotels : Contact Us : About : e-mail : Login
Copyright © 2008 Euler Solutions, Inc. Minneapolis, MN