Oracle Advanced PL/SQL & Performance Workshop

Course Code: ORAAPS
Currency: 10g & 11g
Duration: 4 days
Audience: PL/SQL developers, DBAs and production DBAs.
Prerequisites: Completion of our course Oracle PL/SQL Application Workshop or equivalent knowledge.
Summary: This lab-oriented PL/SQL presentation focuses on the advanced features of Oracle's PL/SQL and SQL features; additionally, all of the attendant performance and tuning issues are elaborated on.
Among the featured topics are:
  • Collections
  • SPARSE collections
  • Table functions
  • BULK COLLECT
  • Cursor variables
  • Dynamic SQL
  • Packages
  • PL/SQL optimisation
  • Locking & concurrency
  • Performance and good practices
Objectives: Upon completion of this course, the participant should be able to develop and tune advanced PL/SQL applications.
View full outline in PDF formatDetailed Outline

print  |  top of page