Oracle

ORACLE (9i/10g) OCP 10gDBA

About Oracle Today the world has witnessed a virtual explosion in electronic commerce. With computers increasingly becoming the most potent instrument of globalization, the demand for professionals who can build and manage databases has grown in geometric proportions. With even small and medium enterprises now implementing database management systems, this growth will only be accentuated over time.
The Power Of Oracle
In such a scenario, it makes sense to take advantage of the world’s largest enterprise software company – Oracle, which is best known for its sophisticated relational database products. Indeed, when it comes to enterprise level database management systems on high end work stations, Oracle is one of the undisputed names to reckon with. These systems help organizations get the most up-to-date and accurate information from the business processes.
Know Your Mentor
What professionals and students like you need is an IT training expert who can help you harness the power of Oracle DBMS. That’s where HCL comes in. At HCL you’ll get the benefit of our teaching experience and rich faculty pool, together with the standardized content of Oracle’s globally recognized certification programs. In effect, you get the best of both worlds!
Why Certify With Oracle?
Industry Analysts and Experts agree:
1. Oracle Certifications are among the most sought after certifications of expertise in the Information Technology marketplace.
2. The OCP DBA certification was the only DBA credential ranked in the Top Ten most Valuable Credentials by CRN.com 2002.
3. IT professionals can differentiate themselves from their peers or competition and gain valuable job security by earning an Oracle certification.
4. An Oracle Technical Certification is a valuable, industry-recognized credential that signifies a proven level of knowledge and skill.
Certification Opens Doors!
Oracle certification will put you on the short list for winning Oracle-based projects.
“- Wally Talen, Vice President, Pacific Application Development
Clear benefits for Today’s IT Professionals 
The Oracle Certification Program can give you a distinct advantage.

• Oracle Certification demonstrates that you have a solid understanding of a job role and the Oracle products used in that role.
• Being an Oracle Certified Professional (OCP) can help raise your visibility and increase your access to the industry’s most challenging opportunities.

OCP 10gDBA Contents
1.ORACLE 10g SQL (IZO – 007)

• Introduction to 10g SQL
  - Writing SQL select Statements
  - Restricting and Sorting Data
  - Using Single Row Functions to Customize Output
  - Reporting Aggregated Data using the Group Functions
  - Displaying Data from Multiple Tables
  - Using Sub-queries to Solve Queries
  - Using the SET Operators
  - Manipulating Data
  - Using DDL Statements to Create and Manage Tables
  - Creating Other Schema Objects
  - Managing Objects with Data Dictionary Views
  - Controlling User Access
  - Controlling User Access
  - Manage Schema Objects

- Manipulating medium Data Sets
- Generating Reports by Grouping Related Data
- Managing Data in Different Time zones
- Searching Data Using Advanced Sub Queries
- Hierarchal Retrieval
- Regular Expression Support
2. ORACLE Database 10g Admin. Workshop I (IZO-042)

• Introduction (Database Architecture)
  - Installing the Oracle Database Software on LINUX/WINDOWS.
  - Creating an Oracle Database
  - Managing an Oracle Instance
  - Managing Database Storage Structures
  - Administering User Security
  - Managing Schema Objects
  - Managing Data and Concurrency
  - Managing Undo Data
  - Implementing Oracle Database Security
  - Configuring the Oracle Network Environment
  - Proactive Maintenance
  - Performance Management
  - Backup and Recovery Concepts
  - Performing Database Backups
  - Performing Database Recovery

3. ORACLE Database 10g Admin. Workshop II (IZO-043)

• Introduction to 10g Administration Workshop II
  - Configuring Recovery Manager
  – Using Recovery Manager
  – Oracle Secure Backup
  – Recovering from Non-critical Losses
  – Incomplete Recovery
  – Flashback
  – Dealing with Database Corruption
  – Monitoring and Managing Memory
  – Automatic Performance Management
  – Monitoring and Managing Storage I
  – Monitoring and Managing Storage II
  – Automatic Storage Management
  – VLDB Support
  – Managing Resources
  – Automating Tasks with the Scheduler
  – Database Security
  – Data Movement
  – Using Globalization Support 
  - Workshop Methodology, requirements, and setup Oracle Database 10g:

Oracle Database 10gAdfministrator Certified Professional