Stay linked in with us:
Get to know us
What we stand for
Our Leadership Position
Our Management team and Values
The Customer Experience
What we do
BI and EPM Services
BI Centre of Excellence
Business Process Management
Application Management and Support
Database Management and Support
AsparonaCloud Service Solutions
Credit Card Processing
Who we've helped
Want to join?
JD Edwards ERP Solution Architect, Auckland / Wellington
Oracle Cloud ERP Applications Lead- Auckland
Intrastructure Technical Consultant (Oracle & DevOps), Auckland/ Wellington
Oracle Fusion Middleware Senior Technical Consultant (Oracle Identity Management)
Oracle Fusion Middleware Development Senior Technical Consultant (BPM, SOA), Wellington
*NEW* Oracle Learning Streams
Courses by Date
Courses by Category
Oracle SQL & Database
Advanced Oracle Database
Developer - PL/SQL, SQL, APEX
Oracle BI, ODI & Data Warehousing
Linux, Solaris & SUN
Exadata / Exalogic / Exalytics
Middleware / SOA
Oracle e-business suite
PeopleSoft / UPK
Hyperion / Siebel / Policy Automation
WebCenter / Content Management
Endeca / Right Now
Training on Demand (TOD) - not...
ALL Courses by name - & not really...
Courses by Location
Courses by Keyword
Training room hire - update
Education - terms and conditions
Oracle Course Categories
Developer - PL/SQL, SQL, APEX
All Oracle University SQL & PL/SQL, APEX, Java/J2EE & XML courses are delivered at Asparona. Important towards OCA/OCP Developer certifications. If the course you need is not showing Please enquire -
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.
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.
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.
Discover the benefits of Oracle's powerful programming language, while learning real-world scenarios where these lessons can be applied.
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.
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.
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.
Application Express Workshop I NEW
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.
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.
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
& install & configure the Oracle REST Data Service
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: 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.
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.
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.
11g: SQL and PL/SQL New Features
Students learn new features of SQL and PL/SQL in Oracle Database 11g. This course introduces you to the SQL Developer tool, using which you learn various enhancements in language functionality and triggers.
Oracle Data Integrator 12c: New Features NEW
This Oracle Data Integrator workshop details the new features and techniques of using Oracle Data Integrator 12c (ODI) for implementing high-performance movement.
Oracle Data Integrator (ODI) 11g: Integration & Admin
A comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services...
Oracle Data Integrator (ODI) 11g: Advanced Integration & Dev.
Covers advanced techniques for using Oracle Data Integrator 11g (ODI). Learn to implement high-performance movement & transformation of data among various platforms.
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.
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. L
earn to access Oracle Database using JDBC, UCP, Java stored procedures & SQLJ technologies. Discover the benefits of accessing & manipulating SQL data using JDBC & SQLJ technologies
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.
© 2017 Asparona
Website by Solutionists™