Oracle

Oracle Database 10g is Oracle's revolutionary new grid offering for database administrators, which include breakthrough self-management, storage management, and clustering features. It is designed to relieve system administrators from repetitive, low-value administrative work and provide them with an opportunity to increase their value and expand their technical skills. The new Oracle University curriculum tracks for Oracle Database 10g are tailored to the scale and needs of customers' data centers. These new courses target current and new Oracle Database Administrators and provide training in half the time and half the cost.

Oracle Database 10g offers many new tools that help DBAs work more efficiently (and perhaps more enjoyably), freeing them for more strategic, creative endeavors-not to mention their nights and weekends. Oracle Database 10g really is that big of a deal for DBAs.

SQL & Database Fundamentals

• Introduction to Databases
• DDL & DML
• Writing SQL statements
• Using the Oracle SQL Developer Environment
• Creating & Managing Tables
• Restricting Data
• Sorting Data
• SQL Functions
• Conditional Expressions
• Aggregating Data Using Group Functions
• Displaying Data From Multiple Tables
• Using Sub Queries
• Inserting, Updating & Deleting Data
• SQL Joins, Procedures & Triggers
• Database Transactions

---

Oracle Database 10g Administration

• Installing the Oracle Database Software on Windows & Linux
• Creating an Oracle Database
• Managing the Oracle Instance
• Managing Database Storage Structures
• Administering User Security
• Managing Schema Objects
• Managing Data and Concurrency
• Managing Undo Data
• Implementing Oracle Database Security
• Configuring the Oracle Network Environment
• Proactive Maintenance
• Performance Management
• Backup and Recovery Concepts
• Performing Database Backups

---

Advance Administration

• Configuring Recovery Manager
• Using Recovery Manager
• Oracle Secure Backup
• Recovering from Non-critical Losses
• Incomplete Recovery
• Flashback
• Dealing with Database Corruption
• Monitoring and Managing Memory
• Automatic Performance Management
• Monitoring and Managing Storage I
• Monitoring and Managing Storage II
• Automatic Storage Management
• VLDB Support
• Managing Resources
• Automating Tasks with the Scheduler
• Database Security
• Data Movement
• Using Globalization Support