Skillport Login

Exam 1Z0-051: Oracle Database 11g: SQL Fundamentals I Curriculum Outline

Oracle Database 11g: Using SQL to Query Your Database

Overview/Description
To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting, modifying, and formatting this information.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites

Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)

Expected Duration

2 Hours

Objectives :

Oracle Database 11g: Using SQL to Query Your Database

identify the functions, capabilities, and terminology associated with Oracle Database 11gs components and relational databases in general.

recognize the steps for using Oracle SQL Developer to create a new database connection and browse tables.

recognize the steps for using the SQL SELECT statement to retrieve different sets of data from a database.

recognize the steps for limiting and ordering the rows returned by a SQL query.

recognize ways to sort data returned by a SQL query, using substitution variables as well as the DEFINE and VERIFY commands.

recognize the steps for using SQL functions to modify, format, and otherwise manipulate returned data.

identify and write SQL queries to display, sort, and format output in a given scenario.

Back to List

Oracle Database 11g: Conversion Functions, Group Functions, and Joins

Overview/Description
To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites

Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)

Expected Duration

2 Hours

Objectives :

Oracle Database 11g: Conversion Functions, Group Functions, and Joins

identify the steps for using functions to convert character, date, and numeric values and perform operations pertaining to null values.

recognize the steps for using the CASE expression and the DECODE function to implement conditional processing.

identify and write queries that convert data types and implement conditional processing, in a given scenario.

recognize the benefits of using group functions to return values for groups of rows.

identify the steps for creating, restricting, and nesting group functions.

identify the steps for using joins to return data from more than one table.

write queries that calculate values for groups of data and return values from multiple tables in a given scenario.

Back to List

Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms

Overview/Description
To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites

Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)

Expected Duration

1.75 Hours

Objectives :

Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms

recognize the steps for creating, defining, and naming a table, and for specifying data types for its columns.

recognize the steps for using constraints to prevent invalid data entry into tables.

recognize the steps for altering or dropping a table.

identify the steps for creating and manipulating views to view or hide a tables data.

recognize the steps for using seqences to create integers, using indexes to improve the performance of queries, and using synonyms to give a table an alternative name.

create a new table and create and use a sequence, index, and synonym.

Back to List

Oracle Database 11g: Using Subqueries and Regular Expressions

Overview/Description
To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).

Expected Duration (hours)
1.8

Lesson Objectives
Oracle Database 11g: Using Subqueries and Regular Expressions

Identify the steps for writing multiple-column and scalar subqueries.

Recognize the steps for solving problems by using correlated subqueries and the WITH clause.

Write multiple-column, correlated, and scalar subqueries in a given scenario and solve a problem using the WITH clause.

Recognize the benefits of implementing complex match logic in the database, using regular expressions.

Identify the steps for using regular expressions functions and for accessing subexpressions.

Use regular expression functions to search for, replace, and manipulate data, and also add a CHECK constraint to a column.

Back to List

Exam 1Z1-052: Oracle Database 11g: Administration I Curriculum Outline

Oracle Database 11g: Database Architecture and Installation

Overview/Description
Identify the elements of the Oracle Database 11g architecture and recognize the tools and steps required to install the Oracle Database 11g software

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisites

A working knowledge of SQL

Expected Duration

120 Minutes

Objectives :

Oracle Database 11g: Database Architecture and Installation

Identify the main structural components of Oracle Database 11g.

Identify the components of the Oracle Database 11g memory structures.

Identify the functions of the Oracle Database 11 server and background processes.

Recognize how information is stored and structured within the Oracle Database 11g storage architecture.

Identify the necessary tasks and essential tools required to administer an Oracle Database 11g database.

Recognize the steps for planning and carrying out an installation of Oracle Database 11g software using the Oracle Universal Installer (OUI).

Install Oracle Database 11g software in a given scenario.

Back to List

Oracle Database 11g: Database Creation, Instance Management, and Connectivity

Overview/Description
Identify the steps for creating a new Oracle Database 11g database and then configuring it and managing the instance, and also recognize the steps for configuring new Oracle Net Listeners and database connectivity

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisites

A working knowledge of SQL

Expected Duration

150 Minutes

Objectives :

Oracle Database 11g: Database Creation, Instance Management, and Connectivity

Recognize the steps for creating, configuring, or deleting a database using the Database Configuration Assistant (DBCA), and also for managing a database instance using various Oracle tools.

Recognize the scope and capabilities of Oracle Database 11g initialization parameters and identify the steps for maintaining them.

Recognize the steps for configuring database startup and shutdown options, administering a blackout, and using alerts and dynamic data to assess database performance.

