Delegates will learn how to:

• 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 SQLPlus and iSQLPlus; 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 user; 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 SQLLoader 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; Use external tables to move data via platform-independent files

• Database Administrators
• Support Engineer
• Sales Consultants
• Technical Consultant
• Database Designers
• Project Manager