Explore the Lifecycle Development Phases

• Define a database
• Discuss the theoretical, conceptual and physical aspects of a relational database
• Describe the Oracle implementation of the RDBMS and the ORDBMS
• Describe PL/SQL

Write and Execute a Basic SQL Statement

• Describe the SQL SELECT capabilities
• Differentiate between SQL and SQL*Plus commands
• Limit and sort the rows retrieved by a query
• Customize the SQL*Plus environment
• Save customizations

Examine Single Row Functions

• Use a variety of character, number, and date functions in SELECT statements
• Describe different types of join
• Insert and update rows in a table
• Delete rows from a table
• Group functions and their uses
• Define subqueries
• Write single-row, multi-row, and multi-column subqueries
• Control transactions

Create Tables and Views

• Describe the Oracle7 datatypes and the Oracle8 datatypes
• Alter table definitions
• Drop, rename and truncate tables
• Use logic tables
• Retrieve data via a view
• Insert, update and delete data through views
• Drop views
• Alter the definition of a view
• Create and maintain sequences and indexes

Control User Access

• Understand the concepts of users, roles, and privileges
• GRANT and REVOKE object privileges
• Create private and public synonyms
• Declare variables and constants
• Recognize and execute a basic PL/SQL block
• Distinguish between PL/SQL and non-PL/SQL variables

Write Executable Statements

• List the rules of nested blocks
• Write DML statements in PL/SQL
• Control transactions in PL/SQL
• Identify the types of control structures and loop statements
• Construct an IF statement
• Control block flow using nested loops and labels

Work with Composite Datatypes

• Create user-defined PL/SQL records
• Create a PL/SQL table and a PL/SQL table of records
• Use PL/SQL record and table variables
• Distinguish between the implicit and explicit cursor
• Write a cursor FOR loop

Handle Exceptions

• Define PL/SQL exceptions and recognize unhandled exceptions
• List different types of PL/SQL exception handlers
• Trap unanticipated errors
• Customize PL/SQL exception messages

Manage an Oracle Database

• Start up and shut down a database
• Create an operational database
• Manage Oracle database files
• Maintain redo log files
• Manage tablespaces and data files
• Manage rollback and temporary segments
• Manage tables, indexes, and physical storage
• Examine and manage extents and blocks

Ensure Data Integrity

• Maintain data integrity constraints
• Use clusters and index-organized tables
• Load and reorganize data
• Manage security

Manage Database Users

• Enroll, monitor and drop database users
• Create and manage default and specific user profiles
• Grant database privileges
• Manage roles and resources
• Examine auditing
• Specify National Language Support (NLS)
• Use NLS features

Describe Backup and Recovery Strategies

• List the key issues involved when defining an effective backup and recovery strategy
• Discuss methods for restoring Oracle recovery structures and processes
• Examine Oracle backup and recovery configuration
• Implement different types of backup methods using the various Oracle DBA tools

List the Components of the Oracle Recovery Manager Architecture

• Discuss Oracle recovery catalog maintenance
• List the different Oracle backup methods
• Examine physical backups with and without Oracle recovery manager
• Examine logical backups using the Export utility
• Use appropriate restore and recovery operations to resolve database failure
• Diagnose and troubleshoot database problems and failures

Practice Recovery Methods

• Recover a database with and without archiving
• Study complete and incomplete Oracle recovery with archiving
• View Oracle export/import utilities
• Discuss Oracle standby databases
• Configure a standby database to minimize primary database down-time
• Develop confidence of recovery techniques through various workshop scenarios

Explore Oracle Performance Tuning Methodology

• Discuss the nature of tuning
• List available Oracle diagnostic tools
• Discuss views, utilities and files
• Outline a tuning methodology
• Explain the primary importance of SQL tuning
• Examine operating system related issues
• Tune the Shared Pool memory structure, the Buffer Cache memory structure and the Redolog Buffer memory structure

Examine Database Configuration and I/O Issues

• Describe space management and performance
• Diagnose and resolve performance issues associated with the multi-threaded server
• Optimize sort operations
• Configure memory and disk resources to optimize sort operations
• Identify and resolve I/O, data storage and database configuration issues

Tune Rollback Segments

• Check rollback segment performance
• Monitor and detect lock contention
• Understand latch contention and discuss additional contention issues
• Examine user connection and Network tuning
• Tune with Oracle Expert
• Discuss workshop scenarios

Overview of Basic Net8 Architecture

• Examine basic Net8 server and client configuration
• Configure a net8 client and server node
• Establish a connection between a Net8 client and server node

Explore the Usage and Configuration of Oracle Names

• Configure Oracle Names to resolve a service name
• Start up, and shut down the Oracle Intelligent Agent for OEM
• Configure and start up a multi-threaded server
• Configure the Connection Manager to perform connection pooling and connection restriction

Troubleshoot the Network Environment

• Discuss security In the Network environment
• Identify network security risks and related Oracle solutions
• Use logging, tracing, and Network Assistant to help identify network problem