Recognize the steps for using the Data Dictionary to find information about users, objects, constraints, and storage.

Create a database using the DBCA and manage instances using Enterprise Manager.

Recognize ways of configuring and managing the Oracle network, and identify the steps for creating a new Oracle Net Listener via Enterprise Manager.

Identify the steps for connecting to an Oracle Database 11g database using different naming methods as well as advanced connection options, and identify when to employ connection pooling.

Identify the steps for using and configuring Oracle Net Services in a given scenario.

Back to List

Oracle Database 11g: Storage Structures and User Security

Overview/Description
identify the steps for maintaining storage structures and automating storage management in Oracle Database 11g, and for managing privileges, roles, and other security features for users.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisites

A working knowledge of SQL

Expected Duration

150 Minutes

Objectives :

Oracle Database 11g: Storage Structures and User Security

Recognize the purposes of table spaces and datafiles.

Recognize the steps for creating a new tablespace.

Recognize how to manage the storage of information by maintaining tablespaces and viewing their information, and automating manual storage using Automatic Storage Management (ASM).

View tablespace information and create a new tablespace.

Recognize the steps for creating and authenticating database user accounts.

Recognize the steps for granting and revoking privileges and creating and managing roles.

Recognize the steps for creating and managing profiles, implementing password security, and assigning quotas.

Grant privileges to users in a given scenario.

Back to List

Oracle Database 11g: Managing the Schema, Data, and Concurrency

Overview/Description
Identify the steps for managing schema objects, such as tables, views, and indexes, and recognize ways to use SQL and PL/SQL commands to manipulate data and ensure data concurrency

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisites

A working knowledge of SQL

Expected Duration

120 Minutes

Objectives :

Oracle Database 11g: Managing the Schema, Data, and Concurrency

Recognize the features and functions of schemas and data types, and identify the steps for modifying a table.

Recognize the steps for using constraints to maintain data integrity, viewing the contents of a table, and perform actions on the table.

Recognize ways of improving data update and retrieval, storing queries, speeding up performance by creating and using indexes, views, sequences, and temporary tables.

Create a table with columns and also create constraints and indexes, in a given scenario.

Recognize ways for manipulating data with SQL commands and for administering PL/SQL objects.

Recognize the steps for triggering events, and for monitoring and resolving locking conflicts.

Back to List

Oracle Database 11g: Managing Undo Data, Database Security, and Maintenance

Overview/Description
recognize the steps required to manage undo information, secure an Oracle Database 11g database, and maintain it by monitoring statistics, automated tasks and alert thresholds.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisites

A working knowledge of SQL

Expected Duration

145 Minutes

Objectives :

Oracle Database 11g: Managing Undo Data, Database Security, and Maintenance

Recognize the steps for managing undo operations in Oracle Database 11g to allow users to roll back transactions.

Recognize the requirements and best practices for implementing database security according to international and regional laws.

Recognize the steps for enabling, specifying, maintaining, and reviewing database auditing.

Recognize the process for obtaining and applying Critical Patch Updates (CPUs).

Configure an Oracle Database 11g database to support retention and implement database security in a given scenario.

Recognize the steps for managing and gathering optimizer statistics.

Identify the steps for managing Automatic Workload Repository (AWR) statistics, using the Automatic Database Diagnostic Monitor (ADDM), and utilizing advisors.

Identify the steps for viewing and configuring automated tasks and setting alert thresholds.

Back to List

Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup

Overview/Description
identify the steps for ensuring an Oracle Database 11g database is available to users when needed, by monitoring its performance, anticipating and avoiding database failure, setting up instance recovery options, and creating backups.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisites

A working knowledge of SQL

Expected Duration

120 Minutes

Objectives :

Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup

Identify the steps for monitoring and analyzing performance, managing memory, and troubleshooting invalid objects that affect performance.

Recognize ways to anticipate and avoid various types of failure that can occur in Oracle Database 11g.

Recognize the process used to configure an Oracle Database 11g database for instance recovery.

Recognize the features of different backup strategies you can employ in Oracle Database 11g.

Recognize the steps for using RMAN to configure, schedule, manage, and view backup operations.

Resolve performance issues, prepare the database for recovery, and perform a database backup in a given scenario.

Back to List

Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database

Overview/Description
recognize ways to make use of Oracle Database 11gs tools for moving and recovering data, reporting on problems, and installing updates to enhance a database.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisites

A working knowledge of SQL

Expected Duration

130 Minutes

Objectives :

Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database

Recognize the tools required and steps performed in identifying whether a recovery is necessary, and then recovering various types of database files.

Recognize the features of the various options for moving data in Oracle Database 11g.

