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

Course Schedule

  • 15-18 April
  • 13-16 May
  • 10-13 June
  • 15-18 July
  • 12-15 August
  • 9-12 September
  • 14-17 October

Price: £1,275+VAT
Venue: Gatwick

Book Course

Course Outlines

Detailed course outlines are available in PDF format. Download Adobe's Acrobat Reader free from: www.adobe.com
Get Acrobat Reader

Training Topics

GENERAL

print  |  top of page