Oracle Database 11g: Administration Workshop I
About This Course
This course is offered as an e-Learning course and is comprised
of six (6) modules.
Target Audience
Database Administrators, Database Designers, Developer Support
Engineers, and Technical Administrators
Course Outline
Module 1: Oracle Database 11g: Database Architecture and
Installation
Overview/Description
Identify the elements of the Oracle Database 11g architecture
and recognize the tools and steps required to install the Oracle
Database 11g software.
Lesson Objectives
Oracle Database 11g: Database Architecture and
Installation
- identify the main structural components of Oracle Database
11g.
- identify the components of the Oracle Database 11g memory
structures.
- identify the functions of the Oracle Database 11 server and
background processes.
- recognize how information is stored and structured within the
Oracle Database 11g storage architecture.
- identify the necessary tasks and essential tools required to
administer an Oracle Database 11g database.
- recognize the steps for planning and carrying out an
installation of Oracle Database 11g software using the Oracle
Universal Installer (OUI).
- install Oracle Database 11g software in a given scenario.
Module 2: Oracle Database 11g: Database Creation,
Instance Management, and Connectivity
Overview/Description
Identify the steps for creating a new Oracle Database 11g
database and then configuring it and managing the instance, and
also recognize the steps for configuring new Oracle Net Listeners
and database connectivity.
Lesson Objectives
Oracle Database 11g: Database Creation, Instance
Management, and Connectivity
- recognize the steps for creating, configuring, or deleting a
database using the Database Configuration Assistant (DBCA), and
also for managing a database instance using various Oracle
tools.
- recognize the scope and capabilities of Oracle Database 11g
initialization parameters and identify the steps for maintaining
them.
- recognize the steps for configuring database startup and
shutdown options, administering a blackout, and using alerts and
dynamic data to assess database performance.
- recognize the steps for using the Data Dictionary to find
information about users, objects, constraints, and storage.
- create a database using the DBCA and manage instances using
Enterprise Manager.
- recognize ways of configuring and managing the Oracle network,
and identify the steps for creating a new Oracle Net Listener via
Enterprise Manager.
- identify the steps for connecting to an Oracle Database 11g
database using different naming methods as well as advanced
connection options, and identify when to employ connection
pooling.
- identify the steps for using and configuring Oracle Net
Services in a given scenario.
Module 3: Oracle Database 11g: Storage Structures and
User Security
Overview/Description
Identify the steps for maintaining storage structures and
automating storage management in Oracle Database 11g, and for
managing privileges, roles, and other security features for
users.
Lesson Objectives
Oracle Database 11g: Storage Structures and User
Security
- recognize the purposes of table spaces and datafiles.
- recognize the steps for creating a new tablespace.
- recognize how to manage the storage of information by
maintaining tablespaces and viewing their information, and
automating manual storage using Automatic Storage Management
(ASM).
- view tablespace information and create a new tablespace.
- recognize the steps for creating and authenticating database
user accounts.
- recognize the steps for granting and revoking privileges and
creating and managing roles.
- recognize the steps for creating and managing profiles,
implementing password security, and assigning quotas.
- grant privileges to users in a given scenario
Module 4: Oracle Database 11g: Managing the Schema,
Data, and Concurrency
Overview/Description
Identify the steps for managing schema objects, such as tables,
views, and indexes, and recognize ways to use SQL and PL/SQL
commands to manipulate data and ensure data concurrency
Lesson Objectives
Oracle Database 11g: Managing the Schema, Data, and
Concurrency
- recognize the features and functions of schemas and data types,
and identify the steps for modifying a table.
- recognize the steps for using constraints to maintain data
integrity, viewing the contents of a table, and perform actions on
the table.
- recognize ways of improving data update and retrieval, storing
queries, speeding up performance by creating and using indexes,
views, sequences, and temporary tables.
- create a table with columns and also create constraints and
indexes, in a given scenario.
- recognize ways for manipulating data with SQL commands and for
administering PL/SQL objects.
- recognize the steps for triggering events, and for monitoring
and resolving locking conflicts
Module 5: Oracle Database 11g:
Managing Undo Data, Database Security, and Maintenance
Overview/Description
Recognize the steps required to manage undo information, secure
an Oracle Database 11g database, and maintain it by monitoring
statistics, automated tasks and alert thresholds.
Lesson Objectives
Oracle Database 11g: Managing Undo Data, Database
Security, and Maintenance
- recognize the steps for managing undo operations in Oracle
Database 11g to allow users to roll back transactions.
- recognize the requirements and best practices for implementing
database security according to international and regional
laws.
- recognize the steps for enabling, specifying, maintaining, and
reviewing database auditing.
- recognize the process for obtaining and applying Critical Patch
Updates (CPUs).
- configure an Oracle Database 11g database to support retention
and implement database security in a given scenario.
- recognize the steps for managing and gathering optimizer
statistics.
- identify the steps for managing Automatic Workload Repository
(AWR) statistics, using the Automatic Database Diagnostic Monitor
(ADDM), and utilizing advisors.
- identify the steps for viewing and configuring automated tasks
and setting alert thresholds.
Module 5: Oracle Database 11g: Performance Monitoring,
Recovery Concepts and Backup
Overview/Description
Identify the steps for ensuring an Oracle Database 11g database
is available to users when needed, by monitoring its performance,
anticipating and avoiding database failure, setting up instance
recovery options, and creating backups.
Lesson Objectives
Oracle Database 11g: Performance Monitoring, Recovery
Concepts and Backup
- identify the steps for monitoring and analyzing performance,
managing memory, and troubleshooting invalid objects that affect
performance.
- recognize ways to anticipate and avoid various types of failure
that can occur in Oracle Database 11g.
- recognize the process used to configure an Oracle Database 11g
database for instance recovery.
- recognize the features of different backup strategies you can
employ in Oracle Database 11g.
- recognize the steps for using RMAN to configure, schedule,
manage, and view backup operations.
- resolve performance issues, prepare the database for recovery,
and perform a database backup in a given scenario.
Module 6: Oracle Database 11g: Recovering, Moving, and
Enhancing the Oracle Database
Overview/Description
Recognize ways to make use of Oracle Database 11g's tools for
moving and recovering data, reporting on problems, and installing
updates to enhance a database.
Lesson Objectives
Oracle Database 11g: Recovering, Moving, and Enhancing
the Oracle Database
- recognize the tools required and steps performed in identifying
whether a recovery is necessary, and then recovering various types
of database files.
- recognize the features of the various options for moving data
in Oracle Database 11g.
- recognize the steps for importing, exporting, and moving data
between Oracle databases using Oracle Data Pump.
- recover the database from a media failure and move data using
the Data Pump Wizard in a given scenario.
- recognize the steps for using the Enterprise Manager Support
Workbench and Oracle Support to investigate, report on, and resolve
problems.
- recognize the steps for searching MetaLink for new critical
patches and for logging service requests.
- recognize ways for managing and applying patches in Oracle
Database 11g.