Oracle Database 11g: SQL Fundamentals I

• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Identify the major structural components of the Oracle Database 11g
• Create reports of aggregated data
• Write SELECT statements that include queries
• Retrieve row and column data from tables with the SELECT statement
• Run data manipulation statements (DML) to update data in the Oracle Database 11g
• Create tables to store data
• Utiliye views to display and retrieve data
• Write multiple-column sub-queries
• Use scalar and correlated sub-queries Use
• the regular expression support in SQL
• Create reports of sorted and restricted data
• Controlling User Access
• Manipulating Data
• Managing Data in Different Time Zones

Oracle Database 11g: Program with PL/SQL

• Create and debug stored procedures and functions
• Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code
• Design PL/SQL packages to group related constructs
• Create overloaded package subprograms for more flexibility
• Design PL/SQL anonymous blocks that execute efficiently
• Use the Oracle supplied PL/SQL packages to generate screen output, file output and mail output
• Write dynamic SQL for more coding flexibility
• Describe the features and syntax of PL/SQL
• Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
• Manage dependencies between PL/SQL subprograms
• Handle runtime errors
• Create triggers to solve business challenges
• Design PL/SQL code for predefined data types, local subprograms, additional pragmas,
• standardized constants and exception

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

• Create form modules, including components for database interaction and GUI controls
• Display form modules in multiple windows and use a variety of layout styles
• Test form modules in a Web browser
• Debug form modules in a 3-tier environment
• Implement triggers to enhance form functionality
• Reuse objects and code
• Link one form module to another

Oracle Reports Developer 11g: Build Reports

• Use report parameters and customize a runtime parameter form
• Enhance reports using graphs and PL/SQL trigger code
• Maximize report performance using Oracle Bea 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
• Add dynamic data to an existing HTML page