Oracle 10g & 11g

Course Overview

The Oracle 10g and 11g online training videos are perfect for companies with a large workforce. Some of the topics include creation of new databases, software installation, and management of database files. The course will also take you deep into topics like database architecture, data structures, processes, and memory and much more.

Course Outline

Oracle 10g – 24 hrs, 29 mins

Oracle 10g Administration 1 – 4hrs, 58 mins

  • Database Architecture
  • Installing the Oracle Database Software
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Schema Objects
  • Managing Data & Concurrency
  • Managing Undo Date
  • Implementing Oracle Database Security
  • Configuring the Oracle Network Environment
  • Proactive Maintenance
  • Performance Management
  • Backup & Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Performing Flashback
  • Moving Data

Oracle 10g Administration 2 – 3 hrs, 40 mins

  • Using Globalization Support
  • Controlling Access to the Oracle Listener
  • Configuring Recovery Manager
  • Using Recovery Manager
  • Diagnostic Sources
  • Recovering from Noncritical Losses
  • Database Recovery
  • Flashback Database
  • Recovering form User Errors
  • Dealing with Database Corruption
  • Automatic Management
  • Monitoring & Management Storage
  • Automatic Storage Management
  • Monitoring and Managing Memory
  • Database Resource Manager
  • Oracle Scheduler

Oracle 10g Application Server 1 – 7 hrs, 15 mins

  • Key Components and Features
  • Installing OracleAS Infrastructure
  • Installing OracleAS Middle Tier
  • Using OracleAS Management Tools
  • Configuring and Managing Oracle HTTP Server
  • Configuring Directives and Virtual Hosts
  • Configuring and Managing OracleAS Web Cache
  • Configuring and Managing OC4J
  • Deploying J2EE Applications
  • Oracle Application Server Security Services
  • Configuring Oracle Application Server Components in Oracle Internet Directory
  • Managing the OracleAS Portal
  • Configuring OracleAS Portal
  • Administering the OracleAS Single Sign-On Server
  • Managing Access Using Oracle Delegated Administration Services
  • Managing and Configuring OracleAS Certificate Authority
  • Securing OracleAS Components by Using SSL
  • Backing Up and Restoring Oracle Application Server

Oracle 10g Application Server 2 – 3 hrs, 10 mins

  • Getting Started with Oracle Application Server
  • Installing Oracle Application Server 10g R3 (10.1.3.1.0)
  • Tools for Administering Oracle Application Server
  • Administering Using Oracle Application Server Control
  • Deploying J2EE Applications
  • Deploying Advanced J2EE Applications
  • Advanced J2EE Concepts and Technologies
  • Managing OC4J Web Sites
  • Managing Secure Sockets Layer (SSL) in Oracle Application Server
  • Configuring Oracle Application Server
  • Backing Up and Restoring Oracle Application Server
  • High Availability Solutions
  • Active-Active Clustering in Oracle Application Server 10g R3
  • Troubleshooting the Oracle Application Server

Oracle 10g Introduction to PL SQL – 1 hr, 49 min

  • Introduction to PL/SQL
  • Declaring PL/SQL Variables
  • Writing Executable Statements
  • Interacting with the Oracle Server
  • Writing Control Structures
  • Working with Composite Data Types
  • Using Explicit Cursors
  • Handling Exceptions
  • Creating Stored Procedures & Functions

Oracle 10g Introduction to SQL – 3hrs, 35 mins

  • The SQL Select Statement
  • The WHERE and ORDER BY Clause
  • Single-Row Functions
  • Group Function
  • Joining Tables
  • Subqueries
  • Set Operators
  • Data Manipulation Language (DML)
  • Data Definition Language (DDL)
  • Indexes, Views, Sequences and Synonyms
  • Created
  • Data Dictionary Views
  • Controlling User Access
  • Manage Schema Objects
  • Manipulating Large Data Sets
  • Grouping Data
  • Time Zones
  • Subqueries
  • Hierarchical Retrieval

Oracle 11g – 23 hrs, 13 mins

Oracle 11g Administration Part 1 – 7 hrs

  • Oracle Database Architecture
  • Installing Oracle Software
  • Create an Oracle Database
  • Managing the Oracle Instance
  • Oracle Network
  • Tablespaces and Tables
  • Administering Users
  • Schema Objects
  • Concurrency
  • Managing Undo Data
  • Database Security
  • Database Maintenance
  • Performance Management
  • Backup and Recovery
  • Database Backups
  • Database Recovery
  • SQL*LOADER and DATAPUMP
  • Enhancing Database Capabilities

Oracle 11g Administration Part 2 – 5 hrs, 27 mins

  • Database Architecture and ASM
  • Configuring for Recoverability
  • RMAN Recovery Catalog
  •  Configuring Backup Specifications
  • Using RMAN to Create Backups
  • User-Managed Backup and Recovery
  • Using RMAN to Perform Recovery
  • RMAN to Duplicate a Database
  • Tablespace Point-in-Time Recovery
  • Undo Data
  • Flashback Technology
  • Additional Flashback Operations
  • Diagnosing the Database
  • Memory
  • Database Performance
  • Space Management
  • Globalization

Oracle 11g Developing PL SQL – 3 hrs, 24 mins

  • Introduction
  • Procedures
  • Working with Functions
  • Working with Packages
  • Advanced Packages
  • Oracle Supplied Packages
  • Dynamic SQL
  • Design Considerations for PL/SQL Code
  • Triggers
  • Compound Triggers, DDL Triggers and Event Database Triggers
  • PL/SQL Compiler
  • PL/SQL Code
  • Managing Dependencies

Oracle 11g Introduction to SQL – 3 hrs, 17 mins

  • Introduction to Oracle and SQL
  • SELECT Statement
  • WHERE Clause and ORDER BY Clause
  • Single-Row Functions
  • Conversion Functions Case Logic and Decode
  • Aggregated Data and Group Functions
  • Joining Tables
  • Using Subqueries
  • Set Operators
  • Data Manipulation Language (DML)
  • Create and Manage Tables
  • Other Schema Objects

Oracle 11g Advanced – 1 hr, 7 mins

  • User Access
  • Schema Objects
  • Data Dictionary Views
  • Large Data Sets
  • Different Time Zones
  • Using Subqueries
  • Regular Expression Support

Oracle 11g PL SQL Fundamentals – 2 hrs, 55 mins

  • Introduction
  • Introduction to PL/SQL
  • PL/SQL Variables
  • Executable Statements
  • Interacting with the Oracle Database Server
  • Control Structures
  • Composite Data Types
  • Explicit Cursors
  • Exceptions
  • Stored Procedures and Functions