Oracle University at Oracle OpenWorld 2011

Oracle and Exadata. The Perfect Fit!

Instructor: Eric Siglin

Bio: Eric Siglin is a Senior Principal Instructor for Oracle University. He brings with him over 25 years of IT experience with 18 years as an Oracle Database Administrator working with every version of Oracle from 6.0 through and including 11g Release 2 on Unix, Linux and Windows. Eric is the Lead Instructor for the Sun Oracle Exadata Database Machine Workshop and Seminar, Oracle Database 11g New Features for Administrators, Oracle GoldenGate Fundamentals of Transactional Data Management, Database Vault, Audit Vault, Administering Clusterware, Administering ASM and Information Lifecycle Management. He also teaches Oracle University's most technical course such as Exadata Storage, Sun Oracle Exadata Database Machine Administration, Real Application Clusters, Oracle GoldenGate, Data Guard, Streams, Solaris and Enterprise Linux.

Course Description:
Oracle Exadata Storage Server is a storage server that is highly optimized for use with Oracle Database. Exadata delivers outstanding I/O and SQL processing performance for data warehousing and online transaction processing (OLTP) applications. Coupled with the Oracle Database, it provides a perfect combination of software and hardware. Learn how in this new course presented by Oracle University.

Target Audience:

• System Administrators, Storage Administrators, Database Administrators

Course Objectives:

• Describe Exadata and how it differs from traditional database storage
• List the key capabilities and features of Exadata and DBM
• Configure DBM
• Implement Exadata security
• Maintain DBM and perform various maintenance tasks
• Monitor DBM using alerts, thresholds, metrics, current activities, SQL plans, V$ views and database statistics

Course Topics:

• Database Machine Overview and Architecture Options
• Database Machine Capacity & Database Machine Performance
• InfiniBand Network Architecture
• X2-2 Leaf Switch Topology & Full Rack Spine and Leaf Topology
• Scale Performance and Capacity & Scaling Out to Multiple Full Racks
• Exadata Overview and Introduction
• Exadata Storage Deployment & Exadata Implementation Architecture Overview
• Classic Database I/O and SQL Processing Model
• Exadata Smart Scan Model & Exadata Smart Storage Capabilities
• Exadata Hybrid Columnar Compression Architecture Overview, Exadata Smart Flash Cache & Exadata Storage Index Exadata Architecture
• Exadata Software Architecture Overview
• Exadata Smart Flash Cache Architecture
• Exadata Monitoring Architecture
• Disk Storage Entities and Relationships
• Flash Storage Entities and Relationships
• Disk Group Configuration
• Migrating Databases to Database Machine
• Performing Capacity Planning
• Post-Migration Best Practices Bulk Data Loading with Database Machine
• Backup and Recovery with Database Machine
• Using RMAN with Database Machine
• Disk Based Backup Strategy
• Tape Based Backup Strategy & Tape Based Backup Configuration
• Hybrid Backup Strategy

Pre-requisites:

• Oracle Grid Infrastructure 11g: Manage Clusterware and ASM Release 2
• Oracle Enterprise Linux: System Administration
• System and Storage Administration Concepts
• Networking (inc. Infiniband)
• Oracle Database 11g: Administration Workshop I DBA Release 2

OpenWorld Certification Exam Cram: Oracle Database 11g: New Features for Administrators

Instructor: Jerry Lee

Bio: Jerry Lee is an Oracle Certified Master (OCM) and holds a Master Degree in Mechanical Engineering from the University of Washington in Seattle. As a Senior Principal Instructor with Oracle University, Jerry has expertise in Database High Availability areas such as Backup/Recovery, Automatic Storage Management (ASM), Real Application Cluster (RAC), Streams, Data Guard, and Exadata Database Machine. He has been recognized as a Tau Beta Pai Engineering Honor Society Member and has received numerous awards for excellence in instruction to include being a three time recipient of the Oracle University Leadership Circle.

Course Description:
Join the experts at Oracle University for the OpenWorld ExamCram to sharpen your skills and gain knowledge. This year's ExamCram is "Oracle Database 11g: New Features for Administrators." which will help you start your Oracle DBA Certified Professional upgrade to 11g.

 

Target Audience:

• Database Administrators
• Data Warehouse Administrator
• Technical Consultant
• Sales Consultants
• Support Engineer

Course Objectives:

• Install Oracle Grid Infrastructure

Course Topics:

