Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Oracle Database 11g Release 2: Database Architecture and Installation $74.95
Oracle Database 11g Release 2: Database Creation and Instance Management $74.95
Oracle Database 11g Release 2: The ASM Instance and Network Connectivity $74.95
Oracle Database 11g Release 2: Storage Structures and User Security $74.95
Oracle Database 11g Release 2: Managing Concurrency, Undo, and Auditing $74.95
Oracle Database 11g Release 2: Managing Database Maintenance and Performance $74.95
Oracle Database 11g Release 2: Backup and Recovery $74.95
Oracle Database 11g Release 2: Moving Data and Oracle Support $74.95

Bundle Price: $289.00
Total Savings: $310.60


Oracle Database 11g Release 2: Database Architecture and Installation

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 logical and physical storage structures. In addition, this course describes the role of a database administrator (DBA) and the tasks and tools required for this role. This course also covers how to plan for the Oracle Grid Infrastructure and Oracle Database 11g software installations, as well as how to do the installation using the Oracle Universal Installer. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration I (1Z0-052) exam. Passing this exam will earn the learner Oracle Certified Associated (OCA).
  • identify key characteristics of Oracle Database 11g's grid computing technology
  • identify the main architectural components of Oracle Database 11g
  • identify the components of Oracle Database 11g's memory structures
  • recognize how the Oracle Database 11g process architecture works
  • recognize how information is stored and structured within Oracle Database 11g's storage architecture
  • identify tasks and tools required to administer Oracle Database 11g
  • plan the Oracle Database 11g installation
  • install the Oracle Grid Infrastructure
  • install the Oracle Database 11g software
  • install Oracle Grid Infrastructure
  • install Oracle Database 11g software

Oracle Database 11g Release 2: Database Creation and Instance Management

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 installation to ensure that it runs properly, and is started and shut down correctly to avoid problems. This course describes the DBA tasks to plan a database installation and how to use the Database Configuration Assistant (DBCA) to install the Oracle Database 11g software. It demonstrates how to manage the instance, including setting initialization parameters, accessing the database and Enterprise Manager, viewing information about the instance, startup and shutdown stages, and viewing the alert log to ensure that there are no issues with the instance. This course also demonstrates how to use Oracle Restart to manage components. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration I (1Z0-052) exam. Passing this exam will earn the learner Oracle Certified Associated (OCA).
  • plan a database
  • choose the character set for the database
  • configure a database using the DBCA
  • access a database instance using various Oracle tools
  • recognize the scope and capabilities of database initialization parameters
  • modify database initialization parameters
  • configure database startup and shutdown options
  • assess database performance and metadata information
  • use Oracle Restart to manage components
  • create a new database
  • stop and start the database

Oracle Database 11g Release 2: The ASM Instance and Network Connectivity

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 data file movements and reorganizations. When ASM is used, an ASM instance is also used. The ASM instance allocates memory and uses the SGA differently than in a database instance. This course describes the ASM instance and how it works, and demonstrates how to manage it with various utilities. It discusses the ASM disk groups and how to create, extend, and drop them. This course also identifies how to configure the Oracle network environment which includes configuring and controlling the listeners that allow database connections, creating Oracle Net Service aliases, and the tools for configuring and managing the Oracle network, naming conventions, and shared server usage. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration I (1Z0-052) exam. Passing this exam will earn the learner Oracle Certified Associated (OCA).
  • recognize the primary processes of the ASM instance
  • manage the ASM instance
  • identify the features of ASM disks
  • manage ASM disk groups
  • configure and manage Oracle Net Services and the Oracle Net Listener using Enterprise Manager
  • configure database connections
  • manage the ASM instance and network connectivity

Oracle Database 11g Release 2: Storage Structures and User Security

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 user account and successfully authenticate as required by that user account. What the user can execute once they are logged in is controlled by privileges granted to them, which can be system or object. Privileges can be better controlled by using roles and profiles, which control resource consumption and account status and passwords.This course describes the purpose and functions of tablespaces, and provides details on how to create and manage database user accounts. It also discusses creating privileges, roles, and profiles, as well as using the password file and assigning quotas to users. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration I (1Z0-052) exam. Passing this exam will earn the learner Oracle Certified Associated (OCA).
  • recognize how table data is stored
  • create a new tablespace
  • manage the storage of information in a database
  • create and authenticate database user accounts
  • grant and manage privileges
  • create and manage roles
  • implement user profiles and user security
  • create a new tablespace
  • create and configure profiles
  • create a role

