Online 11g Dba eLearning

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 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 R2 Installation Oracle Restart Oracle Database 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  more...

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

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

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

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

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

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

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

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

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

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

Oracle Database 11g R2 Database Creation Instance Management Oracle Database 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,  more...

Oracle Database 11g R2 The ASM Instance Network Connectivity Oracle Database 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  more...

Oracle Database 11g R2 Storage Structures User Security Oracle Database 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  more...

Oracle Database 11g R2 Managing Concurrency Undo Auditing Oracle Database 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  more...

Oracle Database 11g R2 Managing Database Maintenance Performance Oracle Database 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  more...

Oracle Database 11g R2 Backup Recovery Oracle Database 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.  more...

Oracle Database 11g R2 Moving Data Oracle Support Oracle Database 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  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...

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