| Course Details |
| •Install Oracle Database 10g and configure a database. |
| •Manage the Oracle instance. |
| •Manage the Database storage structures. |
| •Create and administer user accounts. |
| •Perform backup and recovery of a database. |
| •Monitor, troubleshoot, and maintain a database. |
| •Configure Oracle Net services. |
| •Move data between databases and files. |
| Introduction (Database Architecture) |
| Describe course objectives |
| Explore the Oracle 10g database architecture |
| Installing the Oracle Database Software |
| Explain core DBA tasks and tools |
| Plan an Oracle installation |
| Use optimal flexible architecture |
| Install software with the Oracle Universal Installer (OUI) |
| Creating an Oracle Database |
| Create a database with the Database Configuration |
| Assistant (DBCA) |
| Create a database design template with the DBCA |
| Generate database creation scripts with the DBCA |
| Managing the Oracle Instance |
| Start and stop the Oracle database and components |
| Use Enterprise Manager (EM) |
| Access a database with SQL*Plus and iSQL*Plus |
| Modify database initialization parameters |
| Understand the stages of database startup |
| View the Alert log |
| Use the Data Dictionary |
| Managing Database Storage Structures |
| Describe table data storage (in blocks) |
| Define the purpose of tablespaces and data files |
| Understand and utilize Oracle Managed Files (OMF) |
| Create and manage tablespaces |
| Obtain tablespace information |
| Describe the main concepts and functionality of Automatic |
| Storage Management (ASM) |
| Administering User Security |
| Create and manage database user accounts |
| Authenticate users |
| Assign default storage areas (tablespaces) |
| Grant and revoke privileges |
| Create and manage roles |
| Create and manage profiles |
| Implement standard password security features |
| Control resource usage by users |
| Managing Schema Objects |
| Define schema objects and data types |
| Create and modify tables |
| Define constraints |
| View the columns and contents of a table |
| Create indexes, views and sequences |
| Explain the use of temporary tables |
| Use the Data Dictionary |
| Managing Data and Concurrency |
| Manage data through SQL |
| Identify and administer PL/SQL Objects |
| Describe triggers and triggering events |
| Monitor and resolve locking conflicts |
| Managing Undo Data |
| Explain DML and undo data generation |
| Monitor and administer undo |
| Describe the difference between undo and redo data |
| Configure undo retention |
| Guarantee undo retention |
| Use the undo advisor |
| Implementing Oracle Database Security |
| Describe DBA responsibilities for security |
| Apply the principal of least privilege |
| Enable standard database auditing |
| Specify audit options |
| Review audit information |
| Maintain the audit trail |
| Configuring the Oracle Network |
| Environment |
| Use Enterprise Manager for configuring the Oracle network |
| environment |
| Create additional listeners |
| Create Net Service aliases |
| Configure connect-time failover |
| Control the Oracle Net Listener |
| Test Oracle Net connectivity |
| Identify when to use shared versus dedicated servers |
| Proactive Maintenance |
| Use statistics |
| Manage the Automatic Workload Repository (AWR) |
| Use the Automatic Database Diagnostic Monitor (ADDM) |
| Describe advisory framework |
| Set alert thresholds |
| Use server-generated alerts |
| Use automated tasks |
| Performance Management |
| Use Enterprise Manager pages to monitor performance |
| Use the SQL Tuning Advisor |
| Use the SQL Access Advisor |
| Use Automatic Shared Memory Management |
| Use the Memory Advisor to size memory buffers |
| Use performance related dynamic views |
| Troubleshoot invalid or unusable objects |
| Backup and Recovery Concepts |
| Identify the types of failure that may occur in an Oracle |
| Database |
| Describe ways to tune instance recovery |
| Identify the importance of checkpoints, redo log files, and |
| archived log files |
| Configure ARCHIVELOG mode |
| Performing Database Backups |
| Create consistent database backups |
| Back your database up without shutting it down |
| Create incremental backups |
| Automate database backups |
| Monitor the flash recovery area |
| Performing Database Recovery |
| Recover from loss of a control file |
| Recover from loss of a redo log file |
| Perform complete recovery following the loss of a data file |
| Performing Flashback |
| Describe Flashback database |
| Restore the table content to a specific point in the past with |
| Flashback Table |
| Recover from a dropped table |
| View the contents of the database as of any single point in |
| time with Flashback Query |
| See versions of a row over time with Flashback Versions |
| Query |
| View the transaction history of a row with Flashback |
| Transaction Query |
| Moving Data |
| Describe available ways for moving data |
| Create and use directory objects |
| Use SQL*Loader to load data from a non-Oracle database |
| (or user files) |
| Explain the general architecture of Data Pump |
| Use Data Pump Export and Import to move data between |
| Oracle databases |
