Overview/Description To provide an overview of Oracle database and instance architecture and demonstrate how to use the Database Configuration Assistant Target Audience Anyone wanting to learn about Oracle Database 10g database administration Prerequisites An understanding of database concepts and technologies Expected Duration (hours) 2.3 Lesson ObjectivesOracle Database 10g: Creating Databases Release 2 identify the files and logical storage units that make up the Oracle database. recognize the characteristics of the Oracle instance and its management interfaces. distinguish between the...

Overview/Description To explain how to use SQL and SQL*Plus to access an Oracle 10g database and introduce other common database interfaces Target Audience Anyone wanting to learn about Oracle Database 10g database administration Prerequisites An understanding of database concepts and technologies Expected Duration (hours) 3.0 Lesson ObjectivesOracle Database 10g: Database Interfaces Release 2 identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus. recognize how to use the DESCRIBE, PROMPT, and SELECT commands to work with data. recognize how to...

Overview/Description To discuss how to manage backup and recovery in an Oracle 10g database Target Audience Anyone wanting to learn about Oracle Database 10g database administration Prerequisites An understanding of database concepts and technologies Expected Duration (hours) 4.0 Lesson ObjectivesOracle Database 10g: Managing Backup and Recovery Release 2 recognize the types of database failure that can occur in an Oracle 10g database and identify possible solutions. recognize how to tune instance recovery and configure a database for maximum recoverability. recognize how to multiplex the...

Overview/Description To discuss how to manage undo data and manage lock conflicts in an Oracle database Target Audience Anyone wanting to learn about Oracle Database 10g database administration Prerequisites An understanding of database concepts and technologies Expected Duration (hours) 1.8 Lesson ObjectivesOracle Database 10g: Managing Undo Data and Lock Conflicts Release 2 identify factors to take into consideration when managing undo. recognize how to estimate required tablespace size and resize a tablespace in a given scenario. calculate undo tablespace sizing and resize an undo...