 |
 |
 |
|
|
 |
 |
| |
|
|
| |
|
| |
|
| |
|
| |
|
 |
|
 |
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. |
| |
|
|
 |
![]() |
 |
|
| |
| |
|
|
|
 |
|
| |
 |
 |
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 |
|
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|