Online 11g eLearning

Oracle Database 11g PL SQL Variables Attributes and Executable Statements Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements Oracle To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.  more...

Oracle Database 11g Using DML DDL Cursors Control Structures and Loops Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops Oracle To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.  more...

Oracle Database 11g Using Data Types INDEX BY Tables and Cursors in PL SQL Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL Oracle To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters.  more...

Oracle Database 11g Controlling User Access and Managing Schema Objects Oracle Database 11g: Controlling User Access and Managing Schema Objects Oracle To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.  more...

Oracle Database 11g Data Dictionary Views and Large Data Sets Oracle Database 11g: Data Dictionary Views and Large Data Sets Oracle 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.  more...

Oracle Database 11g Managing Data in Different Time Zones Oracle Database 11g: Managing Data in Different Time Zones Oracle To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.  more...

Oracle Database 11g Getting Started with SQL and PL SQL New Features Oracle Database 11g: Getting Started with SQL and PL/SQL New Features Oracle To recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer, and use them to create reports and scripts, browse and manage database objects, find subpatterns, and track dependencies  more...

Oracle Database 11g Using Dynamic SQL and Implementing Performance Improvements Oracle Database 11g: Using Dynamic SQL and Implementing Performance Improvements Oracle To recognize the steps for improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL, language enhancements, and a variety of performance enhancements  more...

Oracle Database 11g Using Trigger Data Warehousing and Pivoting Enhancements Oracle Database 11g: Using Trigger, Data Warehousing, and Pivoting Enhancements Oracle To recognize the steps for improving performance, managing scalabilty, enhancing control and processing speed, and reducing network load using enhanced features such as compound triggers, SecureFile LOBs, and PIVOT operations  more...

Oracle Database 11g Using the PL SQL Debugger Collections and Data Warehousin Oracle Database 11g: Using the PL/SQL Debugger, Collections, and Data Warehousin Oracle To recognize ways to utilize the PL/SQL Debugger to analyze your code, identify the uses and benefits of collections, and identify the steps for employing data warehousing enhancements to improve query execution times.  more...

Oracle Database 11g Using SQL to Query Your Database Oracle Database 11g: Using SQL to Query Your Database Oracle 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.  more...

Oracle Database 11g Conversion Functions Group Functions and Joins Oracle Database 11g: Conversion Functions, Group Functions, and Joins Oracle 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.  more...

Oracle Database 11g Subqueries Set Operators and Data Manipulation Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation Oracle 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.  more...

Oracle Database 11g Using DDL Views Sequences Indexes and Synonyms Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms Oracle 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.  more...

ORACLE DATABASE 11G PL SQL FUNDAMENTALS ORACLE DATABASE 11G: PL/SQL FUNDAMENTALS Oracle  more...

ORACLE DATABASE 11G SQL FUNDAMENTALS II ORACLE DATABASE 11G: SQL FUNDAMENTALS II Oracle  more...

Oracle 11g DBA OCA Library Oracle 11g DBA OCA Library Oracle Oracle Database 11g Administrator Certified Associate Oracle Database Administrator 11g Certfied Associate Library  more...

Oracle Database 11g R2 Database Architecture Recovery Operations ...11g R2: Database Architecture & Recovery Operations Oracle An important aspect of Oracle Database administration is to understand how a database and its major components function. Also as an Oracle Database administrator, you need to be able to recover when problems occur in the database. This is accomplished using backups, which are used to protect against problems such as media failure,  more...

Oracle Database 11g R2 The RMAN Catalog Creataing Backups ...11g R2: The RMAN Catalog & Creataing Backups Oracle RMAN uses a recovery catalog to store metadata about Oracle databases, and allows stored scripts to be used to run sequences of RMAN commands stored in the catalog. When administering an Oracle Database, it is important to be familiar with what a backup is, how the process of creating a backup is completed, and the various types of  more...

ORACLE DATABASE 11G ADMINISTRATION WORKSHOP II R2 ORACLE DATABASE 11G: ADMINISTRATION WORKSHOP II R2 Oracle  more...

Oracle Database 11g R2 Managing Database Space Duplication ...11g R2: Managing Database Space & Duplication Oracle To effectively manage space, you can configure automatic management by the Oracle database server. This allows you to generate alerts about potential problems and recommend possible solutions. This course explores how to use the Oracle database server for automatic space management, proactively monitor and manage tablespace space usage,  more...

Oracle Database 11g R2 Managing Databse Resources The Scheduler ...11g R2: Managing Databse Resources & The Scheduler Oracle By using the Database Resource Manager, you have more control over the allocation of machine resources than is normally possible through operating system resource management alone. Many tasks in the Oracle environment need job-scheduling capabilities. Using advanced Scheduler features, you can exercise more control over various  more...

Oracle Database 11g R2 Managing Database Memory Performance ...11g R2: Managing Database Memory & Performance Oracle Because there is a finite amount of memory available on a database server and on an Oracle Database 11g instance, you must pay attention to how memory is allocated. Also, database planning must include a balance between performance, cost, and reliability. You must consider the investment in the system architecture, which includes the  more...

Oracle Database 11g R2 Database Diagnostics Flashsback Technologies ...11g R2: Database Diagnostics & Flashsback Technologies Oracle Administering an Oracle database requires monitoring and diagnosing data failures and recovering from them. Oracle Database 11g Release 2 provides the Data Recovery Advisor which eases this task by automatically detecting errors when they occur and providing repair advice. The use of the Automatic Diagnostic Repository can also  more...

Oracle Database 11g R2 Performing Restore Recovery Tasks ...11g R2: Performing Restore & Recovery Tasks Oracle As a database administrator it is very important to understand how to restore and recover your database in the event of a loss of a file due to media, hardware, or user error. The restoration process involves moving a backup into place to be used by the database when a file is damaged. The recovery process involves applying redo to bring  more...

Oracle Database 11g R2 Using Monitoring Tuning RMAN ...11g R2: Using, Monitoring & Tuning RMAN Oracle Reconstructing the contents of all or part of a database from a backup typically involves two phases. The first phase is the retrieval of a copy of the data file from the backups. The second involves reapplying changes to the file that occurred since the backup, using archived and online redo logs. To effectively administer an Oracle Database  more...

ORACLE DATABASE 11g SQL PL SQL NEW FEATURES ORACLE DATABASE 11g: SQL & PL/SQL NEW FEATURES Oracle  more...

ORACLE DATABASE 11g SQL FUNDAMENTALS I ORACLE DATABASE 11g: SQL FUNDAMENTALS I Oracle  more...

Oracle SOA Suite 11g Introduction to SOA ...11g: Introduction to SOA Oracle This course outlines the challenges faced by enterprises in integrating applications, and how Service-Oriented Architecture can provide a solution. The various drivers that enable you to build a reference architecture, which is the first step toward embarking into a Service-Oriented Architecture, will also be covered. This course also introduces the Oracle  more...

Oracle SOA Suite 11g SOA Governance Service Design ...11g: SOA Governance & Service Design Oracle In this course, the need for governance in a Service-Oriented Architecture environment is highlighted, and the different characteristics related to service management are covered. You are also introduced to the concepts that enable defining and implementing a service. This is an important aspect of designing an SOA system as it allows  more...

Oracle SOA Suite 11g SOA Composite Applications Oracle SOA Suite 11g: SOA Composite Applications Oracle In this course, the need of governance in a Service-Oriented Architecture environment is highlighted. It also introduces the various service artifacts and service classification in a Service-Oriented Architecture environment.  more...

Oracle SOA Suite 11g Mediator BPEL Components Oracle SOA Suite 11g: Mediator & BPEL Components Oracle This course introduces you to the Mediator component and its routing functionality. You will also be introduced to process orchestration concepts and using the BPEL component.  more...

Oracle SOA Suite 11g Human Task Business Rules Components Oracle SOA Suite 11g: Human Task & Business Rules Components Oracle This course introduces the Human Workflow task component and its functionality. It also introduces you to Oracle Business Rules and its features.  more...

Oracle SOA Suite 11g SOA Security Adoption Planning Oracle SOA Suite 11g: SOA Security & Adoption Planning Oracle This course provides an introduction to the topic of securing services and composite applications. It also describe the activities involved in SOA adoption planning.  more...

ORACLE SOA SUITE 11G ESSENTIAL CONCEPTS ORACLE SOA SUITE 11G: ESSENTIAL CONCEPTS Oracle  more...

Oracle Database 11g Subprograms Packages Exception Handling in PL SQL Oracle Database 11g: Subprograms, Packages & Exception Handling in PL/SQL Oracle To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.  more...

Oracle Database 11g Packages Dynamic SQL Coding Considerations in PL SQL Oracle Database 11g: Packages, Dynamic SQL & Coding Considerations in PL/SQL Oracle To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.  more...

Oracle Database 11g Using Triggers the PL SQL Compiler Managing Code Oracle Database 11g: Using Triggers, the PL/SQL Compiler & Managing Code Oracle To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings.  more...

Oracle Database 11g Managing PL SQL Code Dependencies Oracle Database 11g: Managing PL/SQL Code & Dependencies Oracle To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.  more...

ORACLE DATABASE 11G DEVELOP PL SQL PROGRAM UNITS ORACLE DATABASE 11G: DEVELOP PL/SQL PROGRAM UNITS Oracle  more...

Oracle Database 11g Querying a Database with SQL Oracle Database 11g: Querying a Database with SQL Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert 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.  more...

Oracle 11g Conversion Funct Conditional Expressions Group Funct Joins Oracle 11g: Conversion Funct., Conditional Expressions, Group Funct. & Joins Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert 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.  more...

Oracle Database 11g Manipulating Queries Data Oracle Database 11g: Manipulating Queries & Data Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert 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.  more...

Oracle Database 11g Using DDL Views Schema Objects Oracle Database 11g: Using DDL, Views & Schema Objects Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert 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.  more...

Oracle Database 11g Controlling User Access Managing Objects Oracle Database 11g: Controlling User Access & Managing Objects Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.  more...

Oracle Database 11g Managing Data Dictionary Views Large Data Sets Oracle Database 11g: Managing Data Dictionary Views & Large Data Sets Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert 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.  more...

Oracle Database 11g Managing Time Zones Datetime Functions Oracle Database 11g: Managing Time Zones & Datetime Functions Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.  more...

Oracle Database 11g Suqueries Regular Expressions Oracle Database 11g: Suqueries & Regular Expressions Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.  more...

1Z0-047 Oracle Database 11g SQL Expert 1Z0-047 Oracle Database 11g SQL Expert Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert  more...

Oracle Database 11g Getting Started with PL SQL Oracle Database 11g: Getting Started with PL/SQL Oracle To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.  more...

Oracle Database 11g Using DML DDL Cursors Loops Control Structures Oracle Database 11g: Using DML, DDL, Cursors, Loops & Control Structures Oracle To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.  more...

Oracle Database 11g Using Data Types INDEX BY Tables Cursors Oracle Database 11g: Using Data Types, INDEX BY Tables & Cursors Oracle To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters.  more...

Oracle Database 11g Using Exceptions Subprograms JDeveloper REF Cursors Oracle Database 11g: Using Exceptions, Subprograms, JDeveloper & REF Cursors Oracle To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables.  more...

Oracle Database 11g Subprograms Packages Exception Handling Oracle Database 11g: Subprograms, Packages & Exception Handling Oracle To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.  more...

Oracle Database 11g Packages Dynamic SQL Coding Considerations Oracle Database 11g: Packages, Dynamic SQL & Coding Considerations Oracle To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.  more...

Oracle Database 11g Using Triggers the PL SQL Compiler Oracle Database 11g: Using Triggers & the PL/SQL Compiler Oracle To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings.  more...

Oracle Database 11g PL SQL Code Dependency Management Oracle Database 11g: PL/SQL Code & Dependency Management Oracle To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.  more...

ORACLE DATABASE 11G PROGRAM WITH PL SQL ORACLE DATABASE 11G: PROGRAM WITH PL/SQL Oracle  more...

Oracle Database 11g Performance Tuning Methodology Tools ...11g: Performance Tuning Methodology & Tools Oracle 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  more...

Oracle Database 11g Using AWR Defining Problems ...11g: Using AWR & Defining Problems Oracle 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  more...

Oracle Database 11g Metrics Alerts Baselines AWR Tools Services ...11g: Metrics, Alerts, Baselines, AWR Tools & Services Oracle 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  more...

Oracle Database 11g Problem SQL Statements Oracle Optimizer ...11g: Problem SQL Statements & Oracle Optimizer Oracle 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  more...

Oracle Database 11g SQL Performance Database Replay ...11g: SQL Performance & Database Replay Oracle 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  more...