Recognize the steps for importing, exporting, and moving data between Oracle databases using Oracle Data Pump.

Recover the database from a media failure and move data using the Data Pump Wizard in a given scenario.

Recognize the steps for using the Enterprise Manager Support Workbench and Oracle Support to investigate, report on, and resolve problems.

Recognize the steps for searching MetaLink for new critical patches and for logging service requests.

Recognize ways for managing and applying patches in Oracle Database 11g.

Back to List

Exam 1Z0-042: Oracle Database 10g: Administration I Curriculum Outline

Oracle Database 10g: Installing Oracle Database 10g

Overview/Description
To introduce the concepts of RDBMS and Oracle database administration, and explain how to install Oracle Database 10g software

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration
2.25 Hours

Oracle Database 10g: Installing Oracle Database 10g

• Recognize the characteristics of a relational database system
• Identify the basic tasks involved in Oracle database administration
• Identify the basic concepts involved in RDBMS and Oracle database administration
• Identify the components involved in the Oracle preinstall process
• Recognize how to configure the Oracle install environment using the Oracle Universal Installer
• Recognize how to configure the Oracle Database 10g installation
• Install Oracle Database 10g on a UNIX operating system

Back to List

Oracle Database 10g: Creating Databases

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
2.25 Hours

Oracle Database 10g: Creating Databases

• 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 basic components of Oracle database architecture
• Recognize how to configure database identification, management, password, and storage options using the Database Configuration Assistant
• Recognize how to use the Database Configuration Assistant to set file locations and parameters
• Recognize how to set database storage settings and creation options, and delete a database using the Database Configuration Assistant
• Create an Oracle database, and delete one, using the Database Configuration Assistant

Back to List

Oracle Database 10g: Database Interfaces

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
3 Hours

Oracle Database 10g: Database Interfaces

• 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 join tables and use DML and DDL statements to manipulate and define data
• Identify the functions of different SQL statements and recognize the function of data locking
• Identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus
• Use SQL*Plus and iSQL*Plus to manage data
• Identify the basic elements of PL/SQL and recognize the uses of PL/SQL
• Identify the characteristics of some common database interfaces
• Identify how Oracle works with common database interfaces

Back to List

Oracle Database 10g: Database Control and Storage Structures

Overview/Description
To explain the fundamentals of Oracle database control and how to use tablespaces

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration
2.25 Hours

Oracle Database 10g: Database Control and Storage Structures

• Recognize how to use the Oracle Database 10g management framework
• Recognize how to start up and shut down an Oracle database
• Identify the characteristics of initialization parameters and the alert log and recognize how to view them
• Start and stop the Oracle Enterprise Manager Database Control, Oracle Listener, and Oracle Database 10g instance
• Recognize how to create tablespaces
• Recognize how to manipulate tablespaces in an Oracle database
• View tablespace information and create a tablespace

Back to List

Oracle Database 10g: Users and Security

Overview/Description
To explain how to manage users, implement security, and audit database activity on 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
3.25 Hours

Oracle Database 10g: Users and Security

• Recognize how to create user accounts and profiles
• Recognize how to grant privileges and assign quotas to users
• Recognize how to create a role and assign it to a user
• Administer user accounts on an Oracle 10g database
• Recognize how to restrict access to an Oracle database
• Recognize how to implement database security by configuring user profiles
• Implement password security by configuring user profiles
• Recognize how to monitor database activity using Oracles built-in audit tools
• Recognize how to implement fine-grained auditing in an Oracle 10g database
• Audit database activity in an Oracle 10g database

Back to List

Oracle Database 10g: Managing Schema Objects and Data

Overview/Description
To demonstrate how to manage schema objects and data 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
3 Hours

Oracle Database 10g: Managing Schema Objects and Data

• Identify the basic features of objects in a database schema
• Recognize how to create and modify tables in an Oracle 10g database
• Create, delete, and modify tables in an Oracle 10g database
• Recognize how to create indexes and views and use sequences in an Oracle 10g database
• Work with indexes, views, and sequences in an Oracle 10g database
• Manipulate tables, indexes, and views in an Oracle 10g database
• Recognize how to manage data using the INSERT, UPDATE, DELETE, COMMIT, and ROLLBACK commands
• Recognize how to use Oracles Data Pump to export and import data
• Export and import data using Oracles Data Pump utility

Back to List

Oracle Database 10g: The SQL* Loader and PL/SQL

Overview/Description
To provide an overview of how to use the SQL*Loader and PL/SQL 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
2 Hours

Oracle Database 10g: The SQL* Loader and PL/SQL

