Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Oracle11g AdminI

GK# 400134

Course Overview

Oracle Database 11g delivers economies of scale on easily managed low-cost grids, making it easier to reduce cost of downtime with maximum availability architecture, change IT systems faster using Real Application Testing, partition and compress data to run queries faster using less disks, securely protect and audit data, enable total recall of data, and make productive use of standby resources with Active Data Guard.

This course addresses administration for Oracle Database 11g and is focused on:

  • Database Architecture and Installation
  • Database Creation, Instance Management, and Connectivity
  • Storage Structures and User Security
  • Managing the Schema, Data, and Concurrency
  • Managing Undo Data, Database Security, and Maintenance
  • Performance Monitoring, Recovery Concepts and Backup
  • Recovering, Moving, and Enhancing the Oracle Database

 

For self-paced learning, you will have access to this course for 12 months from the purchase date.

Delivery Format Options

  • Self-Paced

    Self-Paced

    Recordings, hands-on labs and expert instructors empower you to train on your own schedule.

    From

    $2025 CAD

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

  • Elements of the Oracle Database 11g architecture and the tools and steps required to install the Oracle Database 11g software
  • Steps for creating a new Oracle Database 11g database and then configuring it and managing the instance
  • Steps for configuring new Oracle Net Listeners and database connectivity
  • Steps for maintaining storage structures and automating storage management in Oracle Database 11g and for managing privileges, roles, and other security features for users
  • Steps for managing schema objects, such as tables, views, and indexes, and recognize ways to use SQL and PL/SQL commands to manipulate data and ensure data concurrency
  • Steps required to manage undo information, secure an Oracle Database 11g database, and maintain it by monitoring statistics, automated tasks and alert thresholds
  • Steps for ensuring an Oracle Database 11g database is available to users when needed by monitoring its performance, anticipating and avoiding database failure, setting up instance recovery options, and creating backups
  • Ways to make use of Oracle Database 11g's tools for moving and recovering data, reporting on problems, and installing updates to enhance a database

Follow-On Courses

Prerequisites

  • Working knowledge of SQL
  • Oracle 11g: Programming with SQL Intro

Who Needs To Attend

Database administrators, database designers, developer support engineers, and technical administrators