Oracle Developer 11g Training

Oracle Developer 11g Training

This Oracle Database Administration Training will develop the key fundamental skills necessary to be an Oracle DBA. Students will design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit of administration scripts for database management and tuning by the end of this class.

Course Information

Oracle 11g Course Duration: 40 Hours

Oracle 11g Training Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day

Oracle 11g Training Method: Online/Classroom Training

Oracle 11g Study Material: Soft Copy

 

Course Content

Module I [SQL]

•Retrieving Data Using the SQL SELECT Statement 

•Restricting and Sorting Data Using Single-Row Functions to Customize Output 

•Using Conversion Functions and Conditional Expressions 

•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 

Module II  [Oracle 11g: PL/SQL Fundamentals]

•Introduction to Oracle Forms Developer and Oracle Forms Services   

•Running a Forms Developer Application   Creating LOVs and Editors  

•Creating Additional Input Items   

•Creating No input Items 

•Creating Windows and Content Canvases

•Working with Other Canvas Types

•Introduction to Triggers

•Working in the Forms Developer Environment

•Creating a Basic Form Module

• Working with Data Blocks and Frames

•Working with Text Items

•Producing Triggers

•Debugging Triggers

•Adding Functionality to Items

•Run Time Messages and Alerts

•Query Triggers

•Validation

•Navigation

•Transaction Processing

• Writing Flexible Code

•Sharing Objects and Code

• Introducing Multiple Form Applications

•Creating a Menu Module

•Managing Menu Modules

•Programming Function Keys

•Building Multiple Form Applications

•Defining Data Sources

•Working with Record Groups

•Using Database Objects in Forms Applications

Key Features

Instructor Led Oracle 11g Online Training

Flexible Time At Your Convenience

Over 1,00,000+ Professionals Trained Across 100 Countries

24x7 Live Support via Chat, Mail and Phone

Corporate Training and On-Job Support

Reviews

Request for demo