Oracle Business Intelligence

Manual Testing concepts:

-----------

1. SQA

 1.2 SQC

  a. Introduction

    a.1 BRS

    a.2 SRS

    a.3 Review

    a.4 HLD

    a.5 LLD

    a.6 Protype

    a.7 Build

    a.8 Kick off meeting

    a.9 verification

    a.9 Validation

2. Software Environment

  a. Test setup

  b. test bed

  c. 1-tier

  d. 2- tier

  e. 3-tier

  f. N-tier

3. SDLC models

  a. SDLC

  b. Waterfall model

  c. V model

  d. protype model

  e. Spiral model

  f. Agile model (With real time examples and explanations)

4. Test design techniques

  a. Blackbox testing

    i. Equivalance partiioning

    ii. Boundary value Analysis

    iii. Decision table testing

    iv.State transition testing

    v. use case testing

  b. Whitebox testing

    i. Statement testing and coverage

    ii. decision testing

    iii. other structure based techniques

    iv. condition coverage

    v. multi condition coverage

  c. Grey box testing

  d. Experience based testing

    i. Error guessing

    ii. Exploratory testing

5. Test levels

  a. Unit testing

  b. Integration testing

  c. System testing

  d. Acceptance testing

6. STLC and Bug life cycle

7. Test Documentation

  a. Test Plan

  b. Test Strategy

  c. Test Approach

  d. Test Scenarios

  e. Test Case template\

  f. Bug Report

  g. Test metrics

  h. Test Summary Document

--------------------------------------------

1. SQA

 1.2 SQC

  a. Introduction

    a.1 BRS

    a.2 SRS

    a.3 Review

    a.4 HLD

    a.5 LLD

    a.6 Protype

    a.7 Build

    a.8 Kick off meeting

    a.9 verification

    a.9 Validation

2. Software Environment

  a. Test setup

  b. test bed

  c. 1-tier

  d. 2- tier

  e. 3-tier

  f. N-tier

3. SDLC models

  a. SDLC

  b. Waterfall model

  c. V model

  d. protype model

  e. Spiral model

  f. Agile model (With real time examples and explanations)

4. Test design techniques

  a. Blackbox testing

    i. Equivalance partiioning

    ii. Boundary value Analysis

    iii. Decision table testing

    iv.State transition testing

    v. use case testing

  b. Whitebox testing

    i. Statement testing and coverage

    ii. decision testing

    iii. other structure based techniques

    iv. condition coverage

    v. multi condition coverage

  c. Grey box testing

  d. Experience based testing

    i. Error guessing

    ii. Exploratory testing

5. Test levels

  a. Unit testing

  b. Integration testing

  c. System testing

  d. Acceptance testing

6. STLC and Bug life cycle

7. Test Documentation

  a. Test Plan

  b. Test Strategy

  c. Test Approach

  d. Test Scenarios

  e. Test Case template\

  f. Bug Report

  g. Test metrics

  h. Test Summary Document

Testing Fundamentals

What is Automation testing?

  • Benefits of Automation testing?
  • What type of Test cases can automate?
  • What type of test cases not to automate?
  • Automation life cycle
  • Different types of Automation tools
  • Difference between QTP & Selenium

Introduction to Selenium

  • History of selenium
  • What is selenium?
  • Components of selenium

Locator identification

  • What is element property?
  • Different ways to recognize element properties
  • What is firebug and firepath?
  • How to recognize element in chrome & I.E Browsers?

Webdriver Introduction

  • Why webdriver?
  • Downloading Webdriver Jars and configuration in Eclipse
  • First Program in Webdriver
  • Opening different browsers.

Element Identification methods

  • findElement()
  • findElements()
  • diffrence between findElement() & FindElements()

Handling Links

  • How to recognize link in the webpage?
  • How to perform operation using links
  • retrieve list of the links in the page
  • retrieve specific links in the webpage
  • checking link is displaying or not

