Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Oracle Database 11g: Installation and Upgrade Enhancements $74.95
Oracle Database 11g: Storage Enhancements $74.95
Oracle Database 11g: Change Management Overview and SQL Plan Management $74.95
Oracle Database 11g: Database Replay and Automatic SQL Tuning $74.95
Oracle Database 11g: Intelligent Infrastructure Enhancements $74.95
Oracle Database 11g: Performance Enhancements $74.95
Oracle Database 11g: Partitioning and Storage-Related Enhancements $74.95
Oracle Database 11g: Using RMAN Enhancements, Flashback and LogMiner $74.95
Oracle Database 11g: Diagnostic Enhancements and Using the Data Recovery Advisor $74.95
Oracle Database 11g: New Security Features $74.95
Oracle Database 11g: SecureFiles and Miscellaneous New Features $74.95

Bundle Price: $379.00
Total Savings: $445.45


Oracle Database 11g: Installation and Upgrade Enhancements

Recognize the enhancements to Oracle Database 11g's installation and upgrade processes, as well as its various post-upgrade steps, and recognize how to create a new database.
  • Introduction to Oracle Database 11g - recognize the benefits of Oracle's Infrastructure grid and self-tuning capabilities.
  • Oracle Database 11g Software Installation - identify the changes to the Oracle database installation process and recognize the steps for installing Oracle Database 11g.
  • Oracle Database 11g Upgrade Process - recognize Oracle Database 11g's upgrade enhancements and identify the steps for performing an upgrade.
  • Oracle Database Upgrade Assistant - recognize the steps for running the Oracle Database Upgrade Assistant as part of an upgrade.
  • Post Upgrade Tasks and Database Creation - recognize the common post-upgrade steps and adjustments to initialization parameters, and identify the steps for creating a database.
  • Direct Network File System and Hot Patching - identify the steps for enabling Direct Network File System and installing a hot patch.
  • Oracle Database 11g Best Practices - identify the best practices and recommendations for testing and analyzing an Oracle Database 11g installation.
  • Creating a New Database - create a new Oracle Database 11g database.

Oracle Database 11g: Storage Enhancements

recognize ways in which storage has been enhanced in Oracle Database 11g using Automatic Storage Management's (ASM's) commands and extensions.
  • ASM Fast Mirror Resync and ASM Preferred Mirror Read - recognize the ways to enhance efficiency and performance of Oracle Database 11g by using Automatic Storage Management (ASM) Fast Mirror Resync and ASM Preferred Mirror Read.
  • ASM Performance, Scalability, and Disk Group Management - identify ways to use ASM to enhance scalability and performance and control disk group attributes and compatibility.
  • ASM with and without Fast Mirror Resync - identify the steps for adding an offlined disk without ASM and also with ASM, following a nondata issue.
  • CHECK, MOUNT, and DROP commands for ASM - recognize the syntax for performing disk group checks, mounting disk groups for fast rebalance, and forcing a disk group drop.
  • ASMCMD Extensions - identify the correct method for backing up ASM metadata using ASMCMD extensions.
  • Using ASMCMD Extensions - back up ASM metadata using ASMCMD extensions.

Oracle Database 11g: Change Management Overview and SQL Plan Management

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.
  • Overview of Change Management in Oracle Database 11g - recognize the steps for managing change when upgrading or reconfiguring Oracle Database, including the setting up a snapshot standby database as a test environment.
  • SQL Performance Analyzer Overview - recognize the general uses and benefits of SQL Performance Analyzer for ascertaining performance gains following a database change.
  • Capturing the SQL Workload using SQL Tuning Sets - identify the steps for capturing the SQL workload using SQL tuning sets.
  • SQL Performance Analyzer Tasks - identify the different tasks that can be performed when managing components using the SQL Performance Analyzer.
  • Performance Monitoring with SQL Performance Analyzer - recognize the ways in which the different phases of the SQL Performance Analyzer help to assess the SQL performance impact of change.
  • SQL Plan Management and Seeding SQL Plan Baselines - identify the elements of SQL plan management and recognize the steps for seeding SQL plan baselines.
  • SQL Plan Baselines and SQL Plan Management Scenarios - recognize ways to load and evolve SQL plan baselines, select SQL plans, and set up various SQL plan management scenarios.
  • Phases of SQL Plan Management - recognize the steps for executing all phases of SQL plan management.
  • Seeding SQL Plan Baselines - seed SQL Plan Baselines for your most regressing statements.

Oracle Database 11g: Database Replay and Automatic SQL Tuning

