Oracle Database 10g Administrator Certified Professional

Training/Coaching/Tuition by Compufield Computer Institute Mumbai View Contact

Starting from: INR 30,000 Per Course (Taxes As Applicable) Request Info

Learn: Oracle 10g SQL certification | 1Z0-007 | 1Z0-042 | 1Z0-043

Category: IT Certification

Medium of instruction:

English

PAPER I : (1Z0-007)

PAPER II : (1Z0-042)

PAPER III : (1Z0-043)

 

Paper I - IZ0-007 : SQL

Oracle9i is a Relational Database Management System(RDBMS) with Object Relational Database Management(ORDBMS) futures. Oracle9i is the latest technology, which has many new features over previous versions like 8i and 8.

 

Salient Features

• Oracle has sophisticated security mechanisms control access to sensitive data by an assortment of privileges

• Oracle provides sophisticated backup & recovery routines. Backup creates a second copy of Oracle Data, recovery restores a copy of data from back up.

• Oracle provides flexible space management. It has special abilities that are capable of handling very large databases.

• Oracle provides open connectivity to & from other vendors software

• Oracle server supports a wide range of Development tools, end user query tools, off the shelf applications & office wide information tools.

 

Application

• Education Industry

• Software Development Industry

• Data warehouse and maintenance

• Domestic Air Services

• Production Industry

• Banking Industry

 

Topics Covered

• Writing Basic SQL Select Statement.

• Restricting and Sorting Data.

• Displaying Data from Multiple Tables.

• Aggregating Data Using Group Functions.

• Sub queries.

• Producing Readable Output with iSQL*Plus.

• Manipulating Data.

• Creating and Managing Tables.

• Including Constraints.

• Creating Views.

• Other Database Objects.

• Controlling User Access.

• SQL Workshop.

• Using Set Operators.

• Date time Functions.

• Enhancements to Group by Clause.

• Advanced Sub queries.

• Hierarchical Retrieval.

• Extensions to DML and DDL Statements.

 

Paper II - IZ0-042

This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how 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. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding Oracle Certified Associate exam.

 

Salient Features

• Oracle has sophisticated security mechanisms control access to sensitive data by an assortment of privileges.

• Oracle provides sophisticated backup & recovery routines. Backup creates a second copy of Oracle Data, recovery restores a copy of data from back up.

• Oracle provides flexible space management. It has special abilities that are capable of handling very large databases.

• Oracle provides open connectivity to & from other vendors software.

• Oracle server supports a wide range of Development tools, end user query tools, off the shelf applications & office wide information tools.

 

Learn To

• Install the Database

• Back up and Recover Data

• Administer Users

• Transport Data between Databases

• Manage Data

• Configure the Network

 

Application

• Education Industry

• Software Development Industry

• Data warehouse and maintenance

• Domestic Air Services

• Production Industry

• Banking Industry

 

Course Objectives:

• Install Oracle Database 10g and configure a database

• Manage the Oracle instance

• Manage the Database storage structures

• Create and administer user accounts

• Perform backup and recovery of a database

• Monitor, troubleshoot, and maintain a database

• Configure Oracle Net services

• Move data between databases and files

 

Topics Covered

Introduction (Database Architecture)

Describe course objectives

Explore the Oracle 10g database architecture

Installing the Oracle Database Software Explain core DBA tasks and tools

Plan an Oracle installation

Use optimal flexible architecture

Install software with the OraInstaller (OUI) cle Universal

Creating an Oracle Database

Create a database with the Database Configuration Assistant (DBCA)

Create a database design template with the DBCA

Generate database creation scripts with the DBCA

Managing the Oracle Instance

Start and stop the Oracle database and components

Use Enterprise Manager (EM)

Access a database with SQL*Plus and iSQL*Plus

Modify database initialization parameters

Understand the stages of database startup

View the Alert log

Use the Data Dictionary

Managing Database Storage Structures

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

Describe the main concepts and functionality of Automatic Storage Management (ASM)

Administering User Security

Create and manage database user accounts

Authenticate users

Assign default storage areas (tablespaces)

Grant and revoke privileges

Create and manage roles

Create and manage profiles

Implement standard password security features

Control resource usage by users

Managing Schema Objects

Define schema objects and data types

Create and modify tables

Define constraints

View the columns and contents of a table

Create indexes, views and sequences

Explain the use of temporary tables

Use the Data Dictionary

Managing Data and Concurrency

Manage data through SQL

Identify and administer SQL Objects

Describe triggers and triggering events

Monitor and resolve locking conflicts

Managing Undo Data

Explain DML and undo data generation

Monitor and administer undo

Describe the difference between undo and redo data

Configure undo retention

Guarantee undo retention

Use the undo advisor

Implementing Oracle Database Security

Describe DBA responsibilities for security

Apply the principal of least privilege

Enable standard database auditing

Specify audit options

Review audit information

Maintain the audit trail

Configuring the Oracle Network Environment

Use Enterprise Manager for configuring the Oracle network environment

Create additional listeners

Create Net Service aliases

Configure connect-time failover

Control the Oracle Net Listener

Test Oracle Net connectivity

Identify when to use shared versus dedicated servers

Proactive Maintenance

Use statistics

Manage the Automatic Workload Repository (AWR)

Use the Automatic Database Diagnostic Monitor (ADDM)

Describe advisory framework

Set alert thresholds

Use server-generated alerts

Use automated tasks

Performance Management

Use Enterprise Manager pages to monitor performance

Use the SQL Tuning Advisor

Use the SQL Access Advisor

Use Automatic Shared Memory Management

Use the Memory Advisor to size memory buffers

Use performance related dynamic views

Troubleshoot invalid or unusable objects

 

 

Backup and Recovery Concepts

Identify the types of failure that may occur in an Oracle Database

Describe ways to tune instance recovery

Identify the importance of checkpoints, redo log files, and archived log files

Configure ARCHIVELOG mode

 

 

Performing Database Backups

Create consistent database backups

Back your database up without shutting it down

Create incremental backups

Automate database backups

Monitor the flash recovery area

 

 

Performing Flashback

Describe Flashback database

Restore the table content to a specific point in the past with Flashback Table

Recover from a dropped table

View the contents of the database as of any single point in time with Flashback Query

See versions of a row over time with Flashback Versions Query

View the transaction history of a row with Flashback Transaction Query

 

 

Moving Data

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

Use external tables to move data via platform-independent files

 

PAPER III : (1Z0-043)

Exam Topics

Using Globalization Support Objectives

• Customize language-dependent behavior for the database and individual sessions

• Specify different linguistic sorts for queries

• Use datatime datatypes

• Query data using case insensitive and accent insensitive searches

• Obtain Globalization support configuration information

Securing the Oracle Listener

• Secure the listener

• Remove default EXTPROC entry and add a separate listener to handle external procedure calls

Configuring Recovery Manager

• Configure database parameters that affect RMAN operations

• Change RMAN default settings with CONFIGURE

• Manage RMAN's persistent settings

• Start RMAN utility and allocate channels

Recovering from User Errors

• Recover a dropped table using Flashback technology

• Perform Flashback table operation

• Manage the recycle bin

• Recover from user errors using Flashback versions query

• Perform transaction level recovery using Flashback Transaction query

Dealing with Database Corruption

• Define block corruption and list its causes and symptoms

• Detect database corruptions using the following utilities: ANALYZE

• DBVERIFY

• Detect database corruptions using the dbms_repair package

• Implement the DB_BLOCK_CHECKING parameter to detect corruptions

• Repair corruptions using RMAN

Automatic Database Management

• Use the Database Advisors to gather information about your database

• Use the SQL Tuning Advisor to improve database performance

• Use automatic undo retention tuning

Using Recovery Manager

• Use the RMAN BACKUP command to create backup sets and image copies

• Enable block change tracking

• Manage the backups and image copies taken with RMAN with the LIST and REPORT commands

Diagnostic Sources

• Use the alert log and database trace files for diagnostic purposes

• View alerts using Enterprise Manager

• Adjust thresholds for tracked metrics

• Control the size and location of trace files

Recovering from Non-Critical Losses

• Recover temporary tablespaces

• Recover a redo log group member

• Recover index tablespaces

• Recover read-onlym tablespaces

• Recreate the password file

Monitoring and Managing Storage

• Tune redo writing and archiving operations

• Issue statements that can be suspended upon encountering space condition errors

• Reduce space-related error conditions by proactively managing tablespace usage

• Reclaim wasted space from tables and indexes using the segment shrink functionalitym

• Estimate the size of new table and indexes

• Use different storage options to improve the performance of queries

• Rebuild indexes online

Automatic Storage Management

• Set up initialization parameter files for ASM and database instances

• Execute SQL commands with ASM file names

• Start up and shut down ASM instances

• Administer ASM disk groups

• Use RMAN to migrate your database to ASM

Monitoring and Managing Memory

• Implement Automatic Shared Memory Management

• Manually configure SGA parameters for various memory components in the SGA

• Use Automatic PGA Memory Management

Database Recovery

• Recover the control file

• Explain reasons for incomplete recovery

• Perform incomplete recovery using EM

• Perform incomplete recovery using RMAN

• Perform incomplete recovery using SQL

• Perform database recovery following a RESETLOGS operation

Flashback Database

• Determine which flashback technology to use for each recovery situation

• Configure and sue Flashback Database

• Monitor the Flashback Database

• Use the Enterprise Manager Recovery Wizard to flashback database

• Manage (or maintain) the Flash Recovery Area

Managing Resources

• Configure the Resource Manager

• Assign users to Resource Manager groups

• Create resource plans within groups

• Specify directives for allocating resources to consumer groups

Automating Tasks with the Scheduler

• Simplify management tasks by using the Scheduler

• Create a job, program, schedule, and window

• Reuse Scheduler components for similar tasks

• View information about job executions and job instances

Classroom - Regular
When	Duration	Where	Remarks	Price
Not Specified	100 Sessions	All Venues	1 session is of 1hr.	INR 30,000 Per Course (Taxes As Applicable)

Mumbai, Warden Road (Head Office):- Chinoy Mansion, First Floor, Block #2 Opp. St.Stephen's Church Warden Road, Mumbai - 400036, Maharashtra, India

Mumbai, Bandra West (Branch):- 1st Floor. O'Priya Building, Near Mehboob Studio Peter Dias Road Bandra West, Mumbai - 400050, Maharashtra, India

Mumbai, Andheri West (Branch):- Wembley Society, Shop No 3 Shastri Nagar, Lane no2, Lokhandwala Andheri West, Mumbai - 400053, Maharashtra, India