SETC Training844-434-7382
 Find a Course: 
 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

Oracle Training


On behalf of the section here at CBSA I would like to thank you for putting in that extra effort to ensure that the course was a resounding success. Your concern for the participants getting the most out of the course was self-evident and very much appreciated. The participants found the extra day of lab time very worthwhile
Comment from CBSA

1. Title

  • Professional Oracle Administration (ORAADMCP, 5 days)
    View PDF

2. Course Pre-requisites

  • Previous experience in a database environment

3. Target Audience

  • IT professionals who want to learn how to administer an Oracle Database environment

4. Dates and Pricing


May 29 to Jun 2, 2017$2,775.00/person
Sep 11 to Sep 15, 2017$2,775.00/person
Nov 20 to Nov 24, 2017$2,775.00/person

5. Outline

Module 1: Oracle 11g Server Overview

Topic 1: Learning Objectives

Topic 2: DBA Roles and Responsibilities

Topic 3: The Oracle RDBMS

Topic 4: Oracle Server Product Overview

Topic 5: Oracle Architecture

Topic 6: Overview of PL/SQL

Topic 7: Objectives Covered

Module 2: Installing an Oracle 11g Server

Topic 1: Learning Objectives

Topic 2: Preparing for an Oracle 11g Installation

Topic 3: Installing an Oracle 11g Server

Topic 4: Product Specific Prerequisite Checks

Topic 5: Database Configuration

Topic 6: Database Content: Sample Schemas

Topic 7: Recovery Configuration

Topic 8: Memory Parameters

Topic 9: Database Connection Mode

Topic 10: Security Settings

Topic 11: Creation Options

Topic 12: Objectives Covered

Module 3: Creating and Configuring Databases

Topic 1: Learning Objectives

Topic 2: Oracle Database Server: Core Services

Topic 3: Tablespaces, Datafiles and Control Files

Topic 4: Converting Text-based to Server Parameter files

Topic 5: Overview of Memory Allocation and Memory Targets

Topic 6: Simplifying Memory Allocation and Memory Targets

Topic 7: Using the SQL *PLUS Utility

Topic 8: Configuring Oracle Databases

Topic 9: Overview of SYSDBA Privilege

Topic 10: Authenticating Connections having SYSDBA Privilege

Topic 11: Automating Database Management

Topic 12: Objectives Covered

Module 4: Administering an Oracle 11g Server

Topic 1: Learning Objectives

Topic 2: Administering Oracle Databases

Topic 3: Using the Oracle Administration Assistant

Topic 4: Administering User Roles

Topic 5: Overview of Sophisticated Password

Topic 6: Authenticating Users with Sophisticated Password Checking

Topic 7: Ensuring Database Availability

Topic 8: Objectives Covered

Module 5: Managing Tables and Files

Topic 1: Learning Objectives

Topic 2: Overview of Profiles

Topic 3: Limiting Resources Usage Through Profiles

Topic 4: Overview of Read Only Tables

Topic 5: Preventing Changes to Read Only Tables

Topic 6: Comparing Traditional managed and Oracle Managed Files

Topic 7: Configuring Storage Patterns for Database Objects

Topic 8: Structuring Data and Index Segments

Topic 9: Overview of Extents and Block Occupancy

Topic 10: Sizing Database Objects by defining Extents and Block Occupancy

Topic 11: Overview of PCTFree and Data Pump

Topic 12: Eliminating Row Mitigation with PCTFree and Data Pump

Topic 13: Compressing Table Data to Conserve Storage

Topic 14: Shrinking Tables and Indexes Online to Regain Space

Topic 15: Objectives Covered

Module 6: Oracle Database Processes and Features

Topic 1: Learning Objectives

Topic 2: Processing Transactions with the Server

Topic 3: Overview of Processes and Memory Structures

Topic 4: Identifying types of Oracle 11g Processes and Memory Structures

Topic 5: Understanding Database File Structures

Topic 6: Archiving the Redo Log

Topic 7: Overview of the Result Cache

