Overview/Description To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled Target Audience Database administrators, application developers, and database operators Prerequisites Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata...

Overview/Description To manage dependencies and recompile PL/SQL units Target Audience Database administrators, application developers, and database operators Prerequisites Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata Expected Duration (hours) 1.4 Lesson ObjectivesManaging Dependencies retrieve local dependency information for a given...

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...