optimus sourcing

If you wish to book any of the course dates below or you would like further course information then please call Blake or Paul on 0845 519 7408 or email training@optimussourcing.com

5 Day Oracle Training Course – RRP £2325 + VAT. Our price £2208 + VAT (Except London locations RRP £2555 + VAT. Our Price £2427 + VAT)

31st October – Manchester

7th November – Belfast, Reading

21st November – London, Manchester

28th November – London

5th December – Manchester, Reading

12th December – Leeds, London, Reading

19th December – London

9th January 2012 – Belfast

16th January 2012 – Reading

30th January 2012 – London

6th February 2012 – London

13th February 2012 – Manchester, Reading

20th February 2012 – Glasgow, London

5th March 2012 – Belfast, Reading

12th March 2012 – Leeds

19th March 2012 – Manchester

16th April 2012 – London

23rd April 2012 – London, Manchester

30th April 2012 – Reading

14th May 2012 – Belfast, London

28th May 2012 – Reading

11th June 2012 – Leeds, London

25th June 2012 – Manchester

What you will learn
This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you’ll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding Oracle Certified Associate exam.The course does not cover the following key Grid technologies: (1) Enterprise Manager Grid Control(2) Real Application Clusters(3) Streams(4) Data Guard. These technologies are addressed by the following courses:(1) Oracle Enterprise Manager 11g Grid Control(2) Oracle Database 11g: RAC Administration(3) Oracle Database 11g: Implement Streams(4) Oracle Database 11g: Data Guard Administration

Learn To:

• Install Oracle Grid Infrastructure
• Create and manage users
• Install and Configure Oracle Database
• Create and manage storage structures
• Administer the Oracle Database
• Backup and Recovery

This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification.

Only instructor-led in class or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.
Database Administrators
Java Developer
Support Engineer
Technical Administrator
Technical Consultant

Oracle Training Course Prerequisites
Required Prerequisites
Taken Oracle Introduction to SQL course or equivalent experience
Taken Oracle PL/SQL course or equivalent experience
Oracle Database: Introduction to SQL
Oracle Database: PL/SQL Fundamentals

Course Objectives
Monitor performance
Describe Oracle Database Architecture
Install Oracle Grid Infrastructure
Install and configure Oracle Database 11g
Configure Oracle Net services
Monitor and administer undo data
Manage the database storage structures
Create and administer user accounts
Perform basic backup and recovery of a database
Manage data concurrency

Course Topics

Exploring the Oracle Database Architecture
Oracle Database Architecture Overview
Oracle ASM Architecture Overview
Process Architecture
Memory structures
Logical and physical storage structures
ASM storage components

Installing your Oracle Software
Tasks of an Oracle Database Administrator
Tools Used to Administer an Oracle Database
Installation: System Requirements
Oracle Universal Installer (OUI)
Installing Oracle Grid Infrastructure
Installing Oracle Database Software
Silent Install

Creating an Oracle Database
Planning the Database
Using the DBCA to Create a Database
Password Management
Creating a Database Design Template
Using the DBCA to Delete a Database

Managing the Oracle Database Instance
Start and stop the Oracle database and components
Use Oracle Enterprise Manager
Access a database with SQLPlus
Modify database installation parameters
Describe the stages of database startup
Describe database shutdown options
View the alert log
Access dynamic performance views

Manage the ASM Instance
Set up initialization parameter files for ASM instance
Start up and shut down ASM instances
Administer ASM disk groups

Configuring the Oracle Network Environment
Use Enterprise Manager to create and configure the Listener
Enable Oracle Restart to monitor the listener
Use tnsping to test Oracle Net connectivity
Identify when to use shared servers and when to use dedicated servers

Managing Database Storage Structures
Storage Structures
How Table Data Is Stored
Anatomy of a Database Block
Space Management in Tablespaces
Tablespaces in the Preconfigured Database
Actions with Tablespaces
Oracle Managed Files (OMF)

Administering User Security
Database User Accounts
Predefined Administrative Accounts
Benefits of Roles
Predefined Roles
Implementing Profiles

Managing Data Concurrency
Data Concurrency
Enqueue Mechanism
Resolving Lock Conflicts
Deadlocks

Managing Undo Data
Data Manipulation
Transactions and Undo Data
Undo Data Versus Redo Data
Configuring Undo Retention

Implementing Oracle Database Auditing
Describe DBA responsibilities for security
Enable standard database auditing
Specify audit options
Review audit information
Maintain the audit trail

