Learning Outcomes:

 

• Develop essential SQL skills that enable developers to write queries against single and multiple tables
• Create database objects .Administer database objects
• Use single row functions to customize output
• Work with group functions to report aggregated data
• Use conversion functions and conditional expressions
• Manipulate queries to return required data
• Perform calculations on data
• Use Oracle Forms Builder 11g .Enhance applications with various GUI controls
• Add functionality to applications by writing triggers
• Validate user input and display meaningful error messages. Validate user input, control navigation and display meaningful messages to users
• Use WebUtil to interact with client computers. Use WebUtil to interact with the client machine and pass values from one form to another
• Replace or supplement default transaction processing
• Use report parameters and customize a runtime parameter form
• Enhance reports using graphs and PL/SQL trigger code
• Maximize report performance using OracleAS Reports Services and tune reports
• Publish a report on the Web and build reports to run in various languages
• Manage report templates, create mailing labels and letters
• Identify the main components in a report document and how they are related
• Identify the differences between Web and paper reports
• Identify standard report design styles and run existing reports to various output destinations
• Create and modify basic tabular reports and high quality Web reports
• Create other report styles such as break reports and matrix reports
• Create reports by accessing data from various data sources
• Understand the Oracle database architecture and how its components work and interact with one another

 

 

Course Content

 

• Oracle Database 11g: SQL Fundamentals I (1Z0-051)   for Certified Associate
• Oracle Database 11g: Program with PL/SQL (1Z0-144) for Oracle Certified  Professionals
• Oracle Fusion Middleware 11g: Build Applications with Oracle Forms (1Z0-151) for  Mastering Oracle technologies