• Oracle Grid Infrastructure
• Installation and Upgrade Enhancements
• Oracle Restart
• ASM Enhancements
• Storage Enhancements
• Data Warehouse and Partitioning Enhancements
• Oracle SecureFiles
• Security and Networking Enhancements
• SQL Performance Analyzer
• SQL Plan Management
• Database Replay
• Automatic SQL Tuning
• Intelligent Infrastructure Enhancements
• Diagnosability Enhancements
• SQL Monitoring
• Performance Enhancements
• Application Maintenance and Upgrade Enhancements
• Backup and Recovery Enhancements
• Flashback Technology, LogMiner, and Data Pump
• Data Recovery Advisor

Pre-requisites:

• Working knowledge of Oracle Database 10g

Oracle Exalogic Elastic Cloud Overview

Instructor: Kevin Tate

Bio: Kevin Tate holds a Bachelor of Computer Science degree and is a Senior Instructor with Oracle University. Kevin has expertise in various programming languages such as Java technologies C/C++, Middleware technologies including WebLogic Server and Tuxedo. Kevin has also designed, architected and tuned many Java and C/C++ applications for various companies. Kevin has over 17 years of experience in the IT industry.

Course Description:
Today's data centers often suffer from complexity, inadequate security, poor or inconsistent performance, and high labor costs. Additionally, years of expansion or acquisition coupled with the lack of a consistent infrastructure can hinder your ability to scale your data center to meet future demands. This course introduces data center and network administrators to Oracle's Exalogic Elastic Cloud solution, which is designed to help standardize and consolidate your infrastructure and also greatly increase application performance. Students first learn how to identify and perform basic administrative tasks on Exalogic's hardware components, including servers, switches and storage. Then they focus on optimizing Oracle software to best take advantage of this hardware configuration, including the InfiniBand fabric.

Target Audience:

• Data Center Specialists and Managers
• Unix/Linux Administrators
• Network Engineers
• Capacity Planning Engineers
• Middleware Architects

Course Objectives:

• Elastic Cloud Overview
• Compute Node Overview
• Storage Appliance Overview
• Infiniband Switches and Gateways
• Host Channel Adapter
• Management Switch
• Power Distribution Units
• Integrated Lights Out Manager (ILOM)
• Enable Fusion Middleware Components to utilize Infiniband private network

Course Topics:

• Describe Elastic Cloud 40 Gb Infiniband Fabric
• Architectural design and hardware specifics for compute node, storage nodes, gateways and switches.
• Describe quarter, half and full rack configuration design and technical specifications.
• Using the Subnet Manager for various rack configurations.
• Describe spine and leaf switches for support of interconnecting multi-rack configurations.
• Enablement of Sockets Direct Protocol (SDP) for Fusion Middleware product support.
• ILOM for management of the hardware components.

Pre-requisites:

• None

Making the Most of Oracle User Productivity Kit (UPK)

Instructor: Barbara Daggett

Bio: Barb Daggett is an Oracle University Senior Instructor with four years of experience with UPK and seven years of experience with Oracle PeopleSoft. Her expertise includes Human Resource, Benefits, Payroll, and Timekeeping systems. She has over fifteen years of training experience with a prior IT background.

Barbara has also served as a business analyst and consultant. Her industry experience has spanned several generations of computer hardware and software from mainframe to PCs. Her human resource systems work has included functional requirement definition, fit/gap analysis, data mapping, and testing and troubleshooting.

Course Description:
UPK is an Oracle tool used to produce documentation and training material. In this one-day course, you will learn how to build an outline that enables your user to navigation through their training material. You will learn how to prepare and record content in your target application and customize the recorded content that will be incorporated in the outline. You will learn how to develop glossary terms and roles to help document filtering. To further enhance your content you will discover how to import external files or (change to "and") creating web pages with text, graphic, and images that link to outlines and recorded content. Content is previewed by the authors of UPK and then published to make content available to the users through a player or printed documentation. The player has many playback modes that will be reviewed during this course and well as reviewing different types of printed documentation. Published output to meet you organization unique styles will be addressed in this course as well as the UPK infrastructure and content permission.

Target Audience:
Authors, editors, and other individuals (end users, Functional Implementers, Project Managers) in need of recording and editing content in the User Productivity Kit Developer.

Course Content:

• Understanding UPK Developer
• Building content
• Recording and editing topics
• Previewing content
• Link existing content to an outline
• Creating web pages and packages
• Link web pages and files to outlines
• Mult-User environment - Check-in/check-out documents
• Customizing published content
• Publishing content, including printable documents

Course Topics:

