OBIEE 10g and 11g Online Training

Oracle BI Suite : OBIEE 10g &11g

Lesson 1

• Repository basics
• Major Components of Oracle BI Architecture
• Identify and Describe the layers of OBI repository
• Use OBI Admin tool to explore repository objects

Lesson 2

• Identify and Describe the objects in the Physical layer of a repository
• Create the physical layer of repository

Lesson 3

• Identify the objects in the BMM Layer of a Repository
• Build a Business model
• Create Measures in Business Model

Lesson 4

• Identify the objects of the presentation layer of a repository
• Modify the properties of the presentation layer objects
• Build the presentation layer of a repository

Lesson 5

• Test and validate a repository

Lesson 6

• Describe normalized and de-normalized table structures in a database design
• Add multiple sources to a LTS for a dimension in a Business model

Lesson 7

• Describe a calculation measure and its views in a business model
• Create new calculation measure based on logical columns
• Create new calculation measures based on physical columns
• Create new calculation measure by using a calculation wizard

Lesson 8

• Create dimension hierarchies
• Create level based measures
• Create rank and share measures

Lesson 9

• Aggregate tables in dimension modeling

Lesson 10

• Create session variables
• Create repository variables
• Create initialization blocks
• Implement a dynamic repository variables

Lesson 11

• Use of Time comparison for business analysis
• Implement time comparison measures in business model

Lesson 12

• Describe the purpose and process of Setting an implicit fact column
• Set an implicit fact column for a presentation catalog

Lesson 13

• define users and groups
• set permissions for users and groups to control access to repository objects
• explain group inheritance
• identify and describe authentication methods used by Oracle BI server

Working with Oracle Business Intelligence Answers

• Introduction to Oracle BI Answers
• Working with requests in Oracle BI Answers
• Using advanced formatting

Filtering Requests in Oracle Business Intelligence Answers

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

Oracle Business Intelligence Answers: Advanced Features

• Combining request criteria using set operations
• Executing direct database requests
• Editing logical SQL generated by a request

Building Views and Charts in Requests

• Introduction to Answers views and charts
• Creating and editing charts
• Performing common view tasks

Showing Results with Gauge Views

• Introduction to Gauge views
• Working with Gauge views

Showing Results with Pivot Tables

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

Creating Oracle Business Intelligence Interactive Dashboards

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

Configuring Oracle Business Intelligence Interactive Dashboards

• Types of dashboard content
• Embedding content in Interactive Dashboards
• Using bookmark links to distribute and save Interactive Dashboards

Customizing the Oracle Business Intelligence User Interface

• Modifying cascading style sheets
• Modifying XML message files
• Making configuration changes using the instance config file

Configuring Guided Navigation Links

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

Administering the Oracle Business Intelligence Presentation Catalog

• Maintaining the Oracle BI Presentation Catalog
• Managing security
• Understanding security inheritance
• Describing the Presentation Catalog structure
• Permission types
• Setting permissions using the Manage Catalog screen    
•  
• http://www.monstertrainings.com/datawarehouse/obiee.php                  

Oracle 11g Online Training

Monstertrainings has experts in online training like ORACLE, OBIEE, INFORMATICA..


We are Starting OBIEE 10g and 11g right way...

Oracle 11g

Duration: 50 Hrs

INTRODUCTION TO ORACLE DBA

• What is DBA ?
• Why a Company needs a DBA?
• Roles & Responsibilities of DBA
• Oracle Architecture
• Physical and Logical Phase of Database
• Types of files(Control file, Redolog file and Datafile)
• Different types of Datafiles
• Instance
• SGA(System Global Area) and Background Process

DATABASE CREATION

• Different Startup Modes
• Different Shutdown Modes
• Types of Database Creation
• Manual Method of Creation

TABLESPACE MANAGEMENT

• Introduction to Table space
• Types of Table space(BIG & SMALL)
• Temporary Table space
• Altering/Renaming a Table space
• Renaming a data file
• Temporary Groups
• Table space Encryption(11g)

STORAGE PARAMETERS

• What are segments?
• What are extents?
• What is Blocks?
• Oracle Blocks
• Estimation of Extents
• Dictionary Managed Table space
• Locally Managed Table space
• Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease)

USER MANAGEMENT

• Who are Database Users?
• Why to create a User?
• Creation of Users
• Assigning Privileges
• Creating and granting Roles
• Allocating table space Quotas to Users
• Assigning default table space for the Users
• Setting Profiles for the Users
• Levels of Authentication
• Schema Management(11g)
• Security(11g)

UNDO MANAGEMENT

• What is Undo?
• Why Undo required?
• Pending offline status
• Brief idea about Rollback segments
• Flashback Features
• Flashback Table
• Flashback query
• Flashback Version query

SPFILE & OMF

• What is spfile?
• Difference between spfile and pfile
• Advantages of spfile
• What is OMF?
• Advantages of OMF
• Files conventions of OMF

NETWORKING IN ORACLE

• Introduction to Oracle Networking
• Network default location
• Editing Network file
• Listener.ora
• Tnsnames.ora
• Introduction to Database Links
• Types of Database Links
• Introduction to Materialized views
• Advantages of Materialized view
• Refresh Modes

REDO-LOG & CONTROLFILE MANAGEMENT

• Introduction to Redo log
• Status of Redo logs
• Multiplexing the Redo log files
• Re-creation of Control file
• Renaming the Database
• Multiplexing the Control file

LOGICAL BACKUP

• What is a logical backup
• Why it is required
• Export/import Utility
• Data Pump
• Difference between Data Pump and Traditional Export/import
• Impdp/expdp
• Transportable Table spaces

PHYSICAL BACKUP

• Introduction to Physical backup
• Types of Physical backup
• Cold & Hot backup
• Recovery scenarios
• RMAN backup
• RMAN Point in time recovery
• RMAN 11g new features

PEFORMANCE TUNING

• What is Performance Tuning?
• Why Tuning required?
• Types of Tuning
• Database Tuning
• Application Tuning
• SQL Tuning
• Memory Tuning
• Network Tuning
• Partitioning and Indexes
• Partitioning Enhancements
• AWR/ASH/ASMM/ADDM
• RAT(Real Application Testing)(11g)
• SQL Performance Analyses (11g)
• Row chaining and Row migration
• Resemble Table spaces

AVAILABILITY

• Introduction to Data Guard
• Types of Standby databases
• 11g New features in Data Guard
• Types of Protection modes
• Active standby/snapshot standby(11g)
• Log Miner
• RMAN Point in time Recovery
• Introduction to Database Cloning
• RMAN Cloning
• Automatic Storage Management(ASM)

SQL-LOADER

• Introduction to SQL Loader
• Types of files
• Control file
• Infile
• Bad file
• Discard file
• Data file

AUDITING

• What is auditing?
• Why auditing performed?
• Types of Auditing
• Levels of Auditing

FLASHBACK FEATURES

• Flashback Database
• Flashback Archive(11g)

MISCELLANEOUS

• Oracle 11g Installations
• Comparison between Oracle 10g and Oracle 11g
• New features Introduced in Oracle 10g
• Upgradation from Oracle 10g to Oracle11g

Contact:
Madhan
+1 7323251743
9959145320

http://www.monstertrainings.com/oracle/oracle-11g.php