Topic 8: Sizing the Result Cache for Optimizing Repeated Queries

Topic 9: Objectives Covered

Module 7: Oracle 11g Networking

Topic 1: Learning Objectives

Topic 2: Oracle Net Configuration Assistant

Topic 3: Listener Configuration

Topic 4: Naming Methods Configuration

Topic 5: Local Net Service Configuration

Topic 6: Directory Usage Configuration

Topic 7: Oracle Net Manager

Topic 8: General Tracing Settings

Topic 9: Oracle Advanced Security

Topic 10: Service Identification

Topic 11: Configuring Listeners

Topic 12: Naming Methods

Topic 13: Objectives Covered

Module 8: Oracle Enterprise Manager

Topic 1: Learning Objectives

Topic 2: Oracle Enterprise Manager

Topic 3: Database Performance Page

Topic 4: Database Availability Page

Topic 5: Database Server Page

Topic 6: Database Schema Page

Topic 7: Database Data Movement

Topic 8: Database Software and Support

Topic 9: Configuring Enterprise Manager

Topic 10: Configuring Administrators

Topic 11: Oracle Notification Methods

Topic 12: Metalink and Patching Settings

Topic 13: Offline Patching Settings

Topic 14: Linux Server Staging Setup

Topic 15: Blackouts

Topic 16: Management Pack Access

Topic 17: Monitoring Templates

Topic 18: Corrective Actions Library

Topic 19: Data Exchange Hub

Topic 20: Management Services and Repository

Topic 21: Agents

Topic 22: Objectives Covered

Module 9: Administering with Database Control

Topic 1: Learning Objectives

Topic 2: Comparing Command-Line and Graphical Interfaces

Topic 3: Overview of Database Control

Topic 4: Administering with Database Control

Topic 5: Equipping Database Control to Manage Additional Databases

Topic 6: Objectives Covered

Module 10: Thresholds and Alerts

Topic 1: Learning Objectives

Topic 2: Overview of Thresholds and Alerts

Topic 3: Setting Thresholds and Generating Alerts

Topic 4: Verifying Changes in the Data Dictionary

Topic 5: Overview of Privilege Management

Topic 6: Performing Privilege Management

Topic 7: Objectives Covered

Module 11: Flashback Management

Topic 1: Learning Objectives

Topic 2: Performing Flashback Management

Topic 3: Managing Space for Rollback and Read Consistency

Topic 4: Monitoring Expansion of Rollback Segments

Topic 5: Swapping to an alternative Undo Tablespace

Topic 6: Resetting Data to Recent Points in Time with Flashback

Topic 7: Tracking Changes to Data Values with Row History

Topic 8: Overview of Transaction History

Topic 9: Obtaining Transaction History with Flashback Transaction

Topic 10: Overview of Flashback Table

Topic 11: Performing efficient Recovery of Data with Flashback Table

Topic 12: Overview of the Recycle Bin

Topic 13: Retrieving Dropped Tables and Dependent Objects from the Recycle Bin

Topic 14: Objectives Covered

Module 12: Partitioning

Topic 1: Learning Objectives

Topic 2: Overview of Partitioning

Topic 3: Partitioning to Support Administration and Availability

Topic 4: Overview of Table Partitions Recommendations

Topic 5: Creating Table Partitions and Sub-Partitions

Topic 6: Choosing Partitioning Methods - range, list, hash, intervals

Topic 7: Partitioning Tables based on Virtual Columns

Topic 8: Setting up Automatic Partition Allocation

Topic 9: Administering Partitions with merge, split, add and drop

Topic 10: Objectives Covered

Module 13: Indexes

Topic 1: Learning Objectives

Topic 2: Overview of Partition Indexes

Topic 3: Maintaining Partition Indexes

Topic 4: Maximizing Performance with Local and Global Indexes

Topic 5: Monitoring Index Partition Usage

Topic 6: Overview of Unusable Indexes

Topic 7: Rebuilding Unusable Indexes

Topic 8: Objectives Covered

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette