Hbase- Overview

HBase -- Installation and Shell

HBase -- Java Client API

HBase -- Java Admin API

HBase - Java Client API Advanced Topics

Map-Reduce on YARN

Developing First MapReduce Job

Job Execution on YARN

Hadoop Streaming

MapReduce Workflows

Introduction To Dataware Housing

• Introduction to Dataware Housing

• Characteristics of Dataware Housing

• OLTP Vs OLAP Databases

• Different Approaches of DWH (Kimball Vs Inmon)

• Data mart Vs Data Warehouse

• Fact Table Vs Dimension Table

• Concepts of Schemas (Star schema & Snowflake schema)

• Industry leading ETL and Reporting tools

Introduction to Cognos

• About Cognos 8.4

Tier Architecture

• Cognos Release (EP series7, Reportnet , Cognos 8.0/8,1/8.2/8.3)

• Features of Cognos 8.4

• Cognos Vs other OLAP tools

• Cognos components (Modeling & Reporting)

• Different cognos services

Cognos Connections

• Personalize cognos connection • Create and manage portals, shortcuts, report views.etc

• Working with Cognos configuration, content Store

• How to Connect to different Data Sources

• Security setup

• Import and Export of Package (Deployment)

• Running the Report Burn

• Scheduling Reports

Framework Manager 

• About Framework Manager

• Framework Manager, Metadata Modeling

• Creation of Interface and Usage

• Creating Model & Namespace (Layers)

• Importing Metadata

• Naming convention for objects in a project

• Creating Query Subjects & Query Items

• Merging Query Subjects

• Creating Relationships & Setting Cardinalities

• Creating Parameter Maps & Macros

• Creating of Model Filters, Prompts & Calculations

• Add Business Rules and Set Governors

• Assigning package level security

• Improving performance

• Publishing Package

Query Studio

• Introduction

• About Ad-hoc Reports

• Types of Report(List, Cross Tab, Chart Reports & Others)

• Applying Filters, Prompts & Calculations

• Sorting, Grouping, Sections & Aggregate Functions

• Run and Manage reports

Report Studio 

• Type of Report Templates

• Creating list, Cross Tab, Chart, repeater, Maps & Other Reports

• Report templates, formatting Reports – fonts, style, header, footer, boarder…etc

• Generating and Creating Prompt Page

• Types of Prompts

• Query Calculations & Layout Calculations

• Static Filters and Dynamic Filters

• Conditional Block

• Conditional Formatting

• Master Details

• Cascading Prompt

• HTML Items & Hyperlinks

• Set Operators

• Setting Burst Options

• Drill through

• Drill up & Drill down

• Setting Variables

• Report Functions

• Report Validation

• Reports Run with Options (separate course not included in this package)

Analysis Studio

• Insert Data

• Change the number of Visible Items

• Nest Data

• Replace Data

• Sort Data

• Explore Data

• Change the measure

• Drill down for Details

• Hide Items

• Insert a calculation

• Save a custom set

• Define a filter

• Compare sets of data

• Using Dynamic Context

Event Studio 

• Creating Agents

• Adding Event conditions

• Task and Task execution rules

• Scheduling Agents

DatawareHouse and ETL Concepts

DatawareHouse (ETL) Testing Process

DatawareHouse (ETL) Test Preparation

DatawareHouse (ETL) Test Execution and Results and Report

Java - Overview

Environment Setup

Basic Syntax

Object & Classes

Basic Datatypes

Variable Types

Modifier Types

Basic Operators

Loop Control

Strings

Arrays

Regular Expressions

Methods

Files and I/O

Exceptions

Java Object Oriented

Inheritance

Overriding

Polymorphism

Abstraction

Encapsulation

Interfaces

Packages

Java Advanced

Data Structures

Collections

Generics

Serialization

Networking

Sending Email

Multithreading

Applet Basics