ITP1

Oracle data types, DDL, DML, DCL, TCL

ITP2

Tables, constraints

ITP3

Query Processing using operators and Buit in function

ITP4

Managing vies, synonyms, sequences and object privileges

ITP5

Table Partitioning

ITP6

Intro To PL/SQL, Cursor etc

ITP7

Creating and managing Procedures, Functions and Packages

ITP8

Creating and Managing Indexes

ITP9

Creating and managing DML Triggers on tables, Instead of triggers on views

Bi1

Materialized Views and Dimension

Bi2

Relational and dimensional Design using ERWIN

Bi3

Informatica PowerCenter 7 Designer, Workflow Manager and Workflow Monitor

Bi4

Informatica Power Center 7 Level 1 Developer
Data Integration Concepts : PowerCenter Components and User Interface : Source Qualifier, Workflow Scheduler, Reusable Transformations, Debugger, Detail Review of the Expression, Filter, Sorter , Aggregator, Joiner, Lookup, Update Strategy, Router and Sequence Generator Transformations. Source and Target Overrides, Parameters and Variables; Self-Join; Incremental Aggregation; Dynamic Lookup Cache; Mapplets; Workflow Configuration and Techniques; Reusable Schedule for a Workflows; Session Configuration; Task and Worklets;

Bi5

Informatica PowerCenter 7 Level 11 Developer
Advance Mapping Techniques; Advance Workflow Techniques; Error Handling; Performance Tuning; Stored Procedures and Custom Transformations; Repository Reporting; Partitions

PM1

Software Project Management Strategies & Project Management Life Cycle

PM2

Software Estimation and Function Point Analysis

PM3

Software Inspections and Defect Management

PM4

LIVE PILOT PROJECT

About Cognos 8

Cognos 8 Business Intelligence (BI) offers a single, strong BI reporting and analysis product for support of analytic and enterprise reporting. The product is strong in all three areas — analytic functionality, application development, and usability with comprehensive support for unification, internationalization, and open APIs, and strong support for OLAP, query, metadata, dashboards, and scorecards. Cognos is one of a growing number of vendors — including Actuate, Business Objects, Hyperion, Microsoft, and MicroStrategy — that offer both analytic and enterprise reporting capabilities. However, Cognos 8 BI is a completely new, Web-based product that incorporates much of the functionality from Cognos legacy BI products such as PowerPlay, Metrics Manager, Impromptu, ReportNet, and others. Cognos is a leader in both analytic and enterprise reporting.

Day 1

Overview of Data warehousing  & Cognos 8 BI
Overview of Data warehousing
Dimensional Modeling
Introduction to Cognos
Examine the different studios in Cognos 8 BI
BI Architecture

Day 2

Framework Manager

Data Sources and metadata modeling
Data Modeling and relational & dimensional data
Types of Relationship in FM
Star Schema Grouping

Day 3

Framework Manager- - Continued

Creating Query Subjects/Query Items/Namespace/Filters/Folder
Properties of Query Items – Usage Property/Aggregate Property
Creating NameSpace/Project, Model and Package.
Publishing Package and Exploring Package

Day 4

Cognos Connection – Web Portal

Overview of Cognos Connection
Define Report/Run Report
Schedule Single/Multiple Report
View  Report/Run History of a Report/Report Output Version
Distribute a Report
Create Report Views/Set Preferences
Organize Content in Cognos Connection
Searching Entries in Cognos Connection

Day 5

Query Studio

Examine Query Studio
Create Reports – Lists, Grouped List, Crosstab, Charts.
Sorting, Grouping, Filter
Add Calculated/Summarized Data
Conditional Formatting/Advanced Filters
Format a Report

Day 6

Report Studio

Examine Report Studio
Studio Interface with templates
Types and formats of reports
Explorer Bar/Properties Pane and Variables
Examine the Report Specification
Layout Components/Query Components
Query Model/Tabular Sql