Explain the benefits and uses of Oracle Database 11g's crucial developer tools, Database Replay and Automatic SQL Tuning, when setting up and testing a database
  • Database Replay and the System Architecture - recognize the benefits of using Database Replay and the concepts and reasons behind recreating a production database workload in a test environment.
  • Database Replay Considerations, Options, and Analysis - identify the scope of Database Replay's capabilities by recognizing the supported database changes and workloads, as well as some of the considerations and available options during capture, replay and replay analysis.
  • Capturing Workload with Enterprise Manager - identify the steps for running Database Replay using the Capture Wizard in Enterprise Manager.
  • Replaying Workload, PL/SQL, and Calibrating Clients - recognize the steps for replaying workload using the Replay Workload Wizard and also using PL/SQL to do the same, as well as calibrating replay clients.
  • Database Replay in Action - identify the steps for capturing the workload for a small application using Database Replay and replaying it to get the same results as during the original execution.
  • Using Database Replay with Enterprise Manager - run Database Replay in Enterprise Manager.
  • Automation of SQL Tuning in Oracle Database 11g - recognize how SQL tuning can benefit developers in improving the performance of SQL statements, and identify the methods and DBA controls that you can use in Oracle Database 11g to run the Automatic SQL Tuning feature.
  • Configuring Automatic SQL Tuning - identify the general steps and concepts behind configuring Automatic SQL Tuning, reviewing results, and performing a fine tune using PL/SQL.
  • Execution of Automatic SQL Tuning - recognize the steps for executing Automatic SQL Tuning and viewing its results.

Oracle Database 11g: Intelligent Infrastructure Enhancements

Identify how to to monitor performance, automate maintenance, calibrate and manage resources, and streamline job scheduling using Oracle Database 11g's intelligent infrastructure enhancements.
  • Overview of Automatic Workload Repository Baselines - recognize the scope of Oracle Database 11g's AWR Baselines feature, which includes baseline template creation options and baseline views.
  • Alert Thresholds and AWR Baseline Creation - recognize the steps for creating an AWR Baseline and using it to define alert thresholds.
  • Automated Maintenance Task Control - recognize the benefits of the Automatic Maintenance Tasks feature for statistics collection, segment advisor, and Automatic SQL Tuning, and identify how to control such tasks.
  • I/O Resource Calibration in Oracle Database 11g - recognize the steps for calibrating I/O resources in Oracle Database 11g.
  • Resource Manager and Lightweight Scheduler Jobs - recognize how to manage resources and streamline schedules using the Resource Manager and lightweight jobs.
  • Lightweight Scheduler Job Creation - identify the steps for creating and running lightweight scheduler jobs.
  • Calibrating I/O Resources in Oracle Database 11g - calibrate I/O Resources in Oracle Database 11g.

Oracle Database 11g: Performance Enhancements

identify the scope and capabilities of Oracle Database 11g's performance-enhancing tools, such as those for memory management, performance analysis, and statistics gathering.
  • Automatic Database Diagnostic Monitor - recognize the different ways to use Automatic Database Diagnostic Monitor to analyze Oracle Real Application Clusters (RACs) and report on issues affecting the entire database as well as individual instances.
  • Automatic Memory Management, ASMM and Memory Advisors - identify the benefits of Oracle Database 11g's Automatic Memory Management system.
  • Gathering Statistics in Oracle Database 11g - identify the concepts and methods employed in Oracle database 11g for gathering and publishing various kinds of statistics.
  • Automatic Memory Management Manipulation - identify the steps for observing memory distribution patterns using Automatic Memory Management and also for testing various statistic gatherings on a particular table.
  • Using Automatic Memory Management - use Automatic Memory Management to observe memory distribution patterns.

Oracle Database 11g: Partitioning and Storage-Related Enhancements

identify the benefits of Oracle Database 11g's partitioning and storage-related enhancements, and recognize how to use SQL Access Advisor to help you optimize your database in this regard.
  • Interval Partitioning - identify the steps for employing Oracle Database's new partitioning scheme to perform interval partitioning.
  • System and Virtual Column-Based Partitioning - recognize the steps for performing system and virtual column-based partitioning, using Oracle Database 11g's new partitioning scheme.
  • Reference Partitioning - identify the steps for performing reference partitioning, using Oracle Database 11g's new partitioning scheme.
  • Extended Composite Partitioning and Table Compression - recognize the steps for performing extended composite partitioning, using Oracle Database 11g's new partitioning scheme, and for compressing tables.
  • SQL Access Advisor Analysis and Partitioning - recognize the steps for using SQL Access Advisor to help you to decide which partitions, indexes, materialized views, and materialized view logs you need to optimize your database's workload.
  • Getting Partitioning Recommendations - use the SQL Access Advisor to get partitioning recommendations.