• Identify the function of the SQL* Loader and the files it uses
• Recognize how to load data using the SQL* Loader
• Load data using the SQL*Loader
• Identify the characteristics of PL/SQL objects, functions, and procedures
• Recognize the characteristics of PL/SQL packages and triggers and identify the configuration options that control PL/SQL performance
• Recognize the basic concepts of PL/SQL

Back to List

Oracle Database 10g: Oracle Net Services and Shared Servers

Overview/Description
To provide an overview of Oracle Net Services and Shared Server

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration
2.75 Hours

Oracle Database 10g: Oracle Net Services and Shared Servers

• Recognize how to create and configure an Oracle Net listener in Oracle Database 10g
• Recognize how to monitor Oracle Net Services using the Listener Control utility
• Create and configure an Oracle Net Listener
• Configure local name resolution in a given scenario
• Configure local Oracle Net Services aliases
• Recognize how to configure advanced connection options and test Oracle Net connectivity
• Distinguish between Oracle server connection types
• Distinguish between the initialization parameters used to configure Shared Server
• Recognize how to monitor Shared Server
• Configure and verify Shared Server

Back to List

Oracle Database 10g: Monitoring and Maintenance

Overview/Description
To demonstrate how to control database performance and configure proactive database maintenance

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration
2.75 Hours

Oracle Database 10g: Monitoring and Maintenance

• Repair invalid and unusable objects
• Detect and repair unusable indexes
• Recognize how to monitor performance using dynamic performance views, Enterprise Manager, and optimizer statistics
• Gather optimizer statistics for a database schema
• Set thresholds and baselines for performance metrics
• Identify the functions of various tuning and diagnostic advisors and use the segment advisor to detect storage problems in a given scenario
• Recognize how to manage the AWR and use the ADDM to review database performance
• Configure a database for proactive maintenance

Back to List

Oracle Database 10g: Managing Undo Data and Lock Conflicts

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
1.75 Hours

Oracle Database 10g: Managing Undo Data and Lock Conflicts

• 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 tablespace
• Recognize how locks are used to ensure concurrent user access to a database
• Manage lock conflicts
• Detect and resolve lock conflicts

Back to List

Oracle Database 10g: Managing Backup and Recovery

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
2.75 Hours

Oracle Database 10g: Managing Backup and Recovery

• 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 Oracle 10g redo log and archive redo log files
• Configure a database for backup and recovery
• Recognize how to configure and manage database backups
• Recognize how to schedule database backups and back up control files to trace
• Configure database backups
• Back up a database
• Identify the types of media failure that can cause an instance to fail
• Recover from the loss of control files, redo log files, and datafiles
• Recover a database

Back to List

Exam 1Z0-311: Oracle Application Server 10g: Administration I Curriculum Outline

Oracle Application Server 10g: Introduction

Overview/Description
To provide an introduction to OracleAS architecture, components, and installation options

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
1.25 Hours

Oracle Application Server 10g: Introduction

• Identify the solution areas and terminology associated with OracleAS
• Distinguish between the components of some of the solution areas of OracleAS
• Distinguish between the components of selected solution areas of OracleAS
• Identify how OracleAS middle-tier installation types can be deployed
• Determine an OracleAS installation type for a given scenario

Back to List

Oracle Application Server 10g: Infrastructure and Middle Tier Installation

Overview/Description
To demonstrate how to prepare for, execute, and verify OracleAS Infrastructure and Middle Tier installation

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
2.75 Hours

Oracle Application Server 10g: Infrastructure and Middle Tier Installation

• Determine any issues that need to be addressed before the installation of OracleAS Infrastructure
• Select the necessary options when initiating OracleAS Infrastructure installation in a given scenario
• Complete an OracleAS Infrastructure installation
• Perform OracleAS Infrastructure postinstallation tasks
• Prepare for, execute, and verify an installation of OracleAS Infrastruture
• Perform an installation of OracleAS Middle Tier
• Perform OracleAS Middle Tier postinstallation tasks
• Execute and verify an installation of OracleAS Middle Tier

Back to List

Oracle Application Server 10g: Management Tools and Oracle Internet Directory

Overview/Description
To demonstrate how to use OracleAS management tools and manage the Oracle Internet Directory (OID)

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
2.75 Hours

Oracle Application Server 10g: Management Tools and Oracle Internet Directory

• Perform some basic management tasks from the home pages of Application Server Control
• Perform some basic process management tasks using the opmnctl utility in OracleAS
• Perform management tasks using the dcmctl utility
• Perform management tasks with emctl, opmnctl, and dcmctl utilities in OracleAS
• Define the role and security benefits of Oracle Internet Directory (OID)
• Identify the architecture of the OID server instance and OID node
• Stop and start an OID server instance in OracleAS
• Identify the commands used to manage data in the directory server and launch Oracle Directory Manager
• Perform some OID process and directory management tasks in a given scenario

