Oracle training courses
London UK & Live Online

JBI Training offers twelve Oracle database courses. These include Oracle SQL Foundation (three days), Oracle SQL Advanced (four days), Oracle PL/SQL Foundation (three days), Oracle PL/SQL and Packages (five days), Oracle DBA Part 1 (five days), Oracle DBA Part 2 (three days), Oracle Admin Essentials (three days), Oracle Performance Tuning (three days), Oracle AWR Usage (three days), Oracle Backup and Recovery Essentials (two days), Oracle GoldenGate Essentials (three days), and Oracle 12c New Features (five days). All are available in London, online, or as customised onsite programmes.

Oracle SQL Foundation is a three-day course for professionals new to Oracle SQL, covering core querying, filtering, sorting, joins, aggregations, subqueries, and DML statements for inserting, updating, and deleting data. Oracle SQL Advanced is a four-day course for those with existing Oracle SQL experience who want to go deeper — covering advanced query techniques, analytical functions, hierarchical queries, XML and JSON handling in Oracle, performance considerations for SQL queries, and advanced features of the Oracle SQL dialect. Delegates should have solid SQL Foundation-level experience before attending the Advanced course.

PL/SQL (Procedural Language/SQL) is Oracle's proprietary procedural extension to SQL, used to write stored procedures, functions, triggers, and packages that run directly within the Oracle database. JBI offers two PL/SQL courses. Oracle PL/SQL Foundation (three days) covers the PL/SQL block structure, variables and data types, control flow, cursors, exception handling, and creating stored procedures and functions. Oracle PL/SQL and Packages (five days) extends this to cover packages, triggers, dynamic SQL, collections, bulk processing, advanced exception handling, and performance optimisation of PL/SQL code. Both courses are suited to Oracle developers and database programmers.

Oracle GoldenGate is a high-performance data replication and integration platform used to capture, transform, and deliver data changes between databases in real time — supporting use cases including zero-downtime migrations, high availability, disaster recovery, and real-time data integration between Oracle and heterogeneous database environments. JBI's three-day Oracle GoldenGate Essentials course covers the GoldenGate architecture, configuring Extract and Replicat processes, managing trails and checkpoints, monitoring and troubleshooting replication, and applying GoldenGate to common enterprise scenarios. It is suited to Oracle DBAs, data engineers, and integration architects working in environments where real-time data replication is required.

The three-day Oracle Performance Tuning course covers the techniques and tools used to identify and resolve performance problems in Oracle database environments. Topics include understanding the Oracle architecture from a performance perspective, using Explain Plan and SQL trace to analyse query execution, tuning SQL queries for optimal execution plans, using Oracle's Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for performance analysis, index design and management, memory configuration tuning, and I/O optimisation. It is suited to Oracle DBAs, senior developers, and database architects who are responsible for the performance and scalability of Oracle database systems in production environments.

Oracle DBA Part 1 is a five-day comprehensive foundation for Oracle database administration, covering Oracle architecture, installation and configuration, managing tablespaces and datafiles, user management and security, backup and recovery using RMAN, network configuration, and routine DBA operational tasks. Oracle DBA Part 2 is a three-day advanced programme for DBAs who have completed Part 1 or have equivalent experience, covering more complex administration topics including advanced backup and recovery strategies, Flashback technology, resource management, performance monitoring, and managing Oracle in more complex multi-tier environments. Together the two programmes provide a thorough, practical grounding in professional Oracle database administration.

Yes. All Oracle courses at JBI can be delivered as customised onsite or online programmes for corporate Oracle database teams. Content can be tailored to the team's Oracle version, existing environment, specific performance challenges, or DBA responsibilities. For example, a team managing Oracle in a high-availability environment can receive training focused on GoldenGate, backup and recovery, and performance tuning, while a development team building Oracle-backed applications can receive an integrated SQL and PL/SQL programme. JBI has delivered Oracle database training for teams at organisations including the BBC, NHS, RBS, Sky, EDF, and Cisco.