Hello Folks,

We are the experts in providing  BODS online trainings by using real time scenories.

Here is my content :

BODS

 

Audience :

This course is designed for individuals responsible for implementing ETL projects (batch-mode), administering and managing projects that involve Data Integrator

Prerequisites:

Experience with these products or technologies will be helpful:
• Knowledge of data warehousing and ETL concepts, SQL language
• Experience with Microsoft SQL Server
• Experience using functions, elementary procedural programming and flow-of-control statements, for example: If then Else, and While Loop statements
It is recommended you review these articles prior to attending the course:

http://www.rkimball.com/html/articles.html

• Data Warehouse Fundamentals: TCO Starts with the End User and Fact Tables and Dimension Tables
• Data Warehouse Architecture and Modeling: There Are No Guarantees
• Architecture/Modeling: Advance Dimension Topics Surrogate Keys: It’s Time for Time and Slowly Changing Dimensions
• Architecture/Modeling – Industry- and Application-Specific Issues: Think Globally, Act Locally
• Data Staging and Data Quality: Dealing with Dirty Data

Synopsis :

Data Integrator enables the implementation of ETL (Extract, Transform, and Load) projects from disparate data sources to deliver more timely and accurate data that end users in an organization can trust. In this 4-day course, the learner will learn about batch data transformation jobs, techniques for capturing changes in data, handling errors, multi-user environment tasks, administering server and migration basics. The course also shows the learner how to use tools to audit, profile data, and manage metadata to assist in the implementation of an ETL project.
Smaller activities in this course focus on the tools and features discussed in each lesson and enable the learner to create dimensions and a fact table. The learner will have a chance to apply different concepts learned from a few combined lessons in two 1-hour comprehensive workshops. At the end of the course, the learner will be able to put into practice data flow design concepts in a final 2-3 hour workshop.
As a business benefit, by being able to create efficient ETL projects, end users can use the transformed data to help improve operational and supply chain efficiencies, enhance customer relationships, create new revenue opportunities, and optimize return on investment from enterprise applications.
BusinessObjects XI R1 and BusinessObjects XI R2 
This offering is applicable for both BusinessObjects XI Release 1 and BusinessObjects Release 2 audiences.
These features include:
• Data profiling – evaluate source data to confirm the use of trusted data in your ETL project
• Enhanced metadata reports – view impact and lineage analysis, operational statistics metadata reports, and job execution dashboards using a new graphical interface; new data quality dashboard reports.
• XML_Pipeline transform – process large XML source files in your ETL project
• Support for ANSI SQL-02 varchar behavior

 

Objectives

Topics :

Lesson 1 – Datawarehousing concepts
• Describe dimensional modeling
Lesson 2 – Understanding Data Integrator
• Describe components, management tools, and the development process
• Explain object relationship
Lesson 3 – Defining source and target metadata
• Create a database datastore and import metadata
• Create a new file format and handle errors in file formats
Lesson 4 – Validating, tracing, and debugging jobs
• Use descriptions and annotations
• Validate and trace jobs
• Use View Data and the Interactive Debugger
Lesson 5 – Creating a batch job 
• Create a project, job, work flow, and data flow
• Use the Query transform in a data flow
• Use template tables
Lesson 6 – Using built-in transforms and nested data 
• Use the case, merge, and validation transforms
• Import metadata from XML documents
• Use the XML_Pipeline in a data flow
Lesson 7 – Using built-in functions
• Use date and time functions and the date generation transform to build a dimension table
• Use the lookup functions to look up status in a table
• Use match pattern functions to compare input strings to patterns
• Use database type functions to return information on data sources
Lesson 8 – Using Data Integrator Scripting Language and variables
• Explain differences between global and local variables
• Create global variables and custom functions
• Use strings and variables in Data Integrator scripting language
Lesson 9 – Capturing Changes in Data
• Use Changed Data Capture (CDC) with time-stamped sources
• Create an initial and delta load job
• Use history preserving transforms
Lesson 10 – Handling errors and auditing
• Recover a failed job
• Create a manual, recoverable work flow
• Define audit points, rules and actions on failures
Lesson 11 – Supporting a multi-user environment 
• Describe terminology and repository types in a multi-user environment
• Create and activate the central repository
• Work with objects in the central repository
Lesson 12 – Migrating Projects
• Create multiple configurations in a datastore
• Work with projects in the central repository
• Create a secure central repository
• Implement and modify group permissions
Lesson 13 – Using the Administrator
• Add a repository and user roles
• Set the job status interval and log retention period
• Execute, schedule, and monitor batch jobs
• Understand architecture, load balance index, and job execution in server groups
Lesson 14 – Profiling Data
• Set up the Data Profiler and users
• Submit a profiling task
• Monitor profiling tasks in the Administrator
Lesson 15 – Managing Metadata
• Import and export metadata
• Use Metadata Reports

 