Back to List

Oracle Application Server 10g: General Management and Directives for the HTTP Server

Overview/Description
To demonstrate how to perform general management of Oracle HTTP Server (OHS)

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
4 Hours

Oracle Application Server 10g: General Management and Directives for the HTTP Server

• Recognize the server-level directives used to set Oracle HTTP Server (OHS) processes and connections
• Identify the role of Oracle HTTP Server (OHS) files and file-location directives in OracleAS
• Perform the steps to change HTTP server properties in OracleAS
• Configure some properties of Oracle HTTP Server (OHS) in OracleAS in a given scenario
• View and edit HTTP server logs in OracleAS
• Use Application Server Control to modify advanced server properties and enable status-report generation for Oracle HTTP Server (OHS)
• Perform the tasks to update Oracle HTTP Server (OHS) logs and configuration files in OracleAS in a given scenario
• Recognize the key concepts associated with Oracle HTTP Server (OHS) configuration
• Define container directives for an HTTP server in OracleAS
• Use the Options and AllowOverrides directives and appropriate parameters to control the features that an HTTP server allows
• Use the appropriate directives to set indexing, error handling, caching behavior, and aliases in Oracle HTTP Server (OHS)
• Identify how to redirect HTTP server requests using mod_rewrite directives
• Define directives for an HTTP server in a given scenario

Back to List

Oracle Application Server 10g: OracleAS Web Cache

Overview/Description
To demonstrate how to administer and configure OracleAS Web Cache

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
2.25 Hours

Oracle Application Server 10g: OracleAS Web Cache

• Recognize the key concepts and administration tasks associated with OracleAS Web Cache
• Perform general administration tasks for OracleAS Web Cache
• Perform basic OracleAS Web Cache administration tasks in a given scenario
• Configure site definitions and server mappings for OracleAS Web Cache
• Create and configure caching rules for OracleAS Web Cache
• Configure basic cache-content invalidation in OracleAS
• Configure logging in OracleAS Web Cache
• Configure different elements of OracleAS Web Cache in a given scenario

Back to List

Oracle Application Server 10g: OracleAS Portal

Overview/Description
To demonstrate how to manage OracleAS Portal

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
3 Hours

Oracle Application Server 10g: OracleAS Portal

• Define the roles of the key utilities of OracleAS Portal
• Create and manage OracleAS Portal schemas and users
• Perform some of the core management tasks associated with OracleAS Portal groups
• Perform management tasks for an OracleAS Portal user and group in a given scenario
• Perform portlet repository management tasks in OracleAS Portal
• Export and import objects in OracleAS Portal
• Perform the appropriate portlet repository and export/import tasks in a given scenario
• Configure self-registration and view OraDAV configuration for OracleAS Portal
• Configure language support and portal dependencies in OracleAS Portal
• Configure some core features of OracleAS Portal in a given scenario

Back to List

Oracle Application Server 10g: mod_plsql, CGI Scripts, and Database Providers

Overview/Description
To demonstrate how to configure mod_plsql, CGI-script execution, and database providers in OracleAS

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
2 Hours

Oracle Application Server 10g: mod_plsql, CGI Scripts, and Database Providers

• Define the role of the key Oracle HTTP Server (OHS) modules used to deploy PL/SQL and CGI applications
• Configure how mod_plsql connects to a database server to fulfill HTTP requests
• Recognize the syntax for invoking a PL/SQL application and configure caching for mod_plsql
• Configure different elements of mod_plsql in a given scenario
• Distinguish between the entries used in an httpd.conf file to enable the execution of different types of CGI scripts
• Register the database provider with OracleAS Portal
• Perform some of the steps to configure Oracle for Fast CGI and the database provider in a given scenario

Back to List

Oracle Application Server 10g: Application Management and Deployment

Overview/Description
To demonstrate how to manage and deploy applications in OracleAS

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
2.50 Hours

Oracle Application Server 10g: Application Management and Deployment

• Perform the appropriate, basic OC4J management tasks in OracleAS
• Configure OC4J server properties in OracleAS
• Perform the basic tasks for J2EE application management in OracleAS
• Manage an OC4J instance and J2EE application in OracleAS, in a given scenario
• Create a data source in OracleAS
• Deploy web-application modules and deploy complete J2EE applications in OracleAS
• Register web providers in OracleAS
• Perform the tasks to deploy an application in OracleAS

Back to List

