Get trained and start highest paying IT career **


To help you succeed in today's competitive job market, Oracle certifications are tangible, industry-recognized credentials that can help you succeed in your IT career, whether you are looking for new opportunities or advancing in your current position.
Oracle certification is a reliable validation of training that can accelerate your professional career and enhance your skills.
Alhamdulillah, OraSoft is the pioneer Oracle Training Institute in Karachi. Each year, we trained hundreds of professionals as well as newcomers. We are continually developing and improving our training programs and facilities to provide a service that matches industry requirements.

Development the way you want it...
Simple and Fast.

Oracle Forms, a component of Oracle Fusion Middleware 11g, is Oracle's long-established technology to design and build enterprise applications quickly and efficiently. Using Oracle Reports Builder to design and build a variety of standard and custom Web and paper reports.

Oracle 11g: Regular Program

Oracle Database SQL (1Z0-071)
Oracle Database 11g: Program with PL/SQL (1Z0-144)
Oracle Fusion Middleware 11g: Build Applications with Oracle Forms (1Z0-151)
Oracle Fusion Middleware 11g: Build Reports with Oracle Reports Builder
Oracle Database 11g: Administration I (1Z0-052)
Oracle Database 11g: Administration II (1Z0-053)

Fee for both Tracks (Developer & Database Administration)
Rs.50,000/- (Fifty Thousand only)
Breakup of Fee Rs.10,000/- Per Month (Five Instalment)
Duration: Six Months
Classes: Three alternate days a week
Timing: (6:30pm to 8:30pm)

Oracle 11g: Developer Track

Oracle 11g: PL/SQL Developer Certified Associate
Oracle Database SQL (1Z0-071)
Oracle Database 11g: Program with PL/SQL (1Z0-144)

Fee: Rs.20,000/- (Twenty Thousand only)
Breakup of Fee Rs.10,000/- per month
Duration: Two n half Months

Oracle 11g: Forms Developer Certified Professional
Oracle Database SQL (1Z0-071)
Oracle Database 11g: Program with PL/SQL (1Z0-144)
Oracle Fusion Middleware 11g: Build Applications with Oracle Forms (1Z0-151)
Oracle Fusion Middleware 11g: Build Reports with Oracle Reports Builder

Fee: Rs.30,000/- (Thirty Thousand only)
Breakup of Fee Rs.10,000/- per month
Duration: Three n half Months

Oracle 11g: PL/SQL, Forms & Reports Courses
Oracle Database 11g: Program with PL/SQL (1Z0-144)
Oracle Fusion Middleware 11g: Build Applications with Oracle Forms (1Z0-151)
Oracle Fusion Middleware 11g: Build Reports with Oracle Reports Builder

Fee: Rs.20,000/- (Twenty Thousand only)
Breakup of Fee Rs.10,000/- per month
Duration: Two n half Months

Oracle 11g: Database Administration Track

Oracle 11g: Database Certified Associate
Oracle Database SQL (1Z0-071)
Oracle Database 11g: Administration I (1Z0-052)

Fee: Rs.23,000/- (Twenty Three Thousand only)
Breakup of Fee on monthly basis Rs.(12,000 / 11,000)
Duration: Two n half Months

Oracle 11g: Database Certified Professional
Oracle Database SQL (1Z0-071)
Oracle Database 11g: Administration I (1Z0-052)
Oracle Database 11g: Administration II (1Z0-053)

Fee: Rs.35,000/- (Thirty Five Thousand only)
Breakup of Fee Rs.(12,000 / 12,000 / 11,000) per month
Duration: Three n half Months

Oracle 11g: Databse Administration Courses
Oracle Database 11g: Administration I (1Z0-052)
Oracle Database 11g: Administration II (1Z0-053)

Fee for only one course will be Rs.15,000/-

Fee: Rs.24,000/- (Twenty Four Thousand only)
Breakup of Fee Rs.12,000/- per month
Duration: Two n half Months


