Oracle 11g : Admin I (Oracle 11g : Admin I)

Through hands-on experience administering an Oracle 11g database, you will gain an understanding of the Oracle Server architecture, and you will learn how to expand the size of the database, implement security, and know why and how specific database administration tasks are performed.


  • Category
    Database
  • Duration
    80 Hours
  • Level
    Intermediate

What Will I Learn ?

  • Oracle Server architecture 
  • Install Oracle Server software 
  • Start and stop an Oracle database 
  • Manage tablespaces and undo segments
  • Create an Oracle database
  • Create tables, constraints, and indexes
  • Create all other database objects
  • Manage redo logs
  • Manage tablespaces and datafiles
  • Manage controlfiles 
  • Manage security
  • Audit the database
  • Manage Oracle networking
  • Perform appropriate backups
  • Perform complete and incomplete recoveries

Prerequisite Knowledge

  • Knowledge of SQL, the Introduction to Oracle 11g SQL and SQL* Plus course, or equivalent experience
  • Introduction to Oracle 11g PL/SQL or equivalent experience is highly recommended
  • Oracle 11g Foundations: SQL & SQL Plus

Who can benefits ?

  • Data analysts 
  • Database administrators
  • Systems administrators
  • Network managers
  • Technical support personnel 

Opportunity Scope

Mentor shall discuss on classroom.

Modules / Chapter

Introduction and Duties of the DBA

  • Oracle RDBMS Components
  • DBA Responsibilities

Tables, Constraints, and Indexes

  • Introduction to Datatypes and Tables
  • Integrity Constraints
  • Temporary Tables, Partitioned Tables (range, hash, list), External Tables, IOTs
  • Indexes and Skip Scanning
  • Online Reorganization
  • Database Workspace Management

Other Database Schema Objects

  • DDL Commands Used
  • Views, Materialized Views
  • Sequences, Synonyms, Database Links
  • Outlines, Dimensions, Hierarchies
  • PL/SQL Program Units
  • Supplied Packages • Oracle Data Dictionary
  • Storage of Large Objects (BFILEs, BLOBs, CLOBs)

Starting and Stopping the Database

  • What Tool to Use
  • Connecting as a Privileged User
  • Password file authentication
  • Starting a Database
  • Shutting Down a Database
  • Reading the Alert Log/Trace Files
  • Quiescing the Database
  • SPFILE / Parameter Management

How Space is Physically Consumed - Blocks and Extents

  • Basic Definitions
  • Blocks and Extents
  • Fragmentation/Deallocation

How Space is Logically Consumed - Segments

  • Introduction to Segments
  • Managing Undo Segments
  • Automatic Undo Management
  • Managing Sort Activity
  • Managing Data Segments
  • Managing Index Segments
  • Monitoring Database Segments

Managing Tablespaces - Default Behavior of CREATE TABLESPACE Command

  • Tablespace Overview
  • System Tablespace
  • Types of Tablespaces
  • Creating Additional tablespaces
  • Altering Tablespaces
  • Temporary Tablespaces - Default
  • Temporary Tablespaces
  • Tablespace Quotas
  • Monitoring Tablespaces

Basic Oracle Architecture

  • Architecture Overview
  • Database Structures
  • Process Structures
  • Memory Structures - SGA
  • Memory Structures - PGA
  • Alternative Configurations

Oracle Database Files

  • Basic Structures of an Oracle RDBMS
  • Data Files • Redo Log Files
  • Archived Redo Log Files
  • Control Files
  • Oracle-Managed Files (OMF)

Users and Security

  • Managing Database Users
  • System/Object Privileges
  • Managing Roles/Profiles
  • Resource and Password Management
  • The Virtual Private Database

Networking

  • Duties of the DBA for Networking
  • Overview of Oracle Network Architecture
  • Name Resolution
  • Oracle Net Client Configuration
  • Oracle Net Server Configuration
  • Tools
  • Configuring the Listener
  • Shared Server

Physical NOARCHIVELOG Mode Backups

  • Oracle Database Backups
  • Automatic Recovery Architecture
  • NOARCHIVELOG Mode
  • ARCHIVELOG Mode
  • Physical Backups
  • Closed Backups in NOARCHIVELOG Mode

Configuring Archivelog Mode

Physical ARCHIVELOG Mode

Backups

  • Configuration of the Database for Archiving
  • Setting the ARCHIVELOG Mode
  • Establishing Multiple Archiving Destinations
  • Closed Backups in ARCHIVELOG Mode
  • Open Backups in ARCHIVELOG Mode
  • Controlfile Backup

Complete Recovery

  • Recovery Structures and Processes
  • Recovery in NOARCHIVELOG and ARCHIVELOG Mode

Incomplete Recovery

  • What is Incomplete Recovery?
  • Recovering from Loss of Current Redo Log Files

Data Loading

  • SQL Loader
  • External Tables
  • Data Pump

Automation Tools

  • The New Enterprise Manager
  • DB Console
  • Mgt. & Advisory Framework
  • Automated Workload Repository
  • ADDM

Enquiry Form

Required fields are marked (*).

(Max 350 words only)

Contact Information

  • Address

    Anamnagar - 32 Kathmandu, Nepal

  • Email

    info@labanepal.com

  • Phone

    +977-1-4102721, 4102722, 4244804

  • Opening Hours

    10 AM - 5 PM

Registration Form

Required fields are marked (*).

(Max 350 words only)

Contact Information

  • Address

    Anamnagar - 32 Kathmandu, Nepal

  • Email

    info@labanepal.com

  • Phone

    +977-1-4102721, 4102722, 4244804

  • Opening Hours

    10 AM - 5 PM

newsletter

Sign Up for News and Offers

Subscribe for the latest news and great deals we offer