Oracle University

Make the Most of Your Oracle OpenWorld Conference Experience

Make the most of your Oracle OpenWorld conference experience with Oracle University. Oracle University takes place on Sunday, September 22, and offers several deep-dive training seminars that cover the most-popular Oracle technology topics. Don't miss this opportunity.

When and Where:

Sunday September 22, 2013, 9:00 a.m. to 4:00 p.m.

Golden Gate University
536 Mission Street
San Francisco, CA 94105

How Much:

$800 for a full day of training (price includes light refreshments and boxed lunch)

Application Development in the Oracle Cloud

In this course, students learn how to order, set up, and monitor trial and paid Oracle Cloud services. A case study is used to demonstrate how a typical organization can migrate its existing database and Java application development projects to an Oracle Cloud environment.

Instructor: Rick Green Read Full Bio

Rick Green is a senior principal curriculum developer in the Oracle Server Technologies curriculum group. Rick joined Oracle in 1997 to develop training materials for the express multidimensional OLAP database technology. Since then, he has focused on data warehousing and data integration tools such as the Warehouse Builder feature, Oracle Data Integrator, and Oracle GoldenGate. He is now writing courses for Oracle Cloud.

Target Audience: Cloud implementers, cloud administrators, cloud database developers, cloud Java developers

Course Objectives Details

  • Become familiar with the full range of Oracle Cloud service offerings
  • Understand how to order and administer an Oracle Cloud service
  • Understand how to develop applications in an Oracle Cloud environment

Course Topics Details

  • Determining whether a public, private, or hybrid cloud is right for you
  • Cloud advantages and challenges
  • Oracle’s comprehensive offerings for cloud users and cloud providers
  • Oracle’s software-as-a-service cloud offerings
  • Oracle’s platform-as-a-service cloud offerings
  • Oracle’s infrastructure-as-a-service cloud offerings
  • Oracle’s approach to security and scalability in a cloud
  • How Oracle helps organizations move to cloud computing
  • How to sign up for an Oracle Cloud service
  • Oracle Cloud training, documentation, and support services

Prerequisites: An interest in learning about cloud concepts and Oracle's implementation of cloud-based information technology.

Ask Tom Kyte Live: Five Things You Probably Didn’t Know and Should Know About SQL, PL/SQL, and Performance

You won’t want to miss this exclusive opportunity to get firsthand insight into key database administration and development topics with Tom Kyte. This session is presented in the same question-and-answer format as on the Website and will go in depth on features and capabilities that you might not know about but will benefit from learning.

Instructor: Tom Kyte Read Full Bio