Oracle Database 11g Release 2: Managing Concurrency, Undo, and Auditing

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 managed through Enterprise Manager or SQL statements. Managing undo data and implementing Oracle Database security are also important DBA roles. Data is manipulated using DML, and undo data exists as a copy of the original, premodified data and is captured for every transaction that changes data. Security requirements have been a matter of individual concern until recently, but now there are a variety of laws enforcing the privacy and accuracy of data. This course discusses the locking mechanism in Oracle and how to resolve lock conflicts and deadlocks. It also discusses how to manage undo data, and how to implement database auditing and maintain the audit trail. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration I (1Z0-052) exam. Passing this exam will earn the learner Oracle Certified Associated (OCA).
  • manage locks and data concurrency
  • manage undo data operations to allow users to roll back transactions
  • recognize how auditing is used to secure a database
  • enable and review audit information and maintain the audit trail
  • resolve lock conflicts
  • undo data in a database
  • configure database auditing

Oracle Database 11g Release 2: Managing Database Maintenance and Performance

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 checkers. DBAs must make sure that databases are open and available to users when they need it and that it is working without bottlenecks by gathering performance metrics. This course explores how to specify, review, and maintain audit information. It also discusses how to use Enterprise Manager to monitor performance, and how to use Automatic Memory Management (AMM) and the Memory Advisor to size the memory areas correctly, as well as how to troubleshoot invalid and unusable objects. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration I (1Z0-052) exam. Passing this exam will earn the learner Oracle Certified Associated (OCA).
  • manage Oracle optimizer statistics
  • manage Automatic Workload Repository statistics
  • use the Automatic Database Diagnostic Monitor and advisors
  • view and configure automated maintenance tasks
  • manage alerts
  • monitor and analyze the performance of the database
  • maintain the database by viewing information and implementing a given recommendation
  • manage database performance

Oracle Database 11g Release 2: Backup and Recovery

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 is minimized as much as possible and they can recover the database in an efficient manner. As an Oracle DBA, it is important to understand the various internal consistency checks a database performs as it moves from the shutdown stage to being fully open. Equally important is an understanding of what can cause a failure, and how to recover from an instance failure. This course explores how to identify the types of failure that can occur in an Oracle database and how to prepare a database for failure recovery by using checkpoints, log files, and the flash recovery area and ARCHIVELOG mode, as well as how to perform different types of backups. It also discusses the need for performing recovery and the use of tools such as the Recovery Manager (RMAN) and the Data Recovery Advisor for file recovery operations. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration I (1Z0-052) exam. Passing this exam will earn the learner Oracle Certified Associated (OCA).
  • identify the types of failure that can occur in a database
  • configure a database for instance recovery
  • prevent media failure
  • configure ARCHIVELOG mode
  • identify strategies for backing up a database
  • use RMAN to configure, schedule, manage, and view backup operations
  • perform data recovery
  • prepare a database for recovery
  • perform a database backup
  • perform recovery on a database

Oracle Database 11g Release 2: Moving Data and Oracle Support

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 that critical errors are resolved, which includes contacting Oracle for support. This course explores how to move data using Data Pump Wizards or the command line. Working with the Enterprise Manager Support Workbench, My Oracle Support, service requests, and patch management are also covered. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration I (1Z0-052) exam. Passing this exam will earn the learner Oracle Certified Associated (OCA).
  • identify the features of Oracle Data Pump
  • move data between Oracle Databases using Oracle Data Pump
  • use SQL*Loader to move data from external files into an Oracle Database
  • use external tables to access data in external sources
  • use Enterprise Manager Support Workbench to investigate, report, and resolve issues
  • work with My Oracle Support
  • manage patches
  • move data using the Data Pump
  • load data using SQL*Loader
  • use Support Workbench
Register Now
Oracle Database 11g: Administration Workshop I Release 2 e-learning bundle
  • Course ID:
    271465
  • Duration:
    n/a
  • Price:
    $289