If anyone interested please mail me on  satish@o2education.com or call me on  +91 9989990935

 

Hello Everyone,

We are the experts in providing  WEBSPHERE ADMIN online trainings by using real time scenories.

Here is my content :

 

IBM WebSphere Application Server V7 Administration on Windows or Linux

 

This course teaches you the skills needed to install and administer IBM WebSphere Application Server V7. As the latest release of WebSphere Application Server, Version 7 offers users enhanced support for standards, emerging technology, and a choice of development frameworks.

In this course, learn how to install, configure, and maintain IBM WebSphere Application Server V7 base and Network Deployment (ND), and to deploy enterprise Java applications in a single machine or clustered configuration. In addition, learn how to work with features new to WebSphere Application Server V7, such as flexible management, business-level applications, administrative console extensions, security enhancements, and the centralized installation manager. Optional units cover topics such as centralized installation and auditing.

Throughout the course, hands-on exercises and demonstrations reinforce lecture content. Gain practical experience with WebSphere Application Server V7 by performing tasks such as installing and assembling applications, using properties file-based configuration, applying problem determination techniques, and working with fine-grained administrative security. Within six (6) months of completing this course or when the certification test expires, whichever comes first, you will be able to take the aligning certification test free of charge

OBJECTIVES

Relate WebSphere Application Server to the WebSphere family of products

Describe the features and standards in WebSphere Application Server V7

Describe the architectural concepts related to WebSphere Application Server

Install and configure WebSphere Application Server V7

Explain the basic concepts of the Java Platform, Enterprise Edition (Java EE 5) platform

Assemble and install server-side Java enterprise applications

Use WebSphere administrative tools to configure and manage enterprise applications

Use the wsadmin scripting library

Configure WebSphere Application Server security

Deploy applications in clustered environments

View performance information about server and application components

Use problem determination tools and log files to troubleshoot problems

Configure messaging with the service integration bus

 

COURSE OUTLINE

Course introduction

WebSphere product family overview

WebSphere Application Server architecture – standalone

WebSphere Application Server architecture – federated

WebSphere Application Server installation

Exercise: Installing WebSphere Application Server

Exercise: Installing IBM HTTP Server

Exercise: WebSphere Information Center installation (optional)

WebSphere Application Server administrative console

Exercise: Exploring the WebSphere Application Server administrative console

Java EE 5 overview for administrators

Application assembly

Introduction to the Trade family of applications

Application installation

Exercise: Assembling an application (Windows and Linux only)

Exercise: Installing an application

Problem determination

Exercise: Problem determination

Command-line administration, scripting, and automation

Exercise: Using wsadmin

Federating a cell

Exercise: Creating a federated cell

Workload management

Exercise: Clustering and workload management

Introduction to WebSphere messaging

Exercise: Configuring the service integration bus

Centralized installation (optional)

Security and auditing

Exercise: Configuring WebSphere security, including fine-grained administrative access

Exercise: Configuring application security

Exercise: Configuring SSL for WebSphere

