Oracle Training in Chennai

Oracle Training in Chennai

Oracle Certified Professional(OCP)

Introduction :

Oracle 10g Developer is a fundamental course for candidates willing to make their careers in field of Oracle Database administrator. Oracle DBA covers Expert Structured Query Language(SQL), PL/SQL Programming, 10g Forms And Reports . After completing 10g Developer course, candidates can apply for OCA And OCP examination.

Objective :

• Evaluate Oracle features and Oracle related products
• Take care of the Database design and implementation
• Create database objects (tables, indexes, etc.)
• Write database procedures, functions and triggers
• Assist developers with database activities
• Tune database queries
• Monitor application related jobs and data replication activities
• Perform general technical trouble shooting and give consultation to development teams
• Document work performed

Eligibility : Knowledge of C Language is essential to learn Oracle Developer.

Course Content : 10g SQL 

• Retrieving Data Using the SQL SELECT Statement
• Restricting and Sorting Data
• Using Single-Row Functions to Customize Output
• Use character, number, and date functions in SELECT statements
• Reporting Aggregated Data Using the Group Functions
• Displaying Data from Multiple Tables
• Using Subqueries 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
• Managing Schema Objects
• Manipulating Large Data Sets
• Generating Reports by Grouping Related Data
• Managing Data in Different Time Zones
• Hierarchical Retrieval
• Regular Expression Support

Course Content : 10g Programming with PL/SQL (OCA)

• Introduction
• Declaring Variables
• Writing Executable Statements
• Interacting with the Oracle Server
• Writing Control Structures
• Working with Composite Data types
• Writing Explicit Cursors
• Advanced Explicit Cursor Concepts
• Handling Exceptions
• Creating Procedures
• Creating Functions
• Managing Subprograms
• Creating Packages
• More Package Concepts
• Using Oracle-Supplied Packages
• Database Triggers
• More Trigger Concepts
• Managing Dependencies
• Manipulating Large Objects

Course Content : 10g Forms Developer: Build Internet Applications(OCP)

• 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
• Creating Windows and Content Canvases
• 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 Triggers
• Debugging Triggers
• Adding Functionality to Items
• Runtime Messages and Alerts
• Query Triggers
• Validation
• Navigation
• Transaction Processing
• Writing Flexible Code
• Sharing Objects and Code

Course Content : Oracle 10g Reports Developer: Build Reports

• Introduction to Oracle10g Reports Developer
• Designing and Running Reports
• Working in Oracle10g Reports Developer
• Creating a Paper Report
• Enhancing a Basic Paper Report
• Managing Report Templates
• Creating a Web Report
• Enhancing Reports Using the Data Model: Queries and Groups
• Enhancing Reports Using the Data Model: Data Sources
• Enhancing Reports Using the Data Model: Creating Columns
• Enhancing Reports Using the Paper Layout
• Controlling the Paper Layout: Common Properties
• Controlling the Paper Layout: Specific Properties
• Web Reporting
• Extending Functionality Using XML
• Creating and Using Reports Parameters
• Embedding a Graph in a Report
• Enhancing Matrix Reports
• Coding PL/SQL Triggers
• Extending Functionality Using the SRW Package
• Maximizing Performance Using Oracle9iAS Reports Services
• Building Reports: Efficiency Guidelines
• Sharing Objects and Code