Oracle 11g New Features Part 1

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 1 Today!

Your Price: $695

Video Title	Minutes
00: Course Introduction	7
01: Installation of Oracle 11g Enterprise Edition	20
02: Upgrading to 11g	25
03: Database Replay: Setup and Capture	20
04: Database Replay: Prepare, Replay and Evaluate	13
05: Lab – Database Replay	18
06: The SQL Performance Analyzer: Capture and Pre-Change Workload	21
07: The SQL Performance Analyzer: Post-Upgrade	14
08: Lab – SQL Performance Analyzer	16
09: PL/SQL New Features Part 1	23
10: Lab - PL/SQL Enhancements	22
11: PL/SQL New Features Part 2	13
12: Lab - Trigger Enhancements Lab	10
13: PL/SQL Function Result Cache	19
14: Lab - PL/SQL Function Result Cache	16
15: SQL New Features	28
16: Lab - SQL and SQL Plan Baselining	13
17: Course Summary	4
Total:	5 hours 2 minutes

Start Learning Oracle 11g New Features Part 1 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 1 Today!

List Price: $995 Your Price: $695

Description

This Oracle online training course gives you the opportunity to explore and complete hands-on exercises with the new change management features and other key enhancements in Oracle Database 11g RLSE 2. You will learn how to install the Enterprise edition, the upgrade to 11g, database replay, the SQL performance analyzer post upgrade, and take an in depth look at the new features.

Once you have completed Oracle 11g New Features Part 1 the next course in this series is Oracle 11g New Features Part 2.  The Oracle 11g New Features Part 2 course will enhance your Oracle knowledge by discussing how to implement manageability features to simplify database management, using the database advisors to proactively monitor the database, look at the improvements to RMAN, Data Pump, and Flashback features to increase data availability, master database changes through change management features, and how to use the new features of SQL and PL/SQL.  Click here to learn more about Oracle 11g New Features Part 2.

Objectives

As a result of 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 2
• Podcast: New Features in Oracle 11g PL/SQL
• Podcast: Oracle11g New Feature: PL/SQL Result Cache
• Podcast: Oracle 11g New Feature: SQL Performance Analyzer
• Podcast: Oracle 11g Miscellaneous Security New Features
• Podcast: Oracle 11g New Feature: Database Replay

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

Start Learning Oracle 11g New Features Part 1 Today!

List Price: $995 Your Price: $695

Oracle 11g New Features Part 1 Outline

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

Module 01: Installation of Oracle 11g Enterprise Edition

• Pre-Installation Tasks
• Using the Oracle Universal Installer
• Post-Installation Tasks

Module 02: Upgrading to 11g

• The Pre-Upgrade Information Tool
• Starting the dbua
• Benefits of Using dbua
• Manually Upgrading
• Downgrading
• Testing Levels
• Post-Upgrade Tasks
• Patching
• Migrating to a Different Operating System
   

Module 03: Database Replay: Setup and Capture

• Real Application Testing Overview
• Database Replay Setup
• Using dbms_workload_capture Package
• Capturing the Workload
   

Module 04: Database Replay: Prepare, Replay and Evaluate

• Making Change to be Evaluated
• Using the dbms_workload_replay Package
• Preparing the Capture
• Starting the Replay Client
• Producing Reports
• Viewing Information in the Data Dictionary
• Using Enterprise Manager (dbcontrol) with Database Replay
   

Module 05: Lab - Database Replay

Module 06: The SQL Performance Analyzer: Capture and Pre-Change Workload

• Capturing the Production System SQL Workload
• Creating a SQL Performance Analyzer Task
• Creating and Using a SQL Tuning Set
• Analyzing the Pre-Change SQL Workload
   

Module 07: The SQL Performance Analyzer: Post-Upgrade

• Analyzing the Post-Upgrade SQL Workload
• Comparing the SQL Performance
• Generating the SQL Performance Analyzer Report
• Using Enterprise Manager (dbcontrol) with Spa
   

Module 08: Lab - SQL Performance Analyzer

Module 09: PL/SQL New Features Part 1

• simple_integer datatype
• Continue Statement
• Sequences in PL/SQL Expressions
• Dynamic SQL Enhancements
• Named and Mixed Notation in PL/SQL Subprogram Calls
• Automatic Subprogram Inlining
• PL/SCOPE
• PL/SQL Native Compiler Enhancements
• New PL/SQL Compiler Warning
• PLS-00436 Restriction in for all Statements Removed
   

Module 10: Lab - PL/SQL Enhancements

Module 11: PL/SQL New Features Part 2

• Trigger Enhancements
• Execution Order of Triggers- Using Follows Clause
• Compound Triggers
• Triggers Created in the Disabled State
   

Module 12: Lab - Trigger Enhancements Lab

Module 13: PL/SQL Function Result Cache

• Using relies_on
• Maintaining the Result Cache
• dbms_result_cache Package

Module 14: Lab - PL/SQL Function Result Cache

Module 15: SQL New Features

• SQL*PLUS Error Logging
• Default Settings in the SQL*PLUS Executable
• Enhancements to Regular Expression Built-in SQL Functions
• Pivot and Unpivot
• Manually Loading a SQL Plan Baseline
• Evolving SQL Plan Baselines
• Evolving Plans with the SQL Tuning Advisor
• Managing the SQL Management Base
• Using Enterprise Manager to Manage SQL Plan Baselines
   

Module 16: Lab - SQL and SQL Plan Baselining

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

 

 

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

Start Learning Oracle 11g New Features Part 1 Today!

List Price: $995 Your Price: $695

Prerequisites

You need to have equivalent experience 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

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

Start Learning Oracle 11g New Features Part 1 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 1 Today!

List Price: $995 Your Price: $695

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