Course Outline

  • 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
  • Defining SELECT Statements
  • 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
  • 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
  • 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
  • Exploring the Oracle Database Architecture
  • Oracle Database Architecture Overview
  • Oracle ASM Architecture Overview
  • Process Architecture
  • Memory structures
  • Logical and physical storage structures
  • ASM storage components
  • Heading
  • Installing your Oracle Software
  • Tasks of an Oracle Database Administrator
  • Tools Used to Administer an Oracle Database
  • Installation: System Requirements
  • Oracle Universal Installer (OUI)
  • Installing Oracle Grid Infrastructure
  • Installing Oracle Database Software
  • Silent Install
  • Creating an Oracle Database
  • Planning the Database
  • Using the DBCA to Create a Database
  • Password Management
  • Creating a Database Design Template
  • Using the DBCA to Delete a Database
  • Managing the Oracle Database Instance
  • Start and stop the Oracle database and components
  • Use Oracle Enterprise Manager
  • Access a database with SQLPlus
  • Modify database installation parameters
  • Describe the stages of database startup
  • Describe database shutdown options
  • View the alert log
  • Access dynamic performance views
  • Manage the ASM Instance/li>
  • Set up initialization parameter files for ASM instance
  • Start up and shut down ASM instances
  • Administer ASM disk groups
  • Configuring the Oracle Network Environment
  • Use Enterprise Manager to create and configure the Listener
  • Enable Oracle Restart to monitor the listener
  • Use tnsping to test Oracle Net connectivity
  • Identify when to use shared servers and when to use dedicated servers
  • Managing Database Storage Structures
  • Storage Structures
  • How Table Data Is Stored
  • Anatomy of a Database Block
  • Space Management in Tablespaces
  • Tablespaces in the Preconfigured Database
  • Actions with Tablespaces
  • Oracle Managed Files (OMF)
  • Administering User Security
  • Database User Accounts
  • Predefined Administrative Accounts
  • Benefits of Roles
  • Predefined Roles
  • Implementing Profiles
  • Managing Data Concurrency
  • Data Concurrency
  • Enqueue Mechanism
  • Resolving Lock Conflicts
  • Deadlocks
  • Managing Undo Data
  • Data Manipulation
  • Transactions and Undo Data
  • Undo Data Versus Redo Data
  • Configuring Undo Retention
  • Implementing Oracle Database Auditing
  • Describe DBA responsibilities for security
  • Enable standard database auditing
  • Specify audit options
  • Review audit information
  • Maintain the audit trail
  • Database Maintenance
  • Manage optimizer statistics
  • Manage the Automatic Workload Repository (AWR)
  • Use the Automatic Database Diagnostic Monitor (ADDM)
  • Describe and use the advisory framework
  • Set alert thresholds
  • Use server-generated alerts
  • Use automated tasks
  • Performance Management
  • Performance Monitoring
  • LManaging Memory Components
  • Enabling Automatic Memory Management (AMM)
  • Automatic Shared Memory Advisor
  • Using Memory Advisors
  • Dynamic Performance Statistics
  • Troubleshooting and Tuning Views
  • Invalid and Unusable Objects
  • Backup and Recovery Concepts
  • Part of Your Job
  • Statement Failure
  • User Error
  • Understanding Instance Recovery
  • Phases of Instance Recovery
  • Using the MTTR Advisor
  • Media Failure
  • Archive Log Files
  • Performing Database Backups
  • Backup Solutions: Overview
  • Oracle Secure Backup
  • User-Managed Backup
  • Terminology
  • Recovery Manager (RMAN)
  • Configuring Backup Settings
  • Backing Up the Control File to a Trace File
  • Monitoring the Flash Recovery Area
  • Performing Database Recovery
  • Opening a Database
  • Data Recovery Advisor
  • Loss of a Control File
  • Loss of a Redo Log File
  • Data Recovery Advisor
  • Data Failures
  • lListing Data Failures
  • Data Recovery Advisor Views
  • Moving Data
  • Describe ways to move data
  • Create and use directory objects
  • Use SQL*Loader to move data
  • Use external tables to move data
  • General architecture of Oracle Data Pump
  • Use Data Pump export and import to move data
  • Working with Support
  • Use the Enterprise Manager Support Workbench
  • Work with Oracle Support
  • Log service requests (SR)
  • Manage patches
  • Core Concepts and Tools of the Oracle Database
  • The Oracle Database Architecture: Overview
  • ASM Storage Concepts
  • Connecting to the Database and the ASM Instance
  • DBA Tools Overview
  • Configuring for Recoverability
  • Backup and Recovery (BR): purpose, typical tasks and terminology
  • Using the Recovery Manager (RMAN)
  • Configuring the database for BR operations
  • Configuring Archivelog mode
  • Configuring backup retention
  • Configuring and using a Flash Recovery Area (FRA)
  • Using the RMAN Recovery Catalog
  • Tracking and storing backup information
  • Setting up a Recovery Catalog
  • Recording backups
  • Using RMAN Stored Scripts
  • Managing the Recovery Catalog (Backup, Export, Import, Upgrade, Drop and Virtual Private Catalog)
  • Configuring Backup Settings
  • Configuring and managing persistent settings for RMAN
  • Configuring Autobackup of control file
  • Backup optimization
  • Advanced Configuration Settings: Compressing Backups
  • Configuring Backup and Restore for very large files (Multisection)
  • Creating Backups with RMAN
  • Backup types
  • Create and Use
  • Backup Sets and Image Copies
  • Whole Database Backup
  • Fast Incremental Backup
  • Configure Backup Destinations
  • Duplexed Backup Sets
  • Archival Backups
  • Restore and Recovery Task
  • Restoring and recovering
  • Causes of file loss
  • Automatic Tempfile Recovery
  • Recovering from the loss of a Redo Log Group
  • Recovering from a Lost Index Tablespace
  • Re-creating a Password Authentication File
  • Complete and Incomplete Recovery
  • Other Recovery Operations
  • Using RMAN to Perform Recovery
  • Complete Recovery after loss of a Critical or Noncritical Data File
  • Recovering image copies and switching files
  • Restore and Recovery of a Database in NOARCHIVELOG Mode
  • Incomplete Recovery
  • Performing Recovery with a Backup Control File
  • Restoring from Autobackup: Server Parameter File and Control File
  • Restoring and Recovering the Database on a New Host
  • Monitoring and Tuning RMAN
  • Monitoring RMAN Jobs
  • Balance Between Speed of Backup Versus Speed of Recovery
  • RMAN Multiplexing
  • Synchronous and Asynchronous I/O
  • Using Flashback Technology I
  • Overview and Setup
  • Using Flashback Technology to query data
  • Flashback Table
  • Flashback transaction query
  • Performing Flashback Transaction Backout
  • Oracle Total Recall
  • Flashback Drop and the Recycle Bin
  • Diagnosing the Database
  • Data Recovery Advisor (DRA)
  • Block corruption
  • Automatic Diagnostic Repository (ADR)
  • Health monitor
  • The ADR Command-Line Tool, ADRCI
  • Performing Flashback Database
  • Configuring Flashback Database
  • Performing Flashback Database Operations
  • Monitoring Flashback Database
  • Managing Memory
  • Oracle Memory Structures
  • Oracle Database Memory Parameters
  • Using Automatic Memory Management
  • Automatic Shared Memory Management
  • Using Memory Advisors
  • Using Data Dictionary Views
  • Managing Database Performance
  • Tuning activities
  • Using statistic preferences
  • Optimizer statistics collection
  • Monitor the performance of Sessions and Services
  • Automatic Workload Repository (AWR)
  • Describing the Benefits of Database Replay
  • Managing Performance by SQL Tuning
  • SQL Tuning and SQL Advisors
  • Using SQL Tuning Advisor
  • SQL Access Advisor
  • SQL Performance Analyzer Overview
  • Managing Resources
  • Overview and Concepts
  • Accessing and creating resource plans
  • Creating Consumer Group
  • Specifying Resource Plan Directives, including:
  • - Limiting CPU Utilization at the Database Level
  • - Instance Caging
  • Activating a Resource Plan
  • Monitoring the Resource Manager
  • Automating Tasks with the Scheduler
  • Simplifying management tasks
  • Creating a Job, Program, and Schedule
  • Using Time-Based, Event-Based, and Complex Schedules
  • Describing the Use of Windows, Window Groups, Job Classes, and Consumer Groups
  • Multi-Destination Jobs
  • Managing Space in Blocks
  • Free Space Management
  • Monitoring space
  • Compressing data
  • Managing Space in Segments
  • Segment Creation on Demand
  • Additional Automatic Space-Saving Functionalit
  • Shrinking Segments
  • Segment Advisor
  • Managing Resumable Space Allocation
  • Managing Space for the Database
  • Using 4 KB-Sector Disks
  • Transporting Tablespaces
  • Transporting Databases
  • Duplicating a Database
  • Purpose and Methods of Cloning a Database
  • Using RMAN to Create a Duplicate Database
  • Cloning a Database from a Backup
  • Duplicate a Database Based on a Running Instance
  • Targetless Duplicating a Database

