Exam 1Z0-053: Oracle Database 11g: Administration II Curriculum Outline
Oracle Database 11g: Database Architecture and ASM
Overview/Description
To recognize the structural elements in Oracle Database 11gs architecture, including and Automatic Storage Management (ASM), and recognize the steps for managing storage using disk groups.
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Database Architecture and ASM
Back to List
Oracle Database 11g: Configuring for Recovery
Overview/Description
To recognize the steps for configuring all aspects of backup and recovery functionality in Oracle Database 11g, using ARCHIVELOG mode, retention policies, a Flash Recovery Area, and an RMAN recovery catalog.
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Configuring for Recovery
Back to List
Oracle Database 11g: Configuring for Backups
Overview/Description
To identify the steps for preparing a database for backup and then for performing various types of RMAN backups and monitoring them using reports and dynamic performance views, and also for performing user-managed backups and recoveries.
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Configuring for Backups
Back to List
Oracle Database 11g: Using RMAN for Recovery
Overview/Description
To identify ways to use RMAN to ensure that data is not lost in Oracle Database 11g, by performing complete and incomplete recoveries as well as disaster recoveries, by cloning databases, and by restoring a tablespace to a particular point in time.
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Using RMAN for Recovery
Back to List
Oracle Database 11g: Supporting RMAN and Using Flashback Technology
Overview/Description
To recognize the steps for making sure that you can recover data quickly by tuning RMAN to avoid bottlenecks, and also for making sure that any changes to a database can be easily reversed, if necessary, using Oracle Database 11gs flashback features.
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Supporting RMAN and Using Flashback Technology
Back to List
Oracle Database 11g: Diagnosing the Database and Managing Memory
Overview/Description
To identify the steps for diagnosing and repairing database problems with the help of Oracle Support using Automatic Diagnostic Repository, Support Workbench, and health checks, and also for enabling and configuring automatic memory management and automatic shared memory management.
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Diagnosing the Database and Managing Memory
Back to List
Oracle Database 11g: Database Performance and Space Management
Overview/Description
To identify the steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and transporting tablespaces.
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Database Performance and Space Management
Back to List
Oracle Database 11g: Managing Resources and Task Automation
Overview/Description
To identify ways to ensure that resources are being put to best use and database jobs are performed when they should be, using the Database Resource Manager and the Scheduler.
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Managing Resources and Task Automation
Back to List
Oracle Database 11g: Globalization
Overview/Description
To recognize the steps for utilizing Oracle Database 11gs globalization support features to ensure that information and data is displayed in a users native language, and that territory and language-dependent conventions are adhered to.
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Globalization
Back to List
Exam 1Z0-311: Oracle Application Server 10g: Administration I Curriculum Outline
Oracle Application Server 10g: Introduction
Overview/DescriptionTo 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/DescriptionTo 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/DescriptionTo 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/DescriptionTo 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/DescriptionTo 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/DescriptionTo 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/DescriptionTo 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/DescriptionTo 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/DescriptionTo 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/DescriptionTo 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/DescriptionTo 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/DescriptionTo 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-312: Oracle Application Server 10g: Administration II Curriculum Outline
Oracle Application Server 10g: Managing Customized Topologies and Distributing Infrastructure Components
Overview/DescriptionTo discuss common deployment topologies and to explain how to install and configure Oracle Application Server components to suit different needs
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; a good understanding of Oracle Application Server components and concepts
Expected Duration
3 Hours
OracleAS 10g: Managing Customized Topologies and Distributing Infrastructure Components
- Identify some of the new features available for managing customized topologies and recognize some of the key deployment considerations
- Identify the main considerations for evaluating general development topologies
- Identify key considerations when evaluating the departmental, development life cycle, and data centre topologies
- Evaluate recommended development and deployment topologies
- Recognize the features of Cold Failover Clusters, Active Failover Clusters, and Identity Management replication as part of high availability deployments
- Identify how to use multiple metadata repositories and list the requirements for installing OracleAS Infrastructure using an existing Oracle9i database
- Install OracleAS Infrastructure by using an existing Infrastructure component
- Install a Metadata Repository into an existing database and install the Infrastructure using the existing repository
- Identify how to upgrade a distributed OracleAS environment and recognize the effect of an upgrade on system availability
- Identify the steps involved in the procedure for upgrading the middle tier, Metadata Repository, and Identity Management Services
- Identify how to upgrade a system to Oracle AS 10g
Back to List
Oracle Application Server 10g: High Availability
Overview/DescriptionTo explain high availability and its importance from the perspective of application servers and discuss the high availability features in Oracle Application Server at the OC4J level
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; a good understanding of Oracle Application Server components and concepts
Expected Duration
2.50 Hours
OracleAS 10g: High Availability
- Recognize the concepts associated with high availability and identify the features of Oracles end-to-end high availability solution
- Determine the appropriate method of providing high availability for applications and the middle tier
- Determine the appropriate method of providing high availability for OracleAS Infrastructure using clustering
- Outline the site-to-site high availability solution for OracleAS Infrastructure
- Determine a high availability solution for a given scenario
- Identify the benefits of J2EE clustering and the configuration of islands
- Recognize the concepts involved in session and application replication for high availability solutions
- Create an OC4J island, configure state replication, and monitor virtual machine metrics
- Configure clustering of OC4J Java Virtual Machines
Back to List
Oracle Application Server 10g: Managing and Configuring Clusters
Overview/DescriptionTo explain how to manage and configure clusters in OracleAS 10g
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; a good understanding of Oracle Application Server components and concepts
Expected Duration
3.25 Hours
OracleAS 10g: Managing and Configuring Clusters
- Explain clustering and describe how OracleAS Web Cache clusters work
- Configure Web Cache cluster members and settings, and identify how to invalidate the cache
- Configure session binding and monitor cache cluster performance
- Configure web cache cluster settings, add an additional web cache to a cache cluster, and obtain performance statistics for the web cache
- Create an OracleAS Farm using a file-based repository
- Identify the characteristics of OracleAS clusters managed using a repository
- Identify the role of OPMN, DCM, and mod_oc4j in OracleAS cluster management
- Create, stop, and start an OracleAS cluster, add and remove instances, and identify how to create an OracleAS cluster using dcmct1
- Create clusters and add standalone instances
- Outline the architecture of OracleAS Infrastructure Cold Failover Clusters and identify how to install middle tiers in a CFC environment
- Identify the steps involved in installing and starting an OracleAS Infrastructure in a Cold Failover Cluster and identify how to manage and test a failover
Back to List
Oracle Application Server 10g: Business Intelligence Component Management
Overview/DescriptionTo examine Business Intelligence components such as Oracle AS Discoverer and OracleAS Reports and to describe how to deploy reports and forms applications to 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; a good understanding of Oracle Application Server components and concepts
Expected Duration
4 Hours
OracleAS 10g: Business Intelligence Component Management
- Monitor OracleAS Report Services and control and configure OracleAS Discoverer
- Configure OracleAS Discoverer Plus, Discoverer Viewer, and Discoverer Portlet Provider, and register Discoverer Portlet Provider
- Control OracleAS Discoverer services
- Identify features for monitoring OracleAS Discoverer, identify the configuration files used with Discoverer, and use the EUL command-line tool for Java
- Identify the capabilities of OracleAS Reports Services and determine how its components contribute to the running of a report
- Identify Reports Services configuration files and configure the Reports Server and the Reports Servlet
- Identify how to deploy reports using OracleAS Reports Services
- Configure Reports Services and deploy a Reports application
- Outline the architecture of Forms Services and identify the role of each Forms Service component in running an application
- Identify the configuration files and the levels of configuration associated with OracleAS Forms Services, identify how the configuration files are used at runtime, and use Application Server Control for configuration tasks
- Configure the Forms Servlet using Application Server Control
- Configure environmental variables in a Forms runtime environment, manage user sessions, and identify how to deploy Forms applications and their associated files
- Configure the Forms Servlet for a new testing environment
Back to List
Oracle Application Server 10g: XML Applications, Web Services, and Monitoring
Overview/DescriptionTo describe how to deploy XML applications and web services with Oracle AS and to discuss the monitoring capabilities of Oracle Enterprise Manager Application Server Control
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; a good understanding of Oracle Application Server components and concepts
Expected Duration
2.75 Hours
OracleAS 10g: XML Applications, Web Services, and Monitoring
- Define terms associated with XML, identify the Oracle XML and XDK components, and identify the steps in the XML parsing process
- Recognize how an XSQL servlet functions, initialize the XSQL demo application, and create and access an XSQL page
- Define the Web services standards, identify why organizations use Web services, and outline the Web services architecture and communication flow
- Identify the main features of SOAP, and describe how to invoke, manage, and deploy Web services, and how to implement a stateless Java Web service
- Use Web services and XSQL
- Identify Log Loader tasks and search log files
- Configure diagnostic message correlation
- Manage and troubleshoot the Log Loader
- Use the log repository to monitor OracleAS
Back to List
Oracle Application Server 10g: Tuning and Reconfiguring the Middle Tier
Overview/DescriptionTo describe how to optimize the performance of Oracle Application Server components and to explain how to perform reconfiguration tasks in the Oracle Application Server middle tier and infrastructure
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; a good understanding of Oracle Application Server components and concepts
Expected Duration
4.25 Hours
OracleAS 10g: Tuning and Reconfiguring the Middle Tier
- Identify how to monitor the performance of Oracle Application Server
- Monitor performance and analyze performance issues in OracleAS
- Monitor and tune the performance of OC4J processes and applications
- Monitor OracleAS system components
- Identify how to set up data sources and connection attributes
- Identify useful hints and tips for tuning servlets, JSPs, EJBs, and the web cache
- Monitor and tune the performance of OracleAS Web Cache and Forms Services
- Configure browser keep-alive and origin server response timeouts and monitor metrics for a Forms Service instance
- Expand a middle tier installation in OracleAS in a given scenario
- Configure services after installation in OracleAS
- Expand a middle tier and configure Forms Services in a given scenario
- Associate installations with the Infrastructure and remove instances in OracleAS
- Identify the steps for changing the host name and IP address on the middle tier and the IP address on the Infrastructure
- Associate a J2EE and Web Cache installation with Identity Management and change the host name on the server hosting Oracle Application Server middle tier
Back to List
Oracle Application Server 10g: Backup and Recovery
Overview/DescriptionTo explain how to perform backup and recovery procedures 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; a good understanding of Oracle Application Server components and concepts
Expected Duration
1.75 Hours
OracleAS 10g: Backup and Recovery
- Identify the type of Oracle Application Server backup to perform in a given scenario
- Recognize how to configure and use the OracleAS Backup and Recovery Tool
- Identify the steps for performing backup procedures in OracleAS
- Identify the steps for restoring OracleAS infrastructure or middle-tier installations from backup
- Back up and restore OracleAS configurations
Back to List
Exam 1Z0-047: Oracle Database 11g: SQL Expert 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 (hours)
2.2
Lesson Objectives
Oracle Database 11g: Using SQL to Query Your Database
257492_eng
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 (hours)
2.0
Lesson Objectives
Oracle Database 11g: Conversion Functions, Group Functions, and Joins
257503_eng
Back to List
Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation
Overview/Description
To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements.
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.9
Lesson Objectives
Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation
257513_eng
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 (hours)
1.8
Lesson Objectives
Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms
257522_eng
Back to List
Oracle Database 11g: Controlling User Access and Managing Schema Objects
Overview/Description
To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.
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: Controlling User Access and Managing Schema Objects
257867_eng
Back to List
Oracle Database 11g: Data Dictionary Views and Large Data Sets
Overview/Description
To recognize the steps for querying data dictionary views to viewsschema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows.
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.7
Lesson Objectives
Oracle Database 11g: Data Dictionary Views and Large Data Sets
257876_eng
Back to List
Oracle Database 11g: Managing Data in Different Time Zones
Overview/Description
To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.
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.3
Lesson Objectives
Oracle Database 11g: Managing Data in Different Time Zones
257884_eng
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
257896_eng
Back to List
Exam 1Z0-050: Oracle Database 11g: New Features for Administrators Curriculum Outline
Oracle Database 11g Release 2: Installation and Oracle Restart
Overview/Description
Oracle Database 11g Release 2 offers a unique scale-out technology with a single database instance, lower server and storage costs, and increased availability and scalability. It also provides customers with improved user service levels, reduced down-time, and more efficient use of IT resources as well as an increased level of performance and security. In addition it provides business intelligence and data warehousing. This course demonstrates how to install the Oracle Grid Infrastructure, use ASMCA to create disk groups, and create and manage ASM volumes and the Cluster File System. It also outlines how to install Oracle Database 11g, enable direct NFS, using online patching, and use Oracle Restart to manage the components. It is one of a series of courses in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for the Oracle Database 10g Administrator Certified Professionals (10g DBA OCP) to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.
Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g
Expected Duration (hours)
2.0
Lesson Objectives
Oracle Database 11g Release 2: Installation and Oracle Restart
od_onft_a01_it_enus
Back to List
Oracle Database 11g Release 2: ASM, Storage and Partitioning Enhancements
Overview/Description
Oracle Database 11g Release 2 provides many improvements from its previous releases. This includes enhancements to ASM and storage to improve performance and to reduce server maintenance down time. This course identifies the enhancements in each of these areas. It also demonstrates how to use ASM fast mirror resync, manage ASM users, disk groups, ACLs, and Intelligent Data Placement, as well as table compression, SQL Access Advisor, and segment creation. It is one of a series of courses in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for the Oracle Database 10g Administrator Certified Professional (10g DBA OCP) to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.
Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g
Expected Duration (hours)
2.0
Lesson Objectives
Oracle Database 11g Release 2: ASM, Storage and Partitioning Enhancements
od_onft_a02_it_enus
Back to List
Oracle Database 11g Release 2: Oracle Partitioning and Security Features
Overview/Description
Oracle Database 11g Release 2 offers more advanced data warehouse, partitioning, security and network feature enhancements to allow the DBA to provide a more efficient way for users to access data in a secure environment. This course covers the enhanced data warehouse and partition enhancements, which includes support for loading data stored in compressed files, new parameters for simplified parallelism implementation, and new partitioning methods. It also covers the security and networking enhancements, including how to use SecureFiles, the password file, default auditing, and tablespace encryption, as well as network support for IPv6 and configuring fine-grained access. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.
Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g
Expected Duration (hours)
2.0
Lesson Objectives
Oracle Database 11g Release 2: Oracle Partitioning and Security Features
od_onft_a03_it_enus
Back to List
Oracle Database 11g Release 2: Using Change Management Solutions
Overview/Description
Oracle Database 11g Release 2 is designed for data center environments that are rapidly evolving and changing to keep up with business demands, enabling DBAs to manage change effectively and efficiently. Oracle Database 11g Release 2 offers significant advances in the areas of automatic diagnostics, supportability, and change management. It can be expensive for organizations to evaluate and implement changes to their data center infrastructure, and Oracle addresses this issue with a collection of solutions under the umbrella of Change Management. These consist of SQL Performance Analyzer, SQL Plan Management, and Database Replay. This course identifies each of these change management solutions and demonstrates how to use them to analyze SQL statements, test upgrades, and capture and analyze workloads. It is one of a series of courses in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.
Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g
Expected Duration (hours)
2.0
Lesson Objectives
Oracle Database 11g Release 2: Using Change Management Solutions
od_onft_a04_it_enus
Back to List
Oracle Database 11g Release 2: Intelligent Infrastructure Enhancements
Overview/Description
Oracle Database 11g Release 2 offers new intelligent infrastructure features to aid DBAs by automatically gathering performance metrics for problem detection and self-tuning purposes. The information gathered can be viewed by the DBA using either reports or views, as well as the alert log. Oracle Database 11g has expanded features for automatic SQL tuning and the Automatic Workload Repository, which allows the DBA to ensure the database is running efficiently, and by using the Enhanced Resource Manager the DBA has the ability to optimize resource allocation among many different database sessions to prevent excessive overhead. This course identifies how to automatically tune SQL statements using Automatic SQL Tuning, use Automatic Workload Repository baselines to gather performance metrics, control maintenance tasks, determine I/O metrics using I/O Calibration tool, and use Resource Manager. This course is one of a series in the SkillSoft learning path that covers objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.
Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g
Expected Duration (hours)
1.5
Lesson Objectives
Oracle Database 11g Release 2: Intelligent Infrastructure Enhancements
od_onft_a05_it_enus
Back to List
Oracle Database 11g Release 2: Diagnosability Enhancements
Overview/Description
Oracle Database 11g Release 2 offers new diagnosability enhancements to help DBAs in diagnosing, resolving, and preventing problems. These new features include enhancements to problem and incident identification, running health checks, and performing repairs on SQL statements. These features enables the DBA to quickly and efficiently diagnose issues and report problems to Oracle Support, as well as reducing damage and interruptions. This course discusses using Automatic Diagnostic Repository, creating and submitting Incident Packages to Oracle Support, running health checks and viewing the reports. It also demonstrates how to use SQL Repair Advisor and SQL Test Case Builder. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.
Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g
Expected Duration (hours)
1.0
Lesson Objectives
Oracle Database 11g Release 2: Diagnosability Enhancements
od_onft_a06_it_enus
Back to List
Oracle Database 11g Release 2: SQL Monitoring and Performance Enhancements
Overview/Description
Oracle Database 11g Release 2 offers improvements and new features to provide DBAs a better way to monitor SQL commands in real-time and to allow the database to automatically manage its own memory and gather optimizer statistics. These features enable the DBA to ensure the optimal memory sizes are being used for the database using Automatic Memory Management, and that SQL statements are running properly by monitoring them in real-time using Enterprise Manager. It also offers a new feature to conceptually extend the buffer cache by using DB Smart Flash. This course demonstrates how to monitor SQL commands in real-time using SQL Monitoring, use Automatic Database Diagnostic Monitoring (ADDM), DB Smart Cache, gather and view different statistics for partitioned tables, hash-based sampling, multicolumn, and expressions, and use deferred statistics. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.
Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g
Expected Duration (hours)
1.0
Lesson Objectives
Oracle Database 11g Release 2: SQL Monitoring and Performance Enhancements
od_onft_a07_it_enus
Back to List
Oracle Database 11g Release 2: Application Performance Enhancements
Overview/Description
Oracle Database 11g Release 2 offers improved and new features to provide better application performance. It offers online table redefinition, which allows tables to be modified without affecting the availability of the table to users and does not affect any of its dependencies. This allows for easier application changes and improved query and DML performance. Application performance in Oracle Database 11g Release 2 is also improved by the use of adaptive cursor sharing, which allows for intelligent cursor sharing and the use of invisible indexes. It provides two different caches. The first cache includes SQL Query Result Cache used to cache query results or query blocks for future use, which reduces memory use and provides scalability. The second cache is the PL/SQL cross-section function result caching mechanism, which provides a language-supported and system-managed means for storing the results of PL/SQL functions in the SGA, so that they are available to all the application sessions that are running. This course identifies the new online redefinition enhancements for tables, invisible indexes, adaptive cursor sharing, and using SQL Query Result, Client Query, and PL/SQL Function Caches. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.
Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g
Expected Duration (hours)
1.0
Lesson Objectives
Oracle Database 11g Release 2: Application Performance Enhancements
od_onft_a08_it_enus
Back to List
Oracle Database 11g Release 2: Backup, Recover, Archive, and Repair Data
Overview/Description
Oracle Database 11g Release 2 offers new and improved features to ensure for continuous data access, even during unplanned failures and scheduled maintenance tasks. New RMAN features make it easier to backup, recover and duplicate databases in a timely manner while minimizing data loss. It also offers Flashback technology, giving DBAs additional protection against data loss, as well as the Data Recovery Advisor which automatically diagnoses data failures and offers suggestions on how to correct the issues. This course demonstrates how to backup and recover database, archive backups, using TSPITR, and manage the recovery catalogs. It also demonstrates how to use the Flashback Data Archive, Flashback Transaction Backout, LogMiner, and Data Pump as well as use the Data Recovery Advisor. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.
Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g
Expected Duration (hours)
2.0
Lesson Objectives
Oracle Database 11g Release 2: Backup, Recover, Archive, and Repair Data
od_onft_a09_it_enus
Back to List
Oracle Database 11g Release 2: Oracle Scheduler and Secure Backup
Overview/Description
Oracle Database 11g Release 2 offers improvements to Oracle Scheduler that increases efficiency and usability. These include allowing users to get specific email notifications about job activities, triggering jobs to automatically execute when the specified file is received, enabling jobs to run on multiple nodes while managing it from a central location, and running PL/SQL on a remote database as a job. Oracle Database 11g Release 2 also offers backup to Amazon S3 through the Oracle Secure Backup module, this offers a low-cost database backup Web services storage option rather than maintaining a local backup infrastructure. This course demonstrates how to use Oracle Schedule to create email notifications, create file watchers and create and manage remote database and multiple destination jobs. It also discusses the Oracle Secure Backup Cloud module. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.
Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g
Expected Duration (hours)
1.0
Lesson Objectives
Oracle Database 11g Release 2: Oracle Scheduler and Secure Backup
od_onft_a10_it_enus
Back to List
Mentoring 1Z0-050 Oracle Database 11g: New Features for Administrators
Overview/Description
SkillSoft Mentors are available to help students with their studies for exam 1Z0-050 Oracle Database 11g: New Features for Administrators. You can reach them by entering a Mentored Chat Room or by using the E-mail My Mentor service.
Target Audience
Individuals who are studying the associated SkillSoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.
Prerequisites
Familiarity with the exam objectives listed below and skills and competencies being measured in the associated certification exam.
Expected Duration (hours)
0.0
Lesson Objectives
Mentoring 1Z0-050 Oracle Database 11g: New Features for Administrators
mnt1z0050
Back to List
TestPrep 1Z0-050 Oracle Database 11g: New Features for Administrators
Overview/Description
To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.
Target Audience
Individuals seeking practice in a structured testing environment, covering the skills and competencies being measured by the vendor certification exam.
Prerequisites
The associated SkillSoft certification content should be completed before attempting this TestPrep. This will maximize the effectiveness of the preparation exam.
Expected Duration (hours)
0.0
Lesson Objectives
TestPrep 1Z0-050 Oracle Database 11g: New Features for Administrators
TP1Z0050_eng
Back to List
Oracle Database 11g: Installation and Upgrade Enhancements
Overview/Description
Recognize the enhancements to Oracle Database 11gs installation and upgrade processes, as well as its various post-upgrade steps, and recognize how to create a new database.
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role
Oracle Database 11g: Installation and Upgrade Enhancements
Back to List
Oracle Database 11g: Storage Enhancements
Overview/Description
recognize ways in which storage has been enhanced in Oracle Database 11g using Automatic Storage Managements (ASMs) commands and extensions.
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role
Oracle Database 11g: Storage Enhancements
Back to List
Oracle Database 11g: Change Management Overview and SQL Plan Management
Overview/Description
outline the uses of management tools in Oracle Database 11g, such as SQL Performance Analzer, SQL tuning sets, and SQL plan baselines, and outline how you can use them to effectively manage change and execute SQL plans.
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role
Oracle Database 11g: Change Management Overview and SQL Plan Management
Back to List
Oracle Database 11g: Database Replay and Automatic SQL Tuning
Overview/Description
Explain the benefits and uses of Oracle Database 11gs crucial developer tools, Database Replay and Automatic SQL Tuning, when setting up and testing a database
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role
Oracle Database 11g: Database Replay and Automatic SQL Tuning
Back to List
Oracle Database 11g: Intelligent Infrastructure Enhancements
Overview/Description
Identify how to monitor performance, automate maintenance, calibrate and manage resources, and streamline job scheduling using Oracle Database 11gs intelligent infrastructure enhancements.
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role
Oracle Database 11g: Intelligent Infrastructure Enhancements
Back to List
Oracle Database 11g: Performance Enhancements
Overview/Description
identify the scope and capabilities of Oracle Database 11gs performance-enhancing tools, such as those for memory management, performance analysis, and statistics gathering.
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role
Oracle Database 11g: Performance Enhancements
Back to List
Oracle Database 11g: Partitioning and Storage-Related Enhancements
Overview/Description
identify the benefits of Oracle Database 11gs partitioning and storage-related enhancements, and recognize how to use SQL Access Advisor to help you optimize your database in this regard.
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role
Oracle Database 11g: Partitioning and Storage-Related Enhancements
Back to List
Oracle Database 11g: Using RMAN Enhancements, Flashback and LogMiner
Overview/Description
identify ways of using Oracle Database 11gs enhanced RMAN, Flashback and LogMiner tools to clone databases, create backups and catalogs, archive historical data, and roll back transactions.
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role
Oracle Database 11g: Using RMAN Enhancements, Flashback and LogMiner
Back to List
Oracle Database 11g: Diagnostic Enhancements and Using the Data Recovery Advisor
Overview/Description
recognize the steps for detecting, diagnosing, and repairing critical errors and data failures in Oracle Database 11g, using its enhanced, proactive, diagnostic tools, such as Automatic Diagnostic Repository, Support Workbench, SQL Repair Advisor, and the Data Recovery Advisor.
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role
Oracle Database 11g: Diagnostic Enhancements and Using the Data Recovery Advisor
Back to List
Oracle Database 11g: New Security Features
Overview/Description
identify the ways in which Oracle Database has enhanced security, including enhancements to Transparent Data Encryption and password security, and identify the steps for managing all aspects of security.
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role
Oracle Database 11g: New Security Features
Back to List
Exam 1Z0-040: Oracle Database 10g: New Features for Administrators Curriculum Outline
Oracle Database 10g: New Installation and Configuration Features
Overview/DescriptionTo discuss the new installation and configuration features of Oracle 10g
Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration
2.25 Hours
Oracle Database 10g: New Installation and Configuration Features
- Identify the products and components of the Oracle 10g grid computing infrastructure
- Identify the installation improvements to Oracle Database 10g
- Identify the key grid and installation features of Oracle 10g and make the necessary installation considerations in a given scenario
- Identify the key upgrades to the Database Configuration Assistant (DBCA) in Oracle 10g
- Identify the key areas of the new Enterprise Manager GUI and use some of its new deployment features
- Use the new features of Enterprise Manager to review database feature usage, manage policies, and modify initialization parameters
- Launch and use the new features of Oracle 10g Enterprise Manager
Back to List
Oracle Database 10g: New Data Loading Features
Overview/DescriptionTo discuss new data loading features in Oracle 10g
Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration
2 Hours
Oracle Database 10g: New Data Loading Features
- Take the preparatory steps for transporting tablespaces from one platform to another in Oracle 10g
- Identify the key processes and file issues associated with Oracle Database 10g Data Pump
- Use the code that allows you to import and export data with Oracle Database 10g Data Pump
- Perform a data-only unload of data in Oracle 10g
- Populate an external table and project column data in Oracle Database 10g
- Perform an external table population in Oracle Database 10g in a given scenario
Back to List
Oracle Database 10g: New Automatic Management and Management Infrastructure Features
Overview/DescriptionTo identify the new automatic management and management infrastructure features of Oracle 10g
Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration
3.25 Hours
Oracle Database 10g: New Automatic Management and Management Infrastructure Features
- Work with the Automatic Database Diagnostic Monitor (ADDM) in Oracle Database 10g
- Perform the tasks and calculations associated with the configuration and management of Automatic Shared Memory Management in Oracle Database 10g
- View Automatic Database Diagnostic Monitor (ADDM) findings and manage shared memory in Oracle Database 10g in a given scenario
- Perform the key tasks associated with Oracle Database 10gs new statistics collection feature
- Use the appropriate code to lock and view automatically gathered statistics in Oracle Database 10g
- Identify the key components and concepts of Oracle 10gs new Automatic Workload Repository (AWR) feature
- Set AWR statistics capturing and snapshot purging in Oracle Database 10g
- Perform the tasks in a typical advisor tuning session in Oracle Database 10g
- Manually invoke the ADDM advisor to analyze an Oracle system in a given scenario
- Identify the alert process and alert types in Oracle Database 10g
- Set alerts and view metrics and server alert information in Oracle Database 10g
- Change an alert threshold and edit a notification rule in a given scenario in Oracle Database 10g
Back to List
Oracle Database 10g: New Resources, Scheduling and Task-Management Features
Overview/DescriptionTo identify the new resource, scheduling, and task-management features of Oracle 10g
Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration
3.25 Hours
Oracle Database 10g: New Resource, Scheduling, and Task-Management Features
- Use the new resource-plan timeout and session mapping features of Resource Manager in Oracle Database 10g
- Use the new group switching and CPU allocation features of Resource Manager in Oracle Database 10g
- Set idle time outs for a consumer group and create a mapping between a consumer group and a session attribute in Oracle Database 10g
- Define the components of the Oracle Database 10g Scheduler and identify the SQL used to assign privileges to them
- Create jobs, programs, and schedules in Oracle Database 10g
- Create job classes, windows, and job priorities in Oracle Database 10g
- Create a job class, job, and window in Oracle 10g Enterprise Manager in a given scenario
- Use the GUI and code-based tools to manage Scheduler components in Oracle Database 10g
- Use the tools to manage Scheduler component attributes and global attributes in Oracle Database 10g
- View information about jobs and purge jobs in Oracle Database 10g
- Manage and view Scheduler components in Oracle Database 10g in a given scenario
Back to List
Oracle Database 10g: New Space Management Features
Overview/DescriptionTo identify the new space management features of Oracle 10g
Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration
2.25 Hours
Oracle Database 10g: New Space Management Features
- Identify the new features of undo management and their functions in Oracle Database 10g
- Set tablespace space usage thresholds in Oracle Database 10g
- Set a space usage threshold for a tablespace in a given scenario in Oracle Database 10g
- Use the appropriate code to define sorted hash clusters in Oracle Database 10g
- Perform a segment shrink operation in Oracle Database 10g
- Access the tools used to optimize segment space in Oracle Database 10g
- Perform a segment shrink operation in a given scenario in Oracle Database 10g
Back to List
Oracle Database 10g: New Storage Features
Overview/DescriptionTo identify the new storage features of Oracle Database 10g
Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration
3 Hours
Oracle Database 10g: New Storage Features
- Use the tools to manage the SYSAUX tablespace and its occupants in Oracle Database 10g
- Rename a tablespace and define a default permanent tablespace in Oracle Database 10g
- Identify the code used to copy and transfer database files in Oracle Database 10g
- Move a tablespace occupant and edit the tablespace properties in a given scenario in Oracle Database 10g using EM
- Differentiate the components of the new Automatic Storage Management (ASM) architecture in Oracle Database 10g
- Identify the processes associated with ASM instance administration, startup, and shutdown
- Follow the GUI-based and code-based steps to administer disk groups in Oracle Database 10g
- Use the appropriate commands and views to administer Automatic Storage Management (ASM) files and templates in Oracle Database 10g
- Create a disk group and add a disk in Oracle Database 10g in a given scenario
Back to List
Oracle Database 10g: New Tuning, Performance-Monitoring and Analysis Features
Overview/DescriptionTo use Oracle 10gs new tuning, performance-monitoring, and analysis features
Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration
3 Hours
Oracle Database 10g: New Tuning, Performance-monitoring, and Analysis Features
- Identify how to use the new optimizer statistics in Oracle Database 10g
- Use the SQL Tuning Advisor in a given scenario
- Use the SQL Access Advisor in a given scenario
- Recognize how Oracle 10g database performance is monitored
- Use the SQL Tuning Advisor and the SQL Access Advisor in a given scenario
- Use MERGE and partitioned outer joins in a given scenario
- Use group mapping in interrow calculations in a given scenario
- Recognize materialized view operations in a given scenario
- Use analytical calculations and fast refresh capabilities in a given scenario
Back to List
Oracle Database 10g: New Backup and Recovery Features
Overview/DescriptionTo use Oracle 10gs new backup and recovery features
Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration
2.25 Hours
Oracle Database 10g: New Backup and Recovery Features
- Recognize flash backup and recovery in Oracle Database 10g
- Use new features associated with incremental backups in a given scenario
- Maintain backups in Oracle Database 10g in a given scenario
- Recognize simplified recovery, database dropping, and enhanced RMAN scripts
- Implement backup and recovery with Oracle Database 10g in a given scenario
- Create and manage compressed backups in a given scenario
- Manage backup operations in a given scenario
Back to List
Oracle Database 10g: Using Flashback
Overview/DescriptionTo recognize Oracle 10gs Flashback technology and use Flashback features
Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration
2.25 Hours
Oracle Database 10g: Using Flashback
- Recognize flashback technology and its features
- Use Flashback Database in a given scenario
- Use Enterprise Manager to flash back a dropped table in a given scenario
- Use Flashback Database and Flashback Drop in a given scenario
- Use Flashback Versions Query and Flashback Transaction Query in a given scenario
- Use Flashback Table in a given scenario
- Use Flashback Versions Query and Flashback Table in a given scenario
Back to List
Oracle Database 10g: New Features in Security and Software Maintenance
Overview/DescriptionTo use the new security and software upgrade features in Oracle 10g
Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration
2.75 Hours
Oracle Database 10g: New Features in Security and Software Maintenance
- Create a column-level VPD policy in a given scenario
- Identify the policy type to use in a given scenario
- Create a fine-grained auditing policy in a given scenario
- Create a column-level VPD policy and a fine-grained auditing policy in a given scenario
- Point out why a column-level VPD policy and a fine-grained auditing policy are incorrect in a given scenario
- Use the Database Upgrade Assistant to perform a database upgrade to Oracle Database 10g in a given scenario
- Identify the order of the principal tasks required to manually upgrade a database to Oracle Database 10g
- Upgrade a database to Oracle Database 10g using Database Upgrade Assistant in a given scenario
Back to List
Oracle Database 10g: New Features in VLDB Support
Overview/DescriptionTo use Oracle 10gs new VLDB support features
Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration
2 Hours
Oracle Database 10g: New Features in VLDB Support
- Use bigfile tablespaces in Oracle Database 10g in a given scenario
- Use Enterprise Manager to create and manage temporary tablespace groups in a given scenario
- Use Enterprise Manager to create and manage partitions in a given scenario
- Use Enterprise Manager to create VLDB objects in a given scenario
- Recognize range, hash, and bitmap index enhancements in Oracle Database 10g
- Recognize how to manage range, hash, and bitmap indexes in a given scenario
Back to List
Oracle Database 10g: Miscellaneous New Features
Overview/DescriptionTo recognize how various new features are used in Oracle 10g
Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration
2.25 Hours
Oracle Database 10g: Miscellaneous New Features
- Recognize the new transaction and statistics monitoring enhancements in Oracle Database 10g
- Recognize how tracing, statistical information gathering, and client and shared server configuration is achieved in multi-tier environments in a given scenario
- Enable tracing and statistics aggregation in a given scenario
- Recognize the enhancements to resumable statements, buffer cache management, and large objects in Oracle Database 10g
- Recognize regular expression support and linguistic sorting in Oracle Database 10g
- Recognize the new e-mail, compression, LogMiner, and quotation mark enhancements in Oracle Database 10g
- Recognize regular expression, sorting, and e-mail usage in a given scenario
Back to List
Exam 1Z0-054: Oracle Database 11g: Performance Tuning Curriculum Outline
Oracle Database 11g: Performance Tuning Methodology and Tools
Overview/Description
Oracle Database 11g provides a variety of tools that can be used for performance tuning in an Oracle database environment. These tools can be used to diagnose and tune common SQL-related and instance-related problems as well as proactively tune an Oracle database. One such tool – Enterprise Manager – can be used to monitor an Oracle database using the many performance-related pages it provides via a user-friendly graphical user interface. This course provides an introduction to performance tuning methodologies, effective tuning goals, and the types of performance data that can be gathered by diagnostic tools available in Oracle Database 11g. It also demonstrates how to use Time Model and Enterprise Manager to diagnose performance issues, and discusses using the various dynamic performance views (V$ views) to perform statistical analysis when diagnosing problems. The use of alert logs, user trace files, and wait events analysis are also explored in this introduction to performance tuning. This course helps to prepare you for the Oracle Database 11g: Performance Tuning exam which counts towards the Oracle Database 11g Performance Tuning Certified Expert designation.
Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.
Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II
Expected Duration (hours)
1.5
Lesson Objectives
Oracle Database 11g: Performance Tuning Methodology and Tools
od_odpt_a01_it_enus
Back to List
Oracle Database 11g: Using AWR and Defining Problems
Overview/Description
Automatic Workload Repository (AWR) is the infrastructure that provides services to Oracle Database 11g components that collect, maintain, and utilize statistics for problem detection and self-tuning purposes. This course explains how to create and manage AWR snapshots, and demonstrates how to use the snapshots to generate individual AWR reports as well as AWR compares period reports. It discusses the identification of performance issues, setting the tuning priorities, how to tune depending on the particular application life cycle phase, and the steps involved in implementing migration, upgrade, and environment changes. The course also delves into the area of interpreting tuning diagnostics using Statspack – a set of scripts and PL/SQL packages that allow you to capture point-in-time performance data. It explains how to capture and manage Statspack snapshots and the generation and usage of Statspack reports for diagnostic analysis.
Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.
Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II
Expected Duration (hours)
1.5
Lesson Objectives
Oracle Database 11g: Using AWR and Defining Problems
od_odpt_a02_it_enus
Back to List
Oracle Database 11g: Metrics, Alerts, Baselines, AWR Tools, and Services
Overview/Description
Metrics, alerts, baselines, and thresholds are monitoring objects that can be used to monitor and manage the performance tuning of an Oracle Database 11g environment. Automatic Workload Repository (AWR) based tools can be used to tune automatic maintenance tasks and generate and read ADDM and ASH reports. This course demonstrates how to create static and repeating baselines, compute baseline statistics, define alert thresholds, and generate ADDM and ASH reports. In Oracle Database 11g you can configure, manage, and implement services to work with client applications using Database Resource Manager and the Scheduler. This course discusses the use of services for monitoring applications and demonstrates how to set performance-metric thresholds on services. It also explains how to configure services aggregation and tracing.
Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.
Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II
Expected Duration (hours)
2.5
Lesson Objectives
Oracle Database 11g: Metrics, Alerts, Baselines, AWR Tools, and Services
od_odpt_a03_it_enus
Back to List
Oracle Database 11g: Problem SQL Statements and Oracle Optimizer
Overview/Description
Oracle Database 11g helps to identify problem SQL statements using Oracle Optimizer and execution plans. This course discusses SQL statement processing and the role of the Oracle Optimizer and execution plans. It also explains how to generate and view execution plans using the DBMS_XPLAN package, the EXPLAIN PLAN command, SQL*Plus AUTOTRACE command options, and the V$SQL_PLAN view. The functions of the Optimizer and how to influence and control the optimizers behavior is discussed in detail, including the various query access paths that can be used, when to use different join methods and sort operations, how to manage and maintain indexes, and how to reorganize tables to optimize the processing of SQL statements.
Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.
Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II
Expected Duration (hours)
2.5
Lesson Objectives
Oracle Database 11g: Problem SQL Statements and Oracle Optimizer
od_odpt_a04_it_enus
Back to List
Oracle Database 11g: SQL Performance Management and Database Replay
Overview/Description
Database Replay allows you to test the impact of a system change by replaying a real-world workload on a test system before it is exposed to a production system. This course demonstrates how to use Database Replay to capture and replay workloads to test the impact of a system change. It also explains how to use SQL Performance Analyzer to ascertain performance gains following a database change and to test the impact of proposed changes. Maintaining SQL performance by managing changes to optimizer statistics, using Automatic SQL Tuning to automate the SQL tuning process, and setting up SQL plan management are also covered.
Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.
Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II
Expected Duration (hours)
2.5
Lesson Objectives
Oracle Database 11g: SQL Performance Management and Database Replay
od_odpt_a05_it_enus
Back to List
Oracle Database 11g: Shared Pool and Buffer Cache Tuning
Overview/Description
The buffer cache is an extremely important component for the performance, scalability, and reliability of the database. This course demonstrates how to identify the symptoms that indicate a buffer cache problem and how to use the various methods available to resolve common performance issues related to the buffer cache. It also discusses the sizing of the buffer cache and using views to analyze the buffer cache, and briefly covers multiple pool management. The fundamental purpose of the shared pool is to serve as a metadata cache. This course explains how to diagnose and resolve hard and soft-parsing problems and shared pool fragmentation issues. It also discusses various methods of tuning the shared pool, including sizing the shared pool, sizing the reserved area of the shared pool, keeping objects in the shared pool, and managing the results cache.
Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.
Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II
Expected Duration (hours)
2.0
Lesson Objectives
Oracle Database 11g: Shared Pool and Buffer Cache Tuning
od_odpt_a06_it_enus
Back to List
Oracle Database 11g: Tuning PGA, Temporary Space, and AMM
Overview/Description
Oracle Database 11g provides various methods for tuning, monitoring and managing memory and temporary tablespaces. Automatic Program Global Area (PGA) memory management adapts the SQL memory allocation based on PGA memory available, SQL operator needs, and system workload. A temporary tablespace is used to store transient data generated explicitly by the user and implicitly by the system. This course explains how to diagnose PGA memory and temporary tablespace issues and demonstrates how to size the PGA memory and manage temporary tablespaces. In addition, in Oracle 11g, Automatic Shared Memory Management (ASMM) uses dynamic System Global Area (SGA) and memory advisors to automatically adapt to workload changes. Automatic Memory Management (AMM) automates the sizing of PGA and SGA according to your workload. This course demonstrates the methods for enabling and configuring ASMM and AMM using Enterprise Manager, memory advisors, SQL, and V-dollar views for monitoring memory management.
Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.
Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II
Expected Duration (hours)
1.5
Lesson Objectives
Oracle Database 11g: Tuning PGA, Temporary Space, and AMM
od_odpt_a07_it_enus
Back to List
Oracle Database 11g: Segment Space, I/O, and Performance Tuning
Overview/Description
Oracle Database 11g provides various methods for tuning segment space usage and input/output (I/O). This course explains how to use Automatic Segment Space Management (ASSM) to tune segment space usage, how to shrink segments using SQL or the Enterprise Manager, and how to use table compression. Automatic Storage Management (ASM) capabilities save you time by automating manual storage and thereby increasing your ability to manage larger databases (and more of them) with increased efficiency. This course discusses the implementation and tuning of ASM using a variety of Redundant Array of Independent Disks (RAID) solutions, depending on the business requirements of the organization. This course also explores the performance tuning methodology and identifies industry-recognized best practices for performance tuning.
Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.
Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II
Expected Duration (hours)
2.5
Lesson Objectives
Oracle Database 11g: Segment Space, I/O, and Performance Tuning
od_odpt_a08_it_enus
Back to List
Professional Oracle Certifications
Oracle certifications are a credible validation of training and experience that can accelerate your professional career, improve
your productivity, and enhance your resume. An Oracle Professional Certification demonstrates that you have a solid understanding
of a job role and the Oracle products used in that role. Being an Oracle Certified Professional can help raise your visibility and
increase your access to the industry's most challenging opportunities.
![Call 1-800-358-6389](/images/CTA-KnowledgeS.jpg)
Oracle certifications are tangible, industry-recognized credentials that can help you succeed in your IT career and provide measurable benefits to your employer. Industry Analysts and Experts agree, Oracle Certifications are among the most sought after badges of credibility for expertise in the Information Technology marketplace. IT professionals can differentiate themselves from their peers or competition and gain valuable job security by earning an Oracle Professional Certification.
Benefits of CBT Direct’s Online Oracle Certification Training
CBT Direct boasts the most beneficial online certification training on the market. With online training, you have the flexibility to study on your schedule, and with the speed and reliability of the internet, CBT Direct’s Oracle training course is accessible anywhere you have an internet connection. Convenience finally costs less with CBT Direct – the most affordable online training solution today.
The unique design of CBT Direct’s Oracle certification course incorporates a proven four-step learning process: presentation, demonstration, guidance and independent practice. This four-step proven learning model for CBT Direct’s Oracle training course ensures the greatest level of retention to prepare you for your Oracle certification exam.
CBT Direct also offers online mentoring for over 100 current major certification exams, including Oracle, for IT
professionals and end-users alike. CBT Direct’s mentors have a minimum of 20 certifications each and are available 24/7*.
* Available for most courses.
Who Benefits from CBT Direct’s Oracle Training?
This training would be beneficial for individuals looking for IT job positions such as; Database Designer, Database Administrator, Oracle Database Administrator or a Database Manager.
What Professionals Will Learn from CBT Direct’s Oracle Training
Oracle Database 11g SQL Expert Certification
Exam 1Z0-047: Oracle Database 11g: SQL Expert
This course takes a deeper look at using Oracle Database 11g utilizing the SQL Programming language. In this course,
students will gain a stronger grasp on relational databases and learn how to better understand and execute the SQL programming
language. This course provides insight on more complex SQL programming skills and more in depth explanations on creating
database objects, table manipulations and writing queries in Oracle Database 11g.
Click here to see a detailed curriculum outline.
Oracle Database 11g Administrator Professional Certification Upgrade
Exam 1Z0-050: Oracle Database 11g: New Features for Administrators DBA
This course will cover
the new features used for managing change, diagnosing and recovering from problems, ensuring high availability and
performance. It will also touch upon the tools needed for strengthening security and several other areas of particular
interest to database administrators. In addition, it will review the many benefits that have come along with the newer
available technology.
Passing the 1Z0-050 exam will upgrade you from Oracle Database 10g to Oracle Database 11g.
Click here to see a detailed curriculum outline.
Oracle Database 11g Administrator Professional Certification
Exam 1Z0-053: Oracle Database 11g: Administration II
This course takes the database administrator beyond the basic tasks covered as part of the Oracle Database 11g: Administration I
course. In this course, students gain a much deeper understanding of possibly the most important job of a DBA, such as
backup and recovery, tuning, scheduling jobs, controlling and managing resources such as memory.
Click here to see a detailed curriculum outline.
Oracle Database 10g Administrator Professional Certification Upgrade
Exam 1Z0-040: Oracle Database 10g: New Features for Administrators
This course introduces students to the new features of in Oracle Database 10g and will learn how to use these
features in order to increase database availability, simplify database performance monitoring and will discuss
usage of the Oracle 10g Advisors. Students will gain a better understanding of database administration using
Enterprise Manager Database Control. The course also covers security changes that students need to understand.
Passing the 1Z0-040 exam will upgrade you from Oracle9i DBA to Oracle Database 10g.
Click here to see a detailed curriculum outline.
Oracle Application Server 10g Administrator Professional Certification
Exam 1Z0-312: Oracle Application Server 10g: Administration II
This course takes the database administrator beyond the basic tasks covered as part of the Oracle Application Server 10g:
Administration I manage customized topologies and distributing infrastructure components, manage and configure clusters and to use
Business Intelligence Component Management. This course will cover XML Applications, Web Services, and monitoring, tuning and
reconfiguring the Middle Tier and how to do a backup and recovery.
Click here to see a detailed curriculum outline.
Oracle Database 11g: Performance Tuning
Exam 1Z0-054: Oracle Database 11g: Performance Tuning
In this course, individuals already familiar with the workings of Oracle 11g will be provided with information in how to
be more consistent while using Oracle 11g. It will provide a deeper understanding of how to utilize Oracle Database 11g
automatic tuning features, including SQL Tuning Advisor, and SQL Access Advisor. It will also cover the Automatic Workload
Repository and Automatic Database Diagnostic Monitor.
Click here to see a detailed curriculum outline.
Hours
(9-5 EST)
1Z0-040 | Oracle Database 10g New Features for Administrators | ü | ü | |
1Z0-047 | Oracle Database 11g: SQL Expert | ü | ü | |
1Z0-050 | Oracle Database 11g: New Features for Administrators | ü | ü | |
1Z0-053 | Oracle Database 11g: Administration II | ü | ü |
Exam 1Z0-050: Oracle Database 11g: New Features for Administrators
Exam 1Z0-040: Oracle Database 10g: New Features for Administrators
Exam 1Z0-047: Oracle Database 11g: SQL Expert
Exam 1Z0-053: Oracle Database 11g: Administration II
Exam 1Z0-311: Oracle Application Server 10g: Administration I
Exam 1Z0-312: Oracle Application Server 10g: Administration II
Exam 1Z0-054: Oracle Database 11g: Performance Tuning