Search for Training

Oracle 11g Administration - Fundamentals

Course Overview


The Oracle 11g Administration Fundamentals Training is designed to give participants a firm foundation in basic administration of Oracle Database 11g. In Oracle 11g Administration Fundamentals class, participants learn how to install and maintain Oracle Database 11g. Participants gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Participants learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.

Course Content


Enterprise Edition Installation

  • Identify System Requirements
  • The Optimal Flexible Architecture (OFA)
  • Oracle_base
  • Oracle_home
  • Configure the Installation Environment
  • Enterprise Edition Installation
  • DBCA

The Administrator Interface

  • Enterprise Manager Tour
  • Using EM SQL Worksheet
  • Duties of a Database Administrator
  • Exploring the Oracle Database Architecture: General
  • The Oracle Enterprise Architecture

Exploring the Oracle Database Architecture: Instance Memory

  • What Is An Oracle Database Instance?
  • More About the System Global Area (sga)
  • About the PGA
  • Managing Memory

Exploring the Oracle Database Architecture: Instance Processes

  • Instance Background Processes
  • SQL Execution Processes

Creating An Oracle Database

  • Create a New Database
  • Configure An Existing Database
  • Drop a Database
  • Manage DBCA Templates
  • Manually Create a Database

Managing the Database Instance

  • Configuring a Linux Environment
  • Starting & Stopping Database Control
  • Starting & Stopping the Database Listener
  • Starting & Stopping the Database Instance
  • More About the Database Files

Manage Database Storage Structures: Tablespaces

  • About Tablespaces
  • Tablespace Management
  • Drop Tablespace
  • Alter Tablespace

Manage Database Storage Structures: Advanced Tablespaces

  • More About Temporary Tablespaces
  • About Temporary Tablespace Groups
  • More About Permanent Tablespaces
  • More About Bigfile Tablespaces
  • More About the Sysaux Tablespace

Manage Database Storage Structures

  • Data Files & Temp Files
  • Managing Data Files
  • Managing Temp Files
  • Enable Oracle-managed Files (OMF)

Managing Undo Data

  • About Undo Space Management
  • Configure Automatic Undo Management
  • Undo_management
  • Undo_tablespace
  • Undo_retention
  • Guarantee Undo Retention
  • Monitor Undo Space
  • Use the Undo Advisor

Network Environment: Oracle Shared Servers

  • Shared Servers Architecture
  • Configure Shared Servers
  • Monitor Shared Servers
  • V$shared_server
  • V$shared_server_monitor
  • V$session
  • V$circuit
  • V$dispatcher & V$dispatcher_config
  • V$queue

Security: Implementing Database Security

  • Database System Privileges
  • Database Object Privileges
  • Administrator Auditing of Database Activity
  • Enhanced Default Security Settings

Security: Administering User Security

  • Create & Manage Database Accounts
  • Grant & Revoke Database Privileges
  • Resource Limits Via Profiles
  • Alter Profile
  • Drop Profile
  • Password Management Via Profiles
  • About Role-based Security
  • With Admin Option
  • Alter User...default Role
  • Set Role
  • Enhanced Default Security Settings

Moving Data: SQL Loader

  • Loader Concepts
  • Control File Options
  • Load Methods
  • Using the EM Interface

Moving Data: Export & Import

  • Manage Directory Objects
  • About the Data Pump Architecture
  • Data Pump Export
  • Data Pump Import
  • Data Pump Data Dictionary Views
  • Using the EM Interface

Database Maintenance & Performance Management

  • The Management & Advisory Framework
  • Manage the Automatic Workload Repository
  • Automatic Database Diagnostic Monitor
  • Use Metrics & Alert Thresholds
  • Automatic Maintenance Tasks

Managing Concurrency & Locks

  • About Latches & Locks
  • Manage & Monitor Latches
  • Manage & Monitor Locks
  • V$lock
  • V$locked_object
  • V$session
  • V$session_wait
  • Dba_blockers & Dba_waiters
  • Dba_dml_locks & Dba_ddl_locks
  • Dml_locks
  • Backup & Recovery Concepts & Configuration
  • About Database Backup & Recovery Structures
  • Managing Redo Data
  • Managing Archival Data
  • Automatic Crash Recovery
  • Creating a Basic Backup Strategy

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

What is the sum of 4 + 1? (security question)

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234

Subscribe to our weekly newsletter