Oracle Advanced PL/SQL & Performance Workshop
Course
In Gatwick
Description
-
Type
Course
-
Location
Gatwick
-
Duration
4 Days
Upon completion of this course, the participant should be able to develop and tune advanced PL/SQL applications. Suitable for: PL/SQL developers, DBAs and production DBAs.
Facilities
Location
Start date
Start date
About this course
Completion of our course Oracle PL/SQL Application Workshop or equivalent knowledge.
Reviews
Course programme
Currency: 10g & 11g 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.
Oracle Advanced PL/SQL & Performance Workshop