SQL (Oracle)

In this three-day course, you’ll develop the skills to query, manipulate, and manage data in Oracle databases using SQL. Training covers selecting, filtering, joining, and aggregating data, as well as creating and modifying database structures. With an emphasis on realistic exercises, you’ll leave able to write accurate, efficient SQL statements to support analysis, reporting, and database maintenance tasks. 

This five-day course introduces you to both Oracle SQL for data management and PL/SQL for procedural programming. You’ll gain experience querying and updating data, creating database objects, and writing simple PL/SQL blocks with variables, loops, and exception handling. Practical, instructor-led exercises ensure you can confidently apply these core skills, whether your goal is formal certification or building a solid foundation for further Oracle learning. 

This five-day course blends fundamental SQL knowledge with PL/SQL programming to create a strong foundation in Oracle database development. You’ll learn to write procedural code, use variables and control structures, handle exceptions, and work with cursors. Guided exercises in a live lab environment ensure you can apply concepts immediately, making this an excellent choice for developers starting their Oracle programming journey. 

This course provides a thorough grounding in Oracle’s PL/SQL programming language, across five days. You’ll learn how to create robust, maintainable code that integrates seamlessly with Oracle databases. Topics include variables, control structures, cursors, exception handling, and stored procedures. With extensive live labs and hands-on practice, you’ll gain the confidence to develop efficient, secure database applications for a range of business requirements.  

This course focuses on creating and managing stored procedures, functions, and packages in Oracle PL/SQL. You’ll explore modular programming techniques, manage dependencies, and work with overloading, forward declarations, and package features. Delivered through interactive sessions, it’s designed for developers wanting to streamline database operations and enhance performance through reusable, well-structured program units. 

Designed for experienced SQL users, this three-day course explores advanced querying techniques and database features in Oracle SQL. You’ll work with complex joins, subqueries, analytical functions, and advanced data manipulation methods. Practical exercises focus on writing efficient queries, optimising performance, and applying advanced SQL tools to solve real-world business problems, ensuring your skills remain sharp and competitive. 

This three-day course is designed for experienced PL/SQL users ready to extend their capabilities. You’ll work with collections, integrate external programs, handle large objects, and apply fine-grained access control. The course also covers performance tuning, caching techniques, and secure coding practices. Delivered live online with extensive exercises, it equips advanced developers to create efficient, secure, and maintainable Oracle applications. 

Across four days, you’ll learn to design and deploy secure, browser-based applications using Oracle APEX 21. This training covers key tools and features, including SQL Workshop, forms, interactive reports, dynamic actions, and shared components. You’ll also explore the latest v12 updates to page design and user interface enhancements. This course is ideal for developers wanting to modernise application delivery while applying their Oracle SQL and PL/SQL knowledge. 

This four-day course builds on existing APEX knowledge and focuses on the new capabilities in version 23. You’ll work with template components, push notifications, and background process execution, while exploring advanced plug-ins, charting options, and security enhancements. Through guided, practical sessions, you’ll develop dynamic, customised applications that take full advantage of the latest APEX features — ensuring your skills stay current in a rapidly evolving platform.