Why do Foreign/Indian Students prefer to study at COMPUFIELD?

Oracle9i Administrator

PAPER I : SQL (50 HOURS)

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. Oracle9i comes with new SQL enhancements.

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.

APPLICATIONS

• 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.

  
    SQL (Paper I)

  Course Duration	Fees (Indian RS.)	Fees (US $)
  50 sessions of 1 hr. each	8,000	200

Paper II : DBA I (50 Hours)

•    Oracle architectural components.
•    Getting started with oracle server.
•    Managing Oracle instance.
•    Creating a database.
•    Using data dictionary and dynamic performance views.
•    Maintaining Control File.
•    Maintaining Redo Log Files
•    Managing tablespaces & datafiles.
•    Storage structure and relationship.
•    Managing Undo Data.
•    Managing Indexes and tables.
•    Managing password security and resources.
•    Managing users .
•    Managing privileges.
•    Managing Roles.
•    Auditing.
•    Loading data into database.
•    sing globalization support.

Paper III : DBA II (50 Hours)

• Networking Overview.
• Oracle Net Architecture
• basic Oracle Net Server Side Configuration.
• Naming Method Configuration
• Usage and Configuration of Oracle Shared Server
• Backup and Recovery Overview.
• Instance and Media Recovery Structures
• Configuring the Database Archiving Mode.
• Oracle Recovery Manager Overview and Configuration
• User Managed Backups
• RMAN Backups
• User-Managed Complete Recovery
• User-Managed Incomplete Recovery
• RMAN Incomplete Recovery
• RMAN Maintenance
• Recovery Catalog Creation and Maintenance
• Transporting Data Between Databases
  

Paper IV : Performance Tune(50 Hours)

• Overview of Oracle 9i Performance Tuning.
• Diagnostic and Tuning Tools
• Sizing the Shared Pool
• Sizing the Buffer Cache
• Sizing Other SGA Structures
• Database Configuration and I/O Issues
• Optimizing Sort Operations
• Diagnosing Contention for Latches
• Monitoring and Detecting Lock Contention
• Tuning the Oracle Shared Server
• SQL Statement Tuning
• Using Oracle Blocks Efficiently
• Application Tuning
• Tuning the Operating System and Using Resource Manager
  

  Exam details:

  Exam	US $
  007	75
  031	75
  032	75
  033	75

Oracle - OCP- DBA- Performance Tune  Paper I to Paper IV

Course Duration	Fees (Indian RS.)	Fees (US $)
200 sessions of 1 hr. each	35,000	875

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

Click here to Register for Oracle 9i Administrator

* Lodging, boarding and travelling not included in the fees. *The above mentioned fees is for one course. COMPUFIELD offers a unique style of learning - One computer : One student : One Instructor Maximum Instructor to Student Ratio 1:4 Sessions : Each session will be of 1 hour Overseas / local Students take 5 to 10 hours per day to complete their courses earlier. The timing can be fixed based on our mutual convenience, between 8.00 a.m. to 8.00 p.m. Course duration in working days = Total sessions divided by number of sessions (hours) per day.

                 

Solve your Queries Online related to our Courses
E-mail me khairaz@compufield.com	Yahoo Messenger compufield@yahoo.com
MSN Messenger compufield@hotmail.com	ICQ No. 28444214
Mobile Number +91-9820134058	Fax Number 091-22-23671772

HEAD OFFICE : Chinoy Mansion, First Floor, Block # 2,
Opposite St.Stephen's Church, Warden Road, Mumbai (Bombay)-400 036
India.
: 091-22-23676218 (3 Lines), Fax: 091-22-23671772