SAP EHS Course Content

SAP  - Environmental, Health and Safety 
About the Training Program

Session      Particulars                                  Duration

EHS01             SAP Overview                                              2Hrs

EHS02             EHS Overview                                              2Hrs
EHS03             ASAP Methodology (Stages of Project)           4Hrs
EHS04             Introduction to ERP                                      2Hrs
EHS05             Familiarization with SAP                               2Hrs
EHS06             Basic Data & Tools                                       2Hrs
EHS07             Product Safety – I                                         2Hrs
EHS08             Product Safety –II                                         2Hrs
EHS09             Hazardous Substance Management – I           2Hrs
EHS10             Hazardous Substance Management – II          2Hrs
EHS11             Dangerous Goods Management – I                 2Hrs
EHS12             Dangerous Goods Management – II                2Hrs
EHS13             Industrial Hygiene and Safety – I                   6Hrs
EHS14             Industrial Hygiene and Safety – II                  6Hrs
EHS15             Waste Management – I                                 2Hrs
EHS16             Waste Management – II                                2Hrs
EHS17             Occupational Health – I                                 3Hrs
EHS18             Occupational Health – II                                3Hrs
EHS19             Reporting System (WWI)                              2Hrs
EHS20             Basic Workflow                                            2Hrs
EHS21             Roles And Profile Definition                          2Hrs
EHS22             Resume Preparation                                     2Hrs
EHS23             Mock Interview and Interview tips                2Hrs
EHS24             Cross Application Components for                2Hrs

                       Integration with SAP EHS information        

         Total Working Hours                          60 Hrs

SAP Environmental Health and Safety 

Week 1

Basic Data & Tools

• Specification Work Bench
• Report Definition
• Phrase management
• Substance Work Bench

Week 2

Product Safety

• Report Management
• Global Label Management
• MSDS, SARA
• Report Template

Week 3

Hazardous Substance Management &

Industrial Hygiene and Safety

• Work Area Management
• Exposure Profile Management
• Risk Assessment
• Measurement Management
• Incident / Accident management
• Reports

Week 4

Dangerous Goods Management

• Basic Data, Master Data
• DG Checks and Documents
• Template Processing
• DG Customization
• Reporting

Week 5

Waste Management

• Basic Data, Master Data
• Waste Generators, Transporters, Disposers
• Disposal Processing,
• Reporting

Week 6

Occupational Health

• Basic Data ,
• Schedule Planning,
• Medical Service
• Injury/Illness Log
• Reporting

SAP EHS Course Content

SAP - Environmental, Health and Safety

About the Training program 

Session      Particulars                                    Duration  

ABAP Content

Course content of SAP ABAP module

1) Introduction to SAP
  * Introduction to ERP
  * Overview of SAP
  * SAP modules at a Glance

2) ABAP Data Types
  * Character
  * Integer
  * Numeric Character
  * Floating Point
  * Packed Decimals
  * Time
  * Date, Strings

3) Loops & Branches
  * Do, Do n times, While
  * If, If Else, if Ladder, Case
  * Small Programs
  * Indentation
  * Code Inspector
  * Extended Program Check

4) Structures & Internal Tables
  * Over View of Structures
  * Similar Structures creation
  * Different Structures
  * Different structures with Extra Fields
  * Over View of Internal Tables
  * Similar Internal tables creation
  * Different Internal tables
  * Different Internal tables with Extra Fields
  * Modify Operation on Internal Table
  * Delete Operation on Internal Tables

  * Sorting Of internal tables ( Sort)
  * Searching Techniques Of internal Table
  * Field Symbols Operations

5) Landscape & SAP R/3 Architecture
  * Landscape Model
  * Overview of R/3

6) Normalization & Select Statements
  * Over view of Normalization
  * Select Statements
  * Logical operators
  * Select Single & Up to 1 rows
  * Nested Select queries
  * For all Entries
  * Join Statements
  * Inner join & Left Outer Join

7) Modularization Techniques
  * Over view of Modularization
  * Includes
  * Subroutines
  * Function Modules

8) Selection Screen Design
  * Over View of Selection Screen
  * Selection Screen elements

9) Basic Report
  * Over view of Report
  * Report without events
  * Report with events ( Classical report)
  * Interactive Report
  * Menu Design
  * Message class Creation
  * Text messages creation
  * Hide Technique
  * Read Line Statement
  * At Events ( control Events)
  * Variant Creation
  * Transaction Code Creation
  * End User access

10) BDC (Batch Data Communication)
  * Over view of BDC
  * GUI Up load
  * GUI Down load
  * BDC Programming
  * Call Transaction
  * Session Method

