Vi ste ovdje
Overview/Description
In Oracle Database 11g, RAC and Data Guard together provide the benefits of system-level, site-level, and data-level protection, resulting in high levels of availability and disaster recovery without loss of data. This course explains how to configure connections for high availability using various types of workload distribution and load balancing, including Fast Application Notification (FAN), Fast Connection Failover (FCF), and Transparent Application Failover (TAF). It also discusses designing for high availability by minimizing downtime using Data Guard, Data Guard...
Overview/Description
Access paths are the ways in which data is retrieved from the database, and there are a number of different access paths which can be used for tables and indexes. This course explores the access paths used for tables, such as full table, rowid, and sample table scan. It also examines the access paths used for indexes, such as unique, range, full, fast full, skip, and index join index scans, as well as bitmap indexes and combining bitmap indexes. Additionally, this course discusses B*-tree, bitmap, composite, and invisible indexes and nullable columns when using indexes....
Overview/Description
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.
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
Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role
Expected Duration (hours...
Overview/Description
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 features. This course provides an introduction to Oracle Database 11g: Real Application Clusters (RAC) and demonstrates how to fulfill the pre-installation requirements for Oracle Clusterware as well as how to install and configure Clusterware. It also demonstrates the installation of Automatic Storage Management (ASM) and Oracle Database software and then explains how to...
Overview/Description
Identify how to to monitor performance, automate maintenance, calibrate and manage resources, and streamline job scheduling using Oracle Database 11g's intelligent infrastructure enhancements.
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
Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role...
Overview/Description
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 also key steps in business security. This course describes business security requirements and defines least privilege, authorization, and authentication. It also covers security policies, the concept of in-depth security, and applies these concepts to prevent SQL injection. Maintaining data integrity, protecting data, and controlling data access are also covered.
Target...
Overview/Description
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, and perform file-system restoration. In addition, this course explores the Oracle Secure Backup processes, configuring defaults and policies, browsing the primary Oracle Secure Backup catalogs, and performing preconfigured catalog backup. Common tasks such as managing clients, media servers, and volumes are also covered.
Target Audience
Database administrators, support...
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
Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.
Prerequisites
Familiarity with data processing concepts and techniques
Expected Duration (hours)
1.7
Lesson ObjectivesOracle Database 11g: Managing Data Dictionary Views and Large Data Sets
identify the steps for using data...
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 ObjectivesOracle Database 11g: Managing Data in Different Time Zones
recognize the steps for managing time zones and time intervals.
recognize the...
Overview/Description
To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.
Target Audience
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants
Prerequisites
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning
Expected Duration (hours)
1.3
Lesson ObjectivesOracle Database 11g: Managing PL/SQL Code and Dependencies...