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
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 · £4,200

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

1Day 1: SQL Foundations
- SELECT statements
- Filtering and sorting
- Functions and expressions
- Data types
2Day 2: Advanced SQL Techniques
- Joins and unions
- Subqueries
- Grouping and aggregation
- Analytical queries
3Day 3: PL/SQL Fundamentals
- Anonymous blocks
- Variables and control structures
- Loops and conditions
- Basic procedures
4Day 4: Advanced PL/SQL Development
- Functions and packages
- Cursors
- Exception handling
- Triggers basics
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.

All dates as PDF

November 2026

16NOV 16 - 20 Nov 2026Mon to Fri · 5 daysNext session

AmsterdamNetherlands · Classroom

£4,250per delegate2+ people: £3,400 each

December 2026

7DEC 7 - 11 Dec 2026Mon to Fri · 5 daysOur home city

LondonUnited Kingdom · Classroom

£4,200per delegate2+ people: £3,360 each

14DEC 14 - 18 Dec 2026Mon to Fri · 5 days

BarcelonaSpain · Classroom

£3,850per delegate2+ people: £3,080 each

21DEC 21 - 25 Dec 2026Mon to Fri · 5 days

GenevaSwitzerland · Classroom

£5,250per delegate2+ people: £4,200 each

January 2027

4JAN 4 - 8 Jan 2027Mon to Fri · 5 daysOur home city

LondonUnited Kingdom · Classroom

£4,200per delegate2+ people: £3,360 each

February 2027

1FEB 1 - 5 Feb 2027Mon to Fri · 5 days

MunichGermany · Classroom

£4,250per delegate2+ people: £3,400 each

March 2027

1MAR 1 - 5 Mar 2027Mon to Fri · 5 days

MadridSpain · Classroom

£4,250per delegate2+ people: £3,400 each

April 2027

5APR 5 - 9 Apr 2027Mon to Fri · 5 days

GenevaSwitzerland · Classroom

£5,250per delegate2+ people: £4,200 each

May 2027

3MAY 3 - 7 May 2027Mon to Fri · 5 days

IstanbulTurkey · Classroom

£2,850per delegate2+ people: £2,280 each

June 2027

7JUN 7 - 11 Jun 2027Mon to Fri · 5 days

Kuala LumpurMalaysia · Classroom

£2,250per delegate2+ people: £1,800 each

July 2027

5JUL 5 - 9 Jul 2027Mon to Fri · 5 days

AmsterdamNetherlands · Classroom

£4,250per delegate2+ people: £3,400 each

August 2027

2AUG 2 - 6 Aug 2027Mon to Fri · 5 daysOur home city

LondonUnited Kingdom · Classroom

£4,200per delegate2+ people: £3,360 each

September 2027

6SEP 6 - 10 Sep 2027Mon to Fri · 5 days

Kuala LumpurMalaysia · Classroom

£2,250per delegate2+ people: £1,800 each

October 2027

4OCT 4 - 8 Oct 2027Mon to Fri · 5 days

AmsterdamNetherlands · Classroom

£4,250per delegate2+ people: £3,400 each

November 2027

1NOV 1 - 5 Nov 2027Mon to Fri · 5 daysOur home city

LondonUnited Kingdom · Classroom

£4,200per delegate2+ people: £3,360 each

December 2027

6DEC 6 - 10 Dec 2027Mon to Fri · 5 days

BarcelonaSpain · Classroom

£3,850per delegate2+ people: £3,080 each

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.

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.

More IT Management and Cyber Security courses

View all

AI Security: Protecting Machine Learning Systems

Next: 14 - 18 Dec 2026 · Paris

Paris, Barcelona, London +7 more

From £2,840

Application Security and Secure Software Development

Next: 21 - 25 Dec 2026 · Barcelona

Barcelona, Munich, London +5 more

From £2,850

Artificial Intelligence (AI) in Cyber Forensics: Investigating Advanced Cyber Crimes

Next: 16 - 20 Nov 2026 · Istanbul

Istanbul, Rome, Frankfurt +5 more

From £2,250

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