11) Data Dictionary
  * Creation of Data Base Table
  * Creation of Domains
  * Creation of Data types
  * Creation of Views
  * Creation of Structures
  * Creation of Type pools
  * Creation of Search Help
  * Creation of Lock objects
  * Creation of table maintenance

12) Module Pools
  * Over view of Module pools
  * Creation of Create button
  * Creation of Display
  * Creation of Sub screens
  * Creation of Tab Strip
  * Creation of Table Control
  * Creation of Save button to update Data Base

13) Sap Scripts
  * Over view of Scripts
  * Creation of Paragraphs
  * Creation of Character Formats
  * Creation of Pages
  * Creation of Windows
  * Creation of Page windows
  * Creation of Script program

Cross Applications

14) RFC
  * Over view of CA
  * Creation of RFC
  * Fetching Data Using RFC
  * ARFC & TRFC

15) ALV (ABAP List Viewer)
  * Over view of ALV
  * ALV List Display
  * ALV Grid Display
  * ALV Catalog Creation
  * Blocked ALV

16) BAPI
  * Over View Of BAPI
  * Remote FM Creation
  * Creation of BOR
  * Creation of BAPI
  * Check The Status of BAPI
  * Super type Creation

17) SMART FORMS
  * Over view of Smart Forms
  * Creation of Paragraphs(Styles)
  * Creation of Character Formats(Styles)
  * Creation of Pages
  * Creation of Windows
  * Creation of Page windows
  * Creation of table format
  * Creation of Smart Form program

18) LSMW
  * Over view of LSMW
  * Creation of Project , Sub Project , Object Type
  * Creation of Batch Input Using Recording Mode
  * Steps To Create LSMW

19) ALE/Idocs
  * Over view of ALE/ IDOcs
  * Creation of RFC Destinations
  * Creation of Ports
  * Creation of Partner Profile
  * Creation of Distributed systems
  * Transfer the data Btw sys

20) Overview on Object Oriented ABAP and Webdynpro

Oracle 11g Course Content

Oracle 10g/11g - SQL & PL/SQL

The Oracle database environment

• Reviewing basic architecture concepts
• Oracle 10g Architecture
• Main features of 9i and 10g

Basic SQL*PLUS commands

• Using script files, START, @, GET, SAVE, LIST, PROMPT, PAUSE, ACCEPT, DEFINE, SPOOL

Basic SELECT Statement

• Writing the statement in sql plus, Running the SELECT statement

Ordering the output

• Single Column, Descending order, multiple column sorts

Conditional retrieval of data

• Working with complex conditions, AND OR NOT LIKE BETWEEN

Working with variables

• Creating and using variables, Command substitution

Pseudo columns and functions

• Pseudo Columns, Row num, Sys date, User & UID, the Dual Table Working with character functions UPPER, LOWER, INITCAP, RPAD(), RTRIM(), SUBSTR(), INSTR(),TRANSLATE(), REPLACE(), GREATEST(), LEAST(), DECODE Working with date functions TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY()

Using non-character function

• ROUND (), TRUNC (), SIGN (), Working with multiple tables, Different type of Joins, Writing Outer Joins

Using the SET operators

• Union, Intersect, minus

Aggregating data using group functions

• GROUP BY, HAVING

Creating Sub queries

• Single Row sub queries, Multiple row Sub queries

Enhancing groups function

• ROLLUP, CUBE

Transaction Control Language

• Rollback, Commit, save point

Processing hierarchies

• creating the Tree structure, LEVEL, CONNECT BY

Data Manipulation Language

• INSERT, UPDATE, DELETE

Data Definition Language

• CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE

Using Declarative Constraints

• Views, Sequences, Synonyms, Indexes, USER_TABLES, USER_TAB_COLUMNS,
• USER_OBJECTS, USER_IND_COLUMNS, USER_UPDATEABLE_COLUMNS, Materialized
• Views, Other Data dictionary views

Database Security

• Object Privileges, Granting access to objects

Improving query performance

• Planning and managing the tuning process, Employing tuning tools, Running EXPLAIN PLAN and auto trace, SQL Trace and TKPROF output, Optimizer concepts, Fundamentals of access paths, Gathering object and system statistics with DBMS_STATS, Utilizing hints and optimizer mode,Specifying first-rows optimization, Determining the driving table

Other Concepts

• The Relational Database Model, The system Development Lifecycle, Overview of normalization

PL/SQL

Blocks

• Structure, Writing Anonymous Blocks

Variables