Oracle Database 11g: Using RMAN Enhancements, Flashback and LogMiner

identify ways of using Oracle Database 11g's enhanced RMAN, Flashback and LogMiner tools to clone databases, create backups and catalogs, archive historical data, and roll back transactions.
  • New Features of RMAN and Optimized Backups - recognize the ways in which enhancements to RMAN in Oracle Database 11g can help you perform faster and optimized backups.
  • Cloning an Active Database - identify the steps for duplicating an active Oracle Database 11g database.
  • Archival Backups and Recovery Catalog Management - identify the steps for creating and managing archival backups and RMAN catalogs in Oracle Database 11g.
  • Duplicating an Active Database - duplicate an active Oracle Database 11g database.
  • Flashback Data Archives in Oracle Database 11g - recognize the benefits of Flashback Data Archives in Oracle Database 11g for retaining historical data.
  • Flashback Data Archives in Action - identify the steps for using Flashback Data Archives.
  • Flashback Transaction Backout and LogMiner - identify the steps for using the Flashback Transaction Backout and LogMiner features to locate and roll back transactions and user errors in Oracle Database 11g.

Oracle Database 11g: Diagnostic Enhancements and Using the Data Recovery Advisor

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.
  • Automatic Diagnostic Repository - recognize the scope and capabilities of the Automatic Diagnostic Repository (ADR) feature in Oracle Database 11g.
  • Support Workbench Wizard and Service Requests - identify the tasks that can be performed, using the Support Workbench wizard, to handle critical errors in Oracle Database 11g.
  • Incident Packages and Custom Packaging - identify the steps for configuring incident packages and for creating, manipulating, and modifying custom packages.
  • Health Monitor and SQL Repair Advisor - identify the steps for dealing with critical errors in Oracle Database 11g, using the Health Monitor and SQL Repair Advisor tools.
  • Data Recovery Advisor and Data Failures - recognize your options for assessing data failures in Oracle Database 11g, using the Data Recovery Advisor.
  • Data Failure Repair and Corruption Detection - identify the steps for getting advice on repairing data failures, executing these repairs using RMAN data repair commands, and setting parameters to detect further corruption.
  • Repairing a Down Database with Enterprise Manager - repair a down database via Enterprise Manager.

Oracle Database 11g: New Security Features

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.
  • Secure Password Support and Security Settings - recognize ways to configure a password file to use case-sensitive passwords and also how to configure security settings in Oracle Database 11g.
  • Encryption and Fine-Grained Access to Network Services - recognize the different types of encryption in Oracle Database 11g, and identify the steps for managing fine-grained access to external network services.
  • Authentication, TDE, and Security Management - recognize ways for setting up administrator authentication and managing transparent data encryption and other security settings.
  • Password Security Features and Encrypted Tablespaces - identify the steps for increasing the security of passwords and implementing tablespace encryption in Oracle Database 11g.
  • Using an Encrypted Tablespace - identify the best approach to take to encrypt a tablespace in Oracle Database 11g.

Oracle Database 11g: SecureFiles and Miscellaneous New Features

Recognize the steps for enhancing the performance of large objects, caching query results, and performing other miscellaneous tasks in Oracle Database 11g.
  • SecureFiles and LOB Data Types - identify the ways in which SecureFiles enhance the performance of large object (LOB) data types.
  • SecureFile Management in Oracle Database 11g - recognize the steps for migrating to SecureFiles and for creating, altering, accessing, and monitoring them.
  • SecureFiles for Compression, Encryption, and Performance - identify the steps for using SecureFiles for compression, data encryption, and performance.
  • SQL Query Result Cache and Miscellaneous New Features - identify the benefits of SQL Query Result Cache and PL/SQL Function Cache, as well as using other Oracle Database 11g enhancements to online redefinition, locking mechanisms, and invisible indexes.
  • PL/SQL, Adaptive Cursor Sharing, and Temporary Space - recognize the benefits of PL/SQL native compilation enhancements, Adaptive Cursor sharing, and temporary tablespace shrink.
  • Manipulate the Query Result Cache - identify the steps using the SQL Query Result Cache in Oracle Database 11g.
  • Using Result Cache in Oracle Database 11g - identify ways of employing the SQL Query Result Cache in a given scenario.
Register Now
Oracle Database 11g: New Features For Administrators e-learning bundle
  • Course ID:
    271469
  • Duration:
    n/a
  • Price:
    $379