Database Maintenance
Manage optimizer statistics
Manage the Automatic Workload Repository (AWR)
Use the Automatic Database Diagnostic Monitor (ADDM)
Describe and use the advisory framework
Set alert thresholds
Use server-generated alerts
Use automated tasks

Performance Management
Performance Monitoring
Managing Memory Components
Enabling Automatic Memory Management (AMM)
Automatic Shared Memory Advisor
Using Memory Advisors
Dynamic Performance Statistics
Troubleshooting and Tuning Views
Invalid and Unusable Objects

Backup and Recovery Concepts
Part of Your Job
Statement Failure
User Error
Understanding Instance Recovery
Phases of Instance Recovery
Using the MTTR Advisor
Media Failure
Archive Log Files

Performing Database Backups
Backup Solutions: Overview
Oracle Secure Backup
User-Managed Backup
Terminology
Recovery Manager (RMAN)
Configuring Backup Settings
Backing Up the Control File to a Trace File
Monitoring the Flash Recovery Area

Performing Database Recovery
Opening a Database
Data Recovery Advisor
Loss of a Control File
Loss of a Redo Log File
Data Recovery Advisor
Data Failures
Listing Data Failures
Data Recovery Advisor Views

Moving Data
Describe ways to move data
Create and use directory objects
Use SQL*Loader to move data
Use external tables to move data
General architecture of Oracle Data Pump
Use Data Pump export and import to move data

Working with Support
Use the Enterprise Manager Support Workbench
Work with Oracle Support
Log service requests (SR)
Manage patches

If you wish to book any of the course dates below or you would like further course information then please call Blake or Paul on 0845 519 7408 or email training@optimussourcing.com

5 Day Oracle Training Course – RRP £2325 + VAT. Our Price £2208 + VAT (Except London locations RRP £2555 + VAT. Our Price £2427 + VAT)

7th November – Glasgow

14th November – Leeds, Reading

21st November – London

28th November – Belfast, London

12th December – Reading

19th December – London

30th January 2012 – Belfast, London

6th February 2012 – Reading

13th February 2012 – London

27th February 2012 – London

12th March 2012 – Reading

19th March 2012 – Belfast

26th March 2012 – London, Manchester

16th April 2012 – London

23rd April 2012 – Belfast

30th April 2012 – Reading

21st May 2012 – London

What you will learn
This five-day 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. Topics covered include the benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance, strengthening security, and several other areas of particular interest to database administrators. In addition, hands-on practice sessions help reinforce understanding of the new capabilities.

Learn To:
Implement manageability features to simplify database management
Use change management features to master database changes
Use database advisors to provide proactive database monitoring
Increase data availability by using ASM, RMAN, and Flashback feature enhancements

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any
time. Registered students must view the class from the country listed in the registration form. Unauthorized recording,
copying, or transmission of LVC content may not be made.

Data Warehouse Administrator
Database Administrators
Sales Consultants
Support Engineer
Technical Consultant

Oracle Training Course Prerequisites

Required Prerequisites
Working knowledge of Oracle Database 10g

Suggested Prerequisites
Oracle Database 10g: Administration Workshop I Release 2
Oracle Database 10g: Administration Workshop II Release 2

Oracle Training Course Objectives
Install Oracle Grid Infrastructure
Install Oracle Database 11g Release 2
Use Oracle Restart to manage components
Use Automatic Storage Management (ASM) enhancements
Implement table compression and hybrid columnar compression
Implement data warehousing and partitioning enhancements
Use the SQL Performance Analyzer
Use SQL Plan Management and load SQL plan baselines
Use Database Replay to record and replay workloads
Set and manage Automatic SQL Tuning
Use Enterprise Manager to monitor SQL commands
Use the new and enhanced RMAN features
Use Total Recall to create, protect, and use history data
Use Data Pump in legacy mode
Use Data Recovery Advisor

Oracle Training Course Topics

Oracle Grid Infrastructure
Installing Oracle Grid Infrastructure for a Standalone Server
Creating an ASM Disk Group
ASM Cluster File System
ASM Dynamic Volume Manager
ASM File System Snapshot

Installation and Upgrade Enhancements
Installing Oracle Database 11g Release 2
Oracle Database Upgrade Enhancements
Online Patching
Upgrading Your Time Zone File and Timestamp with Time Zone Data

Oracle Restart
Controlling Oracle Restart
Using the srvctl Utility
Manually Adding Components to the Oracle Restart Configuration

ASM Enhancements
Setting up ASM fast mirror resync
Using ASM Scalability and Performance Enhancements
ASM Disk Group Compatibility
Using ASMCMD Extensions
ASM File Access Control
ASM Optimal Disk Placement

