Software Courses

Course Name : Informatica online training

Course Duration : 30 Hours

INFORMATICA

DATAWAREHOUSING CONCEPTS:

INTRODUCTION TO DATAWAREHOUSING



Data Warehousing Concepts



Dataware housing (what/Why/How)



Data Modelling(Schemas, FACTS and DIMENSIONS)



Slowly Changing Dimensions



Metadata

PowerCenter Components and User Interface



PowerCenter Architecture



PowerCenter Client Tools



Lab – Using the Designer and Workflow Manager

Source Qualifier



Source Qualifier Transformation



Lab Project Overview



Lab A - Load Payment Staging Table



Source qualifier Joins



Lab B - Load Product Staging Table



Source Pipelines



Lab C - Load Dealership and Promotions Staging Table and Real time issues

Expression, Filter, File Lists and Workflow Scheduler



Expression Editor



Filter Transformation



File Lists



Workflow Scheduler



Lab - Load the Customer Staging Table and Real time issues

Joins, Features and Techniques I



Joiner Transformation



Shortcuts



Lab A - Load Sales Transaction Staging Table



Lab B - Features and Techniques I and Real time issues

Lookups and Reusable Transformations



Lookup Transformation



Reusable Transformations



Lab A - Load Employee Staging Table



Lab B - Load Date Staging Table and Real time issues



Debugger



Debugging Mappings



Lab - Using the Debugger

Sequence Generator



Sequence Generator Transformation



Lab - Load Date Dimension Table and Real time issues



Lookup Caching, More Features and Techniques



Lookup Caching



Lab A - Load Promotions Dimension Table



Lab B - Features and Techniques II



Review and more Lab Activities and Real time issues

Router, update Strategy and Overrides



Router Transformation



Update Strategy Transformation



Expression Default Values



Source Qualifier Override



Target Override



Session Task Mapping Overrides



Lab - Load Employee Dimension Table and Real time issues

Dynamic Lookup and Error Logging



Dynamic Lookup



Lab - Load Customer Dimension Table



Unconnected Lookup, Parameters and Variables



Unconnected Lookup Transformation



System Variables



Mapping Parameters and Variables



Lab - Load Sales Fact Table



Sorter, Aggregator and Self-Join



Sorter Transformation



Aggregator Transformation



Active and Passive Transformations



Data Concatenation



Self-Join



Lab - Reload the Employee Staging Table and Real time issues

SCD type1 - LAB

SCD type2 - LAB

SCD type3 - LAB Mapplets



Mapplets



Lab - Load Product Daily Aggregate Table



Review and more Lab Activities and Real time issues

Workflow Variables and Tasks



Link Conditions



Workflow Variables



Assignment Task



Decision Task



Email Task



Lab - Load Product Weekly Aggregate Table

More Tasks and Reusability



Event Raise Task



Event Wait Task



Command Task



Reusable Tasks



Reusable Session Task



Reusable Session Configuration

Worklets and More Tasks



Worklets



Timer Task



Control Task



Lab - Load Inventory Fact Table

More about Informatica Online Training :

About Informatica Trainer :

Informatica Online Training batch information:

What is OBIEE:

Oracle Business Intelligence Enterprise Edition(Oracle BI EE) is a comprehensive set of enterprise business intelligence tools and infrastructure, including a scalable and efficient query and analysis server, an ad-hoc query and analysis tool, interactive dashboards, proactive intelligence and alerts, real-time predictive intelligence, and an enterprise reporting engine. Oracle Business Intelligence is designed to bring greater business visibility and insight to a wide variety of users.

Oracle BI Enterprise Edition (sometimes simply referred to as Oracle Business Intelligence) provides a full range of business intelligence capabilities that allow you to:



Collect up-to-date data from your organization



Present the data in easy-to-understand formats (such as tables and graphs)



Deliver data in a timely fashion to the employees in your organization

These capabilities enable your organization to make better decisions, take informed actions, and implement more-efficient business processes.

Course Name : OBIEE online training

Course Duration : 30 Hours

OBIEE

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)



Informatica Server ETLLoading 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



Message Severity



Viewing Server Logs

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



Adding Multiple Logical Table Sources



Adding multiple logical table sources to a logical table



Specifying logical content

ADDING MULTIPLE LOGICAL TABLE SOURCES



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

CREATING DIMENSION HIERARCHIES AND LEVEL-BASED MEASURES



Creating dimension hierarchies



Creating level-based measures

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



Introduction to Answers views and charts



Creating and editing charts



Performing common view tasks



Creating a Narrative View



Creating a column 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

More about OBIEE Online Training :

About OBIEE Trainer :

OBIEE Online Training batch information:

Course Name : Cognos online training Course Duration : 30 Hours

COGNOS

INTRODUCTION TO DATAWARE HOUSING (DWH)



Introduction to DWH



Characteristics of DWH



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



3 – Tier Architecture



Cognos Release (EP series7, Reportnet , Cognos 8.0/8,1/8.2/8.3) and their differences



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



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



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

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

