.NET Training Program

Introduction to the .NET Platform
  • Overview of the .NET Framework
  • Benefits of the .NET Framework
  • The .NET Framework Components
  • Languages in the .NET Framework
Overview of C#
  • Structure of a C# Program
  • Basic Input/Output Operations
  • Recommended Practices
  • Compiling, Running, and Debugging
Using Value-Type Variables
  • Common Type System
  • Naming Variables
  • Using Built-In Data Types
  • Creating User-Defined Data Types
  • Converting Data Types
Statements and Exceptions
  • Introduction to Statements
  • Using Selection Statements
  • Using Iteration Statements
  • Using Jump Statements
  • Handling Basic Exceptions
  • Raising Exceptions
Methods and Parameters
  • Using Methods
  • Using Parameters
  • Using Overloaded Methods
Arrays
  • Overview of Arrays
  • Creating Arrays
  • Using Arrays
Essentials of Object-Oriented Programming
  • Classes and Objects
  • Using Encapsulation
  • C# and Object Orientation
  • Defining Object-Oriented Systems
Using Reference-Type Variables
  • Using Common Reference Types
  • The Object Hierarchy
  • Namespaces in the .NET Framework
  • Data Conversions
Creating and Destroying Objects
  • Using Constructors
  • Initializing Data
  • Objects and Memory
  • Resource Managements
Inheritance in C#
  • Deriving Classes
  • Deriving Classes
  • Implementing Methods
  • Using Sealed Classes
  • Using Interfaces
  • Using Abstract Classes
Operators and Events
  • Introduction to Operators
  • Operator Overloading
  • Creating and Using Delegates
  • Defining and Using Events
Properties and Indexers
  • Using Properties
  • Using Indexers
Attributes
  • Overview of Attributes
  • Defining Custom Attributes
  • Retrieving Attribute Values

JAVA J2EE Training Program

  • Java SE6 Programming
  • Java EE Web Services
  • Building Java EE Applications
  • Building Java EE Web Applications
  • Enterprise JavaBeans
  • Servlets & Java Server Pages (JSP’s)
  • Eclipse
  • Enterprise Java Applications with Spring & Hibernate
  • Javascript Introduction
  • Javascript Developers Program
  • J2EE Programming with Oracle WebLogic Server
  • Java Data Objects
  • Java Programming in Rational Application Developer
  • RAD6
  • RAD v7.x for Experienced Java Developers
  • jQuery
  • Struts Web Development Framework
  • Hibernate
  • JSF Java Server Faces (JSF)
  • JMS 1.1 Programmer Reference
  • Fast Track to Spring 3.0
  • Apache Tomcat Administration
  • Java SOA Enterprise Architecture
  • JNDI 1.2 Programmer Reference

Oracle OBIEE Training Program

Repository Introduction
  • Oracle BI architecture
  • Repository structure and features
  • Oracle BI Administration Tool
  • Creating a repository
  • Loading a repository intmemory
Building Repository Physical Layer
  • Importing data sources
  • Connection pools
  • Keys and joins
  • Physical layer object properties
  • Tables and aliases
Business model and mapping layer
  • Building a business model
  • Logical tables, columns, and sources
  • Logical joins
  • Building measures
  • Business model object properties
Repository presentation layer
  • Exploring presentation layer objects
  • Creating presentation layer objects
  • Modifying presentation layer objects
  • Examining presentation layer objects
Testing and validating repository
  • Repository consistency
  • Repository logging
  • Defining repository in initialization file
  • Testing repository with Oracle BI Answers
  • Query log
Calculations
  • Calculation based on existing logical column
  • Calculation based on physical columns
  • Calculation Wizard
Dimension hierarchies and level-based measures
  • Dimension hierarchies
  • Level-based measures
  • Share measures
  • Rank measures
Aggregates
  • Introduction taggregates
  • Query performance with aggregates
  • Testing aggregate navigation
  • Aggregate Persistence Wizard