Storage Enhancements
Using 4 KB-Sector Disks
Using Table Compression
Hybrid Columnar Compression
SQL Access Advisor
Segment Creation on Demand

Data Warehouse and Partitioning Enhancements
Preprocessing Data for ORACLE_LOADER Access Driver in External Tables
Degree of Parallelism Enhancements
In-Memory Parallel Query
Partitioning Enhancements
System-Managed Indexes for List Partitioning

Oracle SecureFiles
Enabling SecureFiles Storage
Using SecureFile Compression
Accessing SecureFiles Metadata
Migrating to SecureFiles

Security and Networking Enhancements
Secure Password Support
Automatic Secure Configuration
Managing Default Audits
Setting Database Administrator Authentication
Transparent Data Encryption
Hardware Security Module
Tablespace Master Key Re-Key
Supporting IPv6 Address Notification

SQL Performance Analyzer
SQL Performance Analyzer: Overview
Using SQL Performance Analyzer
Using Enterprise Manager to Access SQL Performance Analyzer
SQL Performance Analyzer: PL/SQL Example
SQL Performance Analyzer: Data Dictionary Views

SQL Plan Management
SQL Plan Management: Overview
Loading SQL Plan Baselines
Using the MIGRATE_STORED_OUTLINE Functions
Viewing Important Baseline SQL Plan Attributes
Loading a SQL Plan Baseline Automatically
Purging SQL Management Base Policy

Database Replay
Using Database Replay
Database Replay System Architecture
Supported Workloads
Database Replay Workflow in Enterprise Manager
Database Replay PL/SQL Procedures
Database Replay Data Dictionary Views

Automatic SQL Tuning
Automatic SQL Tuning in Oracle Database 11g
Selecting Potential SQL Statements for Tuning
Controlling the Automatic SQL Tuning Task
Configuring Automatic SQL Tuning
Using the PL/SQL Interface to Generate Reports

Intelligent Infrastructure Enhancements
Using New Automatic Workload Repository Views
Creating AWR Baselines
Defining Alert Thresholds Using Static Baseline
Controlling Automatic Maintenance Tasks
Fixed Policy CPU Resource Management
Instance Caging

Diagnosability Enhancements
Setting Up Automatic Diagnostic Repository
ADRCI: The ADR Command-Line Tool
Incident Packaging Service (IPS)
Using the Enterprise Manager Support Workbench
Invoking IPS Using ADRCI
Running Health Checks Manually
Using the SQL Repair Advisor

SQL Monitoring
SQL Monitoring in Oracle Database 11g Release 2
Viewing Session Details
Viewing the SQL Monitoring Report

Performance Enhancements
Using the DBMS_ADDM Package
New and Modified Views
Enabling Automatic Memory Management
Using New Statistic Preferences Features
Locking Enhancements
Adaptive Cursor Sharing
Using Table Annotation to Control Result Caching

Application Maintenance and Upgrade Enhancements
Online Redefinition Enhancements
Creating and Using Invisible Indexes

Backup and Recovery Enhancements
Using New SET NEWNAME Clauses
Optimized Backups
Using New Settings for Binary Compression
Enhancements to Database Duplication
Creating Archival Backups
TSPITR Enhancements and Modifications
Creating and Using Virtual Private Catalogs
Introduction to Oracle Secure Backup Cloud Module

Flashback Technology, LogMiner, and Data Pump
Oracle Total Recall
Flashback Transaction Backout
Enterprise Manager LogMiner Interface
Data Pump Legacy Mode

Data Recovery Advisor
Assessing Data Failures
Data Recovery Advisor RMAN Command-Line Interface
Data Recovery Advisor Views
Setting Parameters to Detect Corruption

Oracle have released the new Transition to Oracle Solaris 11 Training Course and have scheduled dates in London and Reading which are listed below.   Optimus Sourcing is an official Oracle Partner so are able to offer discounts on the price of this training course on all bookings made in 2011.

The  training course is 5 days long and to make a booking or enquiry then please call Blake on 0845 519 7408 or email training@optimussourcing.com

Transition to Oracle Solaris 11 Training Course Start Dates:

• 7th November – London – £3185 – 7% Discount = £2962.05 + VAT
• 5th December – London – £3185 – 7% Discount = £2962.05 + VAT
• 31st October – Reading – £2900 -7% Discount = £2697 + VAT
• 5th December – Reading – £2900 -7% Discount = £2697 + VAT
• 9th January 2012 – Reading – £2900 -7% Discount = £2697 + VAT
• 30th January 2012 – Reading – £2900 -7% Discount = £2697 + VAT
• 26th March 2012 – Reading – £2900 -7% Discount = £2697 + VAT
• 30th April 2012 – Reading – £2900 -7% Discount = £2697 + VAT