About Cognos Trainer :

Cognos Online Training batch information:

Course Name : Teradata online training

Course Duration : 30 Hours

TERADATA V13

WHAT IS TERADATA WHY FOR IT IS WHAT FOR IT IS



What is Teradata?



Teradatav12 & versions



Teradata History



Teradata users scalability



Teradata &other RDBMS



Teradata warehouse



Teradata in the Enterprise



Interview Q&A and Certification queries



Real time Issues & resolving

TERADATA ARCHITECTURE & IT’S COMPONENTS



Node Architecture(Shared Architecture)



SMP Architecture



MPP Architecture



Parsing engine(PE) Architecture



AMP Architecture &uses



Bynet Benefits &types



Parallel data extension(PDE)



Teradata directory program(TDP)



Call level interface(CLI)



Virtual processors



Bynet 0 &Bynet 1



Parallism Architecture

RECOVERY &PROTECTION OF DATA



What is fall back &where it used



Why for fall back



What is Clique



AMP Clustering



& types for simultaneous Access



Why for locks &how to release



RAID 1 &RAID 5



Journals &types



Virtual Disk Array



How & where is used journals



Q & A about data recovery

TERADATA INDEXES



Types of indexes in Teradata



Hash index



Join index



Primary index(unique, non- unique)



Secondary index(unique, non- unique)



Skewness



Keys & indexes (How & why these used)

HOW TO STORAGE & RETRIEVAL OF DATA



Hash algorithm



hash



Hash map



Hash bucket



Receiving VDisc TERADATA SQL QUARRYMAN



SQL fundamentals



Data types and literals



DDL Statements



DML Statements



Teradata naming conversing

TERADATA SQL QUARRYMAN



SQL fundamentals



Data types and literals



DDL Statements



DML Statements



Teradata naming conversing

TERADATA SQL FUNCTIONS & OPERATIONS



String functions



Format functions



Cast functions



Cast functions



Group & Aggregation functions



Logical operations



Arithmetic operations



set operations



join operations



conditional expressions

TERADATA JOIN STRATEGIES & UNIONS



hash join



merge join



nested join



product join



inner join



full outer join

TERADATA BASIC COMMANDS



Help



Show



Explain



Collect statistics TERADATA OBJECTS



Types of tables

o

Set tables

o

Multi tables

o

Volatile tables



Global temporary tables



Derived tables



Views



Macros



Stored procedures



Triggers



TERADATA MEMORY SPACES



Permanent spaces



Temporary spaces



Spool spaces



Users spaces & PWD

TERADATA MEMORY SPACES



Permanent spaces



Temporary spaces



Spool spaces



Users spaces & PWD

TERADATA TRANSACTION MODES



Batch mode



ANSI mode



How Converted into others

TERADATA PERFORMANCE TUNING ON SQL ASSISTANCE



Usage of PMON



Explain usage



Collecting statistics



SQL tuning



Various SQL statements



Real time Issues & resolving

TERADATA UTILITIES & TOOLS (IMPORT & EXPORT)



Teradata BTeq scripts

o

Overview of BTeq

o

Looping stages

o

Batches scripts

o

Import &export scripts with Examples

o

Error handling

o

Real time scripts



Teradata FastLoad

o

Types of phages & how to find it

o

Advantages & its process

o

Limitations of fast load

o

Real time scripts



Teradata MultiLoad

o

Overview of Multi load

o

Types of phages in MultiLoad

o

Advantages & its process

o

Limitations of MultiLoad

o

Uses various types of operations

o

Real time scripts

o

Sample scripts



Teradata Tpump

o

Overview of Tpump

o

Limitations of Tpump

o

Work on Multi tables

o

Real time scripts

o

Sample scripts



Teradata Fast Export

o

How to export the data

o

Passing parameters

o

IN/OUT Modes

o

Work on Multi tables

o

Real time scripts

o

Sample scripts



Teradata SQL Assistant(Quarryman)



Teradata performance monitor



Teradata Administrator usage



Teradata performance tuning on scripts

KEY SERVICE



FAQS



Covering DBA concepts



Concentration on performance tuning



Real time scenarios



Certification guidance



Resume preparation



Sample resumes



Interview & certification FAQS



How to face the interview



Class notes which is useful for who is trying for job



Project preparation

Course Name : Business Objects online training

Course Duration : 50 Hours

BO XI

DATA WAREHOUSING/DIMENSIONAL MODELING PRACTICAL

CONCEPTS



OLTP vs. OLAP



Types of OLAP



Dimensional modeling



Data mart/Data warehouse Life cycle



Star/Snow/Extended Star schema design

DATABASE CONCEPTS NEEDED FOR DATA WAREHOUSING



Joins & Cardinality



Views/Materialized Views



Date/Time Functions



Conversion functions



Derived table & Stored Procedure

ARCHITECTURAL OVERVIEW



Client tier components



Application tier components



Intelligence tier



Processing tier



Data tier



Security management