Oracle Database11g Shared Pool Buffer Cache Tuning ...11g: Shared Pool & Buffer Cache Tuning Oracle 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  more...

Oracle Database 11g Tuning PGA Temporary Space AMM ...11g: Tuning PGA, Temporary Space & AMM Oracle 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  more...

Oracle Database 11g Segment Space I O and Performance Tuning ...11g: Segment Space, I/O and Performance Tuning Oracle 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)  more...

ORACLE DATABASE 11G PERFORMANCE TUNING ORACLE DATABASE 11G: PERFORMANCE TUNING Oracle  more...

Oracle Database 11g Architecture SQL Tuning Optimization ...11g: Architecture, SQL Tuning & Optimization Oracle The Oracle Database server consists of an Oracle Database and one or more Oracle Database instances. SQL (Structured Query Language) is the language with which all programs and users access an Oracle Database. Monitoring the performance of and tuning database components, as well as the SQL statements used to access and manipulate the  more...

Oracle Database 11g Indexes Access Paths and Join Operations ...11g: Indexes, Access Paths and Join Operations Oracle 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,  more...

Oracle Database 11g Execution Plans and Star Transformations ...11g: Execution Plans and Star Transformations Oracle An execution plan is the output of the optimizer and is presented to the execution engine for implementation. The execution plan instructs the execution engine about the operations it must perform for retrieving the data required by a query most efficiently. This course explores gathering, displaying, and interpreting execution plans.  more...

Oracle Database 11g Optimizer Statistics Hints Cursor Sharing ...11g: Optimizer Statistics, Hints & Cursor Sharing Oracle Optimizer statistics describe details about the database and the objects in the database and are used by the query optimizer to select the best execution plan for each SQL statement. This course covers gathering optimizer and system statistics, setting statistic preferences, using dynamic sampling, and manipulating optimizer  more...

Oracle Database 11g Application Tracing Automatic SQL Tuning ...11g: Application Tracing & Automatic SQL Tuning Oracle Oracle Database implements tracing by generating a trace file for each server process when you enable the tracing mechanism. This course explores configuring the SQL Trace facility to collect session statistics, using the TRCSESS utility to consolidate SQL trace files, formatting trace files using the tkprof utility, and interpreting  more...

ORACLE DATABASE 11G SQL TUNING ORACLE DATABASE 11G: SQL TUNING Oracle  more...

Oracle Database 11g Configuring OSB Security ...11g: Configuring OSB & Security Oracle Oracle Secure Backup or OSB is centralized tape-management software that allows you to backup and restore data using a variety of machine architectures. This course covers how OSB complements the Oracle backup and recovery options, as well as terminology, interface options, and backup management features. Additionally, it explores how to decide on  more...

Oracle Database 11g Securing Domain Data In Oracle Secure Backup ...11g: Securing Domain & Data In Oracle Secure Backup Oracle Oracle Secure Backup (OSB) maintains its own catalog of OSB and their rights on the administrative server. You can preauthorize users for the use of the obtool command line, RMAN, or both. You can also associate an OSB user with multiple Windows domain accounts or a single account that applies to all Windows domains. This course  more...

Oracle Database 11g RMAN and Oracle Secure Backup ...11g: RMAN and Oracle Secure Backup Oracle RMAN manages the disk space in the Flash Recovery Area, and by putting RMAN in control of your backup and restore operations, you simplify your availability-related processes. This course describes integrated disk and tape backup, how to register the administrative server in Enterprise Manager, checking RMAN backup and recovery settings, creating  more...

Oracle Database 11g Managing Backups Infrastructure ...11g: Managing Backups & Infrastructure Oracle 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,  more...

Oracle Dabase 11g Tape Vaulting Duplication Tuning ...11g: Tape Vaulting, Duplication & Tuning Oracle Oracle Secure Backup uses a volume rotation policy to track a backup volume as it moves from its originating location to a storage location and is eventually recycled. This process is known as vaulting. This course covers configuring and using tape vaulting and a tape vaulting environment, viewing tape rotation reports, and troubleshooting  more...

ORACLE DATABASE 11G SECURE BACKUP ORACLE DATABASE 11G: SECURE BACKUP Oracle  more...

Oracle Database 11g Installation of Clusterware RAC ...11g: Installation of Clusterware & RAC Oracle 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  more...