Tom Kyte is a senior technical architect in Oracle’s Server Technology division. He currently works closely with the Oracle Database user community and is a regular speaker on Oracle programming and performance at conferences around the world. He is also the Tom behind the Ask Tom Website (, answering readers’ questions about Oracle Database and its tools. A well-known author, he has written many books on Oracle Database and its applications, including Expert Oracle Database Architecture, Expert One-on-One Oracle, Beginning Oracle Programming, and Effective Oracle by Design.

Target Audience: Database administrators and developers

Course Topics Details

  • Five things you probably didn't know about SQL
  • Five things you probably didn't know about PL/SQL
  • Five things you want to know about performance
  • Five things every developer (and DBA) needs to know
  • Five SQL and PL/SQL things in the latest generation of database technology

Certification Exam Cram: Upgrade Your DBA Certification to the Latest Release

Students gain a conceptual understanding of some of the new features available in the latest release of Oracle Database. This session is geared to help prepare students for the latest version of the Oracle Certified Professional Oracle Database Administrator certification exam.

Instructor: Dominique Jeunot Read Full Bio

Dominique Jeunot has worked at the Korean embassy in Morocco and as a teacher at the primary school and high school level. She then began a technology career, working for six years at HP as an analyst. She has been with Oracle for 19 years as a database administrator; an applications, training, and support analyst; and a curriculum developer.

Target Audience: Oracle Database administrators

Course Objectives Details

  • Learn about Oracle Multitenant’s architecture and management
  • Understand new security features
  • Discover recovery enhancements

Course Topics Details

  • Oracle Multitenant architecture and management
  • Heat map and automatic data optimization
  • Moving and datafiles while the database is online
  • In-database archiving and temporal validity
  • New auditing technology with unified audit
  • New administrative privileges to maintain separation of duties
  • Privilege analysis
  • Data redaction
  • Transporting data across platforms
  • Table recovery
  • SQL tuning improvement with adaptive execution plans, SQL plan directives, histogram, statistics, and dynamic sampling enhancements
  • Real-time and compare-period monitoring with the Automatic Database Diagnostic Monitor feature
  • Multiprocess/multithread applications
  • Multiple flash drives in the Automatic Database Diagnostic Monitor feature
  • Temporary undo
  • Table and index enhancements such as compression, multiple indexes on the same set of columns, and invisible columns
  • Oracle Data Pump new features such as fully transportable tablespaces
  • New partitioning features such as online move partition, interval reference partitioning, and partial indexes
  • Extended data types

Prerequisites: Oracle Certified Professional Certification for Oracle Database 11g.

Extending and Customizing Oracle Fusion Applications

In this course, students are introduced to several ways to customize and extend Oracle Fusion Applications, including in a software-as-a-service environment. Students also learn how to use and manage Oracle Metadata Services, which is the basis for managing Oracle Fusion Applications customizations. In addition students gain an understanding of Oracle ADF, which is the foundation for Oracle Fusion Applications.

Instructor: Gary Williams Read Full Bio

Gary Williams is a principal curriculum developer in the Tools division at Oracle. Gary joined Oracle in 1994 to deliver training in Oracle’s CASE tools, and eventually, Oracle Designer. Since then, he has focused on Oracle JDeveloper and Oracle Application Development Framework (Oracle ADF). He has delivered Oracle ADF training to many of the Oracle Fusion Applications development teams. He has also developed and delivered training on the customization of Oracle Fusion Applications.

Target Audience: Oracle Fusion Applications implementers and customizers

Course Objectives Details

  • Become familiar with Oracle Metadata Services
  • Become familiar with Oracle Application Development Framework
  • Understand how to use Oracle Composers in a SAAS environment
  • Understand how to customize Oracle Fusion Applications in an on-premises environment
  • Understand how to use Oracle JDeveloper to customize Oracle Fusion Applications

Course Topics Details

  • Understanding Oracle Metadata Services
  • Understanding Oracle Composer
  • Learning Oracle ADF fundamentals
  • Customizing Oracle Fusion Applications with Oracle JDeveloper
  • Integrating custom applications into Oracle Fusion Applications
  • Managing customizations

Prerequisites: An interest in customizing Oracle Fusion Applications in any environment.

Oracle Business Intelligence 11g: Analytics Overview

The course provides an overview of the key features and functions of Oracle Business Intelligence analyses, scorecards, and dashboards; Oracle Business Intelligence Delivers; Oracle Business Intelligence Server; and Oracle Business Intelligence Publisher. It provides instructions and demonstrations for using Oracle Business Intelligence analyses to build simple reports and analyze data, integrating reports into Oracle Business Intelligence Interactive Dashboards, and using Oracle Business Intelligence Delivers to deliver reports and alerts to other users. Students also get a high-level overview of Oracle Business Intelligence Server and its relationship to other components in the Oracle Business Intelligence Enterprise Edition architecture.

Instructor: Phil Scott Read Full Bio

Phil Scott has more than 10 years of experience as a technical trainer. He holds two master’s degrees, a Master of Science and a Master of Information Systems. As a senior principal instructor with Oracle University, Phil holds certifications as a Siebel 8.0 Certified Expert, and as a Siebel 7.7 Application Developer, Server Architect, and Data Warehouse Developer. In recent years he gained expertise in Oracle Business Intelligence and Oracle Data Integrator. He assisted in the development of numerous Oracle University classes, and helped train many new instructors. When he is not working he enjoys flying small airplanes, working on old cars, biking, and skiing.

Target Audience: Application developers, business analysts, business intelligence developers, data modelers, data warehouse administrators, data warehouse analysts, data warehouse developers, report developers, and business users

Course Objectives Details

  • Create, view, modify, and save an interactive dashboard
  • Define and describe business intelligence
  • Define and describe some key components of Oracle Business Intelligence Enterprise Edition
  • Learn the capabilities of Oracle Business Intelligence analyses that enable users to perform ad hoc queries and analyze business data
  • Learn about the role of Oracle Business Intelligence Delivers as an integrated component of Oracle Business Intelligence Enterprise Edition
  • Learn about the role of Oracle Business Intelligence Interactive Dashboards as an integrated component of the Oracle Business Intelligence Enterprise Edition
  • Become familiar with some key components of the Oracle Business Intelligence Enterprise Edition architecture
  • Become familiar with the relationship between Oracle Business Intelligence Enterprise Edition architecture components and the objects and data displayed in Oracle Business Intelligence user interfaces
  • Become familiar with the three layers of an Oracle Business Intelligence repository, and how the layers relate to each other
  • Use Oracle Business Intelligence analyses to create, view, modify, and save requests
  • Use Oracle Business Intelligence Delivers to create, modify, save agents
  • Use the drilling, graphing, and filtering features of Oracle Business Intelligence analyses to analyze data
  • Understand the role of Oracle Business Intelligence Answers as an integrated component of Oracle Business Intelligence Enterprise Edition
  • Use Oracle Business Intelligence Publisher as a reporting tool

Course Topics Details

  • Creating requests, displaying and modifying request results, displaying different types of views, modifying request criteria columns, and using filters in requests in Oracle Business Intelligence analyses
  • Using dashboards, adding contents to dashboards, modifying dashboard properties, and creating dashboard prompts in Oracle Business Intelligence Interactive Dashboards
  • Creating and delivering agents and accessing alerts in Oracle Business Intelligence Delivers
  • Understanding Oracle Business Intelligence’s component architecture, presentation services, and catalog, BI repository, BI administration tool, and BI scheduler in Oracle Business Intelligence Server
    Creating data models, using the Create Report wizard, scheduling report jobs, and publishing reports in BI dashboards in Oracle Business Intelligence Publisher

Suggested Prerequisites Details

  • Basic SQL
  • Data warehouse design
  • Database design
  • Dimensional modeling

Oracle Big Data Essentials

This course provides an overview of big data, the technologies used to process it, and the role of Oracle Big Data in handling it. Students learn how to acquire the raw data from a variety of sources, and how to use Oracle NoSQL Database and HDFS to store the data. The session also covers how to use Oracle Big Data Connectors to move data to and from Oracle Exadata and organize it using external tables and data pumps. The course includes how to use Oracle Data Integrator Application Adapter for Data Integration to integrate big data with other external data sources. Students explore the wide range of analysis options available in Oracle Advanced Analytics and Oracle R Enterprise, and learn how to choose the best analytic tool based for a given scenario.

Instructor: Sharon Sophia Stephen Read Full Bio

Sharon Sophia Stephen is a senior curriculum developer with Oracle University's Server Technologies curriculum group, and she has more than six years of experience in development and education. She is an active member of the All India Oracle Users Group (AIOUG), and taught sessions on Oracle Big Data, SQL tuning, and Oracle SQL Developer during the 2012 AIOUG SANGAM conference and Oracle Technology Network’s 2013 Yathra event. She is an Oracle Certified Associate and is also certified in various IBM technologies. She has been involved in Oracle University’s big data curriculum, and has authored materials on SQL, Oracle Big Data, and Oracle NoSQL Database. Her areas of interest include PL/SQL programming, database tuning, and big data research.

Target Audience: Database administrators, big data sales consultants, business analysts, Hadoop/big data/Oracle Exadata administrators

Course Objectives Details

  • Learn to use Oracle Big Data
  • Understand the advanced big data analytics options offered by Oracle Big Data

Course Topics Details

  • Oracle Big Data Adaptation
  • Phases of Oracle Big Data
  • Use cases to explain the challenge and solution
  • Extracting and processing the logs using HDFS and Hive
  • Using Oracle Big Data Connectors
  • Using Oracle NoSQL Database and Hadoop
  • Connecting Oracle NoSQL Database and RDBMS
  • Integrating Oracle Big Data Connectors with an existing warehouse
  • Discovering data using Oracle Endeca
  • Projecting facts and results using Oracle Business Intelligence Enterprise Edition dashboard
  • Case study: Simulating the big data application

Pre-requisites: Basic knowledge of the Hadoop framework, Oracle Database, Java, and the R language.

Oracle Cloud Application Foundation: Best Practices and New Features

Oracle Cloud Application Foundation includes Oracle WebLogic Server and Oracle Coherence, and provides a reliable, flexible, and scalable platform for hosting Java applications and services. These solutions are also optimized for Oracle Exalogic Elastic Cloud, which provides not only extreme consolidation and performance but also the benefits of infrastructure as a service. This session covers the latest best practices for implementing a cloud with these solutions. Students learn about the latest new features in Oracle WebLogic Server 12c, Oracle Coherence 12c, and Oracle Exalogic Elastic Cloud.

Target Audience: Data center administrators, system administrators, Java developers, enterprise architects

Instructor: TJ Palazzolo Read Full Bio

TJ Palazzolo is a senior principal curriculum developer in the Oracle Fusion Middleware group. For the last 12 years, he's developed and delivered training on a variety of Java middleware products and technologies, geared toward application developers and system administrators. He's the author of Oracle Exalogic Elastic Cloud Handbook and is a regular presenter at several conferences. TJ currently serves as the lead developer for the Oracle WebLogic Server, Oracle Exalogic, and Oracle Virtual Assembly Builder learning paths. In addition to his curriculum duties, he helps configure, maintain, and troubleshoot Oracle University's Oracle Exalogic machines. TJ is based out of his home in North Carolina and in his spare time plays hockey and enjoys volunteering.

Course Objectives Details

  • Understand Oracle Cloud Application Foundation’s architecture
  • Learn several best practices for an Oracle Exalogic implementation
  • Use the IaaS capabilities of Oracle Exalogic Elastic Cloud
  • Understand the best practices for using Oracle WebLogic Server and Oracle Coherence in the cloud
  • Use the latest features in Oracle WebLogic Server and Oracle Coherence 12c

Course Topics Details

  • Oracle Cloud Application Foundation recommended topology
  • Oracle Exalogic hardware and software architecture
  • Creating and managing vServers
  • Oracle Exalogic storage and networking best practices
  • Oracle Exalogic new features
  • Installation, patching, and upgrading overview
  • Node manager deployment options
  • Server templates
  • Dynamic clusters
  • Startup groups
  • Targeting JMS to an entire cluster
  • Oracle WebLogic best practices and optimizations
  • Oracle WebLogic container for Oracle Coherence
  • Configuring and managing Oracle Coherence in an Oracle WebLogic domain
  • Live event model
  • Oracle Coherence grid archives, best practices, and optimizations

Pre-requisites: Working knowledge of Oracle WebLogic Server and/or Oracle Coherence 11g.

Oracle Multitenant Architecture Overview

Students get an overview Oracle Multitenant’s architecture, including a conceptual overview of the structure. Students also learn how to manage a multitenant container and its associated pluggable databases in an effective and efficient manner.

Target Audience
Oracle Database administrators

Instructor: Jean-Francois Verrier Read Full Bio

After earning his doctorate in Mathematics and Computer Science, Jean-Francois Verrier worked at Steria as a consultant for two years. In 1994, he joined Oracle as a consultant, and later became a trainer in the Server Technologies curriculum. He developed a variety of courses focused on new features and Oracle Real Application Clusters before moving on to manage the Oracle Database and Oracle Enterprise Manager team inside Server Technologies curriculum.

Course Objectives Details

  • Understand the Oracle Multitenant architecture
  • Create and manage Oracle Multitenant container databases and pluggable databases
  • Manage storage and security within container databases and pluggable databases
  • Monitor performance and manage resources within container databases and pluggable databases
  • Perform backup, recovery, and flashback operations on container databases and pluggable databases
  • Manage a container database and a pluggable database in specific configurations
  • Perform particular operations including Oracle Data Pump transportation, loading, encryption, and auditing

Course Topics Details

  • Container database and pluggable database architecture
  • Provisioning pluggable databases
  • Using Oracle Database Oracle Database Configuration Assistant, Oracle Enterprise Manager, SQL*Plus, and Oracle SQL Developer
  • Configuring and creating a container database
  • Creating, dropping, and migrating pluggable databases
  • Managing container databases and pluggable databases
  • Managing pluggable databases’ open mode and settings
  • Configuring container databases and pluggable databases’ initialization parameters
  • Managing permanent and temporary tablespaces in container databases and pluggable databases
  • Managing common and local users, privileges, and roles
  • Understanding shared and nonshared objects
  • Managing common and local profiles
  • Managing backups and recovery operations
  • Managing Oracle Flashback
  • Duplicating and validating pluggable databases
  • Managing performance and resource allocation
  • Maximizing consolidated database replay
  • Exporting and importing data, and loading data
  • Auditing operations and scheduling jobs

Prerequisites: Knowledge of Oracle Database 11g is required.

Oracle Enterprise Manager Cloud Control 12c High-Availability Deployments

This course details the deployment options of Oracle Enterprise Manager Cloud Control 12c that maximize its availability and scalability and ensure full recovery from failure. Topics include the recommended Oracle Real Application Clusters repository configuration, multiple management services setup with a load balancer, deploying management agents, configuring security, command line operations, and recovery techniques. The configuration concepts are paired with demos and provide an end-to-end overview of how to build a high-availability Oracle Enterprise Manager Cloud Control 12c system.

Instructor: Daniela Hansell Read Full Bio

Daniela Hansell joined Oracle in 1994 and has worked in product support, development, and database manageability product management. She is currently responsible for developing courseware for Oracle Enterprise Manager and Oracle Database.

Target Audience: Oracle Enterprise Manager Cloud Control 12c administrators

Course Objectives Details

  • Understand how to deploy Oracle Enterprise Manager for high availability and scalability
  • Learn to configure Oracle Management Services in a variety of deployments
  • Learn to configure a load balancer within the Oracle Enterprise Manager framework
  • Optimize the use of My Oracle Support
  • Implement Oracle Enterprise Manager framework security options
  • Understand techniques for disaster recovery of Oracle Enterprise Manager in an high availability environment
  • Understand silent and command line Oracle Enterprise Manager operations

Course Topics Details

  • Oracle Enterprise Manager best practices, including deployment with a two-node Oracle RAC repository and software library configuration
  • Load Balancer Setup
  • Oracle Management Services deployment and configuration
  • Plug-ins and self-update configuration
  • Oracle Enterprise Manager security
  • Oracle Enterprise Manager recovery techniques

Prerequisites: Knowledge of Oracle Enterprise Manager Cloud Control 12c is required.

Oracle Identity Governance Suite: Installation, Configuration, and Integration

In this course, you learn how to install, configure, and launch two Oracle Identity Governance products: Oracle Identity Manager and the Privileged Account Manager. Next, you learn about some of the key functionalities of Oracle Identity Manager. This includes importing and using Oracle Identity Manager connectors, working with provisioning workflows to provision users to a resource, provisioning users through request-level and operation-level approval workflows, and reconciling user data between Oracle Identity Manager and an external resource. You also learn how to implement self-service workflows in Oracle Privileged Account Manager. Lastly, you see how Oracle Identity Manager and Privileged Account Manager work together as part of an integrated solution.

Instructor: Robert La Vallie Read Full Bio

Robert La Vallie is a senior principal curriculum developer in the Oracle Fusion Middleware area of the Server Technologies curriculum. He has more than 10 years experience developing instructor-led training courses, e-studies, and Oracle-by-Example tutorials for Oracle's identity governance, access management, and directory services products. Robert has created training materials for Oracle Identity Manager, Oracle Identity Analytics, Oracle Privileged Account Manager, and Oracle Virtual Directory, as well as an e-study program that provides an overview of Oracle's identity and access management products. He currently serves as lead curriculum developer for the Oracle Identity Governance 11g R2 PS1: Privileged Accounts Management course. He is based out of the Oracle office in Stamford, Connecticut.

Target Audience: Database administrators, technical administrators, system administrators, product administrators

Course Objectives Details

  • Install, configure, and launch Oracle Identity Manager and Oracle Privileged Account Manager
  • Import and use predefined Oracle Identity Manager connectors to provision users to a resource
  • Incorporate request-level and operation-level approval workflows into a provisioning workflow
  • Reconcile user data between Oracle Identity Manager and a trusted external resource
  • Implement self-service workflows in Privileged Account Manager
  • Integrate Oracle Identity Manager and Privileged Account Manager

Prerequisites Details

  • A general comprehension of Oracle WebLogic Server 11g and Oracle Database 11g
  • A high-level understanding of service-oriented architecture, BPEL, and Oracle JDeveloper
  • A good familiarity with Linux-based environments
  • A general comprehension of LDAP concepts

Oracle Database Machine One-Day Overview

In this course students learn about the various Oracle Exadata Database Machine features and configurations, with emphasis on the unique capabilities delivered by Oracle Exadata Storage Server. The installation and initial configuration process is covered so that students are able to make appropriate up-front configuration decisions. Students are introduced to various options for migrating to Oracle Database Machine as well as learning how to maintain, monitor, and optimize Oracle Database Machine after initial configuration.

Topics covered include monitoring Oracle Exadata Database Machine, with a focus on best practices for what and how to monitor. Students also learn about the monitoring infrastructure within Oracle Exadata Database Machine, along with the monitoring capabilities exposed through Oracle Enterprise Manager Cloud Control 12c.

Best practice recommendations are highlighted throughout.

In addition, after a brief overview of the Oracle Enterprise Manager Cloud Control 12c database-as-a-service (DBaaS) private cloud, students explore how DBaaS implemented on an Oracle Exadata Database Machine provides a level of service and capability that were hitherto unachievable for end users. This is made possible through the use of the self-service portal within Oracle Enterprise Manager Cloud Control 12c and by maximizing Oracle Exadata Database Machine technology.

Instructor: Sean Kim Read Full Bio

Sean Kim has more than 15 years of experience as an IT professional with Oracle technology, and he has been an instructor at Oracle University since 2005. As a senior principal instructor with Oracle University, he has delivered training on database administration, data warehousing, operating systems, and server and storage systems. He has also assisted in the development of Oracle Certification exams, and the development of new Oracle courses as a member of the technical panel, lead instructor, and lead curriculum developer. In his spare time, he enjoys scuba diving, open water swimming, and watching movies with his wife.

Target Audience: Oracle Exadata administrators

Course Objectives Details

  • Understand the key capabilities of Oracle Exadata Database Machine
  • Identify the benefits of using Oracle Exadata Database Machine for different application classes
  • Understand the architecture of Oracle Exadata Database Machine and its integration with Oracle Database, Oracle Clusterware, and Oracle Automatic Storage Management
  • Complete the initial configuration of Oracle Exadata Database Machine
  • Understand various recommended approaches for migrating to Oracle Exadata Database Machine
  • Configure I/O resource management
  • Monitor Oracle Exadata Database Machine health and optimize performance

Course Topics Details

  • Oracle Exadata Database Machine architecture
  • Key capabilities of Oracle Exadata Database Machine
  • Oracle Exadata Database Machine initial configuration
  • Oracle Exadata Storage Server configuration
  • I/O resource management
  • Recommendations for optimizing database performance
  • Using the Exadata Smart Scan feature
  • Consolidation options and recommendations
  • Migrating databases to Oracle Exadata Database Machine
  • Bulk data loading using the Database File System feature
  • Introduction to Oracle Exadata Database Machine platform monitoring
  • Configuring Oracle Enterprise Manager Cloud Control 12c to monitor Oracle Exadata Database Machine
  • Monitoring Oracle Exadata Database Machine
  • Other useful monitoring tools
  • Backup and recovery
  • Oracle Exadata Database Machine maintenance tasks
  • Patching Oracle Exadata Database Machine
  • Oracle Exadata Database Machine automated support ecosystem
  • Database as a service on Oracle Exadata anatomy
Oracle Conferences
Register For Oracle OpenWorld 2013
Sponsor Opportunities