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.
Oracle Database 11g: Installation of Clusterware and RAC
Oracle Database 11g: Real Application Clusters (RAC) enable high utilization of a cluster of standard, low-cost modular servers and offers high availability, scalability, and important grid computing ...
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.
Oracle Database 11g: Introduction to Database Security and Solutions
Every business should identify security threats and concerns and develop policies to protect itself. Maintaining the integrity of important data, and protecting data by controlling access to it are ...
Oracle Database 11g: Managing Backups and Infrastructure
Restoring files is easily accomplished using the Oracle Secure Backup catalog. This course demonstrates how to browse the catalog for file-system backup data, create catalog-based restore requests, ...
Oracle Database 11g: Managing Data Dictionary Views and Large Data Sets
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 ...
Oracle Database 11g: Managing Data in Different Time Zones
To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.
Oracle Database 11g: Managing PL/SQL Code and Dependencies
To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.
Oracle Database 11g: Managing Resources and Task Automation
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.
Oracle Database 11g: Managing the Schema, Data, and Concurrency
Identify the steps for managing schema objects, such as tables, views, and indexes, and recognize ways to use SQL and PL/SQL commands to manipulate data and ensure data concurrency