Oracle OCA Online for graduates by Indiaoptions Softwares Pvt Ltd. - Kaloor

OCA 10g (Developer)

PAPER I
Oracle 10g Database SQL Fundamentals I
Introduction
1. Retrieving Data Using the SQL Select Statement
2. Restricting and Sorting Data
3. Using Single Row Functions to Customize Output
4. Reporting Aggregated Data Using the Group Functions
5. Displaying Data from Multiple Tables
6. Using Subqueries to solve queries
7. Using the Set Operators
8. Manipulating Data
9. Using DDL Statements to Create & Manage Tables
10. Creating Other Schema Objects
11. Managing Objects with Data Dictionary Views
Oracle 10g Database SQL Fundamentals II
Introduction
1. Controlling User Access
2. Managing Schema Objects
3. Manipulating Large Data Sets
4. Generating Reports by Grouping related Data
5. Managing Data in Different Time Zones
6. Retrieving Data using Subqueries
7. Hierarchical Retrieval
8. Regular Expression Support
PAPER-II
Oracle 10g Database PL/SQL Fundamentals I
Introduction
1. Introduction to PL/SQL
2. Declaring PL/SQL Variables
3. Writing Executable Statements
4. Interacting with the Oracle Server
5. Writing Control Structures
6. Working with Composite Data Types
7. Using Explicit Cursors
8. Handling Exception
9. Creating Stored Procedures and Functions

Oracle 10g Database Develop PL/SQL Program Units
Introduction
1. Creating Stored Procedures
2. Creating Stored Functions
3. Creating Packages
4. Using More Package Concepts
5. Using Oracle Supplied Packages in Application Development
6. Dynamic SQL and Metadata
7. Design Consideration for PL/SQL Code
8. Managing Dependencies
9. Manipulating Large Objects
10. Creating Triggers
11. Applications for Triggers
12. Understanding and Influencing the PL/SQL Compiler

OCA 10g (Admin)
PAPER I
Oracle 10g Database SQL Fundamentals I
Introduction
1. Retrieving Data Using the SQL Select Statement
2. Restricting and Sorting Data
3. Using Single Row Functions to Customize Output
4. Reporting Aggregated Data Using the Group Functions
5. Displaying Data from Multiple Tables
6. Using Subqueries to solve queries
7. Using the Set Operators
8. Manipulating Data
9. Using DDL Statements to Create & Manage Tables
10. Creating Other Schema Objects
11. Managing Objects with Data Dictionary Views
Oracle 10g Database SQL Fundamentals II
Introduction
1. Controlling User Access
2. Managing Schema Objects
3. Manipulating Large Data Sets
4. Generating Reports by Grouping related Data
5. Managing Data in Different Time Zones
6. Retrieving Data using Subqueries
7. Hierarchical Retrieval
8. Regular Expression Support
PAPER II
Oracle 10g Administration Workshop I
Introduction
1. Installing the Oracle Database Software
2. Creating and Oracle Database
3. Managing the Oracle Instance
4. Managing Database Storage Structures
5. Administering User Security
6. Managing Schema Objects
7. Managing Data & Concurrency
8. Managing Undo Data
9. Implementing Oracle Database Security
10. Configuring the Oracle Network Environment
11. Proactive Maintenance
12. Performance Management
13. Backup and Recovery Concepts
14. Performing Database Backups
15. Performing Database Recovery
16. Performing Flashback
17. Moving Data

OCP 10g (DEVELOPER)

PAPER I

Oracle 10g Database SQL Fundamentals I
Introduction

1. Retrieving Data Using the SQL Select Statement
2. Restricting and Sorting Data
3. Using Single Row Functions to Customize Output
4. Reporting Aggregated Data Using the Group Functions
5. Displaying Data from Multiple Tables
6. Using Subqueries to solve queries
7. Using the Set Operators
8. Manipulating Data
9. Using DDL Statements to Create & Manage Tables
10. Creating Other Schema Objects
11. Managing Objects with Data Dictionary Views
Oracle 10g Database SQL Fundamentals II
Introduction
1. Controlling User Access
2. Managing Schema Objects
3. Manipulating Large Data Sets
4. Generating Reports by Grouping related Data
5. Managing Data in Different Time Zones
6. Retrieving Data using Subqueries
7. Hierarchical Retrieval
8. Regular Expression Support

PAPER-II
Oracle 10g Database PL/SQL Fundamentals I
Introduction
1. Introduction to PL/SQL
2. Declaring PL/SQL Variables
3. Writing Executable Statements
4. Interacting with the Oracle Server
5. Writing Control Structures
6. Working with Composite Data Types
7. Using Explicit Cursors
8. Handling Exception
9. Creating Stored Procedures and Functions
Oracle 10g Database Develop PL/SQL Program Units
Introduction
1. Creating Stored Procedures
2. Creating Stored Functions
3. Creating Packages
4. Using More Package Concepts
5. Using Oracle Supplied Packages in Application Development
6. Dynamic SQL and Metadata
7. Design Consideration for PL/SQL Code
8. Managing Dependencies
9. Manipulating Large Objects
10. Creating Triggers
11. Applications for Triggers
12. Understanding and Influencing the PL/SQL Compiler