Partitions and fragments
  • Introduction tpartitions and fragments
  • Partition types
  • Modeling partitions in Oracle BI repository
Repository Variables
  • Session variables
  • Repository variables
  • Initialization blocks
  • Variable Manager
  • Filtering with dynamic repository variables
Modeling time series data
  • Time comparisons
  • Oracle BI time series functions
Many-t-many relationships
  • Using bridge tables
  • Using helper tables
Implicit fact columns
  • Adding fact columns tdimension-only queries
  • Predetermined fact table sources
  • Default join paths between dimension tables
Security
  • Users and groups
  • User and group permissions
  • Authenticating with external database
  • Authenticating with database authentication
  • Query limits and timing restrictions
  • Personalization using filters
Cache Management
  • Non-cacheable tables
  • Cache Manager
  • Cache reports
  • Purging cache entries
  • Modifying cache parameters and options
  • Seeding the cache
Usage tracking
  • Tracking and storing Oracle BI Server usage
  • Usage tracking statistics
  • Analyzing usage tracking reports
Multi-user development
  • Setting up environment for multiple users
  • Developing repository for multiple developers
  • Tracking development project history

SAP Business Objects XIR3 Training Program

Introduction to BO
Workflow in BO
BO Architecture
Installation & Configuration of BO XIR3
Different Versions
BO Repository
Components in BO XIR3
  • Designer
  • InfoView
  • Web I Rich Client
  • Web I Thin Client
  • Desk I
  • Import wizard
  • QWAAS (Query as a web server)
  • Report conversion tool
  • Crystal reports basic operating
  • Xcelsius dashboard designing
  • CMC (Central management console)
  • CCM (Central configuration management)
Designer
  • Connections
  • Universe creation
  • Authentications
  • Structure plan
  • Universe plan
  • Joins
  • Joins problems
  • Loops
  • Traps
  • Derived tables
  • Linking universe
  • Context
  • Alias
  • Universe parameters
  • Class
  • Objects
  • Condition objects
  • Hierarchies
  • Securities
  • Cascading LOVs
  • Performance tuning tips & tricks
  • Debugging
Reporting
  • Filters
  • Break
  • Sections
  • Sort
  • Alerts
  • Rank
  • Merge dimensions
  • Purge
  • Track
  • Drill reports
  • Report properties
  • Variables creation
  • Combined queries
  • Hyperlinks
  • Charts
  • Dashboards
  • Performance tuning
  • Session and workflow parameters
CMC
  • Users
  • Group
  • Server
  • Event
  • Calendar
  • Privileges

.NET with Sharepoint Training Program

NET Framework and C# Language
Object Oriented Principles
Architecture of the .NET Framework Platform
Introduction to C#
Working with C# types and the Common Language runtime
C# Languages constructs
Events and Delegates
Exceptions
Garbage collection algorithm
CLR hosting, AppDomains and reflection
Working with Strings

Class Library
Collections
I/O Operations
Namespaces & Assemblies (gacutil and Global Assembly Cache)

ADO.NET and SQL Server 2008 Enterprise Edition
ADO.NET Object model
Connection
Command and Parameters
DataReader and DataAdapter
Dataset
MS SQL Server 2008 is used as database

Windows Forms
Working with different types of controls
Simple Data Binding using Combo boxes and List Boxes
Complex Data binding using the Data Grids
Currency Manager and DataView
Difference between Windows Forms and Web Forms
Developing windows forms examples by involving ADO.NET and Data binding
App.config

XML
Using XML Data
Understanding the DTD and XML Schemas
DOM and SAX parsing techniques
XSL Transformations

SharePoint 2010, Application Development
Module 1: Introduction to the SharePoint 2010 Development Platform
Module 2: Developing Using SharePoint Designer 2010
Module 3: Developing SharePoint Solutions by Using Visual Studio 2010
Module 4: Developing SharePoint 2010 Web Parts by Using Visual Studio 2010

