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

Oracle Training


Great interaction with the instructor. The instructor was able to address my specific questions very well.
Comment from DND

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