Oracle 11g Online Training

ORACLE 11g online training


Duration: 50 Hours

Course Outline: RPD Development

Repository Basics

•    Oracle BI architecture components
•    Repository structure, features, and functions
•    Using the OracleBI Administration Tool
•    Creating a repository
•    Loading a repository into Oracle BI Server memory

Building the Physical Layer of a Repository

•    Importing data sources
•    Setting up connection pool properties
•    Defining keys and joins
•    Examining physical layer object properties
•    Creating alias and select tables

Building the Business Model and Mapping Layer of a Repository

•    Building a business model
•    Building logical tables, columns, and sources
•    Defining logical joins
•    Building measures
•    Examining business model object properties

Building the Presentation Layer of a Repository

•    Exploring Presentation layer objects
•    Creating Presentation layer objects
•    Modifying Presentation layer objects
•    Examining Presentation layer object properties

Testing and Validating a Repository

•    Checking repository consistency
•    Turning on logging
•    Defining a repository in the initialization file
•    Testing a repository using Oracle BI Answers
•    Inspecting the query log

Adding Multiple Logical Table Sources

•    Adding multiple logical table sources to a logical table
•    Specifying logical content

Adding Calculations to a Fact Table

•    Creating new calculation measures based on existing logical columns
•    Creating new calculation measures based on physical columns
•    Creating new calculation measures using the Calculation Wizard

Creating Dimension Hierarchies and Level-Based Measures

•    Creating dimension hierarchies
•    Creating level-based measures
•    Creating share measures
•    Creating rank measures

Using Aggregates

•    Purpose of aggregate tables in dimensional modeling
•    Modeling aggregate tables to improve query performance
•    Testing aggregate navigation
•    Using the Aggregate Persistence Wizard

Using Partitions and Fragments

•    Purpose for segmenting data into partitions and fragments
•    Partition types
•    Modeling partitions in an Oracle BI repository

Using Repository Variables

•    Session variables
•    Repository variables
•    Initialization blocks
•    Using the Variable Manager
•    Using dynamic repository variables as filters

Modeling Time Series Data

•    Using time comparisons in business analysis
•    Using Oracle BI time series functions to model time series data


•    Creating users and groups
•    Setting permissions for users and groups
•    Authenticating using a external database
•    Authenticating using database authentication
•    Setting query limits and timing restrictions
•    Setting filters to personalize information

Cache Management

•    Restricting tables as non-cacheable
•    Using Cache Manager
•    Inspecting cache reports
•    Purging cache entries
•    Modifying cache parameters and options
•    Seeding the cache

Setting Up and Administering Usage Tracking

•    Tracking and storing Oracle BI Server usage at the detailed query level
•    Using usage tracking statistics to optimize query performance and aggregation strategies
•    Analyzing usage results using Oracle BI Answers and other reporting tools

Multi-user Development

•    Setting up a multi-user development environment
•    Developing a repository using multiple developers
•    Tracking development project history

Using Administration Tool wizards and utilities to manage, maintain, and enhance repositories

•    Employing techniques to optimize Oracle BI query performance
•    Applying Oracle BI repository design principles


Working with Oracle Business Intelligence Answers

•    Introduction to OracleBI Answers
•    Working with requests in OracleBI Answers

Filtering Requests in Oracle Business Intelligence Answers

•    Introduction to filters in Answers
•    Adding filter prompts to requests
•    Using saved requests as filters

Views and Charts in Requests

•    Introduction to Answers views and charts
•    Creating a column selector view

Showing Results with Pivot tables

•    Introduction to pivot tables
•    Formatting pivot tables
•    Setting aggregation rules and building formulas

Creating Interactive Dashboards

•    Introduction to Dashboards and pages
•    Dashboard Editor UI elements
•    Composing Dashboard elements

Configuring Interactive Dashboards

•    Types of Dashboard content
•    Embedding content in Dashboards

Customizing the Oracle Business Intelligence User Interface

•    Modifying cascading style sheets
•    Modifying XML message files

Configuring Guided Navigation Links

•    Building guided navigation with static links
•    Building guided navigation with conditional links and sections

Administering Oracle Business Intelligence Presentation Catalog

•    Maintaining the OracleBI Presentation Catalog
•    Maintaining security
•    Understanding security inheritance

Using Oracle Business Intelligence Delivers

•    Building alerts
•    Building iBots
•    Introduction to OracleBI Scheduler

 Other Feature we provide:

  • FAQS
  • Concentration on performance tuning
  • Real time scenarios
  • Certification guidance
  • Resume preparation
  • Sample resumes
  • Interview & certification FAQS
  • How to face the interview
  • Class notes which is useful for who is trying for job
  • Project preparation