Oracle Developer 11g Training
This Oracle Developer 11g 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.
Few of the clients we have served across industries are:
DHL | PWC | ATOS | TCS | KPMG | Momentive | Tech Mahindra | Kellogg's | Bestseller | ESSAR | Ashok Leyland | NTT Data | HP | SABIC | Lamprell | TSPL | Neovia | NISUM and many more.
MaxMunus has successfully conducted 1000+ corporate training in India, Qatar, Saudi Arabia, Oman, Bangladesh, Bahrain, UAE, Egypt, Jordan, Kuwait, Srilanka, Turkey, Thailand, HongKong, Germany, France, Australia and USA.
Course Information
Oracle Developer 11g Course Duration: 40 Hours
Oracle Developer 11g Training Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day
Oracle Developer 11g Training Method: Online/Classroom Training
Oracle Developer 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 class.