Oracle – Why India
To leverage the world-class IT skills base and provide consistent on-time delivery of high quality products to customers worldwide.

Oracle India – At a Glance

• Oracle India Private Limited
  6 offices around India, with head office in Gurgaon
  Sales, marketing, consulting, education and support
• India Development Center
  Largest Oracle R&D center outside the US
• Oracle Direct
  Highly-skilled direct sales organization helps customers “See Your Business in Our Software”
• Oracle Solution Services India (OSSI)
  Part of Global Consulting, the OSSI team provides rapid, cost effective consulting services to customers worldwide
• Global Support Center
  One of 4 Global Support Centers worldwide
  Offers 24/7 technical support for the entire range of Oracle products 
• Shared Services Center
  Bangalore-based center provides back-office services to all Oracle subsidiaries worldwide
• Oracle Education in India
  Offers certified courses across Oracle technology and applications

Oracle India – Snapshot
• In India for more than 15 years.
• Fifth largest market in Asia, up from 10th two years ago
• Largest R&D facility outside of the U.S.
• More than 10000 employees and growing
• More than 6200 technology and applications customers

Oracle India – association with Government
• Involved with projects with all 28 State Governments.
• Overall 2000 Government projects worldwide – 30 in India.
• Helps Government to create complete architecture for e-Governance.

Statistical perspective - Global

• Countries                                       : 60+
• Locations                                       : 400
• Languages Taught                          : 9
• Total Students Trained Annually       : 520,000
• Online Learners                              : 235,000
• Instructor-led course titles              : 200+
• Instructors                                    : 600+

• DBAs
• Support Engineers
• Application Developers
• System Integrators
• Web Developers
• Implementation Specialists
• Consultants
• Database Analysts

• Trainers
• Oracle Partners, Resellers
• Applications Specialists
• Java Programmers
• Enterprise Solution Developers
• Web Server Administrators
• Data Warehouse / Business Intelligence

Oracle Certification Enrollment :
Developing declarative and non declarative memories

Various techniques combining multiple learning styles:

Oracle University Value Proposition

• Offers a full range of services to help you maximize ROI and support employee development :
  - Customizable / flexible training plans
  - Customized self-study library configurations - Self Service CD’s (SSCDs), Online Library
• Branding message - “Learn Oracle from Oracle”:
  - Curriculum from the developers who built the software
  - All delivered by certified instructors with real-world Oracle implementation experience.

Adaptation to current IT landscape
Oracle Certification meant to:

• Increase IT professional productivity
• Increase security by a better understanding and management of system default
• Give a broader range of skills to the IT professional to increase flexibility / adaptation, and to avoid hiring new workers in a cost-control and offshoring context)
• Allow a global IT knowledge and continuing-education policy, matching business market requirements

Differentiation – Job Credibility

• Certified professionals handle 40% more support calls per day than uncertified counterparts*
• Companies who advocate certification experience 49% less downtime*
• For most, savings from increased effectiveness pay for cost of certification in less than 9 months*
• 89 % of OCPs themselves say…  That they gained more confidence in their Oracle expertise and ability to troubleshoot the system they support **
  ** OCP Survey Results - Oct / Dec 2002   
  ** Source: "Benefits and Productivity Gains Realized Through IT Certification,"

Market  Recognition

• Increased Validity of Oracle Certification as a tool used for making accurate hiring decisions
• Aligned  credentials for job roles, which makes it easier to understand skills requirement for an open position
• OCA used to qualify entry level personnel and as a skill assessment
• OCP as the industry leading credential for hiring decisions of full time DBAs from intermediate to advanced
• OCM as a performance based benchmark for use in hiring senior level Oracle DBAs & project consultants

Use Of OCA, OCP, OCM Logos

• OCA :  
  - OCA member website access
  - Certification kit (includes OU letter, Certificate, Member ID Card)
  - OCA logo usage.
• OCP :  
  - OCA benefits + OCP kit and OCP logo usage
  - STS Practice Test Discounts
  - OTN Support Provider Network Membership
  - Oracle9i OCP Profiles on OTN
• OCM :  
  - OCA, OCP benefits + OCM kit and OCM logo usage
  - OCM Member Profile web page on OTN site
  - Embroidered OCM logo Denim Button Down Shirt

