Font size:

Description:

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

Course Price
Oracle Database 10g: Installing Oracle Database 10g Release 2 $74.95
Oracle Database 10g: Creating Databases Release 2 $74.95
Oracle Database 10g: Database Interfaces Release 2 $74.95
Oracle Database 10g: Database Control and Storage Structures Release 2 $74.95
Oracle Database 10g: Users and Security Release 2 $74.95
Oracle Database 10g: Managing Schema Objects and Data Release 2 $74.95
Oracle Database 10g: The SQL*Loader and PL/SQL Release 2 $74.95
Oracle Database 10g: Oracle Net Services and Shared Servers Release 2 $74.95
Oracle Database 10g: Monitoring and Maintenance Release 2 $74.95
Oracle Database 10g: Managing Undo Data and Lock Conflicts Release 2 $74.95
Oracle Database 10g: Managing Backup and Recovery Release 2 $74.95

Bundle Price: $379.00
Total Savings: $445.45


Oracle Database 10g: Installing Oracle Database 10g Release 2

To introduce the concepts of RDBMS and Oracle database administration, and explain how to install Oracle Database 10g software
  • Introducing RDBMS - recognize the characteristics of a relational database system.
  • Introducing Oracle database administration - identify the basic tasks and tools involved in Oracle database administration.
  • RDBMS and Oracle database administration - identify the basic concepts involved in RDBMS and Oracle database administration.
  • The Oracle Database 10g preinstall process - identify the components involved in the Oracle preinstall process.
  • Setting up the Oracle install environment - recognize how to configure the Oracle install environment using the Oracle Universal Installer.
  • Configuring the Oracle Database 10g installation - recognize how to configure the Oracle Database 10g installation.
  • Installing Oracle Database 10g - install Oracle Database 10g on a UNIX operating system.

Oracle Database 10g: Creating Databases Release 2

To provide an overview of Oracle database and instance architecture and demonstrate how to use the Database Configuration Assistant
  • Oracle 10g database architecture - identify the files and logical storage units that make up the Oracle database.
  • Managing the Oracle 10g instance - recognize the characteristics of the Oracle instance and its management interfaces.
  • The architecture of an Oracle 10g database - distinguish between the basic components of Oracle database architecture.
  • Using Oracle 10g's Database Configuration Assistant - recognize how to configure database identification, management, password, and storage options using the Database Configuration Assistant.
  • Setting file locations and parameters in Oracle 10g - recognize how to use the Database Configuration Assistant to set file locations and parameters.
  • Finalizing the Oracle 10g instance - recognize how to set database storage settings and creation options, and delete a database using the Database Configuration Assistant.
  • Creating an Oracle 10g database - create an Oracle database, and delete one, using the Database Configuration Assistant.

Oracle Database 10g: Database Interfaces Release 2

To explain how to use SQL and SQL*Plus to access an Oracle 10g database and introduce other common database interfaces
  • Introducing SQL and SQL*Plus - identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus.
  • Using SQL*Plus commands to work with data in Oracle 10g - recognize how to use the DESCRIBE, PROMPT, and SELECT commands to work with data.
  • Manipulating data in Oracle 10g - recognize how to join tables and use DML and DDL statements to manipulate and define data.
  • Using transactions in Oracle 10g - identify the functions of different SQL statements and recognize the function of data locking.
  • Managing data in Oracle 10g using SQL and SQL*Plus - identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus.
  • Using SQL*Plus and iSQL*Plus to manage Oracle 10g data - use SQL*Plus and iSQL*Plus to manage data.
  • Introducing PL/SQL - identify the basic elements of PL/SQL and recognize the uses of PL/SQL.
  • Java, OCIs, and APIs - identify the characteristics of some common database interfaces.
  • Using Oracle 10g with PL/SQL, Java, and OCI - identify how Oracle works with common database interfaces.

Oracle Database 10g: Database Control and Storage Structures Release 2