Advanced Topics
NET Remoting concepts
Web Services concepts with examples
All exercises using only C#.Net with Visual Studio .Net 2010 IDEIIS Server for deployment

SQL Server DBA Training Program

Getting started with SQL Server 2012
Setting up SQL Server 2012
Selecting installation options
Installing named instance
Leveraging essential tools
SQL Server management studiConfiguration manager
Transact SQL
Sqlcmd
PowerShell
Dedicated administrator connection

Constructing and Managing Databases
Inspecting storage structures
Creating databases and transaction logs
Spreading data among file groups
Upgrading and moving databases
Choosing between upgrade and migration
Taking advantage of the Upgrade Advisor
Detaching and attaching databases
Controlling database space
Permitting automatic database growth
Adding database files texpand databases
Specifying database options

Handling Server & Database Security
Implementing server security
Comparing authentication modes
Defining logins
Creating user-defined server roles
Enforcing password policy
Granting database access
Adding users
Defining new roles
Delegating privileges with predefined roles
Repairing mis-maped logins
Creating contained databases
Examining components and terminology
Enabling contained databases
Contrasting SQL and Windows users
Converting existing databases tcontained databases
Discovering barriers tcontainment
Transforming current users

Granting and Revoking Permissions
Managing database scoped privileges
Permitting object creation
Giving blanket permissions
Assigning default schema
Defining object level permission
Limiting object access
Meeting complex permission requirements with roles
Examining permission hierarchies

Backup and Recovery
Backing up databases
Selecting recovery model
Exploring transaction log architecture
Running full log and differential backups
Reclaiming transaction log space
Restoring databases
Recovering user and system databases
Testing recovery scenarios

Streamlining Tasks with Jobs, Alerts and Database Mail
Configuring SQL Server agent
Setting agent properties
Implementing database mail
Defining jobs thandle and routine tasks
Creating alerts and operations
Associating alerts with jobs
Initiating multistep jobs

Database Maintenance and Monitoring
Handling fragmentation and database corruption
Identifying and curing fragmentation
Repairing database corruption
Updating optimizer statistics
Building database maintenance plans
Selecting maintenance tasks
Scheduling plan execution
Notifying operators of success or failure
Monitoring SQL Server
Pinpointing blocked users with Activity Monitor 
Resolving connection problems

Datastage Training Program

Data Warehouse Fundamentals
  • Introduction to Data Warehouse
  • Purpose of a Data Warehouse
  • Architecture of a typical Data Warehouse
  • OLTP Vs OLAP
  • Data warehouse Lifecycle
  • Data Marts Vs Data Warehouses
  • Dimensions & Fact Tables
  • Star Schema
  • Snowflake Schema
ETL Design Process
  • Extraction, Transformation & Loading Overview
  • ETL tools in the market
  • SQL Overview
Datastage Introduction
  • What is Datastage
  • Datastage Server Architecture
  • Datastage Server Components
  • Datastage Client Components
Datastage Administrator
  • Projects Management ( Add, Edit, Delete )
  • Environment Management
  • Runtime Column Propagation ( RCP )
  • Parallel Jobs
Datastage Director
  • What is Datastage Director?
  • Datastage Jobs Execution
  • Job Monitoring
  • Job Logs
  • Job Scheduling
Datastage Designer
  • What is Datastage Designer
  • Why Parallelism?
  • Pipeline Parallelism
  • Symmetric Multi Processing ( SMP )
  • Massively Parallel processing ( MPP )
  • Partition Techniques
  • Datastage Repository
  • Passive & Active Stages
  • Job Design Overview
  • Designer Work Area
  • Annotations
  • Create, Delete Jobs
  • Passing Parameters
  • Job Compilation
