Oracle 10g Database OCP Certification

Oracle 10g Database
OCP Certification

Certification Exam Code 1Z0-042 Oracle Database 10g: Administration I 1Z0-043 Oracle Database 10g: Administration II

Course Contents (20 sessions of 3hrs each)

Day 1
3 hrs OCA Exam 1Z0-042 Oracle Database 10g: Administration I
· Oracle 10g Database Structure
· Introduction to Oracle 10g DBA course.
· Discuss the contents and topics,
· Identify the student knowledge levels.
· Introduction to databases,
· explain the database terminology.
· Introduction to SQL Language,
· explain simple SQL statements
· practice using iSQL*Plus.

Day 2
3 hrs · Explain and practice complex SQL statements.
· (Table joins, sub query, outer joins, set operations, etc.
· Explore the Oracle 10g database architecture,
· Explain core DBA tasks and tools,
· Plan an Oracle installation,
· Install software with the Oracle Universal Installer (OUI),
· Create a database with the Database Configuration Assistant (DBCA) .
Day 3
3 hrs · Start and stop the Oracle database and components,
· Access a database with SQL*Plus and iSQL*Plus,
· explain the use of SPFILE and PFILE,
· Modify database initialization parameters,
· Understand the stages of database startup,
· Use DDL statements to create, alter, drop tables
· practice DML statements (insert, update, delete),
· describe table constraints, views, sequences, synonyms and indexes.
Day 4
3 hrs · Describe table data storage (in blocks),
· Define the purpose of tablespaces and data files,
· Understand and utilize Oracle Managed Files (OMF),
· Create and manage tablespaces,
· Obtain tablespace information,
· understand different types of tablespaces and create them.
· Understand temporary tablespaces,
· undo tablespace,
· default tablesspaces in the database.
Day 5
3 hrs · Create and manage database user accounts,
· Authenticate users in 3 different methods (password, externally, globally),
· Grant and revoke privileges,
· Create and manage roles,
· Create and manage profiles,
· Implement standard password security features,
· Control resource usage by users using profiles.

Day 6
3 hrs · Define schema objects and data types,
· Create and modify tables,
· Define constraints,
· Use the Data Dictionary to find object information.
· Explain DML and undo data generation,
· Configure undo retention,
· Guarantee undo retention,
· Describe table locks and different types of locks.
· Understand the data dictionary tables related to the locks.
· Discuss the general concurrency issues and explain the deadlocks.
Day 7
3 hrs · Enable standard database auditing,
· Specify audit options, Review audit information,
· Understand Oracle's Network Architecture,
· Create additional listeners,
· Create Net Service aliases,
· Configure connect-time failover,
· Identify when to use shared versus dedicated servers.
· Set up shared server and monitor shared connections to the database.
· Manage the Automatic Workload Repository (AWR),
· Use the Automatic Database Diagnostic Monitor (ADDM).
· Describe advisory framework.
Day 8
3 hrs · Identify the types of failure that may occur in an Oracle Database,
· Identify the importance of checkpoints,
· redo log files, and archived log files.
· Describe Flashback database,
· Recover from a dropped table,
· See versions of a row over time with Flashback Versions Query,
· View the transaction history of a row with Flashback Transaction Query
· Describe available ways for moving data,
· Create and use directory objects,
· Use SQL*Loader to load data from a non-Oracle database (or user files),
· Explain the general architecture of Data Pump,
· Use Data Pump Export and Import to move data between Oracle databases.
Day 9
3 hrs · Describe available ways for moving data ,
· Create and use directory objects,
· Use SQL*Loader to load data from a non-Oracle database (or user files),
· Explain the general architecture of Data Pump,
· Use Data Pump Export and Import to move data between Oracle databases. Day 10
3 hrs · Database Architecture Review,
· Recovery Manager Features and Components,
· Using a Flash Recovery Area with RMAN, Configuring RMAN,
· Control File Autobackups,
· Retention Policies and Channel Allocation.
· Displaying the current RMAN configuration settings,
· Altering the backup retention policy for a database.
· RMAN Command Overview,
· Parallelization of Backup Sets,
· Compressed Backups, Image Copy,
· Whole Database and Incremental Backups,
· LIST and REPORT commands.
Day 11
3 hrs · Recovery of Non-Critical Files,
· Creating New Temporary Tablespace Recreating Redo Log Files,
· Index Tablespaces, and Indexes,
· Read-Only Tablespace Recovery,
· Authentication Methods for Database Administrators,
· Loss of Password Authentication File,

Day 12
3 hrs · Creating a new temporary tablespace,
· Altering the default temporary tablespace for a database.
· Describe Incomplete recovery,
· Server and User Managed Recovery commands,
· Recovering a Control File Autobackup,
· Creating a New Control File,
· Simplified,
· Point-in-time recovery using RMAN.
Day 13
3 hrs · Describe Flashback Database Architecture,
· Configuring and Monitoring Flashback Database,
· Backing Up the Flash Recovery Area,
· Using V$FLASH_RECOVERY_AREA_USAGE,
· Flashback Database Considerations,
· Using the Flashback Database RMAN interface,
· Using Flashback Database EM Interface
· Managing and monitoring Flashback Database operations.
· How to deal with block corruptions.
· Block Corruption Symptoms: ORA-1578,
· DBVERIFY Utility and the ANALYZE command,
· Initialization parameter DB_BLOCK_CHECKING,
· Segment Metadata Dump and Verification,
· Flashback for Logical Corruption and using DBMS_REPAIR,
· Lock Media Recovery
· RMAN BMR Interface,
· dumping and Verifying Segment Metadata
Day 14
3 hrs · Memory tuning, Oracle Memory Structures,
· Automatic Shared Memory Management,
· SGA Tuning Principles, Resizing SGA_TARGET,
· PGA Management Resources,
· Using the Memory Advisor,
· Identifying Tunable Components,
· Oracle Wait Events and System Statistics,
· Troubleshooting and Tuning Views,
· Direct Attach to SGA for Statistic Collection,
· Workload Repository,
· Advisory Framework
· ADDM Scenarios and Usage Tips,
· Using the SQL Tuning and SQL Access Advisor
· Monitor and manage Database Storage Structures,
· Space Management Overview,
· Oracle-Managed Files (OMF),
· Row Chaining and Migrating,
· Proactive Tablespace Monitoring,
· Monitoring table and index space usage

Day 15
3 hrs · Discuss Table Types,
· Partitioned Tables,
· Index-Organized Tables (IOT),
· Managing index space with SQL,
· Configure optimal redo log file size,
· View "Automatic Tuning of Undo Retention"
· Discuss ASM General Architecture and Functionalities,
· Create, Manage an ASM Instance.
· Database Resource Manager Concepts and Configuration,
· Creating a New Resource Plan,
· Creating a Simple Plan,
· Administering and Monitoring Resource Manager,
· Resource Plan Directives,
· Creating Resource Consumer Groups. Day 16
3 hrs · Discuss Scheduler Concepts,
· Creating a Job Class and a Windows,
· Managing Jobs, Programs,
· Chains, Events,
· Schedules, priority,
· Viewing and Purging Job Logs,
· Creating a program and a schedule,
· Creating a job that uses a program and a schedule.
· Understand Globalization Support Features,
· Database Character Sets and National Character Sets,
· Specifying Language-Dependent Behavior,
· Determining the Default NLS Settings. After Course Free Lab Access