• Create and manage library folders
• Build content outlines using modules, sections, and topics
• Record and edit content
• Preview topics in See It!, Try It!, Know It?, and Do It! modes and in document format
• Link existing content to an outline
• Check-in/check-out documents on the server
• Customize the logo and templates for print and Player deployments
• Publish content, including printable documentation

Pre-requisites:

• Participants should have a basic knowledge of Windows Basic and knowledge for working with publishing documents.

Oracle WebLogic Server 11g: Administration Essentials

Instructor: Bill Albert

Bio: Bill Albert has over 35 years of experience in the IT industry, and, most recently, as an instructor for Oracle University, BEA Systems, and The Object People. He holds a degree in Computer Science and an advanced graduate degree in Operations Research. As a Senior Principal Instructor with Oracle University, Bill has expertise in object-oriented technologies including Smalltalk, Java, JEE, Web services, SOA, WebLogic Application Server, Oracle Identity Manager, and Oracle Coherence. He has helped in the design and implementation of Web and EJB applications. Bill has been elected to Leadership Circle at Oracle University and the SOA Practice at BEA Systems.

Course Description:
The Oracle WebLogic 11g application server product line is the industry's most comprehensive Java platform for developing, deploying, and integrating enterprise applications. This Overview seminar discusses techniques for installing and configuring Oracle WebLogic Server 11g and outlines steps to deploy Java EE applications to Oracle WebLogic Server 11g using the Administration Console and command-line and scripting tools such as WLST.

Target Audience:

• Web Administrator
• Java EE Developer
• Sales Consultants
• J2EE Developer

Course Objectives:

• Backup and recover from various failures
• Monitor application server using GUI and command-line tools such as automation scripts
• Describe the architecture of WebLogic Server including domains, servers and machines
• Install, configure and use WebLogic Server
• Perform routine Oracle WebLogic Server administration functions
• Set up a cluster of servers and distribute applications and resources to the cluster
• Configure Oracle HTTP Server as the Web-tier front end for Oracle WebLogic Server instances and clusters
• Deploy different types of Java EE applications to Oracle WebLogic Server
• Deploy and manage large-scale Java EE applications to servers or clusters through the entire development and production lifecycle
• Configure basic resource and application security

Course Topics:

• Introduction to Oracle Fusion Middleware
• Installing Oracle WebLogic Server Components
• Introduction to Administration Console and other Administration Tools
• Configuring a WebLogic Server Domain
• Managing and Using Logging in Oracle WebLogic Server
• Deploying Applications
• Setting Up Data Sources
• Configuring JMS Applications
• Configuring Basic Security for Oracle WLS Resources and Applications
• Configuring Oracle HTTP Server as Front End for Oracle WebLogic Server
• Configuring Oracle WebLogic Cluster

Pre-requisites:

• Basic TCP/IP networking knowledge of client/server concepts
• Basic Linux commands and desktop navigation

Oracle Business Intelligence 11g: Overview to Analyses and Dashboards

Instructor: Steve Wright

Bio: Steve Wright started out as a Siebel CRM/BI consultant with Siebel and then moved into the Education arena. He has over 14 years of combined consulting and delivery experience. He brings real world examples and scenarios to his training courses. He is now a Senior Practice Manager within Oracle University, where he continues to teach and also mange the Siebel and BI lines of business. He originates from the UK, and has been here in the US for the last 6 years.

Course Description:
The aim of this one day seminar is to give the students an overview of the new version of Business Intelligence, version 11g. It will guide them through the basics of the new look and feel user interface. Then get them familiar with creating a basic Analysis and embedding it into a Dashboard. Showing them the methods and techniques involved with creating simple, but effective data and representing it in a readable manner. Also it will cover the use of the Dashboard and how to embed content into this. Students will then be aware of the basics of BI and then will be keen to learn more of the specifics and get in-depth with the available ILT and LVC classes.

Target Audience:

• Business Intelligence beginners

Course Objectives:

• To provide an overview of the new 11g BI product.

Course Topics:

• Introduction to Oracle Business Intelligence Enterprise Edition;
• Working with Oracle Business Intelligence Analyses;
• Limiting and Grouping Data in Analyses;
• Working with Views and Graphs in Analyses;
• Creating Oracle Business Intelligence Dashboards.

Pre-requisites:

• None

Oracle SOA Suite 11g: Administration

Instructor: J. David Mills

