Oracle 11g New Features Part 2

View Your Course Transcript

Videos

There are several great features that come with this course. The Course Transcript tracks your progress and allows you to pick up where you left off. You can view or email your transcript. The course comes with documentation found in Downloads Tab. You have access to the course and all videos for 1 year. Full screen viewing option available (see icon on bottom right corner of video).

Start Learning Oracle 11g New Features Part 2 Today!

Your Price: $695

Video Title	Minutes
00: Course Introduction	5
01: SQL Result Cache	7
02: LAB - SQL Result Cache	7
03: Administration Enhancements Part 1	24
04: Administration Enhancements Part 2	23
05: LAB - Misc Administration	20
06: Behavior Changes	15
07: Flashback New Features	27
08: LAB - Flashback	18
09: Diagnostic New Features	28
10: LAB - Diagnostics	13
11: Security New Features	24
12: LAB - Security	12
13: RMAN and Data Guard New Features	18
14: LAB - RMAN	6
15: Data Pump and Storage Enhancements	11
16: LAB - Data Pump and Storage Enhancements	5
17: Course Summary	3
Total:	4 hours 26 minutes

Start Learning Oracle 11g New Features Part 2 Today!

Your Price: $695

Course Materials

Want to be able to access these helpful materials? Contact Us!

• Student Guide
• Exercise Guide
• Lab Setup Guide
• Oracle Installation Guide
• Lab Script file

Related Links

• Course Survey

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 11g New Features Part 2 Today!

List Price: $995 Your Price: $695

Description

In this Oracle online training course you will explore and complete hands-on exercises with the new change management features and other key enhancements in Oracle Database 11g RLSE 2. Oracle 11g New Features Part 2 covers SQL Result Cache, administrative enhancements, new features in flashback, diagnostics, security, RMAN and Data Guard, and Data Pump and Partitioning enhancements.

In order to take this course you need to have taken Oracle 11g New Features Part 1 and have experience with administration of  Oracle Database 10g.

Objectives

As a result of taking this Oracle training, you will be able to:
• Simplify database management by implementing manageability features
• Provide proactive database monitoring by utilizing database advisors
• Use improved RMAN, Data Pump, and Flashback features to increase data availability
• Master database changes by using change management features
• Use the new features of SQL and PL/SQL

Related Training

• Course: Oracle 11g New Features Part 1
• Podcast: Edition Based Redifinition: Part 1
• Podcast: Edition Based Redifinition: Part 2
• Podcast: Edition Based Redifinition: Part 3
• Podcast: SQL Plan Management
• Podcast: PLSQLChallenge.com

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 11g New Features Part 2 Today!

List Price: $995 Your Price: $695

Oracle 11g New Features Part 2 Outline

Module 00: Oracle 11g New Features Part 2 Online Training - Course Introduction

Module 01: SQL Result Cache

• Configuring the Result Cache
• Using memory_report Procedure
• Viewing Information in the Data Dictionary

Module 02: LAB - SQL Result Cache

Module 03: Administration Enhancements Part 1

• Review of Manual Memory Management
• Initialization Parameters Used
• Configure at Database Creation
• Configure on an Existing Database
• Display Memory Allocation
• Review Memory Information in the Data Dictionary

Module 04: Administration Enhancements Part 2

• Virtual Columns
• Invisible Indexes
• Shrinking Temporary Tablespaces and Tempfiles
• Define Tablespace for Global Temporary Tables
• Comparing Objects
• Converging Data
• New Data Dictionary Views and Initialization Parameters

Module 05: LAB - Misc Administration

Module 06: Behavior Changes

• Deprecated Initialization Parameters
• New Archivelog Destination Parameters
• Deprecated Data Dictionary Views
• Automatic Maintenance Tasks

Module 07: Flashback New Features

• Creating a Flashback Data Archive
• Enabling and Disabling Flashback Data Archiving
• Generating Reports
• Flashback Transaction Backout
• Prerequisites for Flashback Transaction Backout
• Transaction_Backout Reports

Module 08: LAB - Flashback

Module 09: Diagnostic New Features

• Automatic Diagnostic Repository
• Investigating and Resolving Problems
• Using the Command-Line Tool ADRCI
• The Support Workbench
• Incident Packaging Service
• SQL EST Case Builder
• SQL Test Case Builder from Support Workbench
• Health Monitor Checks
• Manual Checks

Module 10: LAB - Diagnostics

Module 11: Security New Features

• The SYSASM Privilege
• Stronger Password Hash Algorithm
• Default Auditing
• Delayed Failed Login
• Case-Sensitive Password
• Password Management
• Tablespace Encryption
• Oracle Wallet
• Securefile
• Using Securefiles with Lobs

Module 12: LAB - Security

Module 13: RMAN and Data Guard New Features

• Enhanced Block Media Recovery
• Long-Term Backups
• New Options for Validate Command
• Configuring an Archived Redo Log Deletion Policy
• Active (network-based) Database Duplication
• Data Guard Improvements
• Enhancements to Data Guard Broker Based Management Framework

Module 14: LAB - RMAN

Module 15: Data Pump and Storage Enhancements

• Compression Enhancements
• Encryption
• Remapping a Table
• Ignoring Errors
• Enhancements to Partitioning
• New Partition Key Capabilities

Module 16: LAB - Data Pump and Storage Enhancements

Module 17: Oracle 11g New Features Part 2 Online Training - Course Summary

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 11g New Features Part 2 Today!

List Price: $995 Your Price: $695

Prerequisites

You need to have equivalent experience and have taken Oracle 11g New Features Part 1 or have taken the following GogoTraining courses:

• Oracle 10g/11g Database Administration I Part 1
• Oracle 10g/11g Database Administration I Part 2
• Oracle 10g/11g Database Administration II Part 1
• Oracle 10g/11g Database Administration II Part 2
• Oracle 11g New Features Part 1

 

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 11g New Features Part 2 Today!

List Price: $995 Your Price: $695

System Requirements

Hardware:

• RAM: 256 MB minimum: 512 MB recommended.  On Windows Vista, the minimum requirement is 512 MB
• Virtual memory is double the amount of RAM
• Disk Space for basic installation is 2.04 GB, advanced installation is 1.94 GB
• Video adapter: 256 colors
• Processor: 550 MHz minimum. On Windows Vista, the minimum requirement is 800 MHz
• Oracle Database components include 32 MB hard disk to install Java Runtime Environment (JRE) and Oracle Universal Installer on the partition where the operating system is installed

Software:

Detailed set up will be provided with the course.

• Oracle 11g Enterprise Edition
• Oracle 10g Express Edition

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 11g New Features Part 2 Today!

List Price: $995 Your Price: $695

When you purchase a course from GogoTraining, you can submit comments or questions to our expert instructors.