Home Page > Education

Oracle Course Categories                

Developer - PL/SQL, SQL, APEX by Category
All Oracle University SQL & PL/SQL, APEX, Java/J2EE & XML courses are delivered at Deloitte NZ. Important towards OCA/OCP Developer certifications.  If the course you need is not showing Please enquire - Course Enquiry
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: Program with PL/SQL Learn PL/SQL & understand the benefits of this powerful programming language. Create PL/SQL blocks of application code that can be shared by multiple forms, reports, & data management applications. VIEW DETAILS $5,110.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
Develop PL/SQL Program Units Designed for Developers with basic PL/SQL & SQL language skills. Develop, execute & manage PL/SQL stored program units, which include: procedures, functions, packages & database triggers. VIEW DETAILS $3,066.00 View the Product
12c: Advanced PL/SQL
Learn how to use the advanced features of PL/SQL to design and tune PL/SQL to interface with the database and other applications. Explore advanced features of program design, packages, cursors, extended interface methods and collections. 
VIEW DETAILS $3,066.00 View the Product
12c: SQL Tuning for Developers In the Oracle Database: SQL Tuning for Developers course, 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. VIEW DETAILS $3,066.00 View the Product
Application Express Workshop I In the Oracle Application Express Workshop I, discover how to develop database-centric web applications quickly using Oracle Application Express. Learn from expert Oracle University instructors through interactive learning, which includes hands-on exercises. VIEW DETAILS $5,110.00 View the Product
Application Express Workshop II NEW This Oracle Application Express Workshop II will help you extend your skills with Oracle Application Express. Learn to extend your applications using collections, dynamic applications and plug-ins. VIEW DETAILS $3,066.00 View the Product
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. 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
SQL Tuning for Developers Workshop NEW In this application development-centric course, students learn about Oracle SQL statement tuning and how to write well-tuned SQL statements appropriate for the Oracle database. VIEW DETAILS $3,066.00 View the Product
Oracle Data Integrator (ODI) 12c: New Features This ODI workshop details the new features and techniques of using 12c ODI for implementing high-performance movement. VIEW DETAILS $1,278.00 View the Product
BI Publisher 11g: Fundamentals Oracle's strategic enterprise reporting & publishing solution enables you to extract data from multiple data sources, create layouts for report data, & publish the highly formatted reports to a wide range of destinations. VIEW DETAILS $3,834.00 View the Product
Application Express: Administration Ed2 Learn the different ways in which ApEx can be installed & will perform a full dev environment installation on a multitenant architecture of Database 12c. Identify the 3 options of configuring a web server for ApEx & install & configure the Oracle REST Data Service VIEW DETAILS $2,044.00 View the Product
Using Java - for PL/SQL and Database Developers You'll be taught about Oracle Database programming. Use Java with examples and explanations of its appropriate use. Learn to access Oracle Database using JDBC, UCP, Java stored procedures & SQLJ technologies. Discover the benefits of accessing & manipulating SQL data using JDBC & SQLJ technologies VIEW DETAILS $2,044.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