• Oracle Data types, TYPE and ROWTYPE declarations, Value assignments

Control structures

• IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, LOOP END , LOOP statement, WHILE condition, FOR condition

Cursors

• Implicit and Explicit Cursors, Cursor Manipulation statements,OPEN FETCH CLOSE EXIT WHEN

Printing Values to Screen

Procedures

• Creating and Calling Procedures

Functions

• Creating and Calling Functions

Packages

• Package Header, Package Body

Design Tips and Techniques

• Format of standard packages in an application, Spec and Body, NOCOPY hint

Triggers

• Database triggers, calling procedures from triggers

Dynamic SQL

• EXECUTE IMMEDIATE, DBMS_SQL package

Oracle Supplied packages

• DBMS_OUTPUT, UTL_FILE

Collection data types

• Associative Arrays, Nested tables, VARRAYs

SharePoint Course Content

MOSS/Share Point 2007 Overview and Installation

• Introduction to MOSS
• Planning and Architecture of MOSS 2007
• Introduction to various versions of share point servers
• MOSS 2007 Architecture and its internal components
• WSS architecture
• Limitations and difference between MOSS and WSS
• Configuring default databases
• Prerequisites of share point server
• Installation of MOSS 2007

Share Point 2007 Technologies

• Introduction to web application
• Introduction to share point high level components
• Introduction and using of libraries and list items
• Managing libraries and lists
• Create and managing workspaces, sites and pages
• Security trimming

Document Management and Content Management

• Creating and managing document libraries
• Creating and managing form libraries
• Creating and managing wiki page
• Creating and managing Data links library

User Communications, lists and Custom list items

• Announcements
• Contacts
• Discussion board
• Links
• Calendar
• Tasks, project tasks
• Issue tracking and survey
• Custom list
• Alerts

Users Permissions and Access Levels

• Introduction to security
• Access level
• User permission and management

Sits, pages, Master pages, MOSS Designer and Branding

• Creating custom site as templates
• Creating custom pages and designing
• Creating Master pages
• Creating designer based pages
• Creating designer based web parts
• Creating designer based database web parts & web services based web parts

Introduction to Infopath

• Understanding infopath
• Use the system templates
• Create custom templaes
• Create xml based templates and publish to Moss
• Create Database templates and publish to Moss
• Create Web service based templates and publish to Moss

Sites Customization

• Site themes customization
• Site templates customization
• Custom templates
• Uncustom templates

Form based Authentication

• Introduction to FBA
• Creating and configuring FBA
• Creating FBA Users
• Authenticate FBA users

Shared Services Providers (SSP)

• Introduction to SSP
• Creating SSP
• Default SSP and Changing Association of SSP
• Using MY Site and My links
• User Profiles
• Excel Services
• Office server search
• Business Data Catalogs
• Creating and Configuration of BDC Web parts

Introduction to Webparts

• Webpart architecture
• Create and deploy web part
• Create web part and deploy with server controls
• Debugging web parts

Introduction to MOSS API

• Using MOSS API object model
• Access sites, Document Libraries or List items
• Update list items from data base and flat files

Work Flows

• Workflows introduction
• Creating workflows
• Accessing workflows
• Managing workflows

Administration

• Share point web application management
• Share point site management
• Infopath forms services
• Office share point server shared services
• Application security
• External service connections
• Workflows management
• Topology and services

QA Testing Course Content

MANUAL TESTING

SDLC

• What are the different phases of SDLC?
•  How does the process of Software Development Start?
•  Project Initiation
• Requirement Gathering and Analysis
• What is Requirement document and what it contains?
• What is use case document and what it contains?
• What is Basic path and Alternate Path?
• Role of Business Analyst
• Example for explaining each phase
• Role of technical specification team
• What is Technical specification document?
• What is System Design?
• Role of Design team
• What is design document?
• Role of architecture team
• System development
• Role of development team
• Deliverable of Development phase
• System testing
• Role of testers and types of testing
• User acceptance testing
• System deployment
• System maintenance
• Events in the maintenance phase like bug fixes

STLC

• How are the phases of STLC carried out?
• What is testing?
• Role of testers
• Why do we need to test?
• Activities involved in the testing phase
• What is test plan and test case document?
• Steps of test case execution
• What does test case document contain?
• How to write test case document?
• What is required to test any application?

TEST CASES

• What is test case?
• What does test case document contain?
• How to write test case document?
• Different test case techniques

TEST PLAN

• What is Test Plan?
• How to write test plan document?
• What does the test plan document contain?
• Who writes and approves the test plan document?
• How manage the test case documents?
• What is the pass/fail criterion?

