Oracle 11g Certification Training

$217.41 (tax incl.)

Product Details Learning Oracle 11g Certification Training CBT Library Suite is easy with instructor-led Video Training Oracle 11g is the…

Categorized in ,
Quantity

Product Details

Learning Oracle 11g Certification Training CBT Library Suite is easy with instructor-led Video Training

Oracle 11g is the latest version of Oracle’s database management system offering over 500 new features. Don’t wait until the software is installed to learn how to use it, get the training you need now. If you’re a DBA, Oracle developer, or Oracle programmer, you owe it to yourself to explore these new features and find out they will impact your systems.

The self-paced Oracle 11g CBT is an excellent tool to learn about the new features and how they relate to 11g availability, development, and performance tuning. Instead of enrolling in a traditional class, you’ll get the instruction delivered directly to your desktop.

If you’ve never tried a computer based training format before, get ready to be wowed. The Oracle 11g DBA training CD features full motion video segments featuring an expert, certified instructor who gives you a thorough tour of Oracle 11g. In addition to the Oracle 11g training videos, you also get hands-on exercises and activities using realistic simulations. Interactive content, animations, and step-by-step demos round out the curriculum making for a comprehensive and engaging learning environment.

Use the self-paced Oracle 11g DBA CBT to explore the changes and get up to speed with Oracle 11g. This course is also an ideal starting point for new database administrators who want to start a career as an Oracle professional. Simply install the Oracle 11g training CD and begin learning the ins and outs of Oracle 11g – even without a copy of the software installed. The high-quality videos and hands-on simulations give you a front seat and realistic preview of Oracle 11g in action.

Instead of reading books or sitting through hour after hour of classroom lectures, you simply watch Oracle 11g DBA training videos and participate in interactive activities. You can take your learning at a pace that is the best match for your learning needs and time schedule. With regular classes, you’re out of luck if you miss a lecture. This format puts you back in charge. You can even re-watch the videos as often as you want.

New and existing Oracle administrators will benefit by using the Oracle 11g DBA training CD.

Oracle 11g CBT Training Titles by Module:

  • Oracle 11g Introduction to SQL
  • Oracle 11g Database Administration I
  • Oracle 11g Database Administration II
  • Oracle 11g PL/SQL Fundamentals
  • Oracle 11g PL/SQL Develop Program Units

 

Outline

Training Level: Basic to Advance

Table of contents

Oracle 11g Introduction to SQL Essential: 

Lesson 1: Introduction
Lesson 2: Retrieving Data Using SQL Select Statements
Lesson 3: Restricting and Sorting Data
Lesson 4: Using Single-Row Functions to Customize Output
Lesson 5: Using Conversion Functions and Conditional Expressions
Lesson 6: Reporting Aggregated Data Using the Group Functions
Lesson 7: Displaying Data from Multiple Tables
Lesson 8: Using Subqueries to Solve Queries
Lesson 9: Using the Set Operators
Lesson 10: Manipulating Data
Lesson 11: Using DDL Statements to Create and Manage Tables
Lesson 12: Creating Other Schema Objects

Oracle 11g Database Administration I: 

Lesson 1: Oracle Database Architecture
Lesson 2: Installing Oracle Software
Lesson 3: Create an Oracle Database
Lesson 4: Managing the Oracle Instance
Lesson 5: Oracle Network
Lesson 6: Tablespaces and Tables
Lesson 7: Administering Users
Lesson 8: Schema Objects
Lesson 9: Concurrency
Lesson 10: Managing Undo Data
Lesson 11: Database Security
Lesson 12: Database Maintenance
Lesson 13: Performance Management
Lesson 14: Backup and Recovery
Lesson 15: Database Backups
Lesson 16: Database Recovery
Lesson 17: SQL*LOADER and DATAPUMP
Lesson 18: Enhancing Database Capabilities

Oracle 11g Database Administration II: 

Lesson 1: Database Architecture and ASM
Lesson 2: Configuring for Recoverability
Lesson 3: RMAN Recovery Catalog
Lesson 4: Configuring Backup Specifications
Lesson 5: Using RMAN to Create Backups
Lesson 6: User-Managed Backup and Recovery
Lesson 7: Using RMAN to Perform Recovery
Lesson 8: RMAN to Duplicate a Database
Lesson 9: Tablespace Point-in-Time Recovery
Lesson 10: Undo Data
Lesson 10.1 Introduction
Lesson 11: Flashback Technology
Lesson 12: Additional Flashback Operations
Lesson 13: Diagnosing the Database
Lesson 14: Memory
Lesson 15: Database Performance
Lesson 16: Space Management
Lesson 17: Globalization

Oracle 11g PL/SQL Fundamentals: 

Lesson 1: Introduction
Lesson 2: Introduction to PL/SQL
Lesson 3: PL/SQL Variables
Lesson 4: Executable Statements
Lesson 5: Interacting with the Oracle Database Server
Lesson 6: Control Structures
Lesson 7: Composite Data Types
Lesson 8: Explicit Cursors
Lesson 9: Exceptions
Lesson 10: Stored Procedures and Functions

Oracle 11g PL/SQL Program Units: 

Lesson 1: Introduction
Lesson 2: Procedures
Lesson 3: Working with Functions
Lesson 4: Working with Packages
Lesson 5: Advanced Packages
Lesson 6: Oracle Supplied Packages
Lesson 7: Dynamic SQL
Lesson 8: Design Considerations for PL/SQL Code
Lesson 9: Triggers
Lesson 10: Compound Triggers, DDL Triggers and Event Database Triggers
Lesson 11: PL/SQL Compiler
Lesson 12: PL/SQL Code
Lesson 13: Managing Dependencies

Specs and Support

Content: CD-ROM disc (sealed in a DVD-case)

System Requirements:
Platform:  Windows 10, 8, 7 and Vista
Processor: Pentium 133 Mhz or higher
RAM: 32MB
Hard drive space: 10MB
CD-ROM Drive speed: 24X