Exercise: Auditing (optional)

Performance monitoring

Exercise: Using the performance monitoring tools

Flexible management (optional; includes demonstration)

Course summary

 

If anyone interested please mail me on  satish@o2education.com or call me on  +91 9989990935

Hello Everyone,

We are offering QA(Testing Tools) online training by the industry experts at affordable price at trainee’s convenient time.

Here is my content :

 

Manual Testing

 

Software Engineering Concepts

Introduction

Importance of software systems

Common problems in software development and Software Bugs

Testing Objectives

SDLC

Software Life Cycle Stages

Testing Stage in SDLC

Cost of Defect Repair

Risk of inadequate Testing

Software Development Models

Waterfall Model

Incremental Model

Prototype Model

Spiral Model

V Model

Static Testing

Review

Inspections

Walkthroughs

Dynamic Testing

Unit Testing

Integration Testing

System Testing

User Acceptance Testing

Software Testing Life Cycle and implementation

Test Requirements Gathering and Analysis

Requirements Reviews

Requirements Issues Identification

Test Strategy Preparation

System Test Plan Preparation

Test Case identification

Black Box Test Design Techniques

ECP

BVA

Error Guessing

Decision Tables

State Transition

Identify Scenario based Test Cases

What is Use case?

Test Case Design

Introduction:

Test Case Design Templates

Types of Test Cases

Test Case Design Reviews

Requirement Traceability Matrix

Test Data Setup

 

 

 

 

Importance of Test data in Testing

Approach for gathering Test Data

Benefits of Test data Gathering

Managing Test data and creating Data Repositories

Software Environments

Introduction

Different Components in software environments

Difference between Test and Production Environments

Test Execution

Test Execution Life cycle Process

Different levels of Test Execution

Sanity/ Smoke testing(Level 0)

Test Batches or Test suite Preparation and Execution(Level 1)

Retesting(Level 2)

Regression Testing(Level 3)

Database Testing

Defect Reporting and Tracking

What is defect?

Categories of defects

Defect life cycle process

Formal Defect report Template

Defect Metrics

Defect Removal Efficiency

Test Measurement Techniques and Metrics collection

Importance of Test Metrics

Testing Data Used for Metrics

Different types of Metrics

Test Closure Activity

Test Execution Stop Criteria

Test Summary Report Preparation

User Acceptance Testing

Importance of User Acceptance Testing

Scope of UAT

Alpha Testing

Beta Testing

Other commonly performed Testing Techniques

Gray Box Testing

Usability Testing

User Interface Testing

Compatibility Testing

Configuration Testing

Adhoc Testing

Exploratory Testing

Installation and Un-installation Testing

Recovery Testing

Security Testing

 

 

Automation Testing

 

Introduction to Automation Testing

What is Automation Testing

Benefits of Automation Testing

Manual Testing Vs Automation Testing

Various Automation Test Tools

Tool selection criteria

 

QTP 10.0

 

Introduction to QuickTest Pro

Overview of Quick Test Pro

Starting Quick Test

Quick Test Window

Quick Test Window Layout

Using Quick Test Commands

Record and Playback

Creating and executing a Basic Test

‘ Recording a test

‘ Understanding your recorded test

‘ Executing a test

Different Recording Levels

‘ Standard Recording

‘ Analog Recording

‘ Low Level Recording

Analyzing the Quick Test Results

Working with Test Objects and Object Repositories

How QuickTest identifies Objects

Working with Test Objects

Object Spy

Configuring Object Identification

Smart Identification

Managing Object Repositories

Merging Shared Object Repositories

Associating Shared Object Repositories to a Test

Synchronization

Synchronizing your tests

Options to synchronize your tests

‘ Inserting Synchronization Point

‘ Adding Exist Statement

‘ Adding Wait Statement

‘ Global Synchronization Settings

Transactions

‘ Inserting Transactions

‘ Ending Transactions

Checkpoints

CheckPoint Introduction