Oracle Database 11g RAC Database Oracle Clusterware Admin ...11g: RAC Database & Oracle Clusterware Admin. Oracle Oracle Database 11g has many tools available for administering a RAC Database and Oracle Clusterware, including Oracle Enterprise Manager. This course explains how to use Enterprise Manager cluster database pages to administer a RAC database and how to carry out various administration tasks on Oracle Clusterware. It discusses how to  more...

Oracle Database 11g RAC Performance Tuning ...11g: RAC Performance Tuning Oracle Performance Tuning uses diagnostic tools to gather statistics, statistic rates, and sampled statistics in order to tune the database system to provide the best performance as efficiently as possible. Although there are specific tuning areas for Oracle Database 11g: RAC, such as instance recovery and interconnect traffic, you will get the best performance  more...

Oracle Database 11g Configure Manage Use Services in RAC ...11g: Configure, Manage & Use Services in RAC Oracle A service is a grouping of related tasks within a database with common functionality, quality expectations, and priority relative to other services. It provides a single-system image for managing competing applications running within a single instance and across multiple instances and databases. Using standard interfaces, such as the  more...

Oracle Database 11g Diagnosing Oracle Clusterware Node Management ...11g: Diagnosing Oracle Clusterware & Node Management Oracle Problems that occur with Oracle RAC instances can be difficult to diagnose because they span across two or more nodes in a cluster. Oracle Database 11g provides various methods for diagnosing and debugging Oracle Clusterware and RAC components. This course discusses the basics of debugging and the use of diagnostics in a RAC  more...

Oracle Database 11g High Availability ...11g: High Availability Oracle 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  more...

ORACLE DATABASE 11G RAC ADMINISTRATION ORACLE DATABASE 11G: RAC ADMINISTRATION Oracle  more...

Oracle Database 11g Database Security ...11g: Database Security Oracle Oracle Database server is highly secure, but to fully maximize the security features offered, the database must be well protected as well. This course explores how to configure Oracle Database 11g in a secure manner by adhering to industry standard best security practices for operational database deployments. It covers applying the principle of least  more...

Oracle Database 11g Database Auditing ...11g: Database Auditing Oracle Monitoring or auditing should be an integral part of your security procedures. Oracle Database 11g includes auditing tools for database, user, and fine-grained auditing. This course explores how to implement basic database auditing, privileged user auditing, DML and DDL auditing, and how to send audit records to the operating system files. Implementing  more...

Oracle Database 11g Basic User Strong Authentication ...11g: Basic User & Strong Authentication Oracle A basic security requirement is that you must know your users. You must identify them before you can determine their privileges and access rights, so that you can audit their actions on the data. This course covers creating and auditing database authenticated users and operating-system-authenticated users. It explores authenticating users  more...

Oracle Database 11g Enterprise User Security Proxy Authentication ...11g: Enterprise User Security & Proxy Authentication Oracle Enterprise User Security addresses the user, the administrative, and the security challenges by centralizing storage and management of user-related information in a Lightweight Directory Access Protocol-compliant directory service. This course describes the basic components of Enterprise User Security. It shows the architecture  more...

Oracle Database 11g Privileges Roles Application Contexts ...11g: Privileges, Roles & Application Contexts Oracle Authorization is the process that determines the privileges that the user is allowed to exercise. In the Oracle database, authorization is determined by the grant of system and object privileges. This course covers implementing roles, enterprise roles, and the securing of objects through procedures. It also describes how secure  more...

Oracle Database 11g Virtual Private Database ...11g: Virtual Private Database Oracle A Virtual Private Database (VPD) uses fine-grained access control (FGAC) to limit row and column access and an application context to provide the information that is used to set the policy predicates. This course describes VPD, how to implement VPD, and group policies. It also explores how FGAC is used with VPD, as well as tools, policies, and policy  more...

Oracle Database 11g Oracle Label Security the Data Masking Pack ...11g: Oracle Label Security & the Data Masking Pack Oracle Oracle Label Security is a powerful tool for classifying data and mediating access to data based on its classification. It provides an easy-to-implement row-level security solution and is built on the fine-grained access control technology of the virtual private database (VPD). This course describes Oracle Label Security, including  more...

Oracle Database 11g Encryption Concepts ...11g: Encryption Concepts Oracle All encryption has two parts: an algorithm, which is a procedure or a method of manipulating data, and a key or a secret that allows data to be decrypted. This course discusses the issues and challenges of encryption and describes key management solutions. It also describes the encryption options available with Oracle Database 11g. Using DBMS_CRYPTO to  more...

