Oracle – PL/SQL
Course content:

  • PL/SQL Language Study – Syntax, Anonymous blocks, Application Blocks and Control Structures
  • PL/SQL Advanced: Triggers – Construct and Usage.
  • Functions – Constructs and Usage. Use in reporting and intermediate procedural calculations.
  • Procedures and Packages – Study of PL/SQL variables, User Defined variables, cursors and exception handling. Study of ackages – Package Specification and package body.
  • Exception Handling – Using built-in exceptions and user defined exceptions.

Book Information:

  • The Sybex Oracle DBA Certification Kit books are used for the Oracle DBA track.
  • OCP: Oracle Database 11g Adminsitrator Study Guide – Biju Thomas. Sybex, ISBN: 978-0-470-39512-7

System Requirements for doing Labs:

  • Processor: Dual Core. Must be a x64 processor with hardware-assisted virtualization support (Intel VT-x or AMD-V).
  • Memory: 4GB RAM
  • Disk Space: 50GB of free hard drive space
  • OS: Vista or Windows7/8

Want to take this class? Let us know by clicking here.