Adding Checkpoints to a Test

‘ Adding Checkpoint while Recording

‘ Adding Checkpoint while Editing

Types of Checkpoints

‘ Standard Checkpoint

‘ Image Checkpoint

‘ Bitmap Checkpoint

‘ Table Checkpoint

‘ Text Checkpoint

‘ Text Area Checkpoint

‘ Accessibility Checkpoint

‘ Page Checkpoint

‘ Database Checkpoint

‘ XML Checkpoint

Checkpoints Supported Environment

Output Values

Output values introduction

Categories of Output Values

Creating Output Values

Storing Output Values

Storing Output Values

Viewing and Editing Output Values

Working with Actions

Introduction to Actions

Benefits of Actions

Creating Tests with Multiple Actions

‘ Guidelines for Working with Actions

‘ Creating a New Action

‘ Inserting Actions

‘ Inserting Copy of Action

‘ Inserting Existing Action

‘ Splitting Actions

‘ Action Parameters

‘ Test Modularity Implementation

Creating an Action Template

Parameterizing Tests and Data Driven Tests

Introduction to Parameterizing Tests

Parameterizing Tests

‘ Parameterizing a Test Manually

‘ Parameterizing a Test using Data Table

‘ Parameterizing a Test using Environment Variables

Data Driven Test

‘ Create Data Driven Tests

‘ Local and Global Data Tables

Working with Data Tables

Introduction to Data Tables

Working with Global and Action Sheets

Editing and Saving Data Table

Importing and Exporting Data

‘ Importing Data from a Spread Sheet

‘ Importing Data from a Text file

‘ Importing Data from a Database

‘ Exporting Data to a Spread Sheet

Using Formulas in the Data Table

Using Data Table Methods

Regular Expressions

Introduction to Regular Expressions

Defining Regular Expressions

Running and Analyzing a Test with Regular Expressions

Functions

Creating User Defined Functions

Advantages of using functions

Creating generic functions

Preparing Regression Test Automation suites

Function Decomposition

Implementation

Recovery Scenarios

Introduction to Recovery Scenarios

When to use Recovery Scenarios

Defining Recovery Scenarios

Recovery Scenario Manager

Managing Recovery Scenarios

Associating Recovery Scenarios to your Test

Programmatically Controlling the Recovery Mechanism

Working with Quality Center

Connecting to Quality Center

Disconnecting from Quality Center

Integrating QuickTest with Quality Center

Saving Tests into Quality Center

Opening Tests from Quality Center

Automation Frameworks

Basic Frame Work

Keyword-Driven Framework

Data-Driven Framework

Hybrid Framework

 

 

 

Load Runner 9.5

 

Performance Testing Techniques

Introduction

Types of performance testing

Environment Setup

     Performance Test Plan Preparation

Performance Test Cases Preparation

Overview on LoadRunner

Load Testing

Performance Testing

Stress Testing

LoadRunner Architecture

Load Test Process

Vuser Generator

Recording the Basic Script

Enhancing the Script

Executing the Script

Analyzing the Log

LoadRunner Controller

Load Test Planning

Creating the Scenarios

Executing the Scenarios

Defining SLA’S

Analysis

Analyzing the Summary Report

Graphs analysis

Identifying the bottle necks

Creating the reports

 

 

 

Quality Center

 

Overview of Test Management

Creating Projects

Creating Users

Assigning Users to Projects

Importing & Exporting Projects

Customizing QC

Defining & Managing Requirements

Developing Manual & Automated Tests

Creating Test Sets

Executing Tests

Defect Reporting & Tracking

Integration with Other Tools

Preparing Coverage Analysis & Tractability

Generating various Test Reports & Graphs

 

 

BUGZILLA

Overview of the bug management tool

 

 

Projects

 

Telecom

Banking

Insurance

 

If anyone interested please mail me on  satish@o2education.com or call me on  +91 9989990935

Hello,

We are offering Oracle DBA online training by the industry experts at affordable price at trainee’s convenient time.