Oracle Database 11g Transparent Data Encryption ...11g: Transparent Data Encryption Oracle Transparent Data Encryption (TDE) is available with Oracle Advanced Security (ASO) and provides easy-to-use protection for your data without requiring changes to your applications. This course demonstrates how to set up the database master encryption key and implement TDE. It also explores how to encrypt column and tablespace data. Using Recovery  more...

Oracle Database 11g Oracle Net Services Listener Security ...11g: Oracle Net Services & Listener Security Oracle When considering Oracle security, you must also consider the security of the listener, which is the gateway to the network and the network itself. This course describes the items on the client, listener, and network security checklists. It demonstrates how to secure administration of the network, restrict access by IP address, and  more...

Oracle Database 11g Firewalls Oracle Connection Manager and SQL Plus Security ...11g: Firewalls, Oracle Connection Manager and SQL*Plus Security Oracle There is no single best architecture for accommodating Internet requests requiring access to corporate intranets. Instead, trade-offs must be made between two competing goals: security of the intranet against an Internet attack and ease of access to services by both Internet and intranet clients. This course describes  more...

Oracle Database 11g R2 Installation Oracle Restart ...11g R2: Installation & Oracle Restart Oracle 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  more...

Oracle Database 11g R2 ASM Storage Partitioning Enhancements ...11g R2: ASM, Storage & Partitioning Enhancements Oracle 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,  more...

Oracle Database 11g R2 Oracle Partioning Security Features ...11g R2: Oracle Partioning & Security Features Oracle 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  more...

Oracle Database 11g R2 Using Change Management Solutions ...11g R2: Using Change Management Solutions Oracle 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  more...

Oracle Database 11g R2 Intelligent Infrastructure Enhancements ...11g R2: Intelligent Infrastructure Enhancements Oracle 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  more...

Oracle Database 11g R2 Diagnosability Enhancements ...11g R2: Diagnosability Enhancements Oracle 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  more...

Oracle Database 11g R2 SQL Monitoring Performance Enhancements ...11g R2: SQL Monitoring & Performance Enhancements Oracle 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  more...

Oracle Database 11g R2 Application Performance Enhancements ...11g R2: Application Performance Enhancements Oracle 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  more...

Oracle Database 11g R2 Backup Recover Archive Repair Data ...11g R2: Backup, Recover, Archive & Repair Data Oracle 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  more...

Oracle Database 11g R2 Oracle Scheduler Secure Backup ...11g R2: Oracle Scheduler & Secure Backup Oracle 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  more...

ORACLE DATABASE 11G R2 NEW FEATURES FOR ADMINISTRATORS R2 ORACLE DATABASE 11G R2: NEW FEATURES FOR ADMINISTRATORS R2 Oracle  more...

Oracle Database 11g R2 Database Architecture Installation ...11g R2: Database Architecture & Installation Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 To understand how an Oracle Database functions, it is important to gain a basic understanding of its major components. This course identifies the major architectural components of the Oracle Database 11g Release 2,  more...

Oracle Database 11g R2 Database Creation Instance Management ...11g R2: Database Creation & Instance Management Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 As an Oracle Database administrator, it is important to plan the database to ensure that the database software is installed properly. Planning involves the logical storage structure, the overall design, and a backup  more...

Oracle Database 11g R2 The ASM Instance Network Connectivity ...11g R2: The ASM Instance & Network Connectivity Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 Oracle Database 11g Release 2 offers Automatic Storage Management (ASM), which eliminates the need for many tasks that are required on a non-ASM storage environment by the DBA. Some of these tasks include I/O  more...

Oracle Database 11g R2 Storage Structures User Security ...11g R2: Storage Structures & User Security Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 An Oracle database is divided into logical storage units called tablespaces. Oracle also provides Oracle-Managed Files (OMF), which eliminate the need for the DBA to directly manage the operating system files in the Oracle  more...

Oracle Database 11g R2 Managing Concurrency Undo Auditing ...11g R2: Managing Concurrency, Undo & Auditing Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 Oracle Database 11g Release 2 is designed to prevent multiple users from changing the same data at the same time by implementing locks. These locks are used to manage data concurrency and are implemented automatically,  more...