• Introduction to 9i SQL
• Oracle9i Database Administration Fundamental I
• Oracle9i Database Administration Fundamental II
• Oracle9i Database Performance Tuning

• Writing a Basic SQL Statement
• Restricting and Sorting Data
• Displaying Data from Multiple Tables
• Aggregating Data by Using Group Functions
• Writing Subqueries
• Producing Readable Output with iSQL*Plus
• Manipulating Data
• Creating and Managing Tables
• Including Constraints
• Creating Views
• Controlling User Access
• Using Set Operators
• Hierarchical Retrieval
• And many more…

• Identifying database administrative users
• Managing an Oracle Instance
• Creating a Database
• Using the Data Dictionary
• Maintaining the Control File
• Describing storage hierarchy
• Establishing the difference between SYSTEM and Non-SYSTEM tablespaces
• Storage Structures and Relationships
• Managing Undo Data
• Understanding the difference between automatic undo management and manual undo management
• Creating and maintaining UNDO tablespaces
• Managing Tables
• Managing Indexes
• And Many more…

Oracle9i Database  Administration Fundamental - II
Develop your ability to manage the industry's most advanced information system. Learn several methods to backup and to recover your Oracle database

• Basic Oracle Net Architecture
• Basic Oracle Net Services Server-Side Configuration
• Basic Oracle Net Services Client-Side Configuration
• Usage and Configuration of the Oracle Shared Server
• Backup and Recovery Overview
• Instance and Media Recovery Structures
• Oracle Recovery Manager (RMAN) Overview and Configuration
• User-Managed Backups
• RMAN Backups
• User-Managed Complete Recovery
• RMAN Complete Recovery
• User-Managed Incomplete Recovery
• RMAN Repository Maintenance
• Transporting Data Between Databases  - Import, Export, guidelines
• And many more ….

Oracle9i Database Performance Tuning
Database performance tuning is critical to any effective information system

• Overview of Oracle 9i Database Performance Tuning
• Diagnostic and Tuning Tools
• Database Configuration and I/O Issues
• Tuning the Shared Pool
• Tuning the Buffer Cache
• Dynamic Instance Resizing
• Sizing Other SGA Structures
• Tuning the Oracle Shared Server
• Optimizing Sort Operations
• Using Resource Manager
• SQL Statement Tuning
• Using Oracle Blocks Efficiently
• Using Oracle Data Storage Structures Efficiently
• Monitoring and Detecting Lock Contention
• And many more …

Oracle 9i Forms Developer Track

• Introduction to 9i SQL
• Oracle9i: Program with PL/SQL
• Oracle9i Forms Developer: Builds Internet Application

Oracle9i: Program with PL/SQL
This course is a foundation of basic knowledge, which they can build upon as they work toward a career as an Oracle Application

• Overview of PL/SQL Programs
• Creating Procedures
• Creating Packages
• More Package Concepts
• Creating Database Triggers
• More Trigger Concepts
• Creating Functions
• Managing Subprograms
• Oracle Supplied Packages
• Manipulating Large Objects
• Managing Dependencies
• And many more ….

Oracle9i Forms Developer : Builds Internet Application
This course teaches you to develop and deploy Internet applications using Oracle9i Forms. Working in a rapid development environment, participants learn how to customize forms through user input items and how to control data access by creating event-related triggers

• Introduction to Oracle Forms Developer and Oracle Forms Services
• Running a Forms Developer Application
• Working in the Forms Developer Environment
• Creating a Basic Form Module
• Working with Data Blocks and Frames
• Working with Text Items
• Creating LOVs and Editors
• Creating Additional Input Items
• Creating Noninput Items
• Working with Other Canvas Types
• Introduction to Triggers – Producing, Debugging & Adding Function
• Runtime Messages and Alerts
• Query Triggers
• Writing Flexible Code
• And many more …

1. Select a training path befitting your career
2. Address your skill gaps with training and practice
3. Earn a credential to establish credibility for your skill level  (OCP)

WDP – Benefits to the Students

• Oracle training to students of the college
•  Courseware from Oracle
•  Hands on experience on Oracle Software
•  Vouchers for students extending special online OCP examination fees
•  Participation certificate after completion of each module