Oracle Database 11g R2: Administration I

This Oracle Database 11g R2: Administration I training class covers the administration of the Oracle database management system (DBMS) and the server systems on which the DBMS runs.

The primary audience for this course is database administrators, web server administrators, system administrators, implementation specialists, data center support engineers, and senior application designers and developers.


Public Classes: Delivered live online via WebEx and guaranteed to run . Join from anywhere!

Private Classes: Delivered at your offices , or any other location of your choice.

Course Topics
  1. Configure the Linux and MS Windows operating systems in anticipation of a database installation.
  2. Verifiy a valid database installation
  3. Explore database administrator interface options, including the use of Enterprise Manager, command-line SQL*Plus, and terminal console SSH
  4. Explore database deinstallation and inline software patching
  5. Start up and shut down database services and related software components
  6. Learn about super administrator authentication options
  7. Gain an in-depth understanding of the database architecture, including memory, process and data structures, and the management of those structures.
  8. Manage database files.
  9. Explore specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the Result Cache, the database buffer
  10. cache, and other similar components.
  11. Manage security policies and procedures, including administration of user accounts, roles, privileges and profiles.
  12. Utilize advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.
  13. Perform monitoring, problem troubleshooting, and resolving lock and conflict issues.
  1. Configuring the Server for Installation
    1. Identify System Requirements
    2. Optimal Flexible Architecture (OFA)
    5. Configure Linux Installation
    6. Configure MS Windows Installation
    7. Prerequisite Checks and Fixup Utility
  2. Enterprise Edition Installation
    1. More about the Installation
    2. Start the Installation
    3. Desktop Class Installation 11G R2
    4. Server Class Installation 11G R2
    5. Post-installation Configuration
  3. Verify the Installation
    1. Accessing the EM Database Control
    2. Using the EM Interface
    3. Using SQL*Plus
    4. Using EM SQL Worksheet
    5. Using SSH
  4. Upgrade, Deinstallation, and Patching
    1. Database Upgrade
    2. NETCA
    3. DBUA
    4. Online Patching
    5. Oracle Deinstaller
  5. Manually Starting and Stopping Database Services
    1. Starting and Stopping Database Control
    2. Starting and Stopping The Listener
    3. Starting and Stopping the Database
    4. SYSDBA
  6. Exploring the oracle database architecture: General
    1. The Oracle Enterprise Architecture
    2. General Database Architecture
    3. V$VERSION
  7. Exploring the Oracle Database Architecture: Instance Memory
    1. More about Database Instances
    3. About the PGA
    4. Managing Memory
  8. Exploring the Oracle Database Architecture: Instance Processes
    1. Instance Background Processes
    2. SQL Execution Processes
    3. Using V$SESSION
  9. Creating an Oracle Database
    1. Create a New Database
    2. Configure an Existing Database
    3. Drop a Database
    4. Manage DBCA Templates
    5. Manually Create a Database
    6. More about the Database Files
  10. Enabling Transparent Data Encryption
    1. Transparent Data Encryption
    2. Managing TDE
    3. Implementing Column Encryption
  11. Manage Database Storage Structures: Tablespaces
    1. About Tablespaces
    2. Tablespace Management
    3. AUTOEXTEND Options
    4. Drop Tablespace
    5. Alter Tablespace
  12. Manage database storage structures: Advanced Tablespaces
    1. More about Temporary Tablespaces
    2. Using V$SORT_SEGMENT
    3. About Temporary Tablespace Groups
    4. More about Permanent Tablespaces
    6. More about Bigfile Tablespaces
    7. More about the SYSAUX TABLESPACE
  13. Manage Database Storage Structures: Data Files and Temp Files
    1. Managing Data Files
    2. Managing Temp Files
    3. Enable Oracle-Managed Files (OMF)
  14. Managing Undo Data
    1. About Undo Space Management
    2. Configure Undo Management
    6. Guarantee Undo Retention
    7. Monitor Undo Space
    8. Use The Undo Advisor
  15. Network Environment: Oracle Net Services
    1. Oracle Net Services Architecture
    2. Oracle Net Configuration Assistant
    3. Oracle Net Manager
    4. Configuration Using EM
    5. Troubleshooting Network Problems
    6. Countering Database Attacks
  16. Network Environment: Oracle Shared Servers
    1. Shared Servers Architecture
    2. Configure Shared Servers
    3. Monitor Shared Servers
    6. V$SESSION
    7. V$CIRCUIT
    9. V$QUEUE
  17. Security: Implementing Database Security
    1. Database System Privileges
    2. Database Object Privileges
    3. Auditing of Database Activity
    4. AUDIT_TRAIL Parameter
    5. Enhanced Default Security Settings
    6. Security: Administering User Security
    7. Create and Manage Database Accounts
    8. Grant and Revoke Database Privileges
    9. Resource Limits via Profiles
    10. Alter Profile
    11. Drop Profile
    12. Password Management via Profiles
    13. About Role-based Security
    14. With Admin Option
    15. With Admin Option and System Privileges
    16. With Grant Option and Object Privileges
    17. Alter USER...DEFAULT Role
    18. Set Role
    19. Enhanced Default Security Settings
  18. Moving Data: SQL Loader
    1. Loader Concepts
    2. Control File Options
    3. Load Methods
    4. Using The EM Interface
  19. Moving Data: Export and Import
    1. Manage Directory Objects
    2. About the Data Pump Architecture
    3. Data Pump Import
    4. Data Pump Data Dictionary Views
    5. Using the EM Interface
  20. Database Maintenance and Performance Monitoring
    1. Management and Advisory Framework
    2. Manage AWR
    3. ADDM
    4. Use Metrics and Alert Thresholds
    5. Automatic Maintenance Tasks
  21. Managing Concurrency and Locks
    1. About Latches and Locks
    2. Manage and Monitor Latches
    3. V$LOCK
    5. V$SESSION
    9. DML_LOCKS
  22. Backup and Recovery Concepts and Configuration
    1. About Backup and Recovery Structures
    2. Managing Redo Data
    3. Managing Archival Data
    4. Automatic Crash Recovery
    5. Creating a Basic Backup Strategy
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Oracle class:

  • Introductory experience with SQL.
  • Experience with Oracle PL/SQL queries

Experience in the following would be useful for this Oracle class:

  • Familiarity with system administration and administration of other non-Oracle databases.
Prerequisite Courses

Courses that can help you meet these prerequisites:

Training for your Team

Length: 5 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

I found the Oracle 11G R2 class to be exceptional in it's subject matter. It will allow me to get started with my new responsibilities at work right away.
David Metz
The Webucator Introduction to Java course has been a wonderful hands on training course. In just one week I feel more than comfortable with all that Java has to offer. Excellent course. Thank you!!
Edward Booker
MEDecision, Inc.
The course provided a comprehensive and immediately usable education about .NET Web API REST web services.
Daniel King
Department of Water Resources
Very useful class. I learned a lot.
Faranak Fouladi

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing


Students who have taken Instructor-led Training


Organizations who trust Webucator for their Instructor-led training needs


Satisfaction guarantee and retake option


Students rated our Oracle Database 11g R2: Administration I trainers 10.00 out of 10 based on 1 reviews

Contact Us or call 1-877-932-8228