Here is my content :

 ORACLE 10g/11g DBA

Prerequisites

Suggested Prerequisites

Working knowledge of SQL

Simple Unix commands

 

Course Topics

 

Introduction (Database Architecture)

Oracle 10g database architecture

 

Installing the Oracle Database Software

Explain core DBA tasks and tools

Plan an Oracle installation

Install oracle 10g R2 software with the Oracle Universal Installer (OUI)

 

Creating an Oracle Database

Create a database with the Database Configuration Assistant (DBCA)

Create a database design template with the DBCA

Generate database creation scripts with the DBCA

 

Managing the Oracle Instance

Start and stop the Oracle database and components

Use Enterprise Manager (EM)

Modify database initialization parameters

Understand the stages of database startup

View the Alert log

Use the Data Dictionary

 

Managing Database Storage Structures

Describe table data storage (in blocks)

Define the purpose of tablespaces and data files

Understand and utilize Oracle Managed Files (OMF)

Create and manage tablespaces

Obtain tablespace information

Describe the main concepts and functionality of Automatic Storage Management (ASM)

 

Administering User Security

Create and manage database user accounts

Authenticate users

Assign default storage areas (tablespaces)

Grant and revoke privileges

Create and manage roles

Create and manage profiles

Implement standard password security features

 

Managing Schema Objects

Define schema objects and data types

Create and modify tables

Define constraints

View the columns and contents of a table

Create indexes, views and sequences

Explain the use of temporary tables

Use the Data Dictionary

 

Managing Undo Data

Explain DML and undo data generation

Monitor and administer undo

Describe the difference between undo and redo data

Configure undo retention

 

Implementing Oracle Database Security

Describe DBA responsibilities for security

Enable standard database auditing

Maintain the audit trail

 

Configuring the Oracle Network Environment

Create additional listeners

Create Net Service aliases

Configure connect-time failover

Control the Oracle Net Listener

Test Oracle Net connectivity

Identify when to use shared versus dedicated servers

 

Backup and Recovery Concepts

Identify the types of failure that may occur in an Oracle Database

Describe ways to tune instance recovery

Identify the importance of checkpoints, redo log files, and archived log files

Configure ARCHIVELOG mode

 

Performing Database Backups

Create consistent database backups

Back your database up without shutting it down

Create incremental backups

Automate database backups

Monitor the flash recovery area

 

Performing Database Recovery

Recover from loss of a control file

Recover from loss of a redo log file

Perform complete recovery following the loss of a data file

 

Performing Flashback

Describe Flashback database

Restore the table content to a specific point in the past with Flashback Table

Recover from a dropped table

View the contents of the database as of any single point in time with Flashback Query

See versions of a row over time with Flashback Versions Query

View the transaction history of a row with Flashback Transaction Query

Use Data Pump Export and Import to move data between Oracle databases

Use external tables to move data via platform-independent files

 

Proactive Maintenance

Use statistics

Manage the Automatic Workload Repository (AWR)

Active Session History reports (ASH)

Use the Automatic Database Diagnostic Monitor (ADDM)

 

Performance Management

Use Enterprise Manager pages to monitor performance

Use performance related dynamic views

Troubleshoot invalid or unusable objects

 

Configuring Recovery Manager

Using a Flash Recovery Area with RMAN

Setting Parameters for RMAN

Starting RMAN

Configuring Persistent Settings for RMAN

Control File Autobackups

Retention Policies

 

Using Recovery Manager

Issuing Recovery Manager Commands

Parallelization of Backup Sets

Compressed Backups

Copying the Whole Database

Making Incremental Backups

Block Change Tracking

Incrementally Updating Backups

Monitoring RMAN Backups

 

Diagnostic Sources

The Alert Log

Viewing Alerts with EM

Alerts Notification

Editing Thresholds

Trace Files

 

Recovering from non-critical losses

Creating New Temporary Tablespace

Recreating Redo Log Files