Oracle Application Server 10g: Component Administration in Oracle Internet Directory

Overview/Description
To demonstrate how to configure Oracle Internet Directory (OID) components in OracleAS

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
1.50 Hours

Oracle Application Server 10g: Component Administration in Oracle Internet Directory

• Recognize the administration options available with Oracle Internet Directory (OID)
• Assign user and group privileges in Oracle Internet Directory (OID)
• View and modify Oracle Internet Directory (OID) password-related information in OracleAS
• Configure Oracle Internet Directory (OID) settings in OracleAS Portal
• Perform a series of Oracle Internet Directory (OID) administration tasks, in a given scenario, in OracleAS

Back to List

Oracle Application Server 10g: DAS and SSO

Overview/Description
To demonstrate how to manage users and groups with Delegated Administration Service (DAS) and administer the Single Sign-On feature of OracleAS

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
3 Hours

Oracle Application Server 10g: DAS and SSO

• Start, stop, and verify the operation of the Delegated Administrative Service (DAS) in OracleAS
• Perform key user and group administration tasks in OracleAS Delegated Administration Service (DAS)
• Configure how user entries display in OracleAS Delegated Administration Service (DAS)
• Perform service, account, and identity management realm management tasks in OracleAS Delegated Administration Service (DAS)
• Perform the tasks to manage a user and user account in OracleAS Delegated Administration Service (DAS), in a given scenario
• Sequence the steps in the OracleAS Single Sign-On (SSO) authentication process
• Perform some basic Single Sign-On (SSO) administration tasks in OracleAS
• Perform the key administration tasks for partner and external applications in OracleAS Single Sign-On (SSO)
• Perform the tasks to appropriately administer an SSO server, in a given scenario

Back to List

Oracle Application Server 10g: Component Security with SSL

Overview/Description
To demonstrate how to manage wallets and certificates and configure components for SSL in OracleAS

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
2.25 Hours

Oracle Application Server 10g: Component Security with SSL

• Outline the interactions between client and server when using SSL in OracleAS
• Perform key management tasks in Oracle Wallet Manager
• Perform certificate-management tasks in OracleAS
• Perform wallet and certificate management tasks in OracleAS, in a given scenario
• Configure SSO, Oracle Internet Directory (OID), and OracleAS Web Cache for SSL
• Configure OracleAS Portal for SSL
• Perform some of the tasks to configure SSO, OID, and OracleAS Portal for SSL

Back to List

Oracle Application Server 10g: Oracle Certificate Authority Management

Overview/Description
To demonstrate how to manage Oracle Certificate Authority (OCA)

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
1.50 Hours

Oracle Application Server 10g: Oracle Certificate Authority Management

• Identify the tools that make up the OracleAS PKI solution
• Define the key elements of the Oracle Certificate Authority (OCA) architecture
• Perform the steps to set up administration access in OracleAS Certificate Authority (OCA)
• Perform key certificate management tasks in Oracle Certificate Authority (OCA)
• Manage the Oracle Certificate Authority (OCA) server and certificates in a given scenario

Back to List

Exam 1Z0-007: Introduction to Oracle9i SQL Curriculum Outline

Introducing Oracle and SQL

Overview/Description
To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements

Target Audience
Junior database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration
3.25 Hours

Introduction to Oracle and SQL in Oracle9i

• Describe basic relational database concepts
• Define an entity relationship model for a database
• Describe the features and characteristics of an Oracle relational database management system (RDBMS) and an Oracle object relational database management system (ORDBMS)
• Discuss and write basic SELECT SQL statements
• Describe SQL statement features in an Oracle9i database
• Describe the iSQL*Plus environment and how to interact with script files
• Use iSQL*Plus in an Oracle9i database to execute SQL statements and interact with script files
• Restrict the data that a SQL statement returns by using a WHERE clause
• Sort data returned by SQL statements by using the ORDER BY clause
• Use the WHERE and ORDER BY clauses to restrict and sort query results

Back to List

Subqueries, Reporting and User-Access Control

Overview/Description
To describe the use of subqueries, reporting, and user-access control in an Oracle9i database

Target Audience
Junior database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration
2.75 Hours

Subqueries, Reporting, and User-Access Control in Oracle9i

• Describe and define subqueries and to write single-row and multiple-row subqueries for an Oracle database
• Use single-row subqueries in an Oracle database
• Use the advanced functionality of subqueries in an Oracle9i database
• Explain the concept of a hierarchical query and to explain how to create a tree-structure report in an Oracle9i database
• Explain how to produce reports using iSQL*Plus in an Oracle9i database
• Produce reports using iSQL*Plus in an Oracle9i database
• Describe how to control user access to an Oracle database
• Use roles and privileges to control user access to an Oracle database

