Oracle 10g & 11g

Course Objective

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

    • Share Post