Recovering an Index Tablespace

Read-Only Tablespace Recovery

Loss of Password Authentication File

 

Database Recovery

Recovery Steps

User-Managed Recovery Procedures: RECOVER Command

Types of incomplete recovery

Incomplete Recovery Best Practices

Recovery Using EM

Simple Recovery through RESETLOGS

Point-in-time recovery using RMAN

 

Flashback database

When to Use Flashback Technology

Configuring Flashback Database

Monitoring Flashback Database

Best Practices for the Database and Flash Recovery Area

Flash Recovery Area Space Usage

Flashback Database Examples

 

 

 

Dealing with Database Corruption

What is block corruption?

Interpreting DBVERIFY

The ANALYZE command

How to Handle Corruptions

The DBMS_REPAIR Package

Block Media Recovery (BMR)

Detecting Database Corruptions Using DBVERIFY

Using RMAN to Repair Corrupt Blocks

 

Monitoring and Managing Storage

Redo Logfile Size Advisor

Resumable Statements

Tablespace Space Usage Monitoring

Accessing the Segment Advisor

Shrinking Segments Using SQL

Segment Resource Estimation

Monitoring Index Space

Identifying Unused Indexes

 

 

Automatic Storage Management( Only theory)

ASM Concepts

ASM General Architecture

Creating an ASM instance

Creating tablespaces that use ASM storage

Viewing ASM information

Migrating a tablespace to use ASM storage

 

Database Refresh/ Database cloning

 

 

 

 

 

High Availability

 

Data Guard

 

Overview of Data Guard

Configuring Data Guard with Real-time apply

 

Upgrade from Oracle 9i Release 2 to Oracle10g Release 2 to Oracle 11g Release 2

 

11g New Features

 

 

 

If anyone interested please mail me on  satish@o2education.com or call me on  +91 9989990935

Hello Folks,

We are offering OBIEE online training by the industry experts at affordable price at trainee’s convenient time.

Here is my content :

OBIEE

OBIEE Developer’s Training
This course enables delegates to gain a foundational understanding of:
Business intelligence (BI) terms and concepts
Oracle BI user interfaces
Oracle BI architecture
Oracle BI repository
Oracle BI Administration Tool
Prebuilt components in Oracle BI Applications
Day 1
• Oracle BI Enterprise Edition Concepts
• Exploring Oracle BI Enterprise Edition User Interfaces
• Oracle BI Enterprise Edition Architecture
• Oracle BI Applications Concepts
Day 2
• Repository Basics
• Layer of a Repository
• Building the Physical Layer of a Repository
• Building the Business Model and Mapping Layer
• Building the Presentation Layer of a Repository
• Testing and Validating a Repository
Day 3
• Working with Oracle Business Intelligence Answers
• Building Views and Charts in Requests
• Different Views:
[1] Table View
[1] Compound View
[1] No result View
www.o2education.com
[1] Narrative View
[1] Pivot View
[1] Column selector View
[1] View selector
• Filtering Requests in Oracle Business Intelligence Answers
[1] Combined Filter
[1] Group Filter
[1] Filter Based on other Request
[1] Dynamic filter using variable
[1] Dynamic filter using Dashboard
• Creating Interactive Dashboards
• Configuring Interactive Dashboards
Day 4
• Save Dashboard Selection
• Configuring Guided Navigation Links
• RPD – Adding Multiple Logical Table Sources
• RPD – Adding Calculations to a Fact
• RPD – Creating Dimension Hierarchies
• RPD – Level-Based Measures
• RPD – Using Aggregates
Day 5
• RPD – Using Repository Variables
• RPD – Cache Management
• RPD – Using Administration Tool Utilities
• Security Setup and Features
Day 6
• Customizing and Administrating he Oracle Business
Intelligence User Interface
• Multi-User Development
• Using Oracle Business Intelligence Delivers

 

 

If anyone interested please mail me on  satish@o2education.com or call me on  +91 9989990935