Participants will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students will also 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.

This course helps Participants prepare to successfully pass the Oracle certification exam #1z0-042 to become an Oracle Database Administrator Certified Associte (OCA-DBA).

Course schedule

Duration: 30 hours
To view the schedule for this class, click here.

Administrators and other IT Professionals involved in the management of Oracle10g databases

•  Oracle Database 10g: Introduction to SQL
. or equivalent knowledge.

Course Outline

INTRODUCTION
•  Identify the Oracle product line
•  Know core database administrator tasks

INSTALLING ORACLE DATABASE 10G SOFTWARE
•  Identify system requirements
•  Use optimal flexible architecture
•  Install software with the Oracle Universal Installer

CREATE AN ORACLE DATABASE
•  Oracle Database Architecture
•  Use the management framework & the Database Creation Assistant

DATABASE INTERFACES
•  Use SQL, PL/SQL, Java, and Oracle C++ Call Interface (OCCI)

CONTROLLING THE DATABASE
•  Start and stop the agent, the enterprise manager database console, & the listener
•  Startup and shutdown the database

STORAGE STRUCTURES
•  Create & manage tablespaces
•  Obtain tablespace information
•  Create and manage tablespaces using OMF

ADMINISTERING USERS
•  Create and manage database user accounts
•  Create and manage roles
•  Grant and revoke privileges
•  Control resource usage by users

MANAGING SCHEMA OBJECTS
•  Create and modify tables
•  Define constraints
•  View the attributes of a table
•  Create indexes and views

MANAGING DATA
•  Manipulating data through SQL
•  Using Import, Export & SQL Loader

PL/SQL
•  Identify PL/SQL objects
•  Understand triggers & triggering events
•  Identify configuration options that affect PL/SQL performance

ORACLE DATABASE SECURITY
•  Apply the principal of least privilege
•  Manage default user accounts
•  Implement standard password security features
•  Audit database activity

ORACLE NET SERVICES
•  Use Oracle Net Manager to create and configure listeners
•  Use TNSPING to test Oracle Net connectivity

ORACLE SHARED SERVER
•  Configure Oracle Shared Servers
•  Monitoring Shared Servers

PERFORMANCE MONITORING
•  Troubleshoot invalid and unusable objects
•  Gather optimizer statistics
•  View performance metrics
•  React to performance issues

PROACTIVE MAINTENANCE: OBJECTIVES
•  Set warning and critical alert thresholds
•  Collect and use baseline metrics
•  Use tuning and diagnostic advisors
•  Use ADDM
•  Manage the Automatic Workload Repository

UNDO MANAGEMENT
•  Monitor and administer undo
•  Configure undo retention
•  Guarantee undo retention
•  Use the undo advisor

MONITORING AND RESOLVING LOCK CONFLICTS
•  Detect and resolve lock conflicts
•  Manage deadlocks

BACKUP AND RECOVERY CONCEPTS
•  List the types of failure that may occur in an Oracle Database
•  Identify the importance of checkpoints, redo log files, and archived log file
•  Configure ARCHIVELOG mode

DATABASE BACKUPS
•  Create consistent database backups
•  Online backup
•  Monitor the flash recovery area

DATABASE RECOVERY
•  Recover from loss of a control file
•  Recover from loss of a redo log file
•  Recover from loss of a data file