Back to List

SQL Functions

Overview/Description
To describe how to use SQL functions for data retrieval

Target Audience
Junior database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration
5 Hours

SQL Functions in Oracle9i

• Describe and use character, number, and date functions in SELECT statements in an Oracle9i database
• Describe and use datatype conversion functions in SELECT statements in an Oracle9i database
• Describe how to use nested and conditional functions in SELECT statements in an Oracle9i database
• Use single-row functions in SELECT statements in an Oracle9i database
• Use conversion functions to convert date values in SELECT statements
• Explain how to retrieve data from multiple Oracle9i database tables using join methods
• Describe how to retrieve data from multiple Oracle9i database tables using SQL: 1999 join syntax
• Use SQL: 1999 joins to retrieve data from multiple tables in an Oracle9i database
• Describe how to use SET operators to combine multiple queries into a single query using SET operators
• Identify and to describe the use of group functions in an Oracle database
• Describe and use the GROUP BY clause for an Oracle database
• Use group functions and the GROUP BY clause in SELECT statements in an Oracle9i database
• Identify and describe the use of GROUP BY enhancements in an Oracle9i database
• Use GROUP BY enhancements in an Oracle9i database
• Describe and use the new datetime functions in an Oracle9i database

Back to List

Defining and Manipulating Data

Overview/Description
To describe how to define database objects and manipulate the data stored within them in an Oracle9i database

Target Audience
Junior database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration
3.75 Hours

Defining and Manipulating Data in Oracle9i

• Describe how to create and manage Oracle9i database tables
• Describe, create, and maintain constraints in an Oracle9i database
• Create a table, define constraints on a table, and view constraint information
• Describe how to create and manage views in an Oracle database
• Describe how to create and manage sequences, indexes, and synonyms in an Oracle database
• Create views, indexes, sequences, and synonyms in an Oracle database
• Describe how to use Oracle9i database external tables
• Describe how to insert, update, and delete data in an Oracle9i database
• Use DML statements to insert, update, and delete data from an Oracle9i database
• Explain how database transactions work in an Oracle9i database
• Explain the use of multitable INSERT statements in an Oracle9i database

Back to List

Exam 1Z0-031: Oracle9i Database: Fundamentals I Curriculum Outline

Architecture and Administration Tools in Oracle9i

Overview/Description
To describe the Oracle9i database architecture and how to use the database administration tools

Target Audience
Anyone wanting to learn about Oracle9i database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration
2.75 Hours

Architecture and Administration Tools in Oracle9i

• Describe the main components of an Oracle9i database server
• Describe the memory structures of an Oracle9i database instance
• Describe the process architecture of an Oracle9i database instance
• Explain how to use the tools used for installing and configuring an Oracle9i database as well as the optimal file architecture of a database
• Build an Optimal Flexible Architecture for an Oracle9i database installation
• Describe the database administration users, explain how database administrators access an Oracle9i database, and describe how to administer a password file
• Explain how to use the Oracle9i database tools and how to manage a database environment
• Create a password file and add an administrative user to the file

Back to List

Database and Instance Management in Oracle9i

Overview/Description
To describe how to manage an Oracle9i database instance and how to plan and create a database

Target Audience
Anyone wanting to learn about Oracle9i database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration
2.25 Hours

Database and Instance Management in Oracle9i

• Describe the two types of initialization files available in an Oracle9i database
• Start up and shut down an Oracle9i database instance
• Update an SPFILE and reopen an Oracle9i database using the Oracle Enterprise Manager
• Plan for the creation of an Oracle9i database
• Describe how to create an Oracle9i database both manually and using the database Configuration Assistant
• Create an Oracle9i database using the Database Configuration Assistant
• Create an Oracle9i database manually

Back to List

Database Structures in Oracle9i

Overview/Description
To describe how to use an Oracle9i database data dictionary, the control files, and the redo log files

Target Audience
Anyone wanting to learn about Oracle9i database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration
2.25 Hours

Database Structures in Oracle9i

• Describe the contents of an Oracle9i database data dictionary and explain how to use it
• Query an Oracle 9i database data dictionary to access information about an underlying database
• Describe the purpose and content of an Oracle9i database control file and explain how to manage it
• Multiplex an Oracle 9i database control file using the SPFILE
• Describe the structure of the Oracle9i database redo log files and explain how they work and how to archive them
• Describe how to manage redo log groups and members and how to obtain information about them
• Add a new multiplexed log file to an Oracle9i database

Back to List

Data Storage in Oracle9i