Information flow UNIVERSE DESIGN



Understanding Business Objects Universes



Creating the Course Universe



Building the Universe Structure



Creating Dimension Objects



Creating Measure Objects



Resolving Loops in a Universe



Resolving SQL Traps



Using List of Values



Applying Restrictions on Objects



Using @Functions with Objects



Using Hierarchies



Deriving Tables & Indexes



Working with Aggregate Awareness



Designing Advanced Objects



Creating Predefined Condition



LOVs & Joins



Securing Universes



Implementing Universe Life Cycle Mgmt



Maintaining & Optimizing Universes



Creating Universe from Other Data sources

WEB INTELLIGENCE



Understand concepts of Web intelligence



Create Web Intelligence documents with Queries



Restrict data returned by a query



Design a report



Enhance the presentation of data in reports



Format a report



Use multiple data sources



Analyze data



Manage and share Web Intelligence documents



Work with Advanced Query techniques



Work with calculation contexts



Create formulas with character & date string functions



Use "If" logic



Work with additional reporting techniques



Create hyperlinks

CRYSTAL REPORTS



Planning a Report



Selecting Records



Formatting a Report



Representing Data Visually



Distributing Reports



Creating Basic Formulas



Organizing Data on a Report



Applying Section Formatting



Applying Conditional Reporting



Using the Repository



Using Report Templates



Creating Formulas



Building Parameterized Reports



Summarizing Data with Cross-Tabs



Using Report Sections



Managing Reports



Presenting Data Visually



Add hyperlinks to a report



Understanding Dashboard Manager



Setting Up Dashboard Manager



Creating Metrics



Automating Dashboards with Rules



Creating Analytics



Creating Personal Dashboards



Creating Corporate Dashboards



Guiding Dashboard Navigation

MIGRATION TO BOXIR3

MIGRATION FUNDAMENTALS



How Business Objects Enterprise XI 3.0



Migration concepts



Import Wizard Concepts



Understanding object migration



Understanding user and group migration



Migration planning and assessment



After migration with the Import Wizard

ADMINISTRATION



Understand the Business Objects



Enterprise interface & architecture



Manage Business Objects Enterprise content



Secure Business Objects Enterprise content



Secure application security



Schedule content



Publish reports



Identify Business Objects Enterprise architecture



Perform common server management tasks



Manage the Business Objects Enterprise servers

WIDGETS



Using BI Widgets to Access BI Content



working with widgets



BI Widgets Content Authoring Guidelines



Auto refresh of Widgets

DESKTOP INTELLIGENCE



Introduction to desktop intelligence



Scope of analysis



Report creation



saving the reports in local repository



publishing the report



Report conversion (desktop) to (Webi)

WEBI-RICH CLIENT



Installing Web Intelligence Rich Client



Web Intelligence Rich Client working modes



Launching Web Intelligence Rich Client



To set user preferences in Web Intelligence Rich Client



Working with documents



Working with universes in Web Intelligence Rich Client



Accessing Web Intelligence from Info View



Working with queries in Web Intelligence Rich Client



Working with reports

UNIVERSE BUILDER & QUERY BUILDER



Universe Builder basics



Building universes from XML metadata sources



Updating XML metadata source universes



Exporting a universe to a XML file format

QUERY AS WEB SERVICE



Configuring the QWS with BO System



Creating Webservice report from Universes



Creating WSDL reports



Using WSDL reports in external application

VOYAGER



Getting Started with Business Objects Voyager



Using Queries to Analyze Cube Data



Using Charts to Visualize Data



Selecting Members to Display in Crosstabs and Charts



Sorting, Filtering, and Ranking Data



Highlighting Exceptions in Data



Saving and Sharing Voyager Workspaces

SECURITY IMPLEMENTATION



Creating Secured users & group



Creation secured connections



Creation of Secured objects



Creation of security at Table, Column &row level



Creation of secured restriction set and mapping to users or groups

IMPORT WIZARD\PUBLISHING WIZARD



Using Import wizard



Creation of BIAR



Migrating the BO objects



From one CMS TO ANOTHER CMS



Migrating the objects from one



domain to another (dev/stage/Prod)



Backup & Maintenance Deployment

BUSINESS VIEW MANAGER



Creation of Semantic layer for Crystal reports



Creation of Dynamic list of values in Crystal reports



Creation of Cascading list of values in Crystal reports



Creating Data connection and Dynamic data connection



Creation of Data foundation



Creation of Business View



Creation of LOV



Saving the Business view to repository



Accessing the Business View in Crystal reports using Database expert



Creation of Crystal reports using Business

LIVE OFFICE REPORTING



Describe the benefits of using Live Office



Connect to the repository



Navigate the Live Office menu



Insert charts, crosstabs, and fields from a Crystal report



Insert report parts from a Web Intelligence document



Insert a new query based on a Universe



Insert Live Office objects into an email



Navigate and refresh Live Office objects



Enable consolidated prompts



Set refresh settings for objects



Set parameter binding



Take a snapshot



