Home Page > Education

Oracle Course Categories                

Oracle SQL & Database by Category
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 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.
VIEW DETAILS $5,110.00 View the Product
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. VIEW DETAILS $3,066.00 View the Product
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. VIEW DETAILS $2,044.00 View the Product
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. VIEW DETAILS $5,110.00 View the Product
12c: New Features for Administrators NEW

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

VIEW DETAILS $5,110.00 View the Product
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.
VIEW DETAILS $2,044.00 View the Product
12c: 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. VIEW DETAILS $5,110.00 View the Product
12c: Backup and Recovery Workshop NEW Learn to evaluate your own recovery requirements. Develop appropriate strategies for backup, restore & recovery procedures from provided scenarios. VIEW DETAILS $5,110.00 View the Product
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. VIEW DETAILS $8,946.00 View the Product
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. VIEW DETAILS $3,834.00 View the Product
12c: RAC Administration (RAC part2) Learn about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion. VIEW DETAILS $5,112.00 View the Product
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. VIEW DETAILS $5,112.00 View the Product
12c: Managing Multitenant Architecture NEW During this two day course, gain a conceptual understanding of the multitenant architecture. Learn how to manage an Oracle multitenant container database and any associated pluggable databases in an effective and efficient manner. VIEW DETAILS $2,556.00 View the Product
11g: SQL Tuning Workshop
Covers investigative methods that reveal varying levels of detail about how the Oracle database executes a SQL statement. Learn the different ways in which data can be accessed, which ones are most efficient under specific circumstances & how to ensure that the best method is used.
VIEW DETAILS $3,066.00 View the Product
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...

VIEW DETAILS $5,110.00 View the Product
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...
VIEW DETAILS $5,110.00 View the Product
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.
VIEW DETAILS $5,110.00 View the Product
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. VIEW DETAILS $5,110.00 View the Product
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.
VIEW DETAILS $6,132.00 View the Product
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. VIEW DETAILS $2,044.00 View the Product
Oracle VM Admin: OVM Server for x86 NEW This course teaches students how to build a virtualization platform using the Oracle VM Manager and Oracle VM Server for x86. Students learn how deploy and manage highly configurable, inter-connected virtual machines. The course teaches students how to install and configure Oracle VM Server for x86 as well as details of network and storage configuration, pool and repository creation, and virtual machine management. VIEW DETAILS $3,066.00 View the Product
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. VIEW DETAILS $3,066.00 View the Product
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.
VIEW DETAILS $2,044.00 View the Product
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.  VIEW DETAILS $5,110.00 View the Product
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. VIEW DETAILS $5,110.00 View the Product
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. VIEW DETAILS $2,044.00 View the Product
PL/SQL Fundamentals Discover the benefits of Oracle's powerful programming language, while learning real-world scenarios where these lessons can be applied. VIEW DETAILS $2,044.00 View the Product
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. VIEW DETAILS $4,088.00 View the Product
Oracle Database 12c: Backup and Recovery Workshop Learn how to evaluate your own recovery
requirements. You'll develop appropriate strategies for backup, restore and recovery procedures from provided
scenarios.
VIEW DETAILS $0.00 View the Product
12c: Introduction 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. VIEW DETAILS $2,044.00 View the Product
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
VIEW DETAILS $5,110.00 View the Product
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. VIEW DETAILS $5,110.00 View the Product
12c: Performance Management and Tuning NEW 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. VIEW DETAILS $5,110.00 View the Product
   
1
 
 
1