Oracle Database 10g: Administration I en México

Lesson 1:

• Installing Oracle Database 10g Topic 1A: Install Oracle Database 10g

Lesson 2:

• Exploring the Oracle Database 10g Architecture Topic 2A: Understand Database Architecture Topic 2B: Identify Database Object Types Topic 2C: Recognize the Oracle Instance Topic 2D: Understand the User Connection Process Topic 2E: Identify Resources for the DBA

Lesson 3:

• Creating a Database Topic 3A: Create, Configure, and Delete a Database Using the DBCA Topic 3B: Use Client and Administration Tools

Lesson 4:

• Configuring Oracle Net Services Topic 4A: Examine Oracle Net Services Topic 4B: Perform Basic Oracle Net Server-Side Configuration Topic 4C: Perform Basic Oracle Net Client-Side Configuration Topic 4D: Configure Oracle Shared Server Topic 4E: Configure Connect-Time Failover

Lesson 5:

• Using SQL and PL/SQL Topic 5A: Write Simple SQL SELECT Statements Topic 5B: Filter and Sort Data Topic 5C: Work with SQL Functions Topic 5D: Work with Multiple Tables Topic 5E: Modify Data Topic 5F: Control Database Transactions Topic 5G: Explore PL/SQL

Lesson 6:

• Managing the Database Instance Topic 6A: Obtain Instance Information Topic 6B: Manage the Database Instance Topic 6C: Organize Database Objects Topic 6D: Describe Database Objects and Their Storage

Lesson 7:

• Managing Tablespaces and Datafiles Topic 7A: Manage Tablespaces Topic 7B: Find Tablespace and Datafile Information Topic 7C: Resize and Drop Tablespaces Topic 7D: Configure Oracle Managed Files

Lesson 8:

• Managing Tables and Indexes Topic 8A: Create Tables Topic 8B: Gather and Analyze Table Information Topic 8C: Create Indexes Topic 8D: Implement Integrity Constraints Topic 8E: Maintain Integrity Constraints

Lesson 9:

• Creating Views and Sequences Topic 9A: Create Views Topic 9B: Create Sequences

Lesson 10:

• Managing Users and Security Topic 10A: Manage Users Topic 10B: Manage Privileges and Roles Topic 10C: Manage Passwords and Resource Limits Topic 10D: Audit Database Usage

Lesson 11:

• Monitoring Performance Topic 11A: Manage Locks Topic 11B: Gather and Use Tuning and Troubleshooting Information

Lesson 12:

• Loading and Unloading Data Topic 12A: Manage Data Using the Data Pump Topic 12B: Move Tablespaces Topic 12C: Load Data Using SQL*Loader Topic 12D: Create and Access External Tables

Lesson 13:

• Managing Undo Data Topic 13A: Configure Undo Segments and Tablespaces Topic 13B: Understand Automatic Undo Retention

Lesson 14:

• Administering and Performing Backups Topic 14A: Create Redo Log Groups and Members Topic 14B: Plan and Configure the Online Redo Log Group Topic 14C: Manage and Maintain Control Files Topic 14D: Back Up the Database Topic 14E: Examine Recovery Manager Concepts

Lesson 15:

• Administering and Performing Recovery Operations Topic 15A: Manage Recovery Topic 15B: Employ User-Managed and RMAN Recovery Topic 15C: Tune Database Recovery

Appendix A:

• Formatting SQL*Plus Output