Certification IT Training Program - Oracle 10g

Teknowledge
In Bangalore

Price on request
You can also call the Study Centre
80413... More
Compare this course with other similar courses
See all

Important information

  • Certificate
  • Bangalore
  • 80 hours of class
Description

Important information
Venues

Where and when

Starts Location
On request
Bangalore
Saisadhan,1st floor,100 feet ring road,15th cross,J.P nagar 6th phase, Near Sarakki gate, Next to Vo, 560078, Karnataka, India
See map

Course programme

This certification training module program will assist you get hold of superior skills for becoming a Professional Oracle Developer as per the principles governing this training module. This module is much in demand for aspirants' eager of becoming a professional expert in this sphere of influence. Students are given ample amount of realistic training taking into consideration contemporary Oracle 10g associated applications. This is facilitated to impart them with professional expertise.

Oracle 10g S.Q.L

" Introduction
" Writing Basic S.Q.L Statement
" Restricting & Storing Data-Storage
" Using Single Row Function for Customized output
" Displaying Data-Storage From Multiple Table
" Reporting Aggregated Data-Storage
" Sub-Queries
" Using the Set Operators
" Manipulated Data-Storage
" Creating as well as Managing Table
" Creating Other Scheme Object
" Managing Objects in the company of Data-Storage Dictionary View
" Controlling User Access
" Managing Scheme Object
" Manipulating Large Data-Storage Set
" Generating Reports by Grouping related Data-Storage
" Managing Data-Storage in Different Time Zone
" Retrieving Data-Storage Using Sub query
" Hierarchical Retrieval
" Regular Expression Support

Oracle 10-g Part 1

" Introduction
" Installing the Oracle Data-Storage Software-suite
" Creating an Oracle Data-Storage
" Managing the Oracle Instance
" Managing Data-Storage Storage Structure
" Administering User Security
" Managing Scheme Objects
" Managing Data as well as Concurrency
" Managing Undo Data
" Implementing Data-Storage Security
" Configuring the Oracle Network Environment
" Proactive Maintenance
" Performance Management
" Backup as well as Recovery Concepts
" Performing Data-Storage Backups
" Performing Data-Storage Recovery
" Performing Flashback
" Moving Data

Oracle 10g Administration Part 2

" Introduction
" Configuring Recovery administrator
" Using Recovery administrator
" Recovering from Non-Critical fatalities
" Data-Storage recuperation
" Flashback
" Dealing in the company of Data-Storage vice
" Monitoring as well as Managing Memory
" Automatic Performance Management
" Managing format Object
" Managing storage space
" Automatic storage space Management
" Managing Resources
" Automatic Tasks in the company of Scheduler
" Data-Storage safety

Outline of Real Application Cluster (R.A.C)

" RAC Concept
" Failover & Load-balancing
" Cache Fusion
" Transparent Application Fai lover

PL-SQL

" Introduction
" Declaring Variable
" Writing Executable Statement
" Interacting In the company of Oracle Server
" Writing Control Structures
" Working in the company of amalgamated Data type
" Writing Explicit Cursors and Advanced Explicit Cursor
" Handling Exceptions, Creating Procedure
" Creating Functions, Managing Sub-program
" Creating Packages, More Packages Concept
" Oracle Supplied Package
" Manipulation outsized Object
" Creating Database produce
" Managing Dependency

Form-10.g

" Oracle forms Developer as well as Oracle Forms Service
" Running a Forms Developer submission
" Working in the Forms Developer milieu
" Creating a Basic Form Module - Working in the company of Data blocks, Frames as well as Text thing
" Creating LOV's Editors, Input as well as Non-input Item
" Creating as well as working in the company of Window, Content Canvas as well as Canvas Type
" Producing as well as Debugging Form trigger
" Adding Functionality to Item
" Runtime Messaged as well as Alert
" Query Triggers, Validation, Navigation
" Transaction Process means
" Writing Flexible Code
" Sharing Objects as well as Code

Report 10g

" Introduction to Oracle 10g Report Developer
" Designing as well as Running Report in Report Developer
" Creating as well as Enhancing Paper Template
" Managing Report Templates
" Creating A Web Report as well as Web Reporting
" Enhancing Reports by means of the Data Model
" Queries as well as Groups
" Data Sources
" Creating Column
" Enhancing Report by means of the Paper Layout
" Controlling the Paper Layout Common Property
" Controlling the Paper Layout Specific Property
" Extending Functionality by means of XML
" Creating as well as by means of Reports Parameter
" Embedding a Graph in a Report
" Enhancing Matrix Reports
" Coding PI-SQL Triggers
" Extending Functionality by means of the SRW Package
" Maximizing Performance by means of Oracle 10g AS Report
" Services
" Building Reports: Efficiency Guideline




Compare this course with other similar courses
See all