Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4

This course allows the student to gain the skills necessary for day-today administration of an Oracle database.

Course Outline

This course allows the student to gain the skills necessary for day-today administration of an Oracle database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification.


Major tasks to be considered within this course are:

  • Software installation and the creation of new databases.
  • An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.
  • Management of database files.
  • 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 cache, and other similar components.
  • Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles.
  • Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.
  • Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.
  • Using the Oracle Enterprise Manager and SQL interfaces for administration tasks.
  • Control over database support services, including the Database Control, Oracle Net and others.
  • A primer on backup and recovery structures and strategies.
  •     Operating system-specific considerations for various platforms, especially Linux and MS Windows Server.


The primary target audience for this course is Oracle database administrators. Oracle web server and application server administrators, as well as others who must manage an embedded repository database using Oracle database technology will also find this information useful. This course is also recommended for technical consultants, support engineers, project managers and other technical management and support personnel.


Five days

Course Outline

1. Enterprise edition installation

    Identify system requirements
    The optimal flexible architecture (ofa)
    Configure the installation environment
    Enterprise edition installation

2. The administrator interface

    Enterprise manager tour
    Using em sql worksheet
    Duties of a database administrator
    Exploring the oracle database architecture: general

3. The oracle enterprise architecture

4. 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

5. Exploring the oracle database architecture: instance processes

    Instance background processes
    Sql execution processes

6. Creating an oracle database

    Create a new database
    Configure an existing database
    Drop a database
    Manage dbca templates
    Manually create a database

7. 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

8. Manage database storage structures: tablespaces

    About tablespaces
    Tablespace management
    Drop tablespace
    Alter tablespace

9. 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

10. Manage database storage structures

    Data files & temp files
    Managing data files
    Managing temp files
    Enable oracle-managed files (omf)

11. Managing undo data

    About undo space management
    Configure automatic undo management
    Guarantee undo retention
    Monitor undo space
    Use the undo advisor

12. Network environment: oracle shared servers

    Shared servers architecture
    Configure shared servers
    Monitor shared servers

13. Security: implementing database security

    Database system privileges
    Database object privileges
    Administrator auditing of database activity
    Enhanced default security settings

14. 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

15. Moving data: sql loader

    Loader concepts
    Control file options
    Load methods
    Using the em interface

16. 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

17. Database maintenance & performance management

    The management & advisory framework
    Manage the automatic workload repository
    Automatic database diagnostic monitor
    Use metrics & alert thresholds
    Automatic maintenance tasks

18. Managing concurrency & locks

    About latches & locks
    Manage & monitor latches
    Manage & monitor locks

19. Backup & recovery concepts & configuration

    About database backup & recovery structures
    Managing redo data
    Managing archival data
    Automatic crash recovery
    Creating a basic backup strategy

Prerequisites & Certificates

Prerequisites Many students taking this course have familiarity with system administration and administration of other non-Oracle databases, and this is helpful though not mandatory. Specific course prerequisites for this course are: Oracle Database 11g: SQL Fundamentals Oracle Database 11g: Program with PL/SQL

Certificates offered

Cancellation Policy
Student's Right to Cancel Registration

If Customer cancels or reschedules an original registration for a class at least ten (10) business days prior to the class start date, Web Age Solutions will issue a full refund of fees paid for class. Customer is not otherwise entitled to a refund of fees paid or released from its obligation to pay for any registration cancelled or rescheduled by Customer, including without limitation a registration previously rescheduled by Customer. Payment for the course will not be refunded if cancellation is received less than ten (10) business days before the class start date. If you wish to send another student in your place, please contact Web Age Solutions at the number below.

Web Age Solution's Right to Cancel or Reschedule

Web Age Solutions reserves the right to cancel or reschedule a class at any time. If a class is cancelled or rescheduled, Web Age Solutions will attempt to notify students ten (10) business days prior to the scheduled class start date. Web Age Solutions assumes no financial liability for any cancellation fees.


Map & Reviews
Web Age Solutions
[ View Provider's Profile ]


This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.
nope, but the room was quite cold in the mornings
Reviewed by 2014

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 238 times.