Professional training in London and 13 international cities info@llmi.uk +443300011190
Enquire

Professional training course · IMCS-008

Oracle SQL & PL/SQL Development Masterclass

Strong SQL and PL/SQL skills are essential for working with Oracle systems, reporting tools, and enterprise applications. This course helps participants build efficient…

  • 5 daysClassroom or online
  • 16Upcoming dates
  • 8Cities
  • £2,250Fees from
View dates & register Get quotation Download PDF
Oracle SQL & PL/SQL Development Masterclass
Next classroom session Amsterdam 16 - 20 Nov 2026 · £4,250 Next in London London 7 - 11 Dec 2026 · £2,750

Course overview

Why Attend
Strong SQL and PL/SQL skills are essential for working with Oracle systems, reporting tools, and enterprise applications. This course helps participants build efficient queries, automate tasks, and develop database procedures.

Course Methodology
Hands-on exercises, coding labs, demonstrations, workshops, and practical assignments.

Course Objectives

  • Write effective SQL queries
  • Use joins, subqueries, and functions
  • Develop PL/SQL blocks and procedures
  • Handle exceptions and cursors
  • Improve code performance

Target Audience

  • Developers
  • Analysts
  • Database Users
  • Technical Staff

Target Competencies

  • SQL Querying
  • PL/SQL Programming
  • Reporting Skills
  • Data Analysis
  • Code Optimization

Course outline

  1. 1Day 1: SQL Foundations
    • SELECT statements
    • Filtering and sorting
    • Functions and expressions
    • Data types
  2. 2Day 2: Advanced SQL Techniques
    • Joins and unions
    • Subqueries
    • Grouping and aggregation
    • Analytical queries
  3. 3Day 3: PL/SQL Fundamentals
    • Anonymous blocks
    • Variables and control structures
    • Loops and conditions
    • Basic procedures
  4. 4Day 4: Advanced PL/SQL Development
    • Functions and packages
    • Cursors
    • Exception handling
    • Triggers basics
  5. 5Day 5: Performance and Best Practices
    • Query optimization
    • Debugging techniques
    • Secure coding practices
    • Final coding workshop

Schedule

Dates and fees

16 upcoming dates in 8 cities. Fees are per delegate; bring colleagues and every seat is discounted. Every date can also be joined live online for £1,280.

All dates as PDF
November 2026
16NOV 16 - 20 Nov 2026Mon to Fri · 5 daysNext session
Netherlands flag AmsterdamNetherlands · Classroom
£4,250per delegate2+ people: £3,400 each
Register
December 2026
7DEC 7 - 11 Dec 2026Mon to Fri · 5 daysOur home city
United Kingdom flag LondonUnited Kingdom · Classroom
£2,750per delegate2+ people: £2,200 each
Register
14DEC 14 - 18 Dec 2026Mon to Fri · 5 days
Spain flag BarcelonaSpain · Classroom
£3,850per delegate2+ people: £3,080 each
Register
21DEC 21 - 25 Dec 2026Mon to Fri · 5 days
Switzerland flag GenevaSwitzerland · Classroom
£5,250per delegate2+ people: £4,200 each
Register
January 2027
4JAN 4 - 8 Jan 2027Mon to Fri · 5 daysOur home city
United Kingdom flag LondonUnited Kingdom · Classroom
£2,750per delegate2+ people: £2,200 each
Register
February 2027
1FEB 1 - 5 Feb 2027Mon to Fri · 5 days
Germany flag MunichGermany · Classroom
£4,250per delegate2+ people: £3,400 each
Register
March 2027
1MAR 1 - 5 Mar 2027Mon to Fri · 5 days
Spain flag MadridSpain · Classroom
£4,250per delegate2+ people: £3,400 each
Register
April 2027
5APR 5 - 9 Apr 2027Mon to Fri · 5 days
Switzerland flag GenevaSwitzerland · Classroom
£5,250per delegate2+ people: £4,200 each
Register
May 2027
3MAY 3 - 7 May 2027Mon to Fri · 5 days
Turkey flag IstanbulTurkey · Classroom
£2,850per delegate2+ people: £2,280 each
Register
June 2027
7JUN 7 - 11 Jun 2027Mon to Fri · 5 days
Malaysia flag Kuala LumpurMalaysia · Classroom
£2,250per delegate2+ people: £1,800 each
Register
July 2027
5JUL 5 - 9 Jul 2027Mon to Fri · 5 days
Netherlands flag AmsterdamNetherlands · Classroom
£4,250per delegate2+ people: £3,400 each
Register
August 2027
2AUG 2 - 6 Aug 2027Mon to Fri · 5 daysOur home city
United Kingdom flag LondonUnited Kingdom · Classroom
£2,750per delegate2+ people: £2,200 each
Register
September 2027
6SEP 6 - 10 Sep 2027Mon to Fri · 5 days
Malaysia flag Kuala LumpurMalaysia · Classroom
£2,250per delegate2+ people: £1,800 each
Register
October 2027
4OCT 4 - 8 Oct 2027Mon to Fri · 5 days
Netherlands flag AmsterdamNetherlands · Classroom
£4,250per delegate2+ people: £3,400 each
Register
November 2027
1NOV 1 - 5 Nov 2027Mon to Fri · 5 daysOur home city
United Kingdom flag LondonUnited Kingdom · Classroom
£2,750per delegate2+ people: £2,200 each
Register
December 2027
6DEC 6 - 10 Dec 2027Mon to Fri · 5 days
Spain flag BarcelonaSpain · Classroom
£3,850per delegate2+ people: £3,080 each
Register

Questions

Frequently asked questions

How long is the Oracle SQL & PL/SQL Development Masterclass course?

The course runs over 5 days of classroom training, usually Monday to Friday.

When is the next Oracle SQL & PL/SQL Development Masterclass course?

The next public date is 16 - 20 Nov 2026 in Amsterdam. There are 16 upcoming dates in total.

Where is this course held?

Upcoming sessions run in Amsterdam, London, Barcelona, Geneva, Munich, Madrid, Istanbul, Kuala Lumpur.

Can I take Oracle SQL & PL/SQL Development Masterclass online?

Yes. Every date can also be joined live online in a virtual classroom with the trainer, for £1,280 per participant. Choose "Live online" in the dates table when you register.

How much does the course cost?

Fees start from £2,250 per delegate, depending on the city. Fees include tuition and course materials.

Do participants receive a certificate?

Yes. Delegates who complete the course receive a London Leadership Management Innovation certificate of completion.

Can this course be delivered in-house for our team?

Yes. LLMI can tailor and deliver this course privately for your organisation at your premises or in one of our training cities.

Course information last updated 14 November 2026.

Related

More IT Management and Cyber Security courses

View all

Training a team?

Any course in our catalogue can be delivered privately for your organisation, at your offices or in one of our cities, with content shaped around your goals.

Plan in-house training Speak to an advisor