Oracle OCA course for Novice 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