Bio: David is one of our more experienced instructors having worked in technical education since December 1999, and is now a member of the Oracle University instructor staff. He has over 26 years of software engineering experience to include software development, design and architecture, project management, and consulting. He has also been instrumental with designing and developing some of our more advanced courseware offerings. David earned a B.S. in Computer Science from Colorado Technical University in 1998, and is currently working on his M.S. in Computer Science at the University of South Florida. He provides mentoring and classroom instruction for many of the Oracle Fusion Middleware products to include Oracle SOA Suite, Oracle WebLogic Server, Oracle Tuxedo, Oracle Service Bus, Oracle Enterprise Repository, as well as all of our SOA curriculum. He currently resides in Tampa, Florida with his wife, Linda.

Course Description:
The Oracle SOA Suite 11g: Administration seminar describes how Oracle SOA Suite 11g, a Middleware component of Oracle Fusion Middleware, provides a complete set of service infrastructure components (such as Mediator, BPEL, Human Workflow, Business Rules, and Business Process Management) for designing, deploying, and managing SOA composite applications. The participant is therefore required to have knowledge about essential Oracle WebLogic Server administration tasks. They learn how to install and configure Oracle SOA Suite 11g components in Oracle WebLogic Server domains. They learn to use the Oracle Enterprise Manager Fusion Middleware Control Console as well as scripting tools to perform administrative tasks such as deploying SOA composite applications, configuring SOA composite application resources, monitoring SOA composite applications, managing and monitoring service engines, and updating the state of SOA composite applications. In addition, they are given a brief introduction to tuning and configuring Oracle SOA Suite 11g environment for high availability.

Target Audience:

• SOA Architect
• Security Administrators
• Technical Administrator
• System Administrator
• System Integrator
• Administrator

Course Objectives:

• Describe the Oracle SOA Suite 11g Architecture
• Discuss Service Component Architecture (SCA)
• Discuss Service Oriented Architecture (SOA) concepts
• Install Oracle SOA Suite 11g
• Deploy SOA Composite Applications
• Overview of high availability with Oracle SOA Suite 11g
• Configure Security Policies for SOA Composite applications
• Configure and Administer Oracle SOA Suite 11g and its components
• Monitor, troubleshoot, and tune Oracle SOA Suite 11g components

Course Topics:

• Introducing SOA and Oracle SOA Suite 11g
• Installing Oracle SOA Suite 11gSOA
• Managing SOA Composite Applications
• Administering the SOA Infrastructure
• Administering Oracle JCA Adapters and Binding Components
• Administering BPEL Process Service Components and Engines
• Administering Oracle Mediator Service Components and Engines
• Administering Decision Service Components and Business Rules Service Engines
• Administering Oracle User Messaging Service
• Administering Human Task Service Components and Human Workflow Service Engines
• Configuring Security Services and Policies

Prerequisites:

• Basic knowledge of SQL queries
• Familiarity with basic Web Service concepts
• Familiarity with command line scripts and interfaces
• Oracle WebLogic Server 11g: Administration Essentials

What's New in Oracle Solaris 11

Instructor: Michael Ernest

Bio: Michael Ernest manages Inkling Research, a private company of systems managers, programmers, training facilitators and mentors, since 1999. His own journey through the industry includes sales, technical support, professional services management, training, technical writing, custom course development and practice management. He has recently authored the Oracle courses "Java Design Patterns" and "What's New in Oracle Solaris Express 11," and served as a subject matter expert on the Oracle courses "Solaris Performance Management" and "DTrace for Systems Administrators." A long time ago he co-authored The Complete Java 2 Certification Study Guide, 2d ed. He has served as a Sheriff on JavaRanch for over ten years.

Course Description:
This 1-day seminar provides a detailed look at the newest key features of Oracle Solaris 11 and how to use these features within your deployments. You will learn how to implement the new packaging system, how using the default file system, ZFS, will improve your data management capabilities, how to deliver fully virtualized networking, and how to use the advanced user, application, and device security.

Target Audience:

• Network Administrator
• Security Administrators
• Architect
• System Administrator
• System Integrator

Course Objectives:

• Understand the key features of Oracle Solaris 11
• Understand the Image Packaging System
• Describe Automated Installation
• Understand the enhancements in Oracle Solaris 11 virtualization technologies
• Understand the new features and capabilities of ZFS

Course Topics:

• Introduction to Oracle Solaris 11
• Image Packaging System (IPS)
• Automated Installation (AI)
• Advances in Solaris Networking
• Oracle Solaris Containers in Oracle Solaris 11
• ZFS Features in Oracle Solaris 11
• Security Features of Oracle Solaris 11
• Deploying Applications Using SMF

Prerequisites:

• Knowledge of or experience with Solaris 10 OS technologies