SQL (Oracle)

This three-day course builds proficiency in querying, updating, and managing Oracle database content. You’ll work through tasks such as combining data, applying filters, summarising results, and defining database structures. With a focus on real-world practice, you’ll gain the ability to produce reliable SQL statements that support reporting, data analysis, and everyday database operations. 

Spanning five days, this course offers an integrated introduction to Oracle SQL and the PL/SQL programming language. You’ll practise retrieving and modifying data, creating database objects, and developing procedural code with basic program logic. Hands-on, guided sessions ensure you can apply these skills with confidence - whether aiming for industry certification or preparing for more advanced database programming. 

This five-day course bridges core SQL skills with PL/SQL development, giving you the capability to create functional, efficient Oracle programs. You’ll design procedural code, implement decision-making structures, manage exceptions, and handle data retrieval using cursors. The interactive learning format ensures you can translate new knowledge into immediate results, making it an ideal entry point for aspiring Oracle developers. 

Delivered over five days, this course develops a strong command of PL/SQL for Oracle databases. You’ll gain the expertise to design reliable, maintainable code that integrates seamlessly with existing systems. Key areas include program logic, data handling, error management, and stored procedure creation. Live, interactive exercises help you apply concepts effectively, building your capability to produce secure, high-quality database applications. 

In this focused two-day course, you’ll learn to create, manage, and optimise stored procedures, functions, and packages in Oracle PL/SQL. You’ll explore structured programming techniques, dependency handling, and efficient reuse of code components. Through applied learning, you’ll also be able to enhance database performance and streamline operations with well-structured, modular program units. 

Aimed at experienced users, this three-day course covers advanced SQL capabilities within Oracle databases. You’ll refine your skills in complex data retrieval, multi-table joins, advanced functions, and high-level query optimisation. Practical exercises give you the tools to write sophisticated, high-performance SQL code that addresses challenging business requirements and maintains efficiency at scale. 

This three-day programme expands the skills of seasoned PL/SQL developers. You’ll work with advanced collections, integrate with external systems, manage large data objects, and apply fine-grained access control. The course also focuses on security best practices and performance improvements, ensuring you can produce scalable, secure applications in Oracle environments. 

In four days, you’ll learn to create secure, web-based applications using Oracle APEX 21. Training covers essential development tools along with enhancements to interface design and usability. Realistic exercises guide you through building responsive, interactive applications, making this course ideal for those looking to modernise app delivery using their Oracle SQL and PL/SQL expertise. 

This four-day course explores the new and improved capabilities of Oracle APEX version 23. You’ll develop applications using updated interface components, background process handling, and improved notification tools. With advanced security options and customisation features, you’ll be equipped to produce dynamic, modern solutions while keeping pace with the platform’s latest advancements.