Save Live Office documents to the repository



Open and view Live Office documents from the repository

SAP WEBI/DASHBOARD REPORTING:



Creation of Web intelligence reports using Info cube & BW Query

NTRODUCTION TO BO-SDK



Introduction of BO Enterprise SDK



Choosing the right SDK



Customizing the Webi reports using SDK

INTRODUCTION TO BO EXTENSION POINTS

HOW TO USE & LEVERAGE BO EXTENSION POINTS IN BUSINESS OBJECTS



Comparison of all BO Versions (5.x/6.5/XIR1/XIR2/XIR3)



Installation of BOXIR3 suite with System/Audit/Performance mgmt repositories



Using Oracle/SQLSERVER/SAPBW



Testing & Migration of BO components from Dev/Stage/Production environment

BO XI R3 CERTIFICATION GUIDELINES:



Sample questions on Business Objects Certified Professional – Business Objects Web

INTELLIGENCE XI 3.0 – LEVEL ONE



Sample questions on Business Objects Certified Professional – Business Objects Web



Intelligence XI 3.0 –Level two

AB INITIO

Introduction to Abinitio

Operating system & hardware platformthat Ab Initio supports

Salientfeatures ofAb Initio Ab Initiohigh level architecture Products ofAb InitioCorporation Job Anatomy of a running job Ab Initioterminology

Graph, Component, Port, DML etc……

Different ports available on overall components Standard environment and different parameters Multi directory multi file system and ad-hoc multi files Parallism and Layout

Phase & Checkpoint

Common Functions available inAb Initio Types of flows

Conditional components and sub graphs Watcher file

Introduction to .dbc file

Performance improvement processes Advanced concepts

Course Name : SAS online training

Course Duration : 45 Hours

SAS

SAS EXPOSURE IN ORGANISATIONS



History ofSAS



SAS comes inERPsector or not? Why?



Role of Statistical Analysis in Clinical Research Study and Banking analysis



SAS role in Clinical Research Study and Banking analysis



Data modeling and Data mining concepts



Project Management inClinical Research Studyanalysis andBankinganalysis



What is Clinical Research Study?



What is Protocol and role of Protocol in Clinical Research Study?



What is randomization and non randomization? Which is playing main role in Clinical Research Study?



What is SOP (Standard Operating Procedure)?



What is DBMS?



Role of DBMS team in Clinical Research Study



What is CDM (Clinical Data Management)?



Importance of CDM systems for data loading



What is SAP (Statistical Analysis Plan)?



Role of SAP in Clinical Research Study



SAS Work Flow in Clinical Research Study



Relation between SAS and DBMS



Interaction between SAS with CDMs for data access



Various report generation in Clinical Research Study



Role of SAS in Credit Analysis and Different Banking Channels.



When we go any industry for Data modeling and Data mining.



Role of SAS in Data modeling and Data mining



Other types of modeling—data mining etc…

GETTING STARTED WITH SAS SYSTEMS:



Basic operating system commands, operating system file structures



Managing windows in SAS window environment



How to run SAS application in different modes and in different environment like



Windows, Unix and Mainframes



Use of different kind of SAS products and how to use in SAS application.



Difference between the SAS products.



Why using the SAS in different sectors.



How to use the data step to read and manipulate complex forms of data



WriteData and Proc steps.



Data step compile and execution



To run SAS application on different modes



Reading internal reading and printing l raw data into SAS



Read any type of external raw data into SAS



Reading raw data SAS environment into DATA SET using Input statement & advance INLIFE statement options



Working with Data Storage in SAS libraries creation for user defined libraries and multi-engine architecture



Using a single libref to reference some or all SAS libraries reading and printing mixed records formats.



Reading packed and zoned decimal data working with EBCDIC and ASCII data



Reading data from data set to another data set.



To manage the SAS window environment used with global options.



To manage existing data with controlling statements and expressions



Creating Summary Information, SAS Functions, Transforming Data



Changing variable types using the PUT and INPUT functions summarizing data files



Generation data sets to create historical information SAS



To expert data from data sets to delimiter files using with data set block



Understand error messages in the SAS Log and debug your program



Use with Error Handling concepts

PERFORM ITERATIVE PROCESSING ON DATA:



Using Do loops for repetitive calculations and processing



Using Arrays to process across an observations and processing



Using DO WHILE and DO UNTIL statements for conditional looping

DATA STORAGE METHODS AND COMPRESSION:



SAS Engines



Space reduction



Data set compression

INDEXING TECHINIQUES AND USES:



When to use indexes



Creating and deleting indexes



Index advantages and disadvantages

UTILITIES TO MANAGE AND WORK WITH DATASETS:



Data using append procedure to add date values in existing dataset



Using the update statement to update data in existing dataset.



Using the MODIFY statements to update and modify data in place



Merging concepts



Data transformation



Concatenation concept in merging



Interleaving concept and merging



Different kind of match merging using MERGE statement using the contribution (IN=) option in merge concept



Using ODS concept to generate reports