Please note AS THIS IS AN EARLY ADOPTER COURSE, this training is for informational purposes only and is intended solely to assist you in planning for the implementation and upgrade of the product features described. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this course remains at the sole discretion of Oracle.

This course builds on student’s system administration experience with Oracle Solaris 10 and provides the skills and knowledge required for transitioning from Oracle Solaris 10 to Oracle Solaris 11. This course is intended for System Administrators and IT architects who are responsible for planning and performing transitioning tasks.

During this course, students examine various aspects of planning for the transition from Oracle Solaris 10 to Oracle Solaris 11. This course highlights the new features delivered with Oracle Solaris 11 including Automated Installer (AI), Image Packaging System (IPS), and network virtualization. Throughout the course, students practice transitioning to the Oracle Solaris 11 operating environment by performing a series of guided hands-on labs that walk the student through the critical tasks associated with operating system migration activities. These labs include case studies that showcase best practices when transitioning from Oracle Solaris 10 to Oracle Solaris 11. This course focuses on the new and enhanced features found in the Oracle Solaris 11 operating system. It assumes the student already has the skills and knowledge necessary for administering Oracle Solaris 10.

Audience:

• System Administrator
• Data Center Manager
• Network Administrator
• System Integrator
• Support Engineer

Prerequisites:

Required Prerequisites:

• Experience administering an Oracle Solaris 10 environment
• Knowledge of the ZFS file system
• Experience with Oracle Solaris Zones

Suggested Prerequisites:

• System Administration for the Oracle Solaris 10 OS Part 1
• System Administration for the Oracle Solaris 10 OS, Part 2

Course Objectives:

• Manage software updates in Oracle Solaris 11
• Explain the new ZFS file system features and enhancements
• Administer Zones in Oracle Solaris 11
• Manag virtual networks in Oracle Solaris 11
• Describe the new features and enhancements in Oracle Solaris 11
• Describe new user management features and enhancements
• Explain the new security administration features and enhancements
• Install Oracle Solaris 11

Course Topics:

Introducing the Oracle Solaris 11 New Features and Enhancements

• Describe the Solaris operating system features and enhancements that are new with Oracle Solaris 11
• Identify planning considerations for transitioning from Solaris 10 to Oracle Solaris 11

Installing the Oracle Solaris 11 Operating System

• Plan for the Oracle Solaris 11 OS installation
• Describe the Oracle Solaris 11 OS installation methods
• Identify the Oracle Solaris 11 OS installation requirements
• Install the Oracle Solaris 11 OS using the interactive installer
• Install the Oracle Solaris 11 OS using the automated installer (AI)
• Migrate JumpStart rules and profiles to AI format
• Identify the components of the distribution constructor

Managing Software Updates in Oracle Solaris 11

• Describe the Image Package System
• Create an IPS repository
• Manage software packages using IPS
• Publish and removing packages
• Manage boot environments

Administering Oracle Solaris 10 Zones in Oracle Solaris 11

• Identify zone features and enhancements that are new with Oracle Solaris 11
• Configure an Oracle Solaris 11 Zone
• Configure an Oracle Solaris 10 Zone on Solaris 11
• Migrate a physical Solaris 10 system into an Oracle Solaris 10 Zone on Oracle Solaris 11 (P2V)
• Perform a virtual to virtual migration of non-global zones present in source system (V2V)
• Configure NFS server in a non-global zone
• Create read-only zones

Implementing the New Oracle Solaris 11 Network Features and Enhancements

• Identify the network virtualization features and enhancements that are new with Solaris 11
• Describe the new and enhanced network utilities
• Administer Network Auto-Magic (NWAM)
• Describe Solaris 11 network virtualization
• Plan for and configure a virtual network
• Configure IPMP
• Establish network resource controls
• Configure a network bridge

Applying the New Storage Enhancements

• Describe the new and enhanced storage features
• Configure ZFS deduplication
• Determine ZFS snapshot differences
• Describe the ZFS zpool split functionality
• Split a mirrored ZFS pool
• Describe ZFS shadow migration
• Describe COMSTAR
• Configure an iSCSI LUN, target, and initiator

Applying the New System Security Features and Enhancements

• Describe the new security features in Oracle Solaris 11
• Configure data encryption.
• Check the integrity of the system using the Basic Audit Reporting Tool (BART)
• Customizing a BART report