TYPES OF TESTING

• Different Phases of testing
• What is unit testing?
• What is Minimum acceptance testing?
• What is integration, system and system integration testing?
• What is User acceptance testing?
• What is Regression Testing?

DEFECT ANALYSIS

• What is a defect?
• Various Defect tracking tools
• How to use the defect tracking tools?
• How to enter the details of defect in the defect tracking tool?
• How to identify a defect?
• What is severity and priority?

TRACEABILITY MATRIX

• What is Traceability Matrix[TM]?
• Who Prepares the TM document?
• What is the reference for writing TM?
• What is the use of TM?
• What is present in the TM document?
• Sample TM
• Tools used for developing TM 

Various Teams and their Roles

• Configuration Management Team
• Role of configuration management team
• What is Deployment?
• Deployment Team
• Role of Deployment team
• Version Control
• Various version tools and its usage
• Difference between QC and QA
• What is automation testing?
• Why, what and when to automate?
• Various tools used for automation testing

MANAGEMENT TOOL

QUALITY CENTER

• Introduction to Quality Center
• What is Quality Center ?
• Why to use Quality Center
• Version of Quality Center
• Overview of quality Center user interface
• Various tabs in Quality center
• Requirement Module
• Requirement Module Overview
• Creating Requirement tree
• Creating Parent & Child requirements
• Understanding the Description tab
• Understanding the History tab
• Uploading attachments to requirement
• A glance at various columns in requirement
• Types of views in requirement module
• Requirement grid view
• Requirement coverage view
• Test Plan Module
• Creating folder structure
• Create test cases
• Requirement coverage
• Test Lab Module
• Overview of Test Lab
• Detail of various tabs
• Creating folders
• Creating Test sets
• Adding test cases
• Different columns in Execution Grid
• Execution Flow tab
• Scheduling Test runs
• Test Set Properties tab
• Linked Defects tab
• Running Tests manually
• Running Tests automatically
• Viewing Test results
• Quality Center Defects
• Overview of Defects
• Creating defects after test execution
• Adding defects in defect module
• Creating defects during test execution
• Linking Defects
• How to close a defect
• Closing defects after retest
• Mailing the defects
• Quality Center reports & graphs
• Why Reports & Graphs?
• How to create reports & graphs for Analysis?

AUTOMATION TESTING: QUICK TEST PROFESSIONAL

Introduction to QTP

• What is QTP
• Prepare Before Automation
• Application Under Test
• First look at Add-Ins for QTP
• Understanding the QTP User Interface
• Setting up preferences in QTP before recording.

Different versions of QTP(Text based)

• Difference between QTP 9.0 and QTP 8.2.
• Difference between QTP 9.2 and QTP 9.0
• Difference between QTP 9.5 and QTP 9.2.

Record and run a script

• Record a simple script
• Save the script
• Run the test script
• Understand the result

Introduction to Object Repository

• What is Object Repository
•  Types of Object Repository
• Object Repository Manager
• Associating shared Object Repository with test

Shared Object Repository

•  Local Object Repository
• Create a shared Object Repository
• Add objects to shared Object Repository
• Save an shared Object Repository
• Modify the shared Object Repository
• Comparing Local and Shared Object Repository

Synchronization

• What is Synchronization
• Synchronization in QTP
• Add Synchronization Steps for an Object

Check Point

• What is Check Point
• Using Standard Check Point
• Using Text Check Point
• Using Access ability check point
• Using XML Check Point

Database checkpoint

• What is database checkpoint
• Writing SQL Query using Microsoft Query
• Parameterize a database checkpoint

Output Values

• What is Output value
• Using Standard Output value
• Using Text Output value
• Using Database Output value
• Using XML Output value

Data Driven Test

• What is Data Driven test
• What is Parameterization

Actions

Regular Expression

JAVA Course Content

CORE JAVA

·         After all having a lot number of programming languages.

·         Why JAVA; yet another language!!!

·         AND NOW WHY ONLY JAVA???

PART-1

Basics & Core Components

Features and History

·         JVM Architecture and BYTECODE

·         A little bit of CODE & Class files

·         Data types Operators

·         Control Constricts

·         Arrays

·         String Handling-using String, String Buffer classes

·         OOPS and OOPS in JAVA

·         Classes and Objects

·         Methods and Constructors

·         Packages and Interfaces

·         Access specifies

·         Exception Handling

·         Threads and Multithreading

·         Wrapper Classes, Inner classes

·         Applet Programming

PART-2

Java API (The Java Class Libraries)

·         'Java.lang'-Java'slanguage Fundamentals