To explain the fundamentals of Oracle database control and how to use tablespaces
  • Using the Oracle 10g management framework - recognize how to use the Oracle Database 10g management framework.
  • Oracle 10g startup and shutdown - recognize how to start up and shut down an Oracle 10g database.
  • Oracle 10g's initialization parameters and alert log - identify the characteristics of initialization parameters and the alert log and recognize how to view them.
  • Controlling the Oracle 10g database - start and stop the Oracle Enterprise Manager Database Control, Oracle Listener, and Oracle Database 10g instance.
  • Introducing Oracle 10g tablespaces - recognize how table data is stored and create tablespaces.
  • Manipulating Oracle 10g tablespaces - recognize how to manipulate tablespaces in an Oracle database.
  • Working with Oracle 10g tablespaces - view tablespace information and create a tablespace.

Oracle Database 10g: Users and Security Release 2

To explain how to manage users, implement security, and audit database activity on an Oracle 10g database
  • Oracle 10g user accounts and profiles - recognize how to create user accounts and profiles.
  • Setting user privileges and quotas in Oracle 10g - recognize how to grant privileges and assign quotas to users.
  • Using roles in Oracle 10g - recognize how to create a role and assign it to a user.
  • Administering users in Oracle 10g - administer user accounts on an Oracle 10g database.
  • Restricting access in Oracle 10g - recognize how to restrict access to an Oracle database.
  • Authenticating users in Oracle 10g - recognize how to implement database security by configuring user profiles.
  • Implementing password security in Oracle 10g - implement password security by configuring user profiles.
  • Monitoring database activity in Oracle 10g - recognize how to monitor database activity using Oracle's built-in audit tools.
  • Fine-grained auditing - recognize how to implement fine-grained auditing in an Oracle 10g database.
  • Auditing database activity in Oracle 10g - audit database activity in an Oracle 10g database.

Oracle Database 10g: Managing Schema Objects and Data Release 2

To demonstrate how to manage schema objects and data in an Oracle 10g database
  • Oracle schema objects - identify the basic features of objects in a database schema.
  • Creating and modifying tables - recognize how to create and modify tables in an Oracle 10g database.
  • Working with tables in Oracle 10g - create, delete, and modify tables in an Oracle 10g database.
  • Oracle 10g indexes, views, and sequences - recognize the most common index types, create indexes and views, and use sequences in an Oracle 10g database.
  • Working with Oracle 10g indexes, views, and sequences - work with indexes, views, and sequences in an Oracle 10g database.
  • Manipulating Oracle 10g tables, indexes, and views - manipulate tables, views, and indexes in an Oracle 10g database.
  • Managing data in Oracle 10g using SQL - recognize how to manage data using the INSERT, UPDATE, DELETE, COMMIT, and ROLLBACK commands.
  • Using the Oracle 10g Data Pump - recognize how to use Oracle's Data Pump to export and import data.
  • Using Data Pump to export and import in Oracle 10g - export and import data using Oracle's Data Pump utility.

Oracle Database 10g: The SQL*Loader and PL/SQL Release 2

To provide an overview of how to use the SQL*Loader and PL/SQL in an Oracle 10g database
  • The SQL*Loader in Oracle 10g - identify the function of the SQL*Loader and the files it uses.
  • Loading data with the SQL*Loader in Oracle 10g - recognize how to load data using the SQL*Loader.
  • Using the SQL*Loader in Oracle 10g - load data using the SQL*Loader.
  • PL/SQL objects, functions, and procedures in Oracle 10g - identify the characteristics of PL/SQL objects, functions, and procedures.
  • PL/SQL packages, triggers, and settings in Oracle 10g - recognize the characteristics of PL/SQL packages and triggers and identify the configuration options that control PL/SQL performance.
  • Using PL/SQL in Oracle 10g - recognize the basic concepts of PL/SQL.

Oracle Database 10g: Oracle Net Services and Shared Servers Release 2

