Oracle Certified Associate                                                                                                            
1 Month
DBA Fundamentals I
Exam 1Z0-031: Oracle9i Database Fundamentals I

• Oracle Architectural Components
• Getting Started with the Oracle Server
• Managing an Oracle Instance
• Creating a Database
• Data Dictionary

• Maintaining the Control File
• Maintaining Redo Log Files
• Managing Tablespaces and Data Files
• Storage Structure and Relationships
• Managing Undo Data
• Managing Tables
• Managing Indexes
• Maintaining Data Integrity
• Managing Password Security and Resources
• Managing Users
• Managing Privileges
• Managing Roles
• Using Globalization Support

Introduction to SQL
Exam 1Z0-007: Introduction to Oracle9i: SQL

• Writing Basic SQL Select Statements
• Restricting and Sorting Data
• Single-Row Functions
• Displaying Data from Multiple Tables
• Aggregating Data using Group Functions
• Subqueries
• Producing Readable Output with iSQL*Plus
• Manipulating Data
• Creating and Managing Tables
• Including Constraints
• Creating Views
• Creating Other Database Objects
• Controlling User Access