Home - IT Training - Our Programs - Oracle 10g

Teknowledge Certified Oracle DBA/Developer
Teknowledge’s Oracle DBA/Developer course will help you acquire advanced skills for becoming a Database Application Programmer.

Internship Options
Teknowledge is unique in its training and delivery methodology as it is the first in India to provide the participant Hi-End technology training followed by rigorous INTERNSHIP in its INTERNSHIP DEVELOPMENT CENTER. This gives the participant real time software-development experience through Software Development Life Cycle to making him/her a complete Software Professional .

Oracle 10g SQL

• Introduction
• Writing Basic SQL Statements
• Restricting & Storing Data
• Using Single Row Function for Customized output
• Displaying Data From Multiple Tables
• Reporting Aggregated Data
• Sub-Queries
• Using  the Set Operators
• Manipulated Data
• Creating and Managing Tables
• Creating Other Scheme Objects
• Managing Objects with Data Dictionary Views
• Controlling User Access
• Managing Scheme Objects
• Manipulating Large Data Sets
• Generating Reports by Grouping related Data
• Managing Data in Different Time Zones
• Retrieving Data Using Sub queries
• Hierarchical Retrieval
• Regular Expression Support

Oracle 10g Administration Workshop I

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

Oracle 10g Administration Workshop II

• Introduction
• Configuring Recovery Manger
• Using Recovery Manager
• Recovering from Non-Critical Losses
• Database Recovery
• Flashback
• Dealing with Database Corruption
• Monitoring and Managing Memory
• Automatic Performance Management
• Managing Scheme Object
• Managing Storage
• Automatic Storage Management
• Managing Resources
• Automatic Tasks with Scheduler
• Database Security
• Globalization Support

Overview of Real Application Cluster (RAC)

• RAC Concepts
• Failover & Load-balancing
• Cache Fusion
• Transparent Application Failover

SQL

• Introduction
• Writing Basic SQL Statements
• Restricting & Sorting Data
• Single Row Functions
• Displaying Data from Multiple Tables
• Aggregating Data Using Group Functions
• Sub- Queries
• Producing Readable Output with iSQL* Plus
• Manipulating Data
• Creating and Managing Tables
• Including Constraints
• Creating Views & Other Database Objects
• Controlling User Access
• Using Set Operators
• Oracle 10g Datetime Functions
• Enhancements to the Group BY Clause
• Advanced Sub-Queries
• Hierarchical Retrieval
• Oracle 10g Extensions to DML and DDL Statements

PL/SQL

• Introduction
• Declaring Variables
• Writing Executable Statements
• Interacting With Oracle Server
• Writing Control Structures
• Working with Composite Datatypes
• Writing Explicit Cursors and Advanced Explicit Cursors
• Handling Exceptions, Creating Procedures
• Creating Functions, Managing Subprogram
• Creating Packages, More Packages Concepts
• Oracle Supplied Packages
• Manipulation Large Objects
• Creating Database Triggers
• Managing Dependencies

Form 10g

• Oracle forms Developer & Oracle Forms Services
• Running a Forms Developer Application
• Working in the Forms Developer Environment
• Creating a Basic Form Module – Working with Data blocks, Frames and Text Items
• Creating LOV’s Editors, Input and Non-input Items
• Creating and working with Windows, Content Canvases and Canvas Types
• Producing & Debugging Form triggers
• Adding Functionality to Items
• Runtime Messaged and Alerts
• Query Triggers, Validation, Navigation
• Transaction Processing
• Writing Flexible Code
• Sharing Objects and Code

Report 10g

• Introduction to Oracle 10g Reports Developer
• Designing and Running Reports in Reports Developer
• Creating & Enhancing Paper Templates
• Managing Report Templates
• Creating A Web Report & Web Reporting
• Enhancing Reports Using the Data Model:
• Queries and Groups
• Data Sources
• Creating Columns
• Enhancing Reports Using the Paper Layout
• Controlling the Paper Layout: Common Properties
• Controlling the Paper Layout: Specific Properties
• Extending Functionality Using XML
• Creating and Using Reports Parameters
• Embedding a Graph in a Report
• Enhancing Matrix Reports
• Coding PI/SQL Triggers
• Extending Functionality Using the SRW Package
• Maximizing Performance Using Oracle 10g AS Reports
• Services
• Building Reports: Efficiency Guidelines

Course Duration
The duration of the Oracle 10g course is 80 Hours.

Contact us
For more information about this course write to queries@teknowledge.in or walk into our IT Training center located Bangalore.