Course Description

Oracle Database 11g: SQL Fundamentals I (1Z0:051)

This Oracle Database 11g: SQL Fundamentals course teaches you about the fundamentals of SQL using Oracle Database 11g database technology. Learn essential SQL skills to write queries against single & multiple tables, manipulate data in tables & more. This Oracle Database 11g: SQL Fundamentals I – This Course is designed to teach you the fundamentals of SQL using Oracle Database 11g 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

Oracle Database 11g: Administration I (1Z0-052)

This Database 11g Administration training gives you a firm foundation in basic database administration, including how to install and maintain an Oracle database. Learn about architecture and how the database components work and interact. This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam.

Learn To:

  • Install Oracle Grid Infrastructure
  • Create and manage users
  • Install and configure an Oracle Database
  • Create and manage storage structures
  • Administer the Oracle Database
  • Understand the Oracle database architecture and how its components work and interact with one another
  • Perform backup and recovery

Oracle Database 11g: Administration II (1Z0-053)

This Database 11g Administration training teaches you to perform backup and recovery, and diagnose and repair data failures. Manage major database components like memory, performance and resources using Oracle Database 11g. This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

Learn To:

  • Diagnose and repair data failures with Flashback technology
  • Manage space to optimize database storage so you can respond to growing space requirements
  • Monitor and manage major database components, including memory, performance and resources
  • Secure the availability of your database through appropriate backup and recovery strategies
  • Automate DBA tasks with the Scheduler

