Oracle Database 10g

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