PAPER III
Oracle Reports Developer 10g Build Reports
Introduction
1. Introduction to Oracle Reports Developer
2. Designing and Running Reports
3. Working in Oracle Reports Developer
4. Creating a Paper Report
5. Enhancing a Basic Paper Report
6. Managing Report Templates
7. Creating a Web Report
8. Enhancing Reports using the Data Model: Queries and Groups
9. Enhancing Reports using the Data Model: Data Sources
10. Enhancing Reports using the Data Model: Creating Columns
11. Enhancing Reports using Paper Layout
12. Controlling the Paper Layout: Column Properties
13. Controlling the Paper Layout: Specific Properties
14. Web Reporting
15. Extending Functionality using XML
16. Creating and using Report Parameters
17. Embedding a graph in a Report
18. Enhancing Matrix Reports
19. Coding PL/SQL Triggers
20. Extending Functionality using the SRW Package
21. Maximizing Performance Using Oracle AS Report Services
22. Building Reports: Efficiency Guidelines

OCP 10g (DEVELOPER-FORMS)

PAPER I
Oracle 10g Database SQL Fundamentals I
Introduction

1. Retrieving Data Using the SQL Select Statement
2. Restricting and Sorting Data
3. Using Single Row Functions to Customize Output
4. Reporting Aggregated Data Using the Group Functions
5. Displaying Data from Multiple Tables
6. Using Subqueries to solve queries
7. Using the Set Operators
8. Manipulating Data
9. Using DDL Statements to Create & Manage Tables
10. Creating Other Schema Objects
11. Managing Objects with Data Dictionary Views
Oracle 10g Database SQL Fundamentals II
Introduction
1. Controlling User Access
2. Managing Schema Objects
3. Manipulating Large Data Sets
4. Generating Reports by Grouping related Data
5. Managing Data in Different Time Zones
6. Retrieving Data using Subqueries
7. Hierarchical Retrieval
8. Regular Expression Support

PAPER-II
Oracle 10g Database PL/SQL Fundamentals I
Introduction

1. Introduction to PL/SQL
2. Declaring PL/SQL Variables
3. Writing Executable Statements
4. Interacting with the Oracle Server
5. Writing Control Structures
6. Working with Composite Data Types
7. Using Explicit Cursors
8. Handling Exception
9. Creating Stored Procedures and Functions
Oracle 10g Database Develop PL/SQL Program Units
Introduction
1. Creating Stored Procedures
2. Creating Stored Functions
3. Creating Packages
4. Using More Package Concepts
5. Using Oracle Supplied Packages in Application Development
6. Dynamic SQL and Metadata
7. Design Consideration for PL/SQL Code
8. Managing Dependencies
9. Manipulating Large Objects
10. Creating Triggers
11. Applications for Triggers
12. Understanding and Influencing the PL/SQL Compiler

PAPER III
Oracle Forms Developer 10g Build Internet Applications
Introduction
1. Introduction to Oracle Forms Developer and Oracle Forms Services
2. Running a Forms Developer Application
3. Working in the Forms Developer Environment
4. Creating a basic Form Module
5. Creating a Master-Detail Form
6. Working with Data Blocks and Frames
7. Working with Text Items
8. Creating LOVs and Editors
9. Creating Additional Input Items
10. Creating Noninput Items
11. Creating Windows and Content Canvases
12. Working with other Canvas Types
13. Introduction to Triggers
14. Producing Triggers
15. Debugging Triggers
16. Adding Functionality to Items
17. Run-Time Messages and Alerts
18. Query Triggers
19. Validation
20. Navigation
21. Transaction Processing
22. Writing Flexible Code
23. Sharing Objects and Code
24. Using WebUtil to Interact with the Client
25. Introducing Multiple Form Application

OCP 10g (Admin)

PAPER I
Oracle 10g Database SQL Fundamentals I
Introduction
1. Retrieving Data Using the SQL Select Statement
2. Restricting and Sorting Data
3. Using Single Row Functions to Customize Output
4. Reporting Aggregated Data Using the Group Functions
5. Displaying Data from Multiple Tables
6. Using Subqueries to solve queries
7. Using the Set Operators
8. Manipulating Data
9. Using DDL Statements to Create & Manage Tables
10. Creating Other Schema Objects
11. Managing Objects with Data Dictionary Views

Oracle 10g Database SQL Fundamentals II
Introduction
1. Controlling User Access
2. Managing Schema Objects
3. Manipulating Large Data Sets
4. Generating Reports by Grouping related Data
5. Managing Data in Different Time Zones
6. Retrieving Data using Subqueries
7. Hierarchical Retrieval
8. Regular Expression Support

PAPER II
Oracle 10g Administration Workshop I
Introduction
1. Installing the Oracle Database Software
2. Creating and Oracle Database
3. Managing the Oracle Instance
4. Managing Database Storage Structures
5. Administering User Security
6. Managing Schema Objects
7. Managing Data & Concurrency
8. Managing Undo Data
9. Implementing Oracle Database Security
10. Configuring the Oracle Network Environment
11. Proactive Maintenance
12. Performance Management
13. Backup and Recovery Concepts
14. Performing Database Backups
15. Performing Database Recovery
16. Performing Flashback
17. Moving Data

PAPER III
Oracle 10g Administration Workshop II
1. Introduction
2. Configuring Recovery Manager
3. Using Recovery Manager
4. Recovering from Noncritical Losses
5. Database Recovery
6. Flashback
7. Dealing with Database Corruption
8. Monitoring & Managing Memory
9. Automatic Performance Management
10. Managing Schema Objects
11. Managing Storage
12. Automatic Storage Management
13. Managing Resources
14. Automating Tasks with the Scheduler
15. Database Security
16. Using Globalization Support