Search in
Courses Providers, List Your Courses for FREE
Menu
IANT (Institute of Advance Network Technology)

Oracle 10g DBA - OCP Course


Certificate

by IANT (Institute of Advance Network Technology)


Vadodara, Ahmedabad, Jaipur, New Delhi, Indore, Pune, Gandhinagar, Anand, Bhavnagar, Bhuj, Deesa, Gandhidham View More +
View Contact
Request Info
Subjects Covered & Categories
Basic Details
Eligibility:
(Pre-requisites)

Familiarity with Data Processing Concepts & Techniques, Ability to use a graphical user interface (GUI)

Medium of instruction:English
Request Info
Overview, Content & Syllabus

Oracle Forms Certified Professional

Oracle Database 10g – Introduction To Sql (40 Hours) Exam Code 1z0-047

Audience:

  • Database Administrators

  • Forms Developer

  • Business Intelligence Developer

  • End Users Application Developers

  • PL/SQL Developer

Required Prerequisites:

  • Familiarity with Data Processing Concepts & Techniques, Ability to use a graphical user interface (GUI)

Course Topics:

  • Introduction

  • 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

  • Manage Schema Objects

  • Manipulating Large Data Sets

  • Generating Reports by Grouping Related Data

  • Managing Data in Different Time Zones

  • Searching Data Using Advanced Sub Queries

  • Hierarchical Retrieval

Oracle Database 10g: Program with PL/SQL (40 Hrs) Exam Code 1z0-147

Audience:

  • Database Administrators & Designers

  • Forms Developer

  • PL/SQL Developer

  • Technical Consultant

Required Prerequisites:

  • Oracle Database 10g: Introduction to SQL

Course Topics:

  • Introduction to PL/SQL

  • Declaring PL/SQL Identifiers

  • Writing Executable Statements

  • Interacting with Oracle Server

  • Writing Control Structures

  • Working with Composite Data Types

  • Using Explicit Cursors

  • Handling Exceptions

  • Creating Stored Procedures

  • Creating Stored Functions

  • Creating Packages, Using More Package Concepts

  • Utilizing Oracle Supplied Packages in Application Development

  • Dynamic SQL and Metadata

  • Design Considerations for PL/SQL Code

  • Managing Dependencies

  • Manipulating Large Objects

  • Creating Triggers

  • Applications for Triggers

  • Understanding and Influencing the PL/SQL Compiler

Oracle Forms Developer 10g: Build Internet Applications (40 hours) Exam Code - 1z0-141

Audience:

  • Application Developers

  • PL/SQL Developers

  • Support Engineer

  • Technical Consultant

Required Prerequisites

  • Oracle 10g SQL and PL/SQL

Course Topics:

  • Introducing Oracle Forms Developer and Forms Services

  • Creating Forms Modules

  • Working with Data Blocks and Frames

  • Working with Input Items

  • Working with Non Input Items

  • Working with Windows and Canvases

  • Producing Triggers

  • Debugging Triggers

  • Adding Functionality to Items

  • Run-Time Messages and Alerts

  • Query Triggers

  • Validation

  • Navigation

Oracle Reports Developer 10g: Build Reports (40 hrs) (Report developer has no exam)

Audience:

  • Business Intelligence Developer

  • Technical Consultant

  • Reports Developer

Required Prerequisites:

  • Oracle 10g SQL and PL/SQL

Course Topics:

  • Introduction to Oracle Reports Developer

  • Designing and Running Reports

  • Working in Oracle Reports Developer

  • Creating and 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 Report Parameters

  • Embedding a Graph in a Report

  • Enhancing Matrix Reports

  • Coding PL/SQL Triggers

  • Extending Functionality Using the SRW Package

  • Maximizing Performance Using OracleAS Reports Service

  • Building Reports: Efficiency Guidelines

Request Info
Course Schedule & Price
Classroom - Regular
When Duration Where Remarks Price
Not Specified Not Specified All Venues Not Specified Price On Request

Request Info
Venues (Locations)
Vadodara, Waghodia Road (Head Office):- A-201, 202, Manki Plaza, Nr. Indrapuri Atithi Gruh Waghodia Road, Vadodara - 390 019, Gujarat, India

Vadodara, Subhanpura (Corporate Office):- 204,205, Pujer Complex Opp. Golden Silver Appt Subhanpura, Vadodara - 390 023, Gujarat, India

