Oracle 10g DBA - OCP Course
by IANT (Institute of Advance Network Technology)Vadodara, Ahmedabad, Jaipur, New Delhi, Indore, Pune, Gandhinagar, Anand, Bhavnagar, Bhuj, Deesa, Gandhidham View More + |
Request Info |
| Eligibility: (Pre-requisites) | Familiarity with Data Processing Concepts & Techniques, Ability to use a graphical user interface (GUI) |
| Medium of instruction: | English |
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
| Classroom - Regular | ||||
| When | Duration | Where | Remarks | Price |
| Not Specified | Not Specified | All Venues | Not Specified | Price On Request |
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
IANT (Institute of Advance Network Technology)
India's No.1 Hardware and Networking Institute. IANT is emerging as a prospectiveleader in IT education and headed to establish a landmark in Education Industry.Quality thoughts & quality trend is driving the organization to adapt latest technology& techniques. Technological growth of students is perforated with personality traits,which make them an asset for any organization.
As far as IT industry is concerned, old is obsolete. we are proactive to our vendorsto launch their latest technology to be the first ones in country to introduce.



