llmi.ukinfo@llmi.uk
IT Management and Cyber Security · IMCS-008
Oracle SQL & PL/SQL Development Masterclass
5 daysClassroom
16Upcoming dates
8Cities
£2,250Fees from + VAT
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
Day 1: SQL Foundations
- SELECT statements
- Filtering and sorting
- Functions and expressions
- Data types
Day 2: Advanced SQL Techniques
- Joins and unions
- Subqueries
- Grouping and aggregation
- Analytical queries
Day 3: PL/SQL Fundamentals
- Anonymous blocks
- Variables and control structures
- Loops and conditions
- Basic procedures
Day 4: Advanced PL/SQL Development
- Functions and packages
- Cursors
- Exception handling
- Triggers basics
Day 5: Performance and Best Practices
- Query optimization
- Debugging techniques
- Secure coding practices
- Final coding workshop
Dates and fees
| Dates | City | Fee |
|---|---|---|
| 16 - 20 Nov 2026 | Amsterdam, Netherlands | £4,250 + VAT |
| 7 - 11 Dec 2026 | London, United Kingdom | £4,200 + VAT |
| 14 - 18 Dec 2026 | Barcelona, Spain | £3,850 + VAT |
| 21 - 25 Dec 2026 | Geneva, Switzerland | £5,250 + VAT |
| 4 - 8 Jan 2027 | London, United Kingdom | £4,200 + VAT |
| 1 - 5 Feb 2027 | Munich, Germany | £4,250 + VAT |
| 1 - 5 Mar 2027 | Madrid, Spain | £4,250 + VAT |
| 5 - 9 Apr 2027 | Geneva, Switzerland | £5,250 + VAT |
| 3 - 7 May 2027 | Istanbul, Turkey | £2,850 + VAT |
| 7 - 11 Jun 2027 | Kuala Lumpur, Malaysia | £2,250 + VAT |
| 5 - 9 Jul 2027 | Amsterdam, Netherlands | £4,250 + VAT |
| 2 - 6 Aug 2027 | London, United Kingdom | £4,200 + VAT |
| 6 - 10 Sep 2027 | Kuala Lumpur, Malaysia | £2,250 + VAT |
| 4 - 8 Oct 2027 | Amsterdam, Netherlands | £4,250 + VAT |
| 1 - 5 Nov 2027 | London, United Kingdom | £4,200 + VAT |
| 6 - 10 Dec 2027 | Barcelona, Spain | £3,850 + VAT |
London Leadership Management InnovationRegister at llmi.uk/course/oracle-sql-and-pl-sql-development-masterclass