Overview/Description
To describe the data storage structures in an Oracle9i database and explain how to manage them

Target Audience
Anyone wanting to learn about Oracle9i database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration
3.25 Hours

Data Storage in Oracle9i

• Describe the database storage hierarchy and the types of tablespaces in the Oracle9i Database, and explain how to use them
• Describe how to manage tables in an Oracle9i database
• Explain how to manage tablespaces in an Oracle9i database
• Explain how to manage data files in an Oracle9i database
• Describe segments, extents, and datablocks in an Oracle9i database and explain how to manage them
• Create a tablespace and move a data file using the Oracle Enterprise Manager in an Oracle9i database
• Describe the purpose and types of undo segments in an Oracle9i database and explain how to use automatic undo management to administer undo data
• Obtain information about undo segments, establish user quotas, and determine the required size of an undo tablespace in an Oracle9i database
• Create and administer an undo tablespace in an Oracle9i database using the Oracle Enterprise Manager
• Determine the optimal size for an undo tablespace in an Oracle9i database

Back to List

Tables and Indexes in Oracle9i

Overview/Description
To describe how to manage tables and indexes in an Oracle9i database

Target Audience
Anyone wanting to learn about Oracle9i database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration
3 Hours

Tables and Indexes in Oracle9i

• Describe the various methods used to store user data in an Oracle9i database
• Describe the various datatypes used in an Oracle9i database
• Describe how to create tables in an Oracle9i database
• Create a table in an Oracle9i database
• Describe the classification of indexes and their types in an Oracle9i database
• Describe how to create normal B-tree and bitmap indexes in an Oracle9i database
• Describe how to manage indexes in an Oracle9i database
• Create an index in an Oracle9i database
• Rebuild or coalesce an index in an Oracle9i database

Back to List

Data Integrity in Oracle9i

Overview/Description
To describe how to use integrity constraints to enforce business rules on the data in an Oracle 9i database

Target Audience
Anyone wanting to learn about Oracle9i database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration
1.75 Hours

Data Integrity in Oracle9i

• Describe how Oracle9i defines and implements data integrity in a database
• Describe how Oracle9i enforces data integrity constraints in a database
• Describe how Oracle9i defines and enables data integrity constraints in a database
• Define constraints in an Oracle9i database table using the Oracle Enterprise Manager

Back to List

Users and Profiles in Oracle9i

Overview/Description
To describe how to use manage users, passwords, and resources in an Oracle9i database

Target Audience
Anyone wanting to learn about Oracle9i database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration
3 Hours

Users and Profiles in Oracle9i

• Describe Oracle9i database users, how to authenticate them, and their relationship to schemas
• Explain how to create and manage users in an Oracle9i database
• Use the Oracle Enterprise Manager to create a user in an Oracle9i database
• Describe profiles and explain how to use profiles to manage passwords in an Oracle9i database
• Describe how to create and manage password profiles in an Oracle9i database
• Use the Oracle Enterprise Manager to create a password profile and assign it to a number of users in an Oracle9i database
• Describe how to use password profiles to manage Oracle9i database resources
• Describe the Oracle9i Database Resource Manager and explain how to use it to manage database resources
• Explain how to create a resource plan in an Oracle9i database

Back to List

Privileges and Roles in Oracle9i

Overview/Description
To describe how to manage privileges and roles in an Oracle9i database

Target Audience
Anyone wanting to learn about Oracle9i database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration
2.25 Hours

Privileges and Roles in Oracle9i

• Describe the system and object privileges in an Oracle9i database
• Describe how to manage system and object privileges in an Oracle9i database
• Use the Oracle Enterprise Manager to grant a system privilege to a user in an Oracle9i database
• Describe the Oracle9i database roles
• Describe how to create and enable roles in an Oracle9i database
• Describe how to manage roles in an Oracle9i database
• Use the Enterprise Manager to create a role and assign privileges to it in an Oracle9i database

Back to List

Globalization and Auditing in Oracle9i

Overview/Description
To describe how to manage globalization support in an Oracle9i database and how to audit an Oracle9i database

Target Audience
Anyone wanting to learn about Oracle9i database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration
2 Hours

Globalization and Auditing in Oracle9i

• Describe the architecture and features of globalization support in an Oracle9i database
• Describe the character sets available in an Oracle9i database that support globalization and discuss the guidelines for choosing character sets
• Describe how to manage Natural Language Support in an Oracle9i database
• Describe how Oracle9i implements linguistic sorting and to discuss the effect of the Natural Language Support parameters
• Describe Oracle9i database auditing and how to implement it
• Create an Oracle9i audit in an Oracle9i database

Back to List