Courses for Oracle SQL & Database

All Oracle University SQL & DBA courses for administering & tuning Oracle databases - 10g to 12c are delivered at Deloitte NZ.  Courses aligned to OCA/OCP exams.  If the course you need is not showing Please enquire - Course Enquiry. For Advanced training - ADVANCED ORACLE DATABASE courses

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.

SQL: Introduction to SQL

FOUNDATION COURSE FOR ORACLE DATABASE TECHNOLOGIES.
Intro to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions.

SQL Workshop I

Intro to Oracle 12c technology. Learn the concepts of relational databases & the powerful SQL programming language. Discover essential SQL skills that allow developers to write queries against single & multiple tables, manipulate data in tables & create database objects.

SQL Workshop II

Enhance your Application development skills by learning how to manage the database objects, data dictionary views & multicolumn subqueries.  Learn to write more efficient queries using the functions that support timezone & regular expressions.

Oracle 12c: Intro for experienced SQL Users

Learn Oracle Database 12c, the database environment and the Oracle SQL Developer tool. Learn how to create and manage tables, synonyms, sequences, indexes and views.

SQL & PL/SQL Fundamentals

Learn the fundamentals of SQL & PL/SQL and understand the benefits of the programming languages. Students learn the concepts of relational databases.

PL/SQL Fundamentals

Discover the benefits of Oracle's powerful programming language, while learning real-world scenarios where these lessons can be applied.

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

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

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

11g R2: Administration Workshop 1

Learn how to install & maintain the 11g database. Gain a conceptual understanding of the Oracle database architecture & how its components work & interact with one another...

11g R2: Administration Workshop 2

The concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. Includes how to define and test your own backup and recovery scenarios.

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 R2: New Features for Administrators

Learn about & practice with the new change management features & other key enhancements in Oracle Database 11g Release 1 & Release 2...

11g: Administer a Data Warehouse

Learn about Oracle’s Database partitioning architecture and how to identify the benefits of partitioning in addition to using parallel operations to reduce response time for data-intensive operations. Extract, transform, and load data into an Oracle database warehouse.

11g: Managing Oracle on Linux for DBA's

Designed to give the Database Administrator a firm understanding of the components required to successfully deploy an Oracle 11g database on Oracle Enterprise Linux.

11g: Managing Oracle on Linux for DBAs

Designed to give the Database Administrator a firm understanding of the components required to successfully deploy an Oracle 11g database on Oracle Enterprise Linux.

This course is based on Oracle Database 11g Release 1.

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.

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: SQL Tuning for Developers

In the Oracle Database: SQL Tuning for Developers course, you learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code. Learn the different ways in which data can be accessed efficiently.

Oracle 11g: XML Fundamentals

Learn to create an XML document, and format XML documents using XML Stylesheet Language for transformations (XSL). Learn about XML Namespaces, and document type definitions.

Oracle Linux 7: Advanced Administration Ed 1

Ideal for experienced administrators who need to learn more about Oracle Linux 7. You'll learn to configure networking services and authentication services, implement virtualization technologies to more effectively manage system resources, perform advanced storage administration tasks, implement shared storage technologies, and develop advanced troubleshooting skills.

Oracle Linux 7: System Administration Ed 1

Develop a range of skills, including installation, using the Unbreakable Enterprise Kernel, configuring Linux services, preparing the system for the Oracle Database, monitoring and troubleshooting. 

Oracle VM Server for x86: Administration

Explores building the infrastructure for open cloud computing. Expert Oracle University instructors will show you how to support enterprise applications by deploying pooled server resources to create virtual machines.

Unix and Linux Essentials NEW

Provides users and administrators new to the Oracle Solaris 11 and Oracle Linux operating systems with the basic UNIX skills they need to interact comfortably and confidently with the operating system.

Oracle Linux 5 & 6 Advanced Administration

This Oracle Linux Advanced Administration training is ideal for experienced administrators who need to learn more about advanced features of Oracle Linux. You'll learn to configure network and authentication services, implement virtualization technologies to more effectively manage system resources, and deploy new types of file systems to improve performance and increase data integrity, while developing troubleshooting and advanced storage administration skills.