---

In this class, you will learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will 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. Hands-on exercises reinforce the material covered. This course is designed to prepare you for the Oracle Certified Associate exam.

Highlights

• Install and configure the Oracle 10g database
• Create and administer user accounts in the Oracle 10g database
• Backup and recover the database
• Monitor, troubleshoot, and maintain the database
• Configure Oracle Net services for the database

Course Outline

1. Introduction

• Basic concepts of a relational database
• Core database administrator tasks

2. Installing Oracle Database 10g Software

• System requirements
• Use optimal flexible architecture
• Install software with the Oracle Universal Installer

3. Create an Oracle Database

• Oracle database architecture
• Instance architecture
• Use the management framework
• Database Creation Assistant

4. Database Interfaces

• Use structured query language (SQL)
• Procedural Language/Structured Query Language (PL/SQL)
• Java
• Oracle C++ Call Interface (OCCI)

5. Controlling the Database

• Start and stop the agent
• Enterprise manager database console
• Listener
• Start up and shut down the database

6. Storage Structures

• Purpose of tablespaces and data files
• Create and manage tablespaces
• Use Oracle Managed Files (OMF)
• Obtain tablespace information

7. Administering Users

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

8. Managing Schema Objects

• Create and modify tables, indexes, and views
• Define constraints
• View the attributes and the contents of a table

9. Managing Data

• Manipulating data through SQL
• Import
• Export
• Data pump
• SQL Loader

10. PL/SQL

• PL/SQL objects
• Triggers and triggering events
• Configuration options that affect PL/SQL performance

11. Oracle Database Security

• Principal of least privilege
• Manage default user accounts
• Implement standard password security features
• Audit database activity

12. Oracle Net Services

• Oracle Net concepts
• Use Oracle Net Manager to create and configure listeners
• Configure client and middle-tier connection
• Use the listener control utility to control the Oracle Net Listener
• Use TNSPING to test Oracle Net connectivity

13. Oracle Shared Server

• When to use Oracle Shared Servers
• Configure and monitor Oracle Shared Servers

14. Performance Monitoring

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

15. Proactive Maintenance: Objectives

• Set warning and critical alert thresholds
• Collect and use baseline metrics
• Tuning and diagnostic advisors
• Automatic Database Diagnostic Monitor (ADDM)
• Manage the automatic workload repository

16. Undo Management

• Monitor and administer undo information
• Configure and guarantee undo retention
• Use the undo advisor

17. Monitoring and Resolving Lock Conflicts

• Detect and resolve lock conflicts
• Manage deadlocks

18. Backup and Recovery Concepts

• Basics of database backup, restore, and recovery
• Types of failure that may occur in an Oracle Database
• Ways to tune instance recovery
• Importance of checkpoints, redo log files, and archived log file
• Configure ARCHIVELOG mode

19. Database Backups

• Consistent database backups
• Incremental backups
• Automate database backups
• Monitor the flash recovery area
• Back your database up without shutting it down

20. Database Recovery

• Loss of a control file
• Loss of a redo log file
• Loss of a data file

21. A Day in the Life of a DBA

• Daily tasks
• Weekly tasks
• Monthly tasks
• As-needed tasks

Space is limited. Register today to save your space!