Oracle Advanced PL/SQL & Performance Workshop

Course

In Gatwick

£ 1,425 + VAT

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

Gatwick (London)
Regus Centre, First Point, Buckingham Gate, London Gatwick Airport, RH6 0NT

Start date

On request

About this course

Completion of our course Oracle PL/SQL Application Workshop or equivalent knowledge.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

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

£ 1,425 + VAT