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

SQL: Introduction to SQL

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.

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.

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

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

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.

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.

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

Oracle 12c: SQL & PL/SQL New Features

Learn the new features available in Oracle 12c. Explore the latest features in SQL language and enhancements in PL/SQL, data types, language performance and data warehousing. Gain a better understanding of the data warehousing new features available in Oracle 12c. Includes maintaining multiple partitions and SQL for pattern matching.

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.

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

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

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

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

Teaches you how to automate OS installation, recover from boot problems and configure networking and authentication services. Explore shared storage configuration, implement virtualization services implementation, and system resources management. In this course, you will be introduced to the Oracle IaaS Cloud Solution.

Oracle Linux 7: System Administration

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.

12c: Analytic SQL for Data Warehousing

12c: Analytic SQL for DW teaches how to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data & exclude branches from the tree structure. Learn to use regular expressions & sub-expressions to search for, match & replace strings.