Ahmedabad, Paldi (Regional/Local Office):- 4th Floor, Murlidhar Complex, Fatehpura Cross Rd. Opp. Ankur School Paldi, Ahmedabad - 380 007, Gujarat, India

Jaipur, Sindhi Camp (Regional/Local Office):- 1st Floor, A-135, 136, 137, City Center, Sansar Chandra Road Sindhi Camp, Jaipur, Rajasthan, India

New Delhi, Pitampura (Regional/Local Office):- 366, Kohat Enclave Pitampura, New Delhi - 110088, Delhi, India

Indore, A. B. Road (Regional/Local Office):- 203, 2nd Floor, Saket Tower, Ratlam Kothi, Opp. Rukmani Motors Gitabhavan Square Nr. IDBI Bank A. B. Road, Indore, Madhya Pradesh, India

Pune, Shivaji Nagar (Regional/Local Office):- 1st Floor, Laxmi Sadan Apartments, Opp. Kalmadi Petrol Pump J.M. Road Shivaji Nagar, Pune - 411001, Maharashtra, India

Ahmedabad, Maninagar (Branch):- 4th Floor, Nikunjchhaya Complex Nr. Sankalp Restaurant, Krishnabaug Maninagar, Ahmedabad - 380 008, Gujarat, India

Ahmedabad, Ashram Road (Branch):- 2rd, Floor, Dhanlakshmi Complex, Opp. Jet Airways Office Income Tax - Cross Road Ashram Road, Ahmedabad, Gujarat, India

Gandhinagar, Chandkheda (Branch):- 208 Sarjan II, Above Punjab National Bank New C.G.Road Chandkheda, Gandhinagar, Gujarat, India

Ahmedabad, Naranpura (Branch):- B-408, Shivalik Yash, 132ft Ring Road Opp Shastri Nagar BRTS Bus stand, Naranpura cross road Naranpura, Ahmedabad, Gujarat, India

Anand, Vallabh Vidyanagar (Branch):- Lotos Complex, Nr. R .K. Cycle Store, B/h. Ambassy Centre Mota Bazar Vallabh Vidyanagar, Anand - 390023, Gujarat, India

Bhavnagar, Waghawadi Road (Center):- Waghawadi Road, Bhavnagar, Gujarat, India

Bhuj, Jubily Mandvi Road (Center):- Jubily Mandvi Road, Bhuj, Gujarat, India

Deesa, Gayatri Mandir (Center):- Gayatri Mandir, Deesa, Gujarat, India

Gandhidham, Tagore Road (Center):- Tagore Road, Gandhidham, Gujarat, India

Godhra, Anandnagar (Center):- Ankleswer Mahadev Raod Anandnagar, Godhra, Gujarat, India

Jamnagar, Sunnair Club Road (Center):- Sunnair Club Road, Jamnagar, Gujarat, India

Junagadh, Vnazari Garbi Chowk (Center):- Vnazari Garbi Chowk, Junagadh, Gujarat, India

Mahesana, Nagalpur (Center):- Nr. Nagalpur Khadiya Collage Nagalpur, Mahesana, Gujarat, India

Palanpur, Zilla Parishad (Center):- Zilla Parishad, Palanpur, Gujarat, India

Patan, Sidhpur Cross Road (Center):- Sidhpur Cross Road, Patan, Gujarat, India

Surat, Race Course Road (Center):- Bhulka Bhavan Race Course Road, Surat, Gujarat, India

Valsad, Avabai School Road (Center):- Avabai School Road, Valsad, Gujarat, India

Veraval, Tower Chowk (Center):- Tower Chowk, Veraval, Gujarat, India

Visnagar, Station Road (Center):- Station Road, Visnagar, Gujarat, India

Ujjain, Dewas Gate (Center):- Dewas Gate, Ujjain, Madhya Pradesh, India

Bhopal, M. P. Nagar (Center):- M.P. Nagar Zone 2 M. P. Nagar, Bhopal, Madhya Pradesh, India

Jabalpur, Home Science College Road (Center):- Home Science College Road, Jabalpur, Madhya Pradesh, India

Ratlam, Station Road (Center):- Station Road, Ratlam, Madhya Pradesh, India

Request Info
Courses