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 |
|
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 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