Oracle 11g: Developer – Fusion Middleware
Oracle Database SQL (1Z0-071)
This Oracle Database SQL course teaches you about the fundamentals of SQL using Oracle Database SQL database technology. Learn essential SQL skills to write queries against single & multiple tables, manipulate data in tables & more. This Oracle Database SQL – This Course is designed to teach you the fundamentals of SQL using Oracle Database SQL database technology. Using the powerful Structured Query Language (SQL), the data contained within relational databases can be retrieved, managed and manipulated.
Learn to:
- Develop essential SQL skills that enable developers to write queries against single and multiple tables
- Create 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
- Administer database objects
Oracle Database 11g: Program with PL/SQL (1Z0-144)
This Database Program with PL/SQL training shows you how to develop stored procedures, functions, packages and database triggers. You’ll learn to manage PL/SQL program units and dependencies, while using of some of the Oracle-supplied packages. This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through expert Oracle instructors, you’ll learn to develop stored procedures, functions, packages and more.
Learn to:
- Conditionally control code flow (loops, control structures)
- Use PL/SQL packages to group and contain related constructs
- Create triggers to solve business challenges
- Use some of the Oracle supplied PL/SQL packages to generate screen output and file output
- Create anonymous PL/SQL blocks, functions and procedures
- Declare PL/SQL Variables
Oracle Fusion Middleware 11g: Build Applications with Oracle Forms (1Z0-151)
This Oracle Fusion Middleware 11g: Build Applications with Oracle Forms training teaches you how to use Oracle Forms Builder 11g. Expert instructors will teach you how to create rapidly build scalable, high-performance applications for the Web. In this course students build, test, debug, and deploy interactive Internet applications. Working in a graphical user interface (GUI) environment, they develop an order entry application from the ground up. This application incorporates several advanced features that provide a rich user experience while implementing business rules.
Learn to:
- Use Oracle Forms Builder 11g
- Enhance applications with various GUI controls
- Add functionality to applications by writing triggers
- Use the Forms Debugger to troubleshoot applications
- Validate user input and display meaningful error messages
- Use WebUtil to interact with client computers
- Validate user input, control navigation and display meaningful messages to users
- Use WebUtil to interact with the client machine and pass values from one form to another
- Replace or supplement default transaction processing
Oracle Fusion Middleware 11g: Build Reports with Oracle Reports Builder
Oracle Reports, a component of Oracle Fusion Middleware 11g is a high-fidelity enterprise reporting tool. It enables businesses to provide instant access to information to all levels within and outside of the organization in a scalable and secure environment. Generate reports in any popular format for web and paper, and to burst and distribute reports to any destination. Oracle remains committed to the development of this technology, and to the ongoing release as a component of the Oracle Fusion Middleware 11g platform. In this course, students learn how to design and build a variety of standard and custom Web and paper reports using Oracle Reports Builder. Working in the declarative environment of Reports Builder, participants learn how to retrieve, display, and format data from any data source in numerous reporting styles and publish the output to any destination.
Learn to:
- 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
- Add dynamic data to an existing HTML page
Click on link for more detail.
Using Structured Query Language (SQL)
- Explain the relationship between a database and SQL
Using Data Manipulation Language (DML) and Transaction Control Language (TCL)
- Describe the purpose of DML
- Use DML to manage data in tables
- Use TCL to manage transactions
Using Basic SELECT statements
- Build a SELECT statement to retrieve data from an Oracle Database table
- Use the WHERE clause to the SELECT statement to filter query results
Defining Table Joins
- Describe the different types of joins and their features
- Use joins to retrieve data from multiple tables
- Use self joins
Using Conversion Functions and Conditional Expressions
- Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
- Apply general functions and conditional expressions in a SELECT statement
Displaying Data from Multiple Tables
- Use SELECT statements to access data from more than one table using equijoins and nonequijoins
- Join a table to itself by using a self-join
- View data that generally does not meet a join condition by using outer joins
Using the Set Operators
- Use a set operator to combine multiple queries into a single query
- Control the order of rows returned
Using DDL Statements to Create and Manage Tables
- Describe data types that are available for columns
- Create a simple table
- Create constraints for tables
- Describe how schema objects work
- Execute a basic SELECT statement
Managing Objects with Data Dictionary Views
- Use the data dictionary views to research data on objects
- Query various data dictionary views
Managing Schema Objects
- Manage constraints
- Create and maintain indexes including invisible indexes and multiple indexes on the same columns
- Drop columns and set column UNUSED
- Perform flashback operations
- Create and use external tables
Using Data Definition Language (DDL)
- Describe the purpose of DDL
- Use DDL to manage tables and their relationships
- Explain the theoretical and physical aspects of a relational database
Using Data Definition Language (DDL)
- Describe the purpose of DDL
- Use DDL to manage tables and their relationships
- Explain the theoretical and physical aspects of a relational database
- Identify the connection between an ERD and a database using SQL SELECT statements
Restricting and Sorting Data
- Use the ORDER BY clause to sort SQL query results
- Limit the rows that are retrieved by a query
- Sort the rows that are retrieved by a query
- Use ampersand substitution to restrict and sort output at runtime
Using Single-Row Functions to Customize Output
- Use various types of functions available in SQL
- Use conversion functions
- Use character, number, and date and analytical (PERCENTILE_CONT, STDDEV, LAG, LEAD) functions in SELECT statements
Reporting Aggregated Data Using the Group Functions
- Describe the use of group functions
- Group data by using the GROUP BY clause
- Include or exclude grouped rows by using the HAVING clause
Using Subqueries to Solve Queries
- Define subqueries
- Describe the types of problems subqueries can solve
- Describe the types of subqueries
- Use correlated subqueries
- Update and delete rows using correlated subqueries
- Use the EXISTS and NOT EXISTS operators
- Use the WITH clause
- Use single-row and multiple-row subqueries
Manipulating Data
- Insert rows into a table
- Update rows in a table
- Delete rows from a table
- Control transactions
Creating Other Schema Objects
- Create simple and complex views with visible/invisible columns
- Create, maintain and use sequences
Controlling User Access
- Differentiate system privileges from object privileges
- Grant privileges on tables and on a user
- Distinguish between privileges and roles
Manipulating Large Data Sets
- Describe the features of multitable INSERTs
- Merge rows in a table
Overview of PL/SQL
- Identify the benefits of PL/SQL Subprograms
- Overview of the types of PL/SQL blocks
- Create a Simple Anonymous Block
- How to generate output from a PL/SQL Block?
Declare PL/SQL Identifiers
- List the different Types of Identifiers in a PL/SQL subprogram
- Usage of the Declarative Section to Define Identifiers
- Use variables to store data
- Identify Scalar Data Types
- The %TYPE Attribute
- What are Bind Variables?
- Sequences in PL/SQL Expressions
Write Executable Statements
- Describe Basic PL/SQL Block Syntax Guidelines
- Learn to Comment the Code
- Deployment of SQL Functions in PL/SQL
- How to convert Data Types?
- Describe Nested Blocks
- Identify the Operators in PL/SQL
Interaction with the Oracle Server
- Invoke SELECT Statements in PL/SQL
- Retrieve Data in PL/SQL
- SQL Cursor concept
- Avoid Errors by using Naming Conventions when using Retrieval and DML Statements
- Data Manipulation in the Server using PL/SQL
- Understand the SQL Cursor concept
- Use SQL Cursor Attributes to Obtain Feedback on DML
- Save and Discard Transactions
Control Structures
- Conditional processing using IF Statements
- Conditional processing using CASE Statements
- Describe simple Loop Statement
- Describe While Loop Statement
- Describe For Loop Statement
- Use the Continue Statement
Composite Data Types
- Use PL/SQL Records
- The %ROWTYPE Attribute
- Insert and Update with PL/SQL Records
- INDEX BY Tables
- Examine INDEX BY Table Methods
- Use INDEX BY Table of Records
Explicit Cursors
- What are Explicit Cursors?
- Declare the Cursor
- Open the Cursor
- Fetch data from the Cursor
- Close the Cursor
- Cursor FOR loop
- The %NOTFOUND and %ROWCOUNT Attributes
- Describe the FOR UPDATE Clause and WHERE CURRENT Clause
Exception Handling
- Understand Exceptions
- Handle Exceptions with PL/SQL
- Trap Predefined Oracle Server Errors
- Trap Non-Predefined Oracle Server Errors
- Trap User-Defined Exceptions
- Propagate Exceptions
- RAISE_APPLICATION_ERROR Procedure
Stored Procedures
- Create a Modularized and Layered Subprogram Design
- Modularize Development With PL/SQL Blocks
- Understand the PL/SQL Execution Environment
- List the benefits of using PL/SQL Subprograms
- List the differences between Anonymous Blocks and Subprograms
- Create, Call, and Remove Stored Procedures
- Implement Procedures Parameters and Parameters Modes
- View Procedure Information
Stored Functions and Debugging Subprograms
- Create, Call, and Remove a Stored Function
- Identify the advantages of using Stored Functions
- Identify the steps to create a stored function
- Invoke User-Defined Functions in SQL Statements
- Restrictions when calling Functions
- Control side effects when calling Functions
- View Functions Information
- How to debug Functions and Procedures?
Packages
- Listing the advantages of Packages
- Describe Packages
- What are the components of a Package?
- Develop a Package
- How to enable visibility of a Package’s Components?
- Create the Package Specification and Body using the SQL CREATE Statement and SQL Developer
- Invoke the Package Constructs
- View the PL/SQL Source Code using the Data Dictionary
Deploying Packages
- Overloading Subprograms in PL/SQL
- Use the STANDARD Package
- Use Forward Declarations to solve Illegal Procedure Reference
- Implement Package Functions in SQL and Restrictions
- Persistent State of Packages
- Persistent State of a Package Cursor
- Control side effects of PL/SQL Subprograms
- Invoke PL/SQL Tables of Records in Packages
Implement Oracle-Supplied Packages in Application Development
- What are Oracle-Supplied Packages?
- Examples of some of the Oracle-Supplied Packages
- How does the DBMS_OUTPUT Package work?
- Use the UTL_FILE Package to Interact with Operating System Files
- Invoke the UTL_MAIL Package (Concept)
- Write UTL_MAIL Subprograms (Concept)
Dynamic SQL
- The Execution Flow of SQL
- What is Dynamic SQL?
- Declare Cursor Variables
- Dynamically Executing a PL/SQL Block
- Configure Native Dynamic SQL to Compile PL/SQL Code
- How to invoke DBMS_SQL Package?
- Implement DBMS_SQL with a Parameterized DML Statement
- Dynamic SQL Functional Completeness
Design Considerations for PL/SQL Code
- Standardize Constants and Exceptions
- Understand Local Subprograms
- Write Autonomous Transactions
- Implement the NOCOPY Compiler Hint
Triggers
- Describe Triggers
- Identify the Trigger Event Types and Body
- Business Application Scenarios for Implementing Triggers
- Create DML Triggers using the CREATE TRIGGER Statement and SQL Developer
- Identify the Trigger Event Types, Body, and Firing (Timing)
- Differences between Statement Level Triggers and Row Level Triggers
- Create Instead of and Disabled Triggers
- How to Manage, Test and Remove Triggers?
Creating Compound, DDL, and Event Database Triggers
- What are Compound Triggers?
- Identify the Timing-Point Sections of a Table Compound Trigger
- Understand the Compound Trigger Structure for Tables and Views
- Implement a Compound Trigger to Resolve the Mutating Table Error
- Comparison of Database Triggers to Stored Procedures
- Create Triggers on DDL Statements
- Create Database-Event and System-Events Triggers
- System Privileges Required to Manage Triggers
Manage Dependencies
- Overview of Schema Object Dependencies
- Query Direct Object Dependencies using the USER_DEPENDENCIES View
- Query an Object’s Status
- Invalidation of Dependent Objects
- Display the Direct and Indirect Dependencies
- Understand Remote Dependencies
- Recompile a PL/SQL Program Unit
Running a Forms Application
- Running a Form
- Identifying the Data Elements
- Navigating a Forms Application
- Using the Modes of Operation
- Querying Data
- Inserting, Updating, and Deleting Records
- Saving Changes
- Displaying Errors
Working in the Forms Builder Environment
- Forms Builder Key Features
- Forms Builder Components
- Navigating the Forms Builder Interface
- Forms Builder Module Object Hierarchy
- Customizing Your Forms Builder Session
- Forms Executables and Module Types
- Defining Environment Variables
- Testing a Form with the Run Form Button
Creating a Basic Form Module
- Creating a New Form Module
- Creating a New Data Bock
- Using Template Forms
- Saving and Compiling a Form Module
- Module Types and Storage Formats
- Deploying a Form Module
- Producing Documentation
Creating a Master-Detail Form
- Creating Data Blocks with Relationships
- Running a Master-Detail Form Module
- Modifying the Structure of a Data Block
- Modifying the Layout of a Data Block
Working Data Blocks and Frames
- Managing Object Properties
- Creating Visual Attributes
- Controlling the Behavior and Appearance of Data Blocks
- Controlling Frame Properties
- Displaying Multiple Property Palettes
- Setting Properties on Multiple Objects
- Copying Properties
- Creating Control Blocks
Working with Text Items
- Creating a Text Item
- Modifying the Appearance of a Text Item
- Controlling the Data of a Text Item
- Altering the Navigational Behavior of a Text Item
- Enhancing the Relationship between Text Item and Database
- Adding Functionality to a Text Item
- Displaying Helpful Messages
Creating LOVs and Editors
- LOVs and Record Groups
- Creating an LOV Manually
- Using the LOV Wizard to Create an LOV
- Setting LOV Properties
- LOV Column Mapping
- Defining an Editor
- Setting Editor Properties
- Associating an Editor with a Text Item
Creating Additional Input Items
- Input Items Overview
- Creating a Check Box
- Creating a List Item
- Creating a Radio Group
Creating Noninput Items
- Noninput Items Overview
- Creating a Display Item
- Creating an Image Item
- Creating a Push Button
- Creating a Calculated Item
- Creating a Hierarchical Tree Item
Creating Windows and Content Canvases
- Displaying a Form Module in Multiple Windows
- Creating a New Window
- Displaying a Form Module on Multiple Layouts
- Creating a New Content Canvas
Working with Other Canvas Types
- Overview of Canvas Types
- Creating a Stacked Canvas
- Creating a Toolbar
- Creating a Tab Canvas
Producing and Debugging Triggers
- Trigger Overview
- Creating Triggers in Forms Builde
- Specifying Execution Hierarchy
- PL/SQL Editor Features
- Using the Database Trigger Editor
- Using Variables in Triggers
- Adding Functionality with Built-in Subprograms
- Using the Forms Debugger
Adding Functionality to Items
- Coding Item Interaction Triggers
- Interacting with Noninput Items
Displaying Run-Time Messages and Alerts
- Built-Ins and Handling Errors
- Controlling System Messages
- The FORM_TRIGGER_FAILURE Exception
- Triggers for Intercepting System Messages
- Creating and Controlling Alerts
- Handling Server Errors
Using Query Triggers
- Query Processing Overview
- SELECT Statements Issued During Query Processing
- Setting WHERE and ORDER BY clauses and ONETIME_WHERE property
- Writing Query Triggers
- Query Array Processing
- Coding Triggers for Enter-Query Mode
- Overriding Default Query Processing
- Obtaining Query Information at Run Time
Controlling Navigation
- Using Object Properties to Control Navigation
- Writing Navigation Triggers
- Avoiding the Navigation Trap
- Using Navigation Built-Ins in Triggers
Overriding or Supplementing Transaction Processing
- Transaction Processing Overview
- Using Commit Triggers
- Testing the Results of Trigger DML
- DML Statements Issued during Commit Processing
- Overriding Default Transaction Processing
- Getting and Setting the Commit Status
- Implementing Array DML
Writing Flexible Code
- What is Flexible Code?
- Using System Variables for Flexible Coding
- Using Built-in Subprograms for Flexible Coding
- Copying and Subclassing Objects and Code
- Referencing Objects by Internal ID
- Referencing Items Indirectly
Sharing Objects and Code
- Benefits of Reusable Objects and Code
- Working with Property Classes
- Working with Object Groups
- Copying and Subclassing Objects and Code
- Working with Object Libraries
- Working with SmartClasses
- Reusing PL/SQL
- Working with PL/SQL Libraries
Using WebUtil to Interact with the Client
- Benefits of WebUtil
- Integrating WebUtil into a Form
- Interacting with the Client
Introducing Multiple Form Applications
- Multiple Form Applications Overview
- Starting Another Form Module
- Defining Multiple Form Functionality
- Sharing Data among Modules
What is Oracle Reports Builder
- OracleAS Reports Services
- OracleAS Reports Services Architecture
- Designing Reports
- Tabular Report Style
- Master Detail Report Style
- Master with Two Details Report Style
- Matrix Report Style
- Retrieving & Sharing Data
- Report Structures
- Using Common Code
- Using Common Objects
- Running A Report
- Reports Developer Executables
- PL/SQL Library
- Report Data and Layout
- Report Builder Components
- PL/SQL Editor
- The Report Editor
- PL/SQL Development Environment
- Object Categories
- Object Interrelationship
- Setting Pathnames
- Invoking Builder & the Report Wizard
- Creating A Tabular Report Using the Wizard
- Building A Query
- Selecting Displayed Fields
- Labels
The Data Model Objects
- Modifying Properties of a Query
- Creating a New Group
- Changing the Group Structure
- Ordering Data in a Group
- Filtering Data in a Group
- Using a Packaged Filter
- Data Source Types
- Using XML as a Data Source
- Viewing Output from Multiple Query Reports
- Creating Multiple-Query Linked Report
- Other Data Link Methods
- Outer Joins
- Multi-Tier Environment
Data Model Columns
- Maintaining Data Source Columns
- Producing File Content Output
- Creating Summary Columns
- Creating Formula Columns
- Creating Placeholder Column
- The Paper Layout Sections
- Designing Multipanel Reports
- Different Objects In Paper Layout
- The Paper Layout Layers
- Avoiding Layout Errors
- Creating Layout Objects
- Bursting On a Repeating Group
- Using the Report Block Tool
- Tracing the Report Distribution
- Paper Design Versus Paper Layout
Paper Design View
- Modifying a Report in the Paper Design View
- Creating a User-Defined Template
- Default Override Sections
- Adding Web Links to a Template for Report HTML Output
- Predefining Your Own Templates
- What is JavaServer Page (JSP) Technology
- Building a Web Report
- Using Report Wizard
- Technical Note
- Image Format Support
Modifying Paper Layout Object Properties
- Common Layout Properties
- Sizing Objects
- Pagination Icons in the Paper Layout
- Using Page Break Before
- Using Page Break After
- Using Page Protect
- Controlling Print Frequency
- Using Format Triggers
- Layout Object Properties for Web Support
- Controlling the Number of Records per Page
- Defining a Format Mask
- Page Numbering
- Valid Source Columns
- When are the Contents Updated
- Specifying the Format Order
Controlling Spacing Between Records
- Minimum Window Records
- Column Mode
- Creating User Parameters
- Parameter Properties
- Bind Reference
- Lexical Reference
- Hints & Tips for Referencing Parameters
- Creating List of Values
- Dynamic List of Values
- Referencing System Parameters
- Building a Paper Parameter Form
- Creating Parameter Fields
- Creating Parameter Boilerplate Objects
- Using Parameter Form HTML Extensions
- Parameter Form Header & Footer
Creating and Embedding a Graph in a Report
- Adding a Graph to a Web Report
- Adding Options to a Graph
- The rw:graph
- Customizing Graphs Using the Graph.XML File
- Types of Triggers in Reports
- Trigger Code
- Using Of Triggers
- Writing Common Code
- Referencing the Contents of the Package
- Creating a Table of Contents
- Performing DDL Statements
- Querying from Temporary Tables
- Setting Format Attributes
- Using Format Attributes in a Web Layout
Fees and Durations
Fee : Rs.30,000/- (Thirty Thousand only)
Breakup of Fee : Rs.10,000/- per month
Duration : Three n half Months
Days : Three Days a Week (Alternate Days)