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: 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.

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 NEW

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: Backup and Recovery Workshop

Learn to evaluate your own recovery requirements. Develop appropriate strategies for backup, restore & recovery procedures from provided scenarios.

12c: High Availability New Features NEW

Introduces the Database 12c high availability new features contained in Oracle Grid Infrastructure, including Clusterware, Automatic Storage Management [ASM] and Cloud FS), Real Application Clusters (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 R2: Managing Multitenant Architecture

Covers all aspects of the multitenant architecture, providing detailed info on the components of an Oracle multitenant container DB & its regular & application pluggable databases. Learn why & how 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.

OEM Cloud Control 13c: Install & Upgrade Ed 1

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 (12.1.0.5)

Using OEM Cloud Control 13c NEW

Learn to 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.

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.

Exadata Database Machine: 12c Admin Workshop

Introduces you to Oracle Exadata Database Machine, covering 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.

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.

11gR2: RAC Administration - NEW

You will learn about RAC database administration in the Oracle Grid Infrastructure environment.

11gR2: RAC Admin & Grid Infrastructure Accel. Ed2

This 11gR2 RAC & Grid Infrastructure training teaches you to administer the Oracle Clusterware and storage products using both command line utilities and graphical tools. Troubleshoot by examining log files, enabling debugging and more.

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

Enterprise Manager (OEM) 11gR2: Grid Control Essentials

Oracle’s flagship product to address the broad IT requirements for managing the entire Oracle environment.

Database 11g: Secure Backup

Learn how to use Oracle Secure Backup, which supplies reliable tape backup of the database through direct integration with RMAN. It also provides general file system backup to tape....

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.

Oracle 11g: OCM Exam Prep Workshop Ed 2

Designed for those who are preparing to take the Oracle 11g OCM Exam. Review how to configure an Oracle 11g Enterprise Manager Grid Control, Oracle Data Guard, Grid Infrastructure & RAC through interactive instruction & hands-on exercises.

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: 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.

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

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 administer Oracle Database in the cloud.