Handling checkBoxes/RadioButtons

  • How to check/uncheck checkBoxes/RadioButtons
  • Retrieve number of checkboxes/RadioButtons in the webpage
  • Retrieve specific checkboxes/RadioButtons in the webpage.
  • Verifying checkbox/Radio button is selected or Not?

Handling dropdown list

  • What is dropdown list?
  • types of dropdown list
  • About Select Class.
  • select class Methods
  • different ways to select/unselect a option in the dropdown list
  • selecting a option Randomly in the dropdown list

Handling Alerts

  • What is Alert?
  • about Alert interface
  • different methods in Alerts
  • .alert ()
  • .getText ()
  • .sendKeys ()
  • .accept ()
  • . dismiss()
  • How to handle alerts in real time

Handling Windows (Multiple WebPages)/popups

  • Methods to identify webpages

a)getWindowHandle()

b)getWindowHandles()

  • How to navigate from one Page to another Page.
  • How to close multiple windows one after another.
  • Difference between close () & quit ().

Handling Frames

  • what is Frame?
  • How to Identify Frame in the webPage
  • How to check element is Present in the Frame Or not
  • How to move your focus from Page/Frame to Frame
  • How to come back to the main state/page/frame.

Handling WebTables

  • What is webTable?
  • How to Identify Table, rows, columns, cells
  • finding no of rows in the Table
  • Finding no of columns in the Table.
  • retrieving records based on records
  • Retrieving records based on cell by cell.
  • retrieving specific records
  • Retrieving records based on column.

Actions

  • what is Action?
  • when to use Action class?
  • Operations performing using Action class

                                 a)mouseOver

  b)rightclick

                                c)drag & drop

                                d)Keyboard actions

                                 e)move to Element

Wait statements

  • why we need to use Wait statements?
  • different types of Wait statements
  • what is Implicit wait
  • what is Explicit wait statement.
  • difference between Thread.sleep() & waitStatements.

Capturing Screenshot

e.JavaScript Executor.

Framework

  • What is Framework?
  • Different types of Frameworks?

A.data-driven

B.Keyword-driven

C.Modular driven

D.Page Object Model

POM with Pagefacory

  • What is POM?
  • What is Pagefacory?
  • How to implement page using pagectory.
  • Implimenting sample Testcases with POM with Pagefactory.

TestNG Framework

  • what is TestNg
  • Installing TestNg in Eclipse
  • TestNg annotations
  • Understanding usage of annotations
  • Running a Test in TestNg
  • parameterizing Tests - DataProvider
  • TestNg Reports
  • Using TestNg in Selenium
  • Grouping test cases
  • Setting priority of execution for test cases
  • Putting Dataproviders for multiple tests in a single file

Selenium IDE

  • Configuring selenium IDE
  • Record & Play sample testcase
  • Selenium commands
  • Difference between Verification & Assertion.
  • Disadvantages of Selenium IDE

Java Concepts

  • Java Introduction
  • Installing Java
  • Installing Eclipse
  • Features of Java
  • Why Java for Selenium
  • First Eclipse Project
  • First Java program
  • Concept of class file
  • Platform independence
  • Datatypes in Java
  • String class
  • If statements

Loops, Arrays and Functions Conditional and concatenation operators

  • While Loop
  • For Loops
  • Practical Examples with loops
  • Usage of loops in Selenium
  • Single Dimensional Arrays
  • Two Dimensional arrays
  • Practical usage of arrays in Selenium
  • Drawbacks of arrays
  • What are Functions?
  • Function Input Parameters
  • Function Return Types

Object Oriented Programming- 1

  • Local Variables
  • Global Variables
  • Static and Non-Static Variables
  • Static and Non-Static Functions
  • Creating Objects in Java
  • Meaning of static
  • Why is main method static?
  • Constructors
  • Usage of Objects in Selenium

