Online Administration Workshop eLearning

ORACLE DATABASE 10g ADMINISTRATION WORKSHOP I RELEASE 2 ORACLE DATABASE 10g: ADMINISTRATION WORKSHOP I RELEASE 2 Oracle  more...

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

Oracle Database 11g R2 Database Architecture Installation ...istrator 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, explains memory structures, describes background processes, and explores the  more...

Oracle Database 11g R2 Database Creation Instance Management ...istrator 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 strategy. It is also important to manage the database instance after the  more...

Oracle Database 11g R2 The ASM Instance Network Connectivity ...istrator 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 performance tuning, file system, cluster file system, and raw device management, and  more...

Oracle Database 11g R2 Storage Structures User Security ...istrator 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 database. To access the database, a user must specify a valid database  more...

Oracle Database 11g R2 Managing Concurrency Undo Auditing ...istrator 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, which can sometimes cause lock conflicts. Lock conflicts can be detected and  more...

Oracle Database 11g R2 Managing Database Maintenance Performance ...istrator 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 2, including elements such as Automatic Workload Repository (AWR) and database health  more...

Oracle Database 11g R2 Backup Recovery ...istrator 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 need to ensure if a failure does occur that the loss of data  more...

Oracle Database 11g R2 Moving Data Oracle Support ...istrator 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 ensure that the database is up-to-date with the latest patches and  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 10g Administration Workshop II Part 4 This course will teach learners to configure an Oracle database for multilingual applications and distributed database access. Learners will learn how to use various database technologies, such as Resource Manager, the Scheduler, and materialized views. Learn To: Identify features of Automatic Storage Management (ASM). Identify features of Automatic Storage Management (ASM)  more...

Oracle Database 10g Administration Workshop II Part 3 This course covers various functions of the Flashback technology. In addition to performing flashback operations at the database level, you can flash back a table or recover a table that has been dropped by mistake. The course also covers the tools used to monitor and improve database performance as well as detect and repair database corruption. Learn To: Identify features of  more...

Oracle Database 10g Administration Workshop II Part 2 This course will teach learners to use RMAN and explain the various RMAN commands. Diagnostic sources, non-critical recovery, and incomplete recovery concepts are also covered in this course. Learners will also learn how to perform incomplete recovery. Learn To: Match various RMAN commands with their features. Distinguish between the methods for issuing RMAN commands. Identify  more...

Oracle Database 10g Administration Workshop I Part 4 Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will also be taught about undo management, lock management, and backup and recovery techniques. Learn To: Identify benefits of undo data. Identify features of undo segments. Identify undo management tasks that a DBA should perform  more...

Oracle Database Administration Workshop I Part 2 Oracle Database 10g is the first database designed for enterprise grid computing, the most flexible and cost-effective way to manage enterprise information. This course covers salient aspects of Oracle Database 10g such as user and data management. The basic aspects of database management such as database integrity constraints, transferring data, and defining tables and schemas has been discussed  more...

Oracle Database 10g Administration Workshop II Curriculum ...Administration Workshop II Curriculum includes the following courses: Oracle Database 10g: Administration Workshop II(Part 1) Oracle Database 10g: Administration Workshop II (Part 2) Oracle Database 10g: Administration Workshop II (Part 3) Oracle Database 10g: Administration Workshop II (Part 4) To review individual course descriptions, please return to the previous page and  more...

Oracle Database 10g Administration Workshop II Part 1 This course will teach learners to configure an Oracle database for multilingual applications and distributed database access. Students will also practice various methods of recovering the database, using RMAN, SQL, and Flashback technology. Learn To: Match goals of Oracle Database 10g manageability features with the methods of achieving them. Identify features of the Oracle  more...

Oracle Database 10g Administration Workshop I Curriculum ...Administration Workshop I Curriculum includes the following courses: Oracle Database 10g: Administration Workshop I (Part 1) Oracle Database 10g: Administration Workshop I (Part 2) Oracle Database 10g: Administration Workshop I (Part 3) Oracle Database 10g: Administration Workshop I (Part 4) To review individual course descriptions, please return to the previous page and select  more...

Oracle Database 10g Administration Workshop I Part 1 Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will be taught to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Learn To:  more...

IBM DB2 Universal Database V6 1 Admin Curriculum ...repare for the ILT exams DB2 UDB Fundamentals and DB2 UDB Administration Workshop for Windows NT. L earn To: See individual course descriptions for specific course objectives and scope. C ontent Emphasis Skills-Based A udience These courses are intended for database administrators. Students should have a fundamental understanding of relational database technology,  more...

IBM DB2 Universal Database V6 1 Admin Curriculum ...repare for the ILT exams DB2 UDB Fundamentals and DB2 UDB Administration Workshop for Windows NT. L earn To: See individual course descriptions for specific course objectives and scope. C ontent Emphasis Skills-Based A udience These courses are intended for database administrators. Students should have a fundamental understanding of relational database technology,  more...