Organize and sort SAS data sets and working with duplicates



To generate listing output use print



Comparing data sets with proc compare



To create user defined informat and format statements use format



Using proc copy to copy data sets



Importance of contents procedure



Reading data from dataset for reporting use report



Using Proc Datasets to modify data set structure , attributes, how to use permanent formats , Setting up Integrity Consraints to maintain clean data and Setting up indexes



Role of ODS concepts to reporting SAS output



To generate SAS output in different panels like RTF, HTML,PDF and XML Using ODS

How to use PROC SQL to retrieve INFORMATION from their Data



Introduction to SQL Concepts



The origin of SQL and why we use it.



Create new tables, indexes , views and reports

Simple Queries



Understanding to SQL Concepts



How to specify columns and subset rows



Using functions to summarize outputs



Performing group analysis, remerging and sub quiries

Joining Data



What are Cartesian Products , what is join



Innner , FULL,OUTER,LEFT and RIGHT Joins



Set Operator us such as union and intersection joining multiple tables



PROC SQL as compared to the data step

ORKING WITH TABLES , VIEWS AND indexes



Creating Indexes and table in SQL



Why we use Views in SQL



Performance and space ISSUES

WORKING WITH TABLES , VIEWS AND indexes



Creating Indexes and table in SQL



Why we use Views in SQL



Performance and space ISSUES

ADVANCED SQL Topics



HOW TO USE SAS MACROS IN SQL



How dictionary table and views can simplify programming SQL options



How to retrieve Raw data different from DATABASES to SAS environment using SQL Statements



To create table in different databases using SAS sql statement



To manage in different databases using SAS Sql Statements

ADVANCED SQL Topics



HOW TO USE SAS MACROS IN SQL



How dictionary table and views can simplify programming SQL options



How to retrieve Raw data different from DATABASES to SAS environment using SQL Statements



To create table in different databases using SAS sql statement



To manage in different databases using SAS Sql Statements

PASS TROUGH FACILITY



Uses of pass through facility



How to communicate with other database like Access , Oracle, DB2



To control and manage other databases fro the SAS.



To access required data from other databases



To create DATAWAREHOUSING environment

Basic Statistical Procedures (SAS/STAT) and reporting Procedure



To summary statistical Analysis Summary Procedure



Producing Statistical with means Procedure



Testing Categorical Data with FREQ PROCEDURE



Reporting areas in SAS



To generate report use with Proc Report



Examining Data with Univarate Procedure



T-tests and non parametric Comparison



Proc ANOVA for one way ANOVA for one way Analysis of Variance



Examining Correlations with PROC CORR



PROC REG for Regression Analysis

Creating bar & PIE Charts



Producing BAR & pie chart



Enhancing O/P with Title FOOTNOTES Color & font



Producing & Overlaying lots



CONTROLLING Appearance of axe’s



Generating Graphs use with ODS

How to work with SAS/ACCESS & SAS /Connect



To import data from different PC files use import procedure



To export data from different source use access procedure



To export data from datasets to different PC files use export Procedures



Uses of DBLoad procedure and how to work



To transport datasets one environment to another environment and one version to another version to another version (windows to UNIX)use with cprot and cimport procedures



How to use Upload Procedure



How to work with MACRO LANGUAGE INTRODUCTION to MACROS



How the SAS macros Language Works



What is the role of macro in SAS



Introduction to tokening , compiling and executing a SAS program



How the macro Processor Works

Applying MACRO VARIABLES in a SAS PROGRAM



Applying automatic macro variables



Designing customized macro variables



Submitting the macro variables in SAS Programming



Displaying MACRO VARIABLES VALUES in the SAS log



Applying quoting functions with macros

Incorporating SAS Macros in the DATA STEP



Designing macro variables during Data step Execution



Indirecting referencing Macro variables



Understaining the functionality and application of the SYSMGET function and SYSMPUT routine



Usinig the INTO clause to build macro variables during PROC SQL execution

RUNNING MACRO PROGRAMS IN SAS SOFTWARE



Designing and implementing simple macros and reduce customizing SAS application



To Develop Reusable Application use with MACRO



Specifying conditional coding inside a macro



The macro compilation and execution processes in the macro processor SAS system options use dfor debugging macros



Reviewing error and warning log messages displayed by bthe macro processor



Designing and using macros containing parameters within them



Using positional and keyword parameters in macro calls



Difference macros and symbol table Hierarchies



Concepts in MACRO FUNCTIONS , MACRO INTERFACE AND MACRO



Quoting Functions and how to use MACRO CODING.

Techniques for Storing MACROS



Understanding the auto call feature



Permanently storing and using compiled macros



Writing Efficient macro programs

DEBUGGING SAS PROGRAMS



SAS programs that work



Fixining Programs that don’t work



Seraching for the missing semicolon



Input statement reaching past the end of line



Lost card



Invalid Data



How to handle different kind of SAS errors



Missing VALUES were Generated



Numeric values have been converted to Charcter



WRONG results but no error message