Object Oriented Programming -2

  • Concept of Inheritance
  • Interface
  • Overloadings and Overriding Funtions
  • Example on inheritance
  • Object Class
  • Usage of Inheritance in Selenium
  • Packages,Access Modifiers/ Exception Handling
  • Relevance of Packages
  • Creating Packages
  • Accessing Classes Across Packages
  • Good Features of eclipse
  • Accessing modifiers - Public, Private, Default, Protected
  • Exception handling with try catch block
  • Importance of exception handling
  • Exception and Error
  • Different Types of Exceptions
  • Need of exception handling in Selenium framework

---------------------------------

 
Datawarehousing Concepts
  • Introduction and Definition
  • Sources, Transformations and Targets( Architecture )
  • Data Extraction, Data Transformations and
    Data Loading( Data Acquisition Process )
  • Data Warehousing Approaches
  • Staging Area, Metadata, Repository and Data Mart
  • Differences between OLTP and OLAP( DSS ) Systems
  • Operational Data Store( ODS )
  • Business Intelligence
  • Star Schema Design & Confirmed Dimension,
    Fact less Fact Table, Types of Facts
  • Slowly Changing Dimensions( SCD )
OBI Overview
New Features of OBI
OBI Architecture
  • Clients
  • OBI Presentation Services
  • OBI Server
  • OBI Repository (.rpd)
  • Data Sources
OBI Components
  • OBI Administration Tool
  • OBI Answers
  • Intelligence dashboards
Repository Basics
  • Oracle Business Analysis Warehouse
  • DAC and Informatica Server
  • Informatica Server ETL
  • Sample Request Processing
  • Using the OracleBI Administration Tool
  • Repository Directory
  • Repository Files ( Initialization files and log files)
  • Loading a repository into Oracle BI Server memory
  • Creating a repository
  • Connection Pool
  • Repository Modes ( ONLINE and OFFLINE )
  • Physical Layer
  • Business Model & Mapping Layer
  • Presentation Layer
  • Presentation Catalogs, Folders and Columns
  • Error Messages
Building the Physical Layer of a Repository
  • Defining an ODBC System DSN
  • Setting up connection pool properties
  • Importing data sources ( Physical Schema )
  • Verifying the import
  • Defining physical keys and joins
  • Creating alias and select tables
Building the Business Model and Mapping Layer of a Repository
  • Creating the logical business model
  • Creating the logical tables, columns, and sources
  • Defining logical joins
  • Adding Calculation to a Fact Table
  • Building measures
Building the Presentation Layer of a Repository
  • Creating a new Presentation Catalog
  • Modifying Presentation layer objects
  • Rename tables
  • Reorder Table
Testing and Validating a Repository
  • Checking repository consistency
  • Defining a repository in the initialization file
  • Testing a repository using Oracle BI Answers
 
 
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 us ing the Calculation Wizard
Creating Dimension Hierarchies and Level-Based Measures
  • Creating dimension hierarchies
  • Creating level-based measures

Creating & Using Aggregates

  • Purpose of aggregate tables in dimensional modeling
  • Modeling aggregate tables to improve query performance
  • Testing aggregate navigation

Using Initialization Blocks Repository Variables

Creating Dynamic Repository Variables

Execute Direct Database Requests

  • Accessing database directly

Creating Time series Measures

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

Providing Security for Groups & Users

 

Answers (REPORTS):-

 

Working with Oracle Business Intelligence Answers

 
  • Introduction to Oracle BI Answers
  • Working with requests in Oracle BI Answers
  • Using advanced formatting
  • Creating report Level Hierarchy

Filtering Requests in Oracle Business Intelligence Answers

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

Building Views and Charts in Requests

  • Introduction to Answers views and charts
  • Creating and editing charts
  • Performing common view tasks
  • Creating a Narrative View
  • Creating a column Selector
  • Creating View Selector

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
  • Adding Objects to Dashboard
  • Creating Dashboard prompts
  • Embedding content in an Interactive Dashboard