• Advance Your Career Today
  • Learn New Skills
  • Save Money
  • Save Time
  • Get Certified
  • Get Promoted
  • Learn More
  • Advance Your Career Today

Oracle 11g New Features Part 2 Enroll Today!

Select The Package That's Right for You
Standard Deluxe Premium
Videos
1 Year Access to Course
Transcript
Course Materials
Instructors Answer Your Questions
Course Completion Certificate
$195 $425 $695
Add to Cart Add to Cart Add to Cart

Oracle 11g New Features Part 2

Key Course Benefits

  • Achieve Workplace Success by Learning from Real World Experts
  • Learn and Implement New Skills Faster With Real World Examples
  • Take High Quality Classroom Courses Without the Hassles of Travel
  • Student Guide Makes it Easy for You to Take Notes and Increase Learning
  • Course Demos and Exercises Help You Learn More
  • Eliminate Scheduling Conflicts by Training Anytime 24/7 for 1 year
  • Video Training with Materials, Exercises, and Instructor Support Maximizes Learning
  • 1 Year Course Access Gives You Time to Learn and Master Concepts
  • Use Your Course Completion Certificate to Build Your Resume
  • Responsive Customer Service Makes Independent Learning Easy and Smooth
  • Save Money and Learn More

Start Learning Oracle 11g New Features Part 2 Today!

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
Course Survey
Total: 4 hours 26 minutes

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

Start Learning Oracle 11g New Features Part 2 Today!

Course Purchase Options

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.

Prerequisites

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

 

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

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

Start Learning Oracle 11g New Features Part 2 Today!

Course Purchase Options

Prerequisites

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

 

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!

Course Purchase Options

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

Important Links

  • Course Survey

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

Start Learning Oracle 11g New Features Part 2 Today!

Course Purchase Options

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

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

Start Learning Oracle 11g New Features Part 2 Today!

Course Purchase Options

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.

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

Start Learning Oracle 11g New Features Part 2 Today!

Course Purchase Options

When you purchase a Deluxe or Premium course from GogoTraining, you can use your transcript to view and monitor your progress and when you complete the course, you can print or email the transcript, or print a course completion certificate.


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

Start Learning Oracle 11g New Features Part 2 Today!

Course Purchase Options

We show that you have been logged out, probably due to automatic session limits. Please Login to continue viewing content.

Sign up today for your FREE GogoTraining account to access hundreds of free resources.

Security Question

Answer this question to complete your registration.

Which one is a DB2 course?

AIX Fundamentals
Google Web Toolkit
AIX Fundamentals
Red Had Linux Essentials
Google Web Toolkit
Red Had Linux Essentials
SQL for DB2
Red Had Linux Essentials
AIX Fundamentals
Google Web Toolkit
SQL for DB2
SQL for DB2