Oracle Databases: Oracle Corporation is the world leader in Relational Database Management Systems (RDBMS) with more than 50% of businesses and organizationsworldwide using Oracle databases (Source: www.IDC.com). Since it’s formation in 1997, Oracle’s databases have enabled organizations to store, manage and selectively retrieve the tremendous amount of data they require for various activities
In-demand skills: With the widespread acceptance of Oracle, there has been a growing demand for database administrators (DBAs) who have the knowledge of basic architecture of the Oracle database. These professionals are responsible for activities like installing database, taking backups, managing and fine-tuning performance over the network, and data recovery. According to Information Week Magazine, "Oracle is the #1 skill sought by IT managers, and is the hardest to find.". Oracle certified DBAs have a median annual pay package of Rs. 4Lac with Senior Database Administrators drawing as much as Rs. 8.45 Lac (Source: www.Payscale.com). 70% of Oracle Certified Professionals agree that being certified earns them more respect from mangers and peers.(Certmag.com survey)
   
     
 
 
Your dream career is just a step away! Please fill in your details and we will contact you at the earliest.
Info. in Bold is compulsory.
Name:
Phone:
Mobile:
Email :
Best Time to call you:
Other Courses of interest/remarks:
Preferred Location In Mumbai.
 
 
 
     
 
Strategic Education Partner of Oracle
180+ Centers Pan-India
Careers & Certification, not just training
Assured Placements: National & Local Divisions
  More
 
 
 
     
   
   
   
   
IIHT’s course prepares you for the first two levels of certification
OCA (Oracle Certified Associate) and OCP (Oracle Certified Professional)
Fundamentals are first covered followed by certification-based curriculum to ensure a sound foundation in the Oracle domain
Our training program is designed to be instructor-led while facilitated at a pace that is comfortable for the group, with extensive hands-on training that ensures sound fundamentals and practical knowledge.
Career opportunities after course completion include database administrator or a technical consultant on projects related with ORACLE 9i.
The training program is based on the OCP (Oracle Certified Professional) curriculum for the DBA (Database Administrator) Track preparing you for
 
- 1Z0-007: Introduction to Oracle9i SQL certification exam
- 1Z0-031: Oracle9i Database: Fundamentals I certification exam
- 1Z0-032: Oracle9i Database: Fundamentals II
- 1Z0-033: Oracle9i Database: Performance Tuning
   
     
     
   
   
   
   
Certified instructors Advanced lab-based training
Comprehensive Tutorials Comfortable pace
Duration: 4 Months
Oracle9i: Database Fundamentals for Developers (Database)
This course is designed to give the student a firm foundation in the tasks that are required to implement an Oracle server application. It's primary goal is to provide the student with the knowledge and skills needed to design and manage the data structures that support Oracle database applications. Students gain a conceptual understanding of the Oracle database server architecture and SQL statement processing, and learn how to organize and create tables and related storage structures in the database. On completion of this course, students will know how to use and design a schema, load and extract data from the database, enforce business rules with constraints. This course addresses the fundamentals necessary for students to take the next module on SQL and begin with the certification track for Oracle 9i DBA
Introduction to Oracle 9I SQL (Prepares you for Oracle certification exam 1Z0-007)
Database Management Basics
Restricting and Sorting Data
Displaying Data from multiple Tables
Aggregating Data by using Group Functions
Producing Readable Output with iSQL*Plus
Manipulating Data using Data Manipulation Language
Reating & Managing Tables
Manipulating Data using Views
Other Database Objects
Creating , Maintaining and using sequences, Indexes
Controlling User Access
Oracle 9i Datetime functions
Advanced subqueries
Hierarchical Retrieval
Oracle9I extensions to DML and DDL Statements
Oracle9i Database Administration Fundamentals II (Prepares you for Oracle certification exam 1Z0-032)
Oracle Net Architectural
Oracle Net Service & Client – Side Configuration
Usage & Configuration of the Oracle Shared Server
Backup & Recovery
Instance & Media Recovery Structure
Configuration of the Database Archiving Mode
Oracle Recovery Manager (RMAN) Overview & Configuration
User – Managed Backup
RMAN Backups
User – Manage Complete Recovery
RMAN Complete Recovery
RMAN Repository Maintenance
RMAN Catalog Creation & Usage
Transporting Data between Database
Oracle9i Database Administration Fundamentals II (Prepares you for Oracle certification exam 1Z0-032)
Oracle Net Architectural
Oracle Net Service & Client – Side Configuration
Usage & Configuration of the Oracle Shared Server
Backup & Recovery
Instance & Media Recovery Structure
Configuration of the Database Archiving Mode
Oracle Recovery Manager (RMAN) Overview & Configuration
User – Managed Backup
RMAN Backups
User – Manage Complete Recovery
RMAN Complete Recovery
RMAN Repository Maintenance
RMAN Catalog Creation & Usage
Transporting Data between Database
Oracle9i Database Performance Tuning (Prepares you for Oracle certification exam 1Z0-033)
Oracle 9i Performance Tuning
Diagnostic & Tuning Tools
Sizing the Buffer Cache
Database Configuration & I/O Issues
Optimize Sort Operations
Diagnosing Contention for Latches
Monitoring & Detaching Lock Contention
Turning Oracle Shared Server
Application Tuning
Using Oracle Blocks Efficiently
SQL Statement Tuning
Tuning the Operation Systems & using Resource Manager
   
     
         
Privacy Policy