SAS Trucated a character variable



SAS stops in the middle of the job



SAS runs pout of memeory or disk space

Statistical DATAWARE HOUSING



DATAWARE HOSING Concepts



What is ETL



SAS/ETL Concepts

Course Name : SAP ABAP online training

Course Duration : 50 Hours

SAP ABAP

ABAP Contents ERP



Introduction



Evolution of ERP

ASAP ( Accelerated SAP)



Project preparation



Business Blue Print



Realization



Final preparation



Go-Live and Support

SAP R/3 Architecture



Centralized architecture



Distributed architecture



2-tire architecture



3-tire architecture

Landscape and Implementation Lifecycle



Overview of Software Development



Overview of SAP Landscape



Landscape types



Lifecycle Implementation concepts

Introduction to ABAP

Getting Started



SAP Logon Details



SAP Easy Access

ABAP Workbench



Package builder



Object Navigator



Overview of Workbench



Information about Repository Objects

ABAP Dictionary



Database tables



Views



Data types



Type groups



Domain



Search Help

Basic Programming



Data type in ABAP editor



String Functions



Data Functions



Arithmetic Functions



System Fields Formation Techniques



Icons



Symbols



Color



Hotspot Selection-screens



Parameters



Select-options



Comments



Blocks



Tabs Work-Area



Implicit Work Area



Explicit Work Area

Control statements



Conditional statements



Branching statements



Looping statements

User defined Non-Elementary data type



Field String



Field Groups



Field Symbols

ABAP database Access



Open SQL



Native SQL

Internal Table



Without Header line



With Header line



Types of Internal tables



Source code



Include



Macros



Procedure



Subroutines



Function builder Reports



Classical reports



Interactive Reports



ALV(ABAP List Viewer)



Drill down Reports

Screen Objects



Attributes



Implementation and processing



Screen Painter tool



Dynpro



Text Fields



Frames



Status Icon



Input/output Fields



List Box



Pushbutton



Check Box



Radio Button group



Subscreen



Tab strip



Table Control

Developer Tools



ABAP/4 Runtime Analysis



SQL Trace



Performance Tuning

Data Transfer Procedure



Overview of Transfer Procedure available



Data analysis and formatting



Sequential and Local files



Batch Input



Session Method



Call Transaction Method



Legacy System Migration Work Bench (LSMW)



Transaction Recorder



Scheduling Data Transfer in Background processing

SAP Script



Overview of SAP Script



General concepts on Form Painting



Header



Pages



Windows



Page windows



Paragraph



Character Format



SAP Script Style

SMART FORMS (Concepts) CROSS APPLICATIONS



Introduction to Distributed technologies



Why Distributed technologies



General Concepts



RFC

Types of Distributed technologies



ALE



EDI



BAPI Enhancement Technologies



User exits



Menu exits



Screen exits



CMOD and SMOD



BADIS



Workflow



ITS Other



Real-Time Scenarios



Maintenance Project



Implementation Project



Implementation Skills

o

In Various ABAP Concepts

o

Functional Exposure with Real-Time scenarios

o

In MM/SRM

MOSS 2007

This course covers 4 modules i.e.



Using SharePoint as an end user



Designing sites as Designer



Developing applications as SharePoint developer



Administering sites as an administrator

Introduction to SharePoint



Introduction to SharePoint



Introduction to Windows SharePoint Server



Introduction to Microsoft Office SharePoint Server



Other Key SharePoint Development Areas

Windows SharePoint Services



WSS Basics



Content Types and Sites Columns



Templates and Features

SharePoint Site Collections and Sites



SharePoint Site Collection Overview



Creating a Site and Sub Site



Managing and Using Site Templates



Managing Site Security

Working with Pages and Web Parts



Understanding Web Part Pages



Creating Pages



Understanding Web Parts



Adding Web Parts to a Page

Working with Lists



What are Lists?



Creating Lists



Creating and Using Site Columns



Customizing List Views



Understanding List Security

Working with Documents and Libraries



What are Libraries?



Office Integration Features



Creating Libraries



Enabling Check-In/Check-Out



Enabling Notifications



Information Management Polocies



Navigation Settings



Customizing Navigation



Performing Simple and Advanced Searches



Using Keywords and Best Bets

Personalizing SharePoint



Managing Alerts



Using My Sites



Using My Links

Microsoft Office SharePoint Server



InfoPath Services



Excel Services



Reporting and Dashboards



Business Data Catalog



Single Sign on Service



SharePoint Search

Web Part Framework



Web Part Framework Basics



Creating Web Parts



Connectible Web Parts



Debugging and Deploying Web Parts

Workflow



Workflow Basics



Workflow Object Model



No code Workflow



Workflows with SharePoint Designer



Workflows with VS 2005



Deploying Workflows using Features

Advanced SharePoint Development



SharePoint Object Model



Event Handlers



SharePoint Web Services



Application Integration

Introduction - Out of the Box BPA



Understanding Business Process Automation



Using Task Lists

SharePoint Designer Workflows



Understanding the Workflow Designer



Defining Steps Using Conditions and Actions



Using Lookups and Dynamic Routing



Creating Forms and Using Variables



Extending SharePoint Designer with Custom Activities

SharePoint and ASP.NET Forms



Modifying List Forms Using SharePoint Designer

InfoPath Forms



Creating InfoPaths Forms



Using Form Libraries and Data Connection Libraries



Using InfoPath Forms in Office 2007

Creating Custom Workflows



Creating Sequential Workflows



Creating State Machine Workflows

Business Data Catalog



Configuring the BDC



Connecting to External Databases



Connecting to Web Services



Using the BDC Web Parts

Excel Services



Configuring Excel Services



Using the Calculation Engine



Using the Excel Web Parts



Key Performance Indicators



Report Center



Search Center Lite



Search Center with Tabs



Search Web Parts



Search Scopes



Usage Reporting and Keyword Optimization

Managing the Server



Deploying Features



Using STSADM



Common Tasks



Troubleshooting



Managing Site Quotas

Introduction to SharePoint Development



Modes of Development: Configuration, Customization and Solution Development



Site Collections and Sites



Creating and Customizing Lists and Libraries



Using Web Part Pages

Features



Types of Features



Feature Scopes



Feature Activation, Dependencies, and Stapling



Feature Receivers

Styles and Themes



Style Basics



Associating Styles with Pages



Using and Creating Themes

Master Pages



ASP.NET Master Page Basics



Master Pages in SharePoint



Creating a Custom Master Page

Creating User Controls and Web Parts



User Controls



Web Parts



Delegate Controls

Advanced List Concepts



Manipulating Lists and List Items Programmatically



Lists and Cross-site queries



Events



Custom Field Types

Course Name : MSBI online training

Course Duration : 35 Hours

MSBI

SQL Server 2005 Analysis Services

What Is Microsoft BI?



Core concept – BI is the cube or UDM



Example cube as seen using Excel pivot table



MS BI is comprehensive – more than Analysis Services on SQL Server



Demonstration of SQL Reporting Services with cube as data source

OLAP Modeling



Modeling source schemas—stars and snowflakes



Understanding dimensional modeling— Dimensions (Type 1, 2, or 3) or rapidly changing



Understanding fact (measures) and cube modeling



Other types of modeling—data mining etc…

Using SSAS in BIDS



Understanding the development environment



Creating Data Sources and Data Source Views



Creating cubes – using the UDM and the Cube Build Wizard



Refining Dimensions and Measures in BIDS

Intermediate SSAS



KPIs



Perspectives



Translations – cube metadata and currency localization



Actions – regular, drill-through and reporting

Advanced SSAS



Using multiple fact tables



Modeling intermediate fact tables



Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, write back dimensions



Modeling changing dimensions – Dimension Intelligence w/ Wizard



Using the Add Business Intelligence Wizards – write-back, semi-additive measures, time intelligence, account intelligence

Cube Storage and Aggregation



Storage topics – basic aggregations, MOLAP



Advanced Storage Design – MOLAP, ROLAP, HOLAP



Partitions – relational and Analysis Services partitions



Customizing Aggregation Design - Processing Design



Rapidly changing dimensions / ROLAP dimensions



Welcome to the Real Time – Proactive Caching



Cube processing options

Beginning MDX



Basic syntax



Using the MDX query editor in SQL Server Management Studio



Most-used Functions & Common tasks



New MDX functions

Intermediate MDX



Adding calculated members



Adding scripts



Adding named sets



.NET Assemblies

SSAS Administration



XMLA scripting (SQL Mgmt Studio)



Other Documentation methods



Security – roles and permissions



Disaster Recovery – backup / restore



Clustering – high availability

Introduction to Data Mining



What and why?



Examples of using each of the 9 algorithms (MS Clustering, MS Decision Trees, Naïve Bayes, MS



Sequence Clustering, MS Time Series, MS Association Rules, MS Neural Network)



Data Mining dimensions



Data Mining clients



Processing mining models

Introduction to Reporting Clients



Excel 2003 Pivot Tables



SQL RS & Report Builder



SPS RS web parts & .NET 2.0 report viewer controls



Business Scorecards 2005 & ProClarity

Future Directions – Integration with Office 12



SharePoint 12 and AS



Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter



Excel Services 12 and AS (Web Services)

SQL Server 2005 Integration Services

Introduction to SQL Server Integration Services



Product History



SSIS Package Architecture Overview



Development and Management Tools



Deploying and Managing SSIS Packages



Source Control for SSIS Packages

SSIS for DBAs: Using SQL Server Management Studio



The Import and Export Wizard



Working with Packages



Database Maintenance Plans



Creating Database Maintenance Plans using SSMS



Scheduling and Executing Plans



Examining Database Maintenance Plan Packages



Changes in SQL Server 2005 Service Pack 2

Business Intelligence Development Studio



Launching BIDS



Project templates



The package designer



The Toolbox



Solution Explorer



The Properties window



The Variables window



The SSIS menu

Introduction to Control Flow



Control Flow Overview



Precedence Constraints



The Execute SQL Task



The Bulk Insert Task



The File System Task



The FTP Task



The Send Mail Task

Advanced Control Flow



Containers – grouping and looping



The Web Service Task



The WMI tasks



The Analysis Services tasks



The Execute Process Task



The Execute Package Task

Introduction to Data Flow



Data Flow Overview



Data Sources



Data Destinations



Data Transformations



The Copy Column Transformation



The Derived Column Transformation



The Data Conversion Transformation



The Conditional Split Transformation



The Aggregate Transformation



The Sort Transformation



Data Viewers

Variables and Configurations



Variables Overview



Variable scope



SSIS system variables



Using variables in control flow



Using variables in data flow



Using variables to pass information between packages



Property expressions



Configuration Overview



Configuration options



Configuration discipline

Debugging, Error Handling and Logging



SSIS debugging overview



Breakpoints in SSIS



SSIS debugging windows



Data Flow: Error data flow



Configuring Package Logging



Built-in log providers

Advanced Data Flow



Revisiting data sources and destinations



The Lookup Transformation



Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations



The Multicast Transformation



The Merge and Merge Join Transformations



The Data Mining Query Transformation



The Data Mining Model Training Destination



The Slowly Changing Dimension Transformation

Extending SSIS through Custom Code



Introduction to SSIS scripting



The SSIS script editor



The SSIS object model



Script in Control flow: The Script Task



Script in Data flow: The Script Component



Introduction to SSIS component development

SSIS Package Deployment



Configurations and deployment



The deployment utility



Deployment options



Deployment security



Executing packages – DTExec and DTExecUI

SSIS Package Management



The SSIS Service



Managing packages with DTUtil



Managing packages with SQL Server Management Studio Scheduling packages with SQL Server Agent

Introduction to SQL Server Reporting Services



Tour of Features



Reporting Services Architecture



Reporting Services Terminology



Reporting Services Editions



Taking Reporting Services for a Spin

Creating Reports



Deconstructing Reporting Services



Shared Data Sources



Creating Reports from Scratch

Calculations and Formatting



Creating Expressions



Using the Global Collections



Formatting Items



Conditional Formatting

Grouping and Sorting



Creating Groups



Calculating Totals and Percentages



Interactive Sorting



Creating Drill-Down Reports

Report Parameters



Creating Report Parameters



Creating Drop-Down Parameters



Multi-Valued Parameters



Debugging Parameter Issues

Creating Matrix Reports and Charts



Creating a Basic Matrix Report



Matrix Subtotals



Creating a Basic Chart



Exploring the Charting Possibilities



Deploying Reports and Data Sources



Exporting Reports and Printing



Using the Web-Based Report Manager



Using SQL Server Management Studio-based Reporting Services Manager

Reporting Services Security



Two Parts to Reporting Services Security



Securing Access to Reports



Data Source Security

Programming Reporting Services



The Many Reporting Services APIs



Integrating Reporting Services into Applications using URL Access



Using the Report Viewer Controls

Advanced Reporting Services Programming



Using the Reporting Services Web Service



Working with Custom Assemblies

Snapshots and Subscriptions



Caching and Snapshots



Creating Standard Subscriptions



Creating Data-Driven Subscriptions



Managing Subscriptions

Ad-Hoc Reporting with Report Builder



The Report Builder Architecture



Creating Report Model Projects



Running Report Builder

COURSE NAME : Android ONLINE TRAINING

COURSE DURATION : 40 HOURS

Android

Introduction:

Introduction to open source. What is open source?

License Issues (MPL,GPL,LGPL,etc.)

Mobile Application Development overview:

Mobile Device Profiles Mobile Software

Options for Development

Targeting Android-The Big picture:

Introducing Android Stacking up Android

Booting Android Development An Android Application

Development Environment:

Android SDK

Building an Android Application in Eclipse The Android Emulator

User Interface:

Activity Life Cycle Creating the Activity

An Overview of User Interfaces Using XML Layouts

Selection Widgets Date and Time Tabs Using Menus Using Fonts

WebView and WebKit Browser Dialog Boxes: Alert Dialog &Toast Using Resources

Intents and Services:

Listening in with broadcast receivers Building a Service

Performing Inter-Process Communication

Storing and Retrieving Data:

Using Preferences Using the File System

Persisting data to a Database

Working with content Provider Classes

Networking and Web Services:

An Overview of Networking

Communications with Server Socket Working with HTTP

Web Services

Telephony:

Telephony Background and Terms Accessing Telephony Information Interaction with the phone Working with Messaging SMS

Graphics and Animations:

Drawing Graphics in Android Animations

Multimedia:

Introduction to Multimedia Playing Audio

Playing Video and Capturing Media

Location Services:

Simulating your location within the emulator Using Location Manager & Location Provider Working with MAPS

More about Android Online Training :

About Android Trainer :