Courses for Advanced Oracle Database

All Oracle University Advanced DBA courses including RAC & Security and specialties such as Spatial are delivered at Deloitte NZ.  Courses important towards OCE/OCM certifications.  If the course you need is not showing Please enquire - Course Enquiry

18c: Administration Workshop

Detailed information on the Oracle Database architecture enabling you to manage your database resources effectively. Create database storage structures appropriate for the business applications supported by your database. Learn how to create users and administer security to meet your business needs.

18c: Backup and Recovery Workshop

Perform backup and recovery based on the related Oracle Database architecture components. Various scenarios are included to develop appropriate strategy for backup and recovery procedures. ?Includes interactive workshop, with scenarios to diagnose and recover from several related failure situations.

18c: New Features for Administrators

Provides an overview of the Oracle Database 18c new features and enhancements related to Multitenant architecture, security, RMAN, general database areas, performance, data warehousing and Sharding.

18c: High Availability New Features

Learn about new software features and improvements found in Oracle Clusterware, Oracle ASM, Real Application Clusters, and Oracle Data Guard

12c R2: New Features for 12c R1 Administrators Ed 1

Designed for existing 12c R1 DBAs. In addition to covering the New Features of R2, this course also introduces students to the Oracle Database Cloud Service.
*11gDBAs will require the standard "12cR1: New Features" course first

12c R2: Administration Workshop

12c: Admin Workshop teaches about the Oracle Database architecture. Discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment & perform database maintenance.

12c R2: Backup and Recovery Workshop

Teaches you about backup, restore and recovery scenarios. Will help you evaluate your own recovery requirements and develop appropriate strategies for these procedures.You will also be introduced to Oracle Database Cloud Service.

Database Backup & Recovery Strategy for Oracle Cloud

Teaches you how to align or redesign your backup and recovery strategy either post migration or in preparation for your Oracle Database migration to Oracle Cloud. Ideal for experienced DBAs to manage backups on Oracle Cloud and take advantage of Cloud features, such as capacity on demand, built-in encryption, and built-in compression

12c R2: High Availability New Features

Database 12c R2: High Availability New Features course covers High Availability new features introduced in the Oracle Database 12c Release 2. Focus areas include Clusterware, ASM, ACFS, RAC, and Data Guard.

12c: Performance Management & Tuning

Learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues.

12c: RAC & Data Guard Integration Workshop

Learn how to practice deploying, configuring, administering, maintaining, and using noteworthy features associated with Oracle Database 12c RAC and Data Guard.

12c: Clusterware Admin (RAC part1)

Explore general cluster concepts and Oracle Clusterware architecture. Work with expert Oracle University instructors through interactive instruction and hands-on exercises to reinforce your learning.

12c: RAC Administration (RAC part2)

Learn about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion.

12c: ASM Administration (RAC part3)

Teaches about Oracle ASM architecture. Develop a deeper understanding of both standard ASM and Flex ASM applications. Configure and manage advanced CloudFS features

12c R2: Managing Multitenant Architecture

Covers all aspects of the multitenant architecture, ?with detailed info on the components of an Oracle multitenant container DB & its regular & application pluggable ?DBs. Learn to create & manage a multitenant container DB & its regular & application pluggable DBs, with storage structures appropriate for the business applications.

12c: Data Guard Administration

How to use Oracle Data Guard. Expert OU instructors will demonstrate how this solution protects your Oracle database against planned and unplanned downtimes.

Exadata Database Machine: 12c Admin Workshop

Covers the features and capabilities of the Exadata Database Machine X6 product family. Explore the various Exadata Database Machine features and configurations, with emphasis on the unique capabilities delivered by Exadata Storage Server.

OEM Cloud Control 13c: Install & Upgrade