To provide an overview of Oracle Net Services and Shared Server
  • Introducing Oracle Net Listener - recognize how to create and configure an Oracle Net listener in Oracle Database 10g.
  • Monitoring with the lsnrctl utility in Oracle 10g - recognize how to monitor Oracle Net Services using the Listener Control utility.
  • Creating an Oracle Net Listener in Oracle 10g - create and configure an Oracle Net Listener.
  • Configuring local name resolution in Oracle 10g - configure local name resolution in a given scenario.
  • Configuring service aliases in Oracle 10g - configure local Oracle Net Services aliases.
  • Advanced connection options in Oracle 10g - recognize how to configure advanced connection options and test Oracle Net connectivity.
  • Server connection types in Oracle 10g - distinguish between Oracle server connection types.
  • Configuring Shared Server in Oracle 10g - distinguish between the initialization parameters used to configure Shared Server.
  • Monitoring Shared Server in Oracle 10g - recognize how to monitor Shared Server.
  • Setting up Shared Server in Oracle 10g - configure and verify Shared Server.

Oracle Database 10g: Monitoring and Maintenance Release 2

To demonstrate how to control database performance and configure proactive database maintenance
  • Performance monitoring in Oracle 10g - repair invalid and unusable objects.
  • Repairing unusable indexes in Oracle 10g - detect and repair unusable indexes.
  • Working with performance metrics in Oracle 10g - recognize how to monitor performance using dynamic performance views, Enterprise Manager, and optimizer statistics.
  • Gathering optimizer statistics in Oracle 10g - gather optimizer statistics for a database schema.
  • Setting thresholds and baselines in Oracle 10g - set thresholds and baselines for performance metrics.
  • Using advisors in Oracle 10g - identify the functions of various tuning and diagnostic advisors, and use them in a given scenario.
  • Using performance diagnostic tools in Oracle 10g - recognize how to manage the AWR and use the ADDM to review database performance in Oracle Database 10g.
  • Proactive maintenance in Oracle 10g - configure a database for proactive maintenance.

Oracle Database 10g: Managing Undo Data and Lock Conflicts Release 2

To discuss how to manage undo data and manage lock conflicts in an Oracle database
  • Undo management in Oracle 10g - identify factors to take into consideration when managing undo.
  • Managing undo retention in Oracle 10g - recognize how to estimate required tablespace size and resize a tablespace in a given scenario.
  • Managing undo in Oracle 10g - calculate undo tablespace sizing and resize an undo tablespace.
  • Locks in Oracle Database 10g - recognize how locks are used to ensure concurrent user access to a database.
  • Managing lock conflicts in Oracle 10g - manage lock conflicts.
  • Lock conflicts in the Oracle 10g database - detect and resolve lock conflicts.

Oracle Database 10g: Managing Backup and Recovery Release 2

To discuss how to manage backup and recovery in an Oracle 10g database
  • Database failure in Oracle 10g - recognize the types of database failure that can occur in an Oracle 10g database and identify possible solutions.
  • Instance recovery in Oracle 10g - recognize how to tune instance recovery and configure a database for maximum recoverability.
  • Multiplexing and archiving control and log files - recognize how to multiplex the Oracle 10g redo log and archive redo log files.
  • Backup and recovery in Oracle 10g - configure a database for backup and recovery.
  • Working with database backups in Oracle 10g - recognize how to configure and manage database backups.
  • Scheduling database backups in Oracle 10g - recognize how to schedule database backups and back up control files to trace.
  • Configuring database backups in Oracle 10g - configure database backups.
  • Backing up an Oracle 10g database - back up a database.
  • Media failure in Oracle 10g - identify the types of media failure that can cause an instance to fail.
  • Recovering from media failure in Oracle 10g - recover from the loss of control files, redo log files, and datafiles.
  • Flashback recovery in Oracle 10g - recognize how to perform flashback recovery operations in Oracle database 10g.
  • Recovering an Oracle 10g database - recover a database.
Register Now
Oracle Database 10g: Administration Workshop I Release 2 e-learning bundle
  • Course ID:
    271463
  • Duration:
    n/a
  • Price:
    $379