·         'Java.io'-Java's I/O Mechanism

·         'Java.util'-Utilities & Collections Framework

·         'Java.awt.event'-GUI Applications using Java

·         'Java.net'-Socket Programming

·         'Javax.swing'-Java's Extended GUI Programming

·         Attentions & annotations

ADVANCED JAVA

Database Programming using the JDBC API:

·         The X/OPEN Call Level Interfaces

·         Database Connectivity & ODBC Concepts

·         The JDBC mechanism-Connecting to a DB

·         Types of JDBC Drivers

·         The steps in implementing a JDBC application

·         Types of statements, Result Sets etc.

·         Introduction to JDBC 3.0 AP!

Java Servlet v2.4 Technology:

·         CGI Vs Servlets

·         Introduction to web designing

·         Introduction to the web servers

·         HTTP Protocol-Status codes, request methods

·         Deployment descriptors

·         Servlet Lifecycle

·         Types of servlets

·         Servlet API 

·         Sessions & Session tracking

·         Cookies

·         Servlet changing and dispatching

·         Filtering

Java Server Pages:

·         Overview

·         Comparing with the other technologies

·         JSP Architecture

·         Implicit Objects

·         Elements of JSP (Comments, Experessions, Scriptlets, Declarations, actions)

·         JSP Directives

Pageilinclude, taglib

·         Scopes

·         JSP & JDBC

·         JSP & Java Beans-The 'use bean' tag

·         Tag Libraries (JSTL)

Case Study 1

·         Convert the previous site from servlets using the JSPs

Case Study 2

·         Develop a full-fledged shopping (art web applications)

Introduction to Distributed computing

·         Introduction to Distributed computing

Remote Method Invocation (RMI):

·         Introduction to remoting

·         RMI Architecture

·         Stubs 7 skeletons

·         RMI-IIOP

COBRA

·         Introduction to OMG

·         Difference between RMI and COBRA

·         The 'ORB' Protocol

·         COBNRA and Java

·         IDL

·         SAMPLE APPLICATION USING cobra AND Java

J2EE-Java 2.0 Enterprise Edition

J2EE Overview

·         Introduction

·         Components of J2EE

·         Modularization of components-The 3-tier Architecture

Enterprise Java Beans (EJB):

·         Introduction to EJB 2.0

·         Deployment Descriptors for various Application servers

·         Lifecycle of EJB

·         The EJB trilogy-Session Beans, Entity beans, message Driven Beans

·         Session Beans-Stateless, Stateful

·         Life cycle

·         Deployment

·         Areas of Applications

·         Entity Beans-CMP, BMP

·         Life cycle

·         Deployment

·         EJB QL

·         Areas of Applications

Message Driven Beans-'the new entrant into the EJB specification

·         Introduction to JMS and Java Mail

·         Types of Messaging Domains-PTP,Pub/Sub

·         MOM

·         Life cycle

·         Deployment

·         Areas of Applications

·         Configuration of messaging servers

EJB and J2EE Services

·         Transactions

·         Services

·         Attributes

·         ACID Properties and the 2PL Protocol

·         JTAPI

·         Security

·         Bean Management

·         Lazy Loading

·         Dynamic Loading

·         Pooling and Data Sources

·         Relationships-O/R mapping

Developing EJB Clients

·         Introduction to Naming and directory Services

·         The JNDI API

·         LDAP

Struts Framework

·         Introductions to the MVC1 & MVC2 Architecture

·         Overview of struts Framework

·         Components of Model, Vies and Controller

·         Action Classes

·         Forms, Form beans and Dyna Form

·         The Validator plug-in

·         The Tiles plug-in

·         Deployment descriptors

Design Patterns

·         Overview

·         Types of patterns

·         Factory pattern

·         Signleton Pattern

·         Front Controller

·         Session Facade

·         Message Facade

·         DAO

·         DTO

·         Intercepting filter

JDBC Direct Read Design Patterns

·         JDBC Direct Read Design Patterns

XML & Web Services

·         Introduction to XML

·         DTDs, Schemas and Namespaces

·         XML Parsers (SAX and DOM)

·         Interoperability between application Web services

·         SOAP

·         WSDL

·         UDDI

SERVERS

·         TOMCAT 5.5/6.0

·         Web logic 10.X

·         Web sphere 6.X

·         JBOSS 4.X

IDES

·         Eclipse 3.X

·         Net beans 5.5/6.X

·         RAD 6.X

EXTRA TOOLS

·         Log4I

·         ANT

·         JUNIT

Frameworks

·         Hibernate

·         Springs