Oracle Database 11g R2 Managing Database Maintenance Performance ...11g R2: Managing Database Maintenance & Performance Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 General database maintenance and performance monitoring are important Oracle DBA tasks. Proactive and reactive database maintenance is made easy by the sophisticated infrastructure of Oracle Database 11g Release  more...

Oracle Database 11g R2 Backup Recovery ...11g R2: Backup & Recovery Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 Preparing for and performing data recovery and completing database backups are expected job duties of an Oracle Database 11g Database Administrator (DBA) to ensure that the database is available for users when they require it. They also  more...

Oracle Database 11g R2 Moving Data Oracle Support ...11g R2: Moving Data & Oracle Support Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 From time to time Oracle DBAs are required to move data. Oracle Database 11g Release 2 offers various ways to complete this task, including Oracle Data Pump, SQL*Loader, and the use of external tables. DBAs are also required to  more...

1Z0-052 ORACLE DATABASE 11G ADMINISTRATION WORKSHOP I R2 1Z0-052 ORACLE DATABASE 11G: ADMINISTRATION WORKSHOP I R2 Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2  more...

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.  more...

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.  more...

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.  more...

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  more...

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.  more...

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.  more...

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.  more...

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.  more...

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.  more...

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.  more...

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  more...

Oracle Database 11g Database Architecture and Installation Identify the elements of the Oracle Database 11g architecture and recognize the tools and steps required to install the Oracle Database 11g software  more...

Oracle Database 11g Database Creation Instance Management and Connectivity Identify the steps for creating a new Oracle Database 11g database and then configuring it and managing the instance, and also recognize the steps for configuring new Oracle Net Listeners and database connectivity  more...

Oracle Database 11g Storage Structures and User Security identify the steps for maintaining storage structures and automating storage management in Oracle Database 11g, and for managing privileges, roles, and other security features for users.  more...

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  more...

Oracle Database 11g Managing Undo Data Database Security and Maintenance recognize the steps required to manage undo information, secure an Oracle Database 11g database, and maintain it by monitoring statistics, automated tasks and alert thresholds.  more...

Oracle Database 11g Performance Monitoring Recovery Concepts and Backup identify the steps for ensuring an Oracle Database 11g database is available to users when needed, by monitoring its performance, anticipating and avoiding database failure, setting up instance recovery options, and creating backups.  more...

Oracle Database 11g Recovering Moving and Enhancing the Oracle Database recognize ways to make use of Oracle Database 11g's tools for moving and recovering data, reporting on problems, and installing updates to enhance a database.  more...

Oracle Database 11g Database Architecture and ASM To recognize the structural elements in Oracle Database 11g's architecture, including and Automatic Storage Management (ASM), and recognize the steps for managing storage using disk groups.  more...

Oracle Database 11g Configuring for Recovery 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.  more...

Oracle Database 11g Configuring for Backups 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.  more...

Oracle Database 11g Using RMAN for Recovery 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.  more...

Oracle Database 11g Supporting RMAN and Using Flashback Technology 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 11g's flashback features.  more...

Oracle Database 11g Diagnosing the Database and Managing Memory 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.  more...

Oracle Database 11g Database Performance and Space Management 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.  more...

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.  more...

Oracle Database 11g Globalization To recognize the steps for utilizing Oracle Database 11g's globalization support features to ensure that information and data is displayed in a user's native language, and that territory and language-dependent conventions are adhered to.  more...

Understandng Wireless Sol Part 2 IEEE 802 11 Standards WLANs ...titute of Electrical and Electronics Engineers (IEEE) 802.11g standard. Match additional Institute of Electrical and Electronics Engineers (IEEE) 802.11 task groups with their functions. Identify features of Wireless Fidelity (Wi-Fi) Certification. Identify features of Wireless Local Area Network (WLAN) access points (APs).  more...

Certification in Oracle Applications Technologies Hello, Greetings from iWare Logic !!! We are Oracle Approved Education Center which provide Trainings & Certifications in Oracle Applications in 11i & R12 Codes Exams IZ0-007 Introduction to 9i- SQL IZ0-147 Oracle 9i Program with PL/ SQL IZ0-031 Oracle 9i- Database Fundamentals -I IZ0-032 Oracle 9i- Database Fundamentals -II IZ0-033 Oracle 9i Database- Performance Tuning  more...