AI Security: Protecting Machine Learning Systems
Next: 14 - 18 Dec 2026 · Paris
Paris, Barcelona, London +7 more
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
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
Dates and fees
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 + VAT 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
Application Security and Secure Software Development
Next: 21 - 25 Dec 2026 · Barcelona
Barcelona, Munich, London +5 more
Artificial Intelligence (AI) in Cyber Forensics: Investigating Advanced Cyber Crimes
Next: 16 - 20 Nov 2026 · Istanbul
Istanbul, Rome, Frankfurt +5 more