Learn about the architecture of OEM Control 13c, implementation options & perform a standard single-server installation. Review the available upgrade paths from previous versions & execute a 1-system upgrade from OEM Cloud Control 12c (

Using OEM Cloud Control 13c

Use OEM Cloud Control to monitor & manage your environment. Use the out-of-box capability to manage Oracle targets, individually or in groups with templates, monitor the compliance of targets, use the job system to automate commonly performed tasks, view & compare config's & create & use predefined & customized reports.

OEM Cloud Control 12c: Advanced Config. Workshop

Learn to maximize availability and scalability with deployment of EM. Learn techniques for disaster recovery, security and command line operations.

12c: Install and Upgrade Workshop NEW

This Oracle Database 12c: Install and Upgrade Workshop gives you detailed information to help you install Oracle Database 12c software. Expert Oracle instructors will teach you how to create a container database and provision
pluggable databases.

12c: Admin, Install & Upgrade Accel. NEW

Will provide you with key information to install and administer Oracle Database 12c. This is an accelerated course, covering 7 days worth of content in only 5 days.

Oracle Database Cloud for Oracle DBAs

Oracle Database Cloud for Oracle DBAs training teaches you how to administer the Oracle Database Cloud Service. It's ideal for existing DBAs who want to learn how to deploy and administer an Oracle Database 18c environment in the cloud.

Oracle Autonomous Database Workshop

Provision an Oracle Autonomous Database Cloud Service instance on Oracle Cloud suitable for your workload and requirements. A great starting point for developers, administrators, architects. Learn about self-driving, self-securing, self-repairing autonomous database services... and the Autonomous Data Warehouse service that is tuned and optimized for data warehouse workloads...

Migrating Your Oracle Database to the Oracle Cloud

Teaches how to migrate your On-Premises Oracle Database to Oracle Database Cloud. Ideal for experienced DBAs who want to learn the migration techniques to Oracle Database Cloud Service using RMAN, Data Pump, Unplug/Plug, Remote Cloning and SQL Developer. Use cases on advanced migration methods using Data Guard, GoldenGate and Lift & Shift.

11gR2: New Features for Administrators Accelerated

This course gives you the opportunity to learn about and practice with the new change management features and other key enhancements in Oracle Database 11g Release 1 and Release 2.

11gR2: Performance Tuning

Starts with an unknown database that requires tuning. Use 11g automatic tuning features as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository & Automatic Database Diagnostic Monitor, and practice these tuning methods.

11g: Backup and Recovery Workshop - New

Examines various backup, failure, restore, and recovery scenarios. You should have some knowledge of Recovery Manager (RMAN) and Enterprise Manager. Flashback features are also described as additional way to recover from various errors.

GoldenGate 12c: Fundamentals for Oracle

Focuses on Oracle-to-Oracle database replication. Expert Oracle University instructors will deep dive into the Oracle GoldenGate architecture, walking you through various product features.

GoldenGate 12c: Advanced Configuration for Oracle

Enrolling in this Oracle GoldenGate 12c training will help you develop your installation and configuration skills. By interacting with top Oracle instructors, you'll be able to ask questions as you learn to solidify your understanding.

GoldenGate 12c Troubleshooting & Tuning

Teaches how to gather & examine evidence; you’ll learn to solve case problems, diagnose their cause and find methods of resolution. Each of these practices challenges you to diagnose and troubleshoot the issue using GoldenGate software

11gR2: Implement Database Vault

Helps an organization meet their security goals. Many requirements are being put on systems regarding separation of duties and privacy and protection of data, including insider threats. DBAs & security administrators need to understand these requirements and also the tools available for meeting them.

Implementing Oracle Audit Vault NEW

Learn how to use Oracle Audit Vault - a powerful enterprise-wide audit solution to efficiently consolidate, detect, monitor, alert & report on audit data for security auditing and compliance...

12c: Security

Learn how to use Oracle Database features to meet the security, privacy & compliance requirements of your organization. 

Oracle Spatial: Essentials

Covers the concepts and usage of the native data types, functions and operators available in Oracle Spatial for implementing geospatial applications and location-based services.

Oracle Spatial: Advanced

Teaches the advanced features of Oracle Spatial. New features of Oracle Spatial that simplify spatial queries, application development, and deployment are also covered.

Oracle 12c: Use XML DB

Allows you to deep dive into the key features of Oracle XML DB. Use Oracle XML DB to store, access, manipulate, validate, search, update, annotate, transform, generate, import and export XML data.

RAC & Grid Infrastructure for Solaris Sys Admins

Seminar: Learn about Oracle RAC install & admin concepts in a Solaris env. Prepare Solaris cluster nodes to accept an Oracle Grid Infrastructure install using Oracle ASM for cluster storage needs. Also create a RAC database using ASM for the database shared storage.Intended to aid current Solaris Sys Admins to successfully install, configure & administer RAC database envs.

12c R1: New Features for Administrators

Learn about the new and enhanced features of Oracle Database 12c. Expert instructors will teach you how these features increase security, manageability & performance.

Oracle 11g: Implement Streams Release 2

Oracle Streams is a powerful and flexible information sharing feature of Oracle Database 11g R2. Gain a practical experience in configuring and managing a Streams environment.