Oracle Certification

Once students have completed a training program, they are prepared to take the Oracle certification exams, the specific exams required depend on the product area you chosen, such as Oracle Application Development or Database Administration. The Oracle Certified Associate designation, the lowest level of certification, requires passed two exams to become Certified Associate. To earn certifications at higher levels, individuals need to pass one more exam to get the Certified Professional level.

Oracle Developer Certification

ORACLE CERTIFIED ASSOCIATE (OCA) certifications are designed for IT professionals beginning to work with Oracle application development. Having experience using Oracle Database 11g database technology. Using the powerful Structured Query Language (SQL), essential SQL skills to write queries against single & multiple tables, retrieve, manipulate and manage data in relational databases tables, and also knows how to develop stored procedures, functions, packages and database triggers can earns (OCA) credential by passing two exams.

ORACLE CERTIFIED PROFESSIONAL (OCP) Developer certification is designed for individuals who possess a strong foundation in SQL and PL/SQL basics and wish to learn to use Oracle Forms Builder 11g to rapidly build scalable, high-performance applications for the Web. This certification covers topics such as: designing code for reuse, using GUI controls and writing triggers, troubleshooting applications and using WebUtil to interact with client computers.
Successfully completing the requirements of this certification track earns the designation of Oracle Certified Professional, Oracle Fusion Middleware 11g Forms Developer. This certification differentiates candidates in the marketplace by providing a competitive edge through proven expertise. Up-to-date training and field experience are recommended.

Oracle Database Administration Certification

ORACLE CERTIFIED ASSOCIATE (OCA) certifications are designed for IT professionals beginning to work with Oracle technologies. This certification validates the fundamental skills needed to install, configure and maintain an Oracle database, or work on a team that manages the Oracle database in a business environment.

ORACLE CERTIFIED PROFESSIONAL (OCP) credential validates the skills and experience required to manage, develop, or implement enterprise-wide databases, middle-ware or applications. The certification is appropriate for mid to senior level Oracle database administrators. Certified professionals can install, configure, maintain, troubleshoot, backup, configure and manage the Oracle network environment.

** Depending upon your academic qualification, experience and expertise on development tools and databases.