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

Limited Time Offer:

Get a FREE Deluxe Course and a GREAT Corporate Discount for your Company. Click Here.

Oracle 11g New Features Part 1 Enroll Today!

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

Oracle 11g New Features Part 1

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

Video Title Minutes
Need Help Playing Your Videos?
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
Course Survey
Total: 5 hours 2 minutes

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

Start Learning Oracle 11g New Features Part 1 Today!

Course Purchase Options

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.

Prerequisites

You need to have equivalent experience or have taken the following GogoTraining courses:

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

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

Start Learning Oracle 11g New Features Part 1 Today!

Course Purchase Options

Prerequisites

You need to have equivalent experience or have taken the following GogoTraining courses:

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!

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

Course Purchase Options

What should I do if my video will not play?

There are many things that can affect the quality of your video so we have put together these instructions to help you review all the things that need to be tested in order to trouble-shoot video quality.

The first thing we want to assure you is that we have done everything possible to make sure that our videos will play well.  Our videos are hosted in the cloud by Akamai.  Akamai has servers around the world to make sure that your videos are sent from the server that is closest to you.  By hosting our videos with Akamai we make sure that you receive the highest video quality. If you are experiencing video buffering or freezing at home or at the office there are a number of things you can do to help us troubleshoot.

  • Buffering: We provide you with three (3) speed choices that you can select when watching a video.  If the video is buffering then the first thing you want to click on a slower speed option found at the bottom of the video window. Try clicking on Medium and Low and see if that allows the video to play without buffering. If it does not, please read through the rest of this FAQ and follow the steps outlined below.
  • Video will not play: In order to play our videos, you have to have Adobe Flash Player installed. If you click on the video and nothing happens, then you do not have Adobe Flash Player installed.  Click on this link to download and install it.
    • If you have Adobe Flash Player installed and your video is not playing, complete the following steps:
      • Go to your course page, select a video, and click play.
      • Once the video begins playing, place your mouse over the video and right click.
      • You will see the several links and the last link has the words “About Adobe Flasher Player xx.xx.xx” (version # you have).
      • Click here , where you will see your version and what is the latest version. You need to have the latest version installed.
      • If you do not have Adobe Flash Player, click here to download and install it.
  • Popup Blockers: Please check to make sure that your pop-up blocker is turned off when you go to our website. This will prevent the video window from opening.
  • Your Connection Speed: Internet speed needs to be 2.0 Mbps upload and download to successfully watch the videos.  You will want to check and see if your connection speed is 2.0 Mbps or higher.  You can do this by clicking on this link and running a speed test.
  • Jitter and Packet Loss: Your Jitter rate lets us know if your connection speed is consistent while your Packet Loss rate lets us know if your internet connection could be losing pieces of the video.
    • Go to www.pingtest.net to determine if there is any Jitter or Packet Loss on your connection.
    • This is measured by a letter scale with A being the best.
      • If your Packet Loss is below a B, your connection is losing pieces of the video and causing the video to skip.
      • If your Jitter is below a B, your connection speed is very inconsistent and may be changing while you are watching the video which will result in buffering issues.
      • If either of these is the case you will need to contact your internet provider.
  • Ports: You will need to have ports 1935, 443 and 80 open. You can run a port test at this link.
    • If you are watching from work and those ports are not open, check with your IT department.
  • Shared Internet Connection: If you are on a shared internet connection, test playing videos during non-peak hours when usage by others on your network is low.
  • Reset Your Browser: If you've tried all the previous steps, your browser may be retaining data that needs to be deleted, and this requires a reset. If you are using Chrome, use the instructions in this link to reset your browser. If you are using Internet Explorer (IE) you may need to reset it. You can do this by clicking on the cog icon on the top right of your page. Then click on tools, internet options, advanced and reset. If you are using Firefox, use the instructions in this link to reset your browser.
  • Other things to check:
    • At home or at work, test using different browsers and computers to see if you get the same result.
      • Make sure you have the latest version of the browser you are using.
    • If you are using Internet Explorer (IE) you may need to reset it. You can do this by clicking on the cog icon on the top right of your page. Then click on tools, internet options, advanced and reset.
    • Try from a different location using a different network.
    • If you are on a wireless connection try a wired solution.
    • If you are on a home network:
      • Test playing the videos when you are the only user on the network.
      • Try by-passing your router to eliminate it as the point of failure. A direct plug from your ISP to your computer will take care of this and will make sure that neither your router nor other users are affecting your connection.
  • Make sure you do not have any other programs open. File sharing and peer to peer sharing programs, even when limited to low bandwidth, can make it almost impossible to stream properly.

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 NOT the name of a color?

Blue
1000
Red
Green
1000
Green
1000
Green
Red
Blue
Red
Blue