Font size:

Description:

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

Course Price
Oracle Database 11g: Database Architecture and Installation $74.95
Oracle Database 11g: Database Creation, Instance Management, and Connectivity $74.95
Oracle Database 11g: Storage Structures and User Security $74.95
Oracle Database 11g: Managing the Schema, Data, and Concurrency $74.95
Oracle Database 11g: Managing Undo Data, Database Security, and Maintenance $74.95
Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup $74.95
Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database $74.95

Bundle Price: $259.00
Total Savings: $265.65


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
  • Oracle Database 11g Components - identify the main structural components of Oracle Database 11g.
  • Database Memory Structures - identify the components of the Oracle Database 11g memory structures.
  • Database Processes - identify the functions of the Oracle Database 11 server and background processes.
  • Oracle Database 11g Storage Architecture - recognize how information is stored and structured within the Oracle Database 11g storage architecture.
  • Database Administration Tasks and Tools - identify the necessary tasks and essential tools required to administer an Oracle Database 11g database.
  • Installing Oracle Database 11g - recognize the steps for planning and carrying out an installation of Oracle Database 11g software using the Oracle Universal Installer (OUI).
  • Performing an Oracle Database 11g Install - install Oracle Database 11g software in a given scenario.

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.
  • First Steps in Database Creation - recognize the steps for creating, configuring, or deleting a database using the Database Configuration Assistant (DBCA), and also for managing a database instance using various Oracle tools.
  • Maintaining Initialization Parameters - recognize the scope and capabilities of Oracle Database 11g initialization parameters and identify the steps for maintaining them.
  • Database Startup and Shutdown - recognize the steps for configuring database startup and shutdown options, administering a blackout, and using alerts and dynamic data to assess database performance.
  • The Data Dictionary - recognize the steps for using the Data Dictionary to find information about users, objects, constraints, and storage.
  • Creating a New Database - create a database using the DBCA and manage instances using Enterprise Manager.
  • Configuring Oracle Net Services - recognize ways of configuring and managing the Oracle network, and identify the steps for creating a new Oracle Net Listener via Enterprise Manager.
  • Oracle Connections - identify the steps for connecting to an Oracle Database 11g database using different naming methods as well as advanced connection options, and identify when to employ connection pooling.
  • Exploring Oracle Net Services - identify the steps for using and configuring Oracle Net Services in a given scenario.

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.
  • Storage Structures - recognize the purposes of table spaces and datafiles.
  • Creating Tablespaces - recognize the steps for creating a new tablespace.
  • Managing and Viewing Tablespaces - recognize how to manage the storage of information by maintaining tablespaces and viewing their information, and automating manual storage using Automatic Storage Management (ASM).
  • Viewing and Creating Tablespaces - view tablespace information and create a new tablespace.
  • Database User Accounts - recognize the steps for creating and authenticating database user accounts.
  • Privileges and Roles - recognize the steps for granting and revoking privileges and creating and managing roles.
  • Profiles and Users - recognize the steps for creating and managing profiles, implementing password security, and assigning quotas.
  • Granting Privileges - grant privileges to users in a given scenario.

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
  • About Schemas - recognize the features and functions of schemas and data types, and identify the steps for modifying a table.
  • Maintaining Data Integrity - recognize the steps for using constraints to maintain data integrity, viewing the contents of a table, and perform actions on the table.
  • Using Indexes - recognize ways of improving data update and retrieval, storing queries, speeding up performance by creating and using indexes, views, sequences, and temporary tables.
  • Creating Tables, Constraints, and Indexes - create a table with columns and also create constraints and indexes, in a given scenario.
  • Administering PL/SQL Objects - recognize ways for manipulating data with SQL commands and for administering PL/SQL objects.
  • Triggers and Locks - recognize the steps for triggering events, and for monitoring and resolving locking conflicts.

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.
  • Managing Undo Data - recognize the steps for managing undo operations in Oracle Database 11g to allow users to roll back transactions.
  • Industry Security Requirements - recognize the requirements and best practices for implementing database security according to international and regional laws.
  • Database Auditing - recognize the steps for enabling, specifying, maintaining, and reviewing database auditing.
  • Security Updates - recognize the process for obtaining and applying Critical Patch Updates (CPUs).
  • Configuring Database Retention and Security - configure an Oracle Database 11g database to support retention and implement database security in a given scenario.
  • Optimizer Statistics - recognize the steps for managing and gathering optimizer statistics.
  • AWR, ADDM, and the Advisory Framework - identify the steps for managing Automatic Workload Repository (AWR) statistics, using the Automatic Database Diagnostic Monitor (ADDM), and utilizing advisors.
  • Automated Maintenance Tasks - identify the steps for viewing and configuring automated tasks and setting alert thresholds.

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.
  • Performance Monitoring - identify the steps for monitoring and analyzing performance, managing memory, and troubleshooting invalid objects that affect performance.
  • Oracle Database Failure Types - recognize ways to anticipate and avoid various types of failure that can occur in Oracle Database 11g.
  • Instance Recovery - recognize the process used to configure an Oracle Database 11g database for instance recovery.
  • Backup Solutions - recognize the features of different backup strategies you can employ in Oracle Database 11g.
  • Managing Backups with RMAN - recognize the steps for using RMAN to configure, schedule, manage, and view backup operations.
  • Managing Performance, Recovery, and Backups - resolve performance issues, prepare the database for recovery, and perform a database backup in a given scenario.

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.
  • Recovering Data - recognize the tools required and steps performed in identifying whether a recovery is necessary, and then recovering various types of database files.
  • Overview of Moving Data - recognize the features of the various options for moving data in Oracle Database 11g.
  • Moving Data with Oracle Data Pump - recognize the steps for importing, exporting, and moving data between Oracle databases using Oracle Data Pump.
  • Performing Data Recovery and Movement - recover the database from a media failure and move data using the Data Pump Wizard in a given scenario.
  • Oracle Support - recognize the steps for using the Enterprise Manager Support Workbench and Oracle Support to investigate, report on, and resolve problems.
  • MetaLink and Service Requests - recognize the steps for searching MetaLink for new critical patches and for logging service requests.
  • Managing Patches - recognize ways for managing and applying patches in Oracle Database 11g.
Register Now
Oracle Database 11g: Administration Workshop I e-learning bundle
  • Course ID:
    271464
  • Duration:
    n/a
  • Price:
    $259