Parallel Job Stages
  • Database Stages
  • Teradata Enterprise stage
  • Oracle Enterprise stage
  • DB2 Enterprise stage
  • File Stages
  • Sequential File
  • Dataset File
  • File Set
  • Lookup File set
  • Processing Stage
  • Change capture
  • Aggregate stage
  • Transformer stage
  • Surrogate generator stage
  • Join stage
  • Merge stage
  • Lookup stage
  • Difference between Join/ Lookup/ Merge
  • Difference between Join/ Lookup
  • Remove duplicates
  • Pivot
  • Modify
  • Funnel
  • Debug Stages
  • Row Generator
  • Peek
  • Column Generator
  • Container
  • Share container
  • Local container

Informatica Training Program

Introduction to ETL

Enterprises of ETL Architecture

Introduction to Informatica

Installation & Configuration of Informatica

Repository Creation & Management

Designer
Source analyzer
Warehouse designer
Mapplet designer
Mapping designer
Different kinds of transformations
Simple mapping
Mapping involving multiple sources
Multiple targets
Complex logic mapping
Slowly changing dimension
Example of each transformation available
Mapping parameters & variables
Performance tuning tips & tricks
Debugging

Workflow Manager 
Task developer
Worklet designer
Workflow designer
Different kinds of tasks and usage
Control tasks
Workflow control and monitoring
Performance tuning
Session and workflow parameters

Project Related
Real time project scenarios
Complete real time project exposure

Quality Analyst Training Program

Overview 
General Testing Concepts 
Client/Server and Web Application 
SDLC (Software Development Life Cycle) 
FRC (Functional Requirement Specification) 
SDS (System Design Specification) 

Testing Strategy 
Test Plan
Test Case 
Test Summary Report 
STLC (Software Test Life Cycle) 
V – Model 
Traceability Matrix 

Testing Techniques 
Black Box Testing  
White Box Testing 
Path Testing 

Testing Types   
Unit Testing 
Integration Testing 
System Testing  
Regression Testing 
Functionality Testing 
Load /Performance Testing 
Stress Testing 

Testing Types 
Compatibility Testing
UAT
Smoke testing
Sanity Checking/Testing
Backend testing

Bug or Defect Reporting Process 
Defect Lifecycle 
Defect Tracking
Defect  Priority 
Defect Report 
Impact Analysis 
Gap Analysis 

21 CFR Part 11 and Computer System Validation
21 CFR Part 11 
IQ/OQ/PQ 
Change Management 
Version Control 
Document History 
Document Review 
Document Approval 
GDP 

Test Automation 
Overview on Test Automation 
Automation Testing Process 
Importance of Automation Testing 
Test Case selection for Automation Testing 

Mercury WinRunner 
Recording and Running Scripts    
Recording a Test Script 
Setting initial Condition 

Introduction tGUI Map 
How the GUI Map works 
Twmethods for GUI Map maintenance 
Logical Names and Physical Descriptions 
Loading and Unloading a GUI Map file 

Synchronizing Script and Application 
Creating  Synchronization points 

Verification with Standard Checkpoints 
Implementing GUI Checkpoints 
Implementing Bitmap checkpoints Complete 

Data – Driven Test 
Understanding parameters 
Using the Data Driver Wizard 

Creating and Using GUI Maps 
How the GUI Map is recorded and used 
Using the Rapid Test Script Wizard 

Batch Testing 
Running Tests in Batch Mode 
Calling a Test from another Test 

Test Script Language (TSL) 
Functions,Variables,constants and Operators 
Sending messages tthe Test Results window 

User Defined Functions and Reusable Libraries 
Creating Functions and Compiled modules(libraries)
Return codes and error handling 

Advanced Data Driving 
Reading from and writing tthe Data Table 
Writing tspread sheets and tText Files 

Managing Custom Objects in an application 
Leaning the properties of Custom Objects 
Mapping custom objects tstandard classes 

QTP
Fundamentals of Quick Test Professional (QTP) 
Quick Test Benefits in Test Automation 
Overview on Quick Test Professional 
Record and Playback Basic Script 
Object Identification and Object Spy 
Synchronizing Tests 
Standard and Text Checkpoints 
Parameterize tests 
Create data – driven tests 
Local and Global Data tables

Test Director 
Introduction tTest Director 
Test Director Testing process 
Specifying Testing Requirements 
Planning test in Test Director 
Generating Automated Test Templates 

Load Runner 
Requirements and Planning an Effective Load Test 
LoadRunner Overview and  Architecture 
Virtual  User Generator (VuGen) Recording and Playback 
Script Enhancements (Multiple Actions and Transactions) 
Data Parameterization 
Understanding Correlation 

Oracle and Unix 
SQL Commands 
Unit Commands 

SAS Clinical Training Program

SAS Introduction & Clinical Trials Basics
SAS Software Environment & SAS Basics
SAS Versions
SAS Extensions
Windows
Attributes of a Dataset
Data and Proc Step  - PDV
Set Statement
Working with SAS Dates
Reading Raw data files and Datasets
Infile and File Statement
Datalines
Import and Export
Libname – Temporary & Permanent
Conditional Statements, Functions, Formats and Informats
If and Where – PDV
Functions
Formats and Informats
Proc Format – User defined
Shortcuts for a list of Variable names
Rename, Length, Label, Keep, Drop & Attrib Statements
Procedures
Proc Print
Proc Sort
Proc Transpose
Proc Freq
Proc Means
Proc Report
ODS
Combining SAS datasets
Append
Merge
Dataset options and IN= option
Automatic Variables
Macros 
MacrVariables and different ways tcreate them
MacrCreation and MacrParameters
MacrDebugging options
Macrfunctions
ProcSQL
Basic Clauses
Merging
MacrVariable in Proc SQL
Retain, Sum, Arrays and Output Statements.
Advanced SAS
Proc Corr
Proc Ttest
Proc Gplot
Proc LifeTest

Clinical Domain
Clinical Trials Glossary
Responsibilities of SAS Programmer in the Pharma Industry for FDA Submission
Protocol 
SAP – Statistical Analysis Plan
CRF & aCRF– Case Report Form
CDISC with Real Time Assignments
SDTM – Study Data Tabulation Model
ADAM – Analysis Data Model
TLF’s – Tables, Listings and Figures  - With Real Time Assignments
Oncology Domain – With Real Time Assignment

Oracle ADF Training Program

Introduction to Fusion and ADF
Describing Fusion architecture
Explaining how ADF fits into the Fusion Architecture
Describing the ADF technology stack (MVC)
More about ADF

Getting Started with JDeveloper
Listing JDeveloper benefits for application development
Using the features of the JDeveloper IDE
Defining IDE preferences
Creating applications, projects and connections in JDeveloper
 
Modeling the Database Schema
Creating a database diagram
Generating changes to the database
Importing database objects without a diagram
Importing tables

Building a Data Model with ADF Business Components
Types of ADF Business Components
Creating Business Components from tables
Testing the data model

Querying and Persisting Data
Using View Objects
Using Entity Objects to persist data
Synchronizing entity objects with database table changes
Creating associations
Creating updatable view objects
Creating master-detail relationships
Refactoring

Exposing Data to Clients
Creating application modules
Using master-detail view objects in application modules
Managing business components transactions
Abstracting business services with ADF model

Declaratively Customizing Data Services
Internationalizing the data model
Editing business components
Modifying default behavior of entity objects
Changing the locking behavior of an application module

Programmatically Customizing Data Services
Generally java classes
Programmatically modifying the behavior of entity objects
Programmatically modifying the behavior of view objects
Adding service methods to an application module
Using client APIs

Validating User Input
Understanding validation options: Database, Data Model or UI
Triggering validation execution
Handling validation errors
Using groovy expressions in validation
Using programmatic validation

Troubleshooting ADF BC Applications
Troubleshooting the business service
Troubleshooting the UI
Using logging and diagnostics
About web services sample client

Understanding UI Technologies
Describing the use of web browsers and HTML
Describing the function of servlets and JSPs
Explaining the JSF component architecture and JSF component types
Explaining the purpose of backing beans and managed beans
Describing the JSF life cycle
Explaining how ADF faces augments the JSF life cycle

Binding UI Components to Data
Creating a JSF page
Adding UI components to a page
Describing the ADF model layer
Using expression language in data bindings
Using a page definition file
Examining data binding objects and metadata files
Binding existing components to data
Running and testing the page

Planning the User Interface
Describing the model-view-controller design pattern
Differentiating between bounded and unbounded task flows
Creating and converting task flows
Defining control flows
Defining global navigation
Creating routers for conditional navigation
Calling methods and other task flows
Implementing validation in the user interface

Adding Functionality to Pages
Internationalizing the user interface
Using component facets
Displaying tabular data in tables
Displaying hierarchical data in trees
Displaying text or media with icons and images
Defining search forms and display results
Displaying data graphically

Implementing Navigation on Pages
Using ADF faces navigation components
Using buttons and links
Using menus for navigation
Using breadcrumbs
Using a train component

Achieving the Required Layout
Using complex layout components
Explaining how to use ADF faces skins
Using dynamic page layout

Ensuring Reusability
Designing for reuse
Using task flow templates
Creating and using page templates
Deciding which type of reusable component to use

Passing Values between UI Elements
Defining the data model to reduce the need to pass values
Using a managed bean to hold values
Using page parameters
Using task flow parameters
Passing values from containing pages to regions

Responding to Application Events
Using managed beans
Coordinating JSF and ADF lifecycles
Using phase and event listeners
Using action listeners and methods
Understanding additional AJAX events

Implementing Transactional Capabilities
Handling transactions with ADF BC
Using task flows to control transactions
Sharing data controls
Handling transaction exceptions
Defining response to the back button

Implementing Security in ADF BC Applications
Exploring ADF application security options
Understanding ADF security framework
Enabling users to access resources
Implementing to login page
Understanding ADF controller authorization
Using exception language to extend security capabilities

Deploying ADF B Applications
Creating deployment profiles
Configuring deployment options
Deploying an application with JDeveloper
Deploying an application with WebLogic Server Administration console
Automating the deployment process with Ant

Oracle DBA Training Program

Introduction to Oracle 11g
Oracle database product offering
Relational database concepts
Applying data modeling techniques
Oracle database tools: SQL developer and SQL* Plus

Database Installation & Administration 
Assessing Oracle database architecture
Managing Oracle databases
 
Accessing and Manipulating Data
Retrieving data efficiently with SQL developer
Applying powerful SQL techniques
Modifying Data with SQL Statements

Creating and Managing Database Objects
Implementing physical design
Constructing and maintaining tables
Building views, sequences and synonyms

Maintaining Integrity, Security and Performance
Enforcing integrity
Securing data
Improving performance

Programming with PL/SQL
Writing basic programs
Processing data with cursors

Implementing Server-side Logic
Modularizing code
Creating packages and triggers

Introduction to Oracle Database 11g Administration
Configuring instance and database
Maintaining security
Balancing user requirements and resources
Ensuring database availability
Oracle 11g Architecture

Building Oracle 11g Database
Creating database
Setting initialization parameters
Establishing network connectivity
Configuring control files and redo log files
Starting and stopping database
Mounting and opening database with SQL *PLUS
Authentications
Closing database and shutting down instance

Automating Database Management
Oracle enterprise manager architecture
Administering with database control

Performing Flashback Operations
Managing space for rollback and read consistency
Resetting data to recent points in time with flashback

Securing database
Establishing user accounts
Enforcing security

Controlling Database Storage
Defining logical and physical structures
Configuring storage patterns for database objects

Partitioning to Support Administration and Availability
Creating table partitions and sub-partitions
Maintaining index partitions
Maximizing performance with local and global indexes
Monitoring index partition usage
Rebuilding unusable indexes