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.

Goals
  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.
Outline
  1. Configuring the Server for Installation
    1. Identify System Requirements
    2. Optimal Flexible Architecture (OFA)
    3. ORACLE_BASE
    4. ORACLE_HOME
    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
    2. Using V$SGA_DYNAMIC_COMPONENTS
    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
    5. About DATABASE_PROPERTIES
    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
    3. UNDO_MANAGEMENT
    4. UNDO_TABLESPACE
    5. UNDO_RETENTION
    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
    4. V$SHARED_SERVER
    5. V$SHARED_SERVER_MONITOR
    6. V$SESSION
    7. V$CIRCUIT
    8. V$DISPATCHER and V$DISPATCHER_CONFIG
    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
    20. SEC_CASE_SENSITIVE_LOGON Setting
  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
    4. V$LOCKED_OBJECT
    5. V$SESSION
    6. V$SESSION_WAIT
    7. DBA_BLOCKERS and DBA_WAITERS
    8. DBA_DML_LOCKS and DBA_DDL_LOCKS
    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:

Preparing for Class

Training for your Team

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

Training for Yourself

$2,625.00 or 5 vouchers

Upcoming Live Online Classes

  • See More Classes

Please select a class.
  • Live Online Training
  • For Individuals
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video

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
VEGAS.com
The course served as a good introduction to the Basics of XML, and will allow me to progress with the technology.
Lou Giammarino
T. Rowe Price
My instructor covered alot of information within limited time! I was very impressed with her knowledge and teaching style. Not to mention, her ability to keep my attention. :)
Khaleelah Miles
Gray Line of Tennessee
This course was very informative and provided many concepts and tools to enable Scrum teams to be successful.
Christine Schubert
Apollo Group

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

61,490

Students who have taken Instructor-led Training

11,769

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

10.00

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