Oracle Database 10g Administrator Certified Professional

For Corporate Training in this course CLICK HERE

Our Programming Student's Review
Programming Review 1 2 3 4 5
Our Programming Student's Video Review

Enquire About This Course
Name	:
*Country Name	:
		e.g.India, UK, ....
Residence / Office Number	:	Country Code City Code Number
		(Number-Coutry code & city code) e.g. +91-22-23676218
Mobile Number	:
*Email	:
*Course Of Interest	:
Enquiry	:
		(*) Signed fields are mandatory.

PAPER I(IZ0-007) : SQL

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

SALIENT FEATURES

	Oracle has sophisticated security mechanisms that 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 vendor's 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
  
  Paper I : SQL
  

TOPICS COVERD

• Writing Basic SQL Select Statement.
• Restricting and Sorting Data.
• Single Row Functions.
• Displaying Data from Multiple Tables.
• Aggregating Data Using Group Functions.
• Subqueries.
• Producing Readable Output with SQL*Plus.
• Manipulating Data.
• Creating and Managing Tables.
• Including Constraints.
• Creating Views.
• Other Database Objects.
• Controlling User Access.
• SQL Workshop.
• Using Set Operators.
• Datetime Functions.
• Enhancements to Group by Clause.
• Advanced Subqueries.
• Hierarchical Retrieval.
• Extensions to DML and DDL Statements.
  

PAPER II : (1Z0-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

APPLICATIONS

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 PL/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 Database Recovery
• Recover from loss of a control file
• Recover from loss of a redo log file
• Perform complete recovery following the loss of a data file
  
  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-only 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 functionality 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

Oracle Database 10g Administrator Certified Professional
Paper IZ0-007 +IZ0-042 + IZ0-043

Course Duration	Fees (Indian RS.)	Fees (US $)
240 sessions of 1 hr. each	32,000	900

Overseas students can complete this course in 1 month if they take
this course 5-8 hours daily.