IT Training Courses
IT Training Courses

Do you need IT and Project Management Training ?

COMNet Group can help with your IT Training Needs!  Please call our support numbers now:


North Carolina: 

Charlotte Area: (704) 323-7762

RTP Area: (919) 827-4364


South Carolina: 

Rock Hill : (803) 403-1970



Chicagoland Area: (847) 458-8281


or send us an email at




Schaumburg/Hoffman Estates Area:

COMNet Group Inc.

2815 Forbs Avenue, Suite 107

Hoffman Estates, IL 60192



Gurnee/Waukegan/Grayslake/Lake Forest Area:

COMNet Group Inc.

100 Saunders Road, Suite 150

Lake Forest, IL 60045


Naperville/ Oakbrook Area:

COMNet Group Inc.

4320 Winfield Road, Suite 200

Warrenville, IL 60555





University Executive Park Area


COMNet Group Inc.

301 McCullough Drive, Suite 400

Charlotte, NC 28262

Phone: (704) 323-7762



Cary/Raleigh Area - Weston Parkway


COMNet Group Inc.

5000 Centregreen Way, Suite 500

Cary, NC 27513

Phone: (919) 827-4364





Rock Hill:

COMNet Group Inc.

331 East Main Street, Suite 200

Rock Hill, SC 29730

Phone: (803) 403-1970





Santa Clara / Silicon Valley:

COMNet Group Inc.

5201 Great America Pkwy, Suite 320
Santa Clara, CA 95054

Phone: (408) 916-4937


Technical Business Management

Program Description



Technical business Mgmt. to provide Management Professional Certification (PMP) (Current Edition Aligned) along with three Electives


Our Technical management courses comprises of Project management, Six Sigma Green Belt and Agile project management with SCRUM along with the three below courses chosen as electives.

This course prepares students to become proficient in Technical and Business Management irrespective of the domain (finance, IT, insurance, marketing, sales). This course provides students with the knowledge and skills needed to master the project management concepts and attain the Project Management Professional (PMP®) certification along with three of the electives selected.  The students must choose three of the courses from the following: 1. Agile project management with SCRUM 2.  Lean Six Sigma Green Belt 3. ITIL V3 foundations 4. Java Programming 5. SAP CRM 6. SAP SD 7. Quality Assurance 8. ETL

This course is intended to enhance a student’s  IT management experience with global terminology and the proven framework for leading and directing project teams and in delivering project results within the constraints of schedule, budget and resources.


The prerequisites for this course are the same prerequisites that PMI requires for you to become a certified PMP:

Bachelor’s degree or global equivalent and 3 years of project management experience

High school diploma or global equivalent and 5 years of project management experience

Who Should Attend

This course is designed for persons who have on the job experience performing project management tasks, whether or not project manager is their formal job role, who are not certified project management professionals, and who might or might not have received formal project management training. The course is appropriate for these persons if they wish to develop professionally, increase their project management skills, apply a formalized and standards-based approach to project management, seek career advancement by moving into a formal Project Manager job role, as well as to apply for Project Management Institute, Inc. (PMI®) Project Management Professional (PMP®) Certification. “Project Management Professional” and “PMP” are registered


    Project Management Professional (PMP)


    PMP Current Edition


This course qualifies for 35 PDUs or 35 Contact Hours for candidates pursuing PMP Certification. PMI requires you to have 35 contact hours to apply for the PMP exam.


Initiating, Planning, Executing, Monitoring and Controlling and Closing a project across the knowledge areas of Integration, Scope, Time, Cost, Quality, Human Resources, Communications, Risk and Procurement.

Target Audience

The Project Management Professional (PMP) Certification course is intended for experienced Project Managers seeking educational hours for PMP certification, and is designed to prepare experienced project managers to sit for the PMP exam. Project Managers who have had no formal training on the concepts of the PMBOK Guide, Current Edition will enhance their skills in this in-depth course.

Lesson Objectives

Project Management Professional Certification (PMP)

Apply the concepts of the PMBOK Guide, current ed. to better manage projects in their work environment

Gain an understanding for the level of competency required for the exam

Reduce study time by focusing on the relevant exam topics

Understand the makeup and format of the PMP 2012 Exam

Comprehend the professional responsibility domain, process groups and knowledge areas of the PMBOK Guide, Current Edition


Lesson 1: Examining Professional Project Management

Identify Project Management Processes 
Identify Professional and Social Responsibilities 
Identify the Interpersonal Skills Required for a Project Manager

Lesson 2: Initiating a Project

Examine the Project Management Context 
Examine Project Selection 
Prepare a Project Statement of Work 
Create a Project Charter 
Identify Project Stakeholders

Lesson 3: Planning Project Work

Identify Elements of the Project Management Plan 
Document Stakeholder Requirements 
Create a Scope Statement 
Develop a Work Breakdown Structure

Lesson 4: Developing Project Schedules

Create an Activity List 
Create a Project Schedule Network Diagram 
Estimate Activity Resources 
Estimate Duration for Project Activities 
Develop a Project Schedule 
Identify the Critical Path 
Optimize the Project Schedule 
Establish a Schedule Baseline

Lesson 5: Developing Cost Estimates and Budgets

Estimate Project Costs 
Estimate the Preliminary Cost Baseline 
Reconcile Funding and Costs

Lesson 6: Planning Project Quality, Staffing, and Communications

Create a Quality Management Plan 
Document the Project Roles, Responsibilities, and Reporting Relationships 
Create a Communications Management Plan

Lesson 7: Analyzing Risks and Planning Risk Responses

Examine a Risk Management Plan 
Identify Project Risks and Triggers 
Perform Qualitative Risk Analysis 
Perform Quantitative Risk Analysis 
Develop a Risk Response Plan

Lesson 8: Planning Project Procurement

Plan Project Procurements 
Prepare a Procurement Statement of Work 
Prepare a Procurement Document

Lesson 9: Executing Project Work

Identifying the Direct and Manage Project Execution Process 
Execute a Quality Assurance Plan 
Acquire the Project Team 
Develop the Project Team 
Manage the Project Team 
Distribute Project Information 
Manage Stakeholder Relationships and Expectations

Lesson 10: Managing Project Procurement

Identify the Conduct Project Procurements Process 
Obtain Responses from Sellers 
Determine Project Sellers

Lesson 11: Monitoring and Controlling Project Work

Identify the Monitor and Control Project Work Process 
Develop an Integrated Change Control System 
Utilize the Integrated Change Control System 
Review Deliverables and Work Results 
Control the Project Scope

Lesson 12: Monitoring and Controlling Project Schedule and Costs

Control the Project Schedule 
Control Project Costs

Lesson 13: Monitoring and Controlling Project Performance and Quality

Perform Quality Control 
Report on Project Performance

Lesson 14: Monitoring and Controlling Project Risk and Procurements

Monitor and Control Project Risk 
Administer Project Procurements

Lesson 15: Closing the Project

Close Project Procurements 
Close the Project or Phase Administratively


ITIL Certification


ITIL is a method of IT service management that provides a thorough set of IT best practices drawn from years of experience in both the public and private sector. This course covers the latest version of core ITIL best practices presented from a lifecycle perspective. The course introduces the principles and core elements of IT service management (ITSM) based on the current ITIL Edition.
Start your ITIL Certification process with the ITIL Foundations course.

Who Should Attend

IT Professionals, IT Support Staff, Application, Project and Business Managers, Any member of an IT team involved in the delivery of IT Services.



Lesson 1: Introduction

Introduction to key ITIL concepts 
IT as a Service 
Introduction to processes and process management 
The Service Lifecycle approach

Lesson 2: Service Strategy

Purpose, goal, objectives & Scope 
Value Creation through Services 
Assets – Resources and Capabilities 
Service Strategy – Main activities 
Service Strategy processes 
Service Portfolio management 
Demand management 
Financial management

Lesson 3: Service Design

Purpose, goal, objectives & Scope 
Service Design processes 
The 4 P’s 
Service Design aspects 
Service Catalog Management 
Service Level Management 
Capacity Management 
Availability Management 
IT Service Continuity Management 
Service Portfolio 
Information Security Management 
Supplier management

Lesson 4: Service Transition

Purpose, goal, objectives & Scope 
Service Transition value to the business 
Technology and architecture in Service Transition 
Service Transition Processes 
Change Management 
The 7 R’s of Change Management 
Service Asset and Configuration Management 
Release and Deployment Management 
Knowledge Management

Lesson 5: Service Operation

Purpose, goal, objectives & scope 
Service Operation definitions 
The Service Desk 
Technical Management 
Application Management 
IT Operations Management 
Service Operations Processes 
Event Management 
Request Fulfillment 
Problem Management 
Access Management

Lesson 6: Continual Service Improvement

Purpose, goal, objectives & scope 
Models and Processes 
The Deming Cycle 
Measurement and metrics 
Continual Service Improvement activities 
Risk management 
Continual Service Improvement interfaces 
Interface with Service Level Management

Lesson 7: Exam Preparation

Sample Exams 


LEAN Six Sigma Green Belt

The accelerated Lean Six Sigma Green Belt program and methodology allows students to complete certification requirements faster than traditional Six Sigma and Lean training programs.


Lesson 1: Lean Six Sigma Introduction

Introduction to Lean Six Sigma 
Overview Lean Six Sigma Principles & Terminology 
Roles and Responsibilities in a Lean Six Sigma Organization 
Value Stream Maps 
7 Wastes 
Project Selection

Lesson 2: Define Phase

Voice of Customer 
Project Charter 
Process Mapping (high level and detailed mapping)

Lesson 3: Measure Phase

Selecting Measures: Y=(f)x 
Data Collection Planning 
Baseline Data Collection 
Basic Statistics

Lesson 4: Analyze Phase

Process Analysis (Non-Value Add vs. Value Add) 
Graphical Analysis 
Determining Root Cause

Lesson 5: Improve Phase

Lean Solution Concepts: Standard Work, Batch Size Reduction, Work Cells, Kanban, Pull Systems and Kaizen Events 
Brainstorming Solutions to Address Root Cause 
Solution Selection, Pilot and Implementation 
Improvement Data Capture

Lesson 6: Control Phase

Monitoring, Revision and Response Plans 
Mistake Proofing and Visual Management 

Lesson 7: Green Belt Test


Agile Project Management


Develop quality software systems and products in reduced time using Agile practices

Mitigate uncertainty and risk by applying Agile values and principles

Apply the Scrum framework to meet the specific operational needs of your business

Focus on continuous improvement through embedded learning in the workplace

Adapt techniques to apply Scrum to large-scale and geographically distributed projects


Who Should Attend
Project and program managers, software architects, systems analysts, team leaders, developers and anyone interested in applying Scrum and Agile methodologies.



  • Articulating Agile values and principles
  • Comparing Agile with traditional, master plan methods
  • The myths and realities of Agile software development
  • Locating Scrum in empirical process theory


Fundamentals of Scrum for Dealing with Uncertainty and Risk

Identifying the roles and their responsibilities


  • Prioritizing requirements and driving the project through the Product Owner
  • Establishing the Scrum Master as a fundamentally new management role
  • Shaping the self-managed Feature Team
  • Relating to external stakeholders


Managing product delivery


  • Creating a product backlog as a list of requirements and technical issues
  • Iterating development through cycles of one month or less
  • Time boxing to establish a regular rhythm of energized work


Tools for tracking and monitoring a project


  • Capturing requirements as user stories
  • Establishing performance targets using a team's velocity
  • Plotting remaining work with burn down charts and parking lot diagrams
  • Managing development tasks with task boards


Planning an Agile Project

Focusing on business value


  • Delivering business-valued functionality with Release Planning and Sprint Planning
  • Collaborating with customers to manage risk and uncertainty
  • Demonstrating implemented features as "potentially shippable increments"


Identifying features for development in an iteration


  • Breaking large requirements into testable, estimable features
  • Concretizing a Sprint Goal through feature selection
  • Identifying development tasks in the Sprint Backlog


Fostering Self-Management within the Development Team

Creating the optimal working environment


  • Staffing the Feature Team
  • Protecting the team from outside interference
  • Making project progress visible and open


Transitioning to self-management


  • Facilitating cross-functionality and team learning
  • Empowering the team to control their own development process
  • Adapting management roles external to the development effort

Running iterations

  • Micro planning through Daily Scrum meetings
  • Producing a quality-assured, business-valued product
  • Determining what it means to be "done"

Managing Change

Generating rapid feedback through Sprint Reviews


  • Demonstrating completed functionality to the customer
  • Fostering collaboration with stakeholders through discussion of "done" increments
  • Revising estimates on the basis of experience


Reviewing iterations through Sprint Retrospectives


  • Reflecting on lessons learned
  • Embedding new knowledge to maintain continuous improvement

Applying Agile throughout Your Organization

Scaling for large projects


  • Working with large Product Backlogs
  • Scaling the Product Owner role
  • Coordinating Feature Teams and Component Teams


Managing distributed development


  • Release and Sprint Planning for distributed teams
  • Ensuring effective communication across time zones
  • Holding distributed Sprint Reviews and Sprint Retrospectives


Establishing momentum for successful adoption of Agile methods


  • Assessing the organization's readiness for Agile adoption
  • Creating an Improvement Backlog for ongoing improvement


Java Programming


Java is an object-oriented programming language. Java is in the same family as C and C++ and solves many of their complexities (pointers, memory allocation, multiple inheritance, etc.). Java is also a portable language, and compiled Java programs run without recompilation on MAC, Microsoft Windows, UNIX and other platforms.

Java is a mature language that can be used to write entire standalone or server applications. Java has become the dominant platform for modern software development for reasons of reliability, maintainability and ease of development.

Who Should Attend

Anyone developing Java applications that have previous experience with a programming language such as C, JavaScript, PHP or COBOL



Introduction to Java Programming

  • Stand-alone applications and servlets
  • Compiling source code into byte code
  • Overview of class libraries

Object-Oriented Programming with Java

The object paradigm


  • Encapsulation, inheritance and polymorphism
  • OO analysis and design: "Is a" and "Has a"
  • Designing an OO application step by step
  • Diagramming object structure with Unified Modeling Language (UML)


Java's object-oriented features


  • Instantiating objects from classes
  • Aggregation and composition
  • Extending existing classes
  • Overloading and overriding methods


Structure of the Java Language

Language syntax


  • Declaring and initializing variables
  • Declaring and using arrays
  • Upcasting, downcasting and autoboxing


Flow control


  • Invoking methods and passing parameters
  • Conditionals and loops
  • Handling exceptions with try and catch


Defining classes


  • Fields (instance data)
  • Methods (functions)
  • Abstract classes and interfaces
  • Organizing classes with packages and modifiers
  • Composition vs. inheritance


Building the components of a Java program


  • Leveraging generics with the collections API
  • Developing new classes
  • Compiling and debugging


Developing GUIs

Foundations of user interfaces


  • Basic GUI widgets
  • Event-driven programming
  • Benefits of a portable windowing library


Java Foundation Classes (JFC)


  • Creating Swing components
  • Adding Swing components to containers
  • Arranging Swing components using layout managers
  • Dialogs and message boxes


Event handling


  • Registering event handlers
  • Inner classes and top-level classes


Storing and Retrieving Data with File I/O

Java streams


  • Streams, Readers and Writers
  • Catching and throwing exceptions
  • Formatting text output
  • Reading and writing files
  • Creating, deleting and renaming files
  • Obtaining directory and file information

Files and directories


Working with Relational Databases

JDBC database access


  • Leveraging the JDBC API
  • Choosing database drivers
  • Connecting to a database

Improving performance with prepared statements and stored procedures


  • Submitting SQL statements
  • Retrieving and processing results
  • Java Development Kit (JDK)
  • Compiler (java)
  • Javadoc utility
  • Java Archive (JAR) utility
  • Java Integrated Development Environments (IDEs)


Java Development Tools



Recommended Java Courses after this class:

Java Best Practices and Design Patterns

Developing Java Web Applications

Struts 2 for Enterprise Java Web Development

Java EE: Integrating JSF, EJB and JPA

Enterprise Java with Spring and Hibernate Building Java Enterprise Applications

Building XML Web Services with Java



SAP (CRM – Customer Relationship Management)

More than ever, in today's challenging business environment, best-run companies are staying focused on their most valuable assets - their customers. Companies seek to retain their best customers and maximize the effectiveness of every customer interaction - whether it's sales, service, or marketing.

Armed with an understanding of the comprehensive functionality in SAP CRM, you can manage the entire customer life cycle efficiently and intelligently. You'll learn how to optimize key processes, leverage various analytics and reporting tools, and assess your performance.



  • My SAP CRM Solution Overview
  • Overview and Introduction to
  • Foundation & Architecture of mySAP CRM
  • mySAP CRM Analytics
  • mySAP CRM Marketing
  • mySAP CRM E-Commerce
  • mySAP CRM Channel Management
  • mySAP CRM Sales
  • mySAP Interaction Center
  • mySAP Service
  • mySAP Field Applications (with focus on Mobile Service)
  • mySAP CRM for Industries
  • Integration with other MySAP suite of modules


  • CRM Base Customizing
  • CRM Basic data & Customizing settings for these objects:
  • Business partner
  • Organizational model
  • Territory Management
  • Product master CRM Business Transactions
  • Overview of generic functions in business transactions
  • Activity Management (including Activity Journal and Groupware Integration)
  • Transaction type and item category customizing for these objects.
  • Middleware settings:
  • Middleware connections to R/3, APO and CRM
  • CRM Business Partner - CRM Middleware
  • CRM Middleware - Sales and Billing
  • Basic concepts of CRM middleware
  • Replication administration
  • Monitoring & error handling


  • Implement - Customer Interaction Center
  • Architecture landscape
  • Agent functions and processes in the IC
  • Define CIC Profile and Customer-Specific
  • Workspaces
  • Define Front-office framework
  • Component Configuration
  • Action Box Configuration
  • CTI Configuration
  • Client Implementation Case Study - Live Exercise


  • Implement Internet Sales
  • Architecture and landscape
  • Set up logical system and connection with OLTP R/3 and APO
  • Configuration of the CRM Server - Base Customizing
  • Configuration Web Application
  • Creating Product catalogs
  • Publication of Product Catalog content
  • Create Internet User for order processing
  • Sales Transactions using Internet Sales
  • Web Shop Maintenance
  • Client Implementation Case Study - Live Exercise


  • Implement CRM Marketing
  • Opportunity Management
  • Activity Management
  • Marketing Planning and Campaign Management (Marketing Planner, Product Selection, Partner Functions, Generic Actions, Campaign Execution)
  • Marketing Calendar
  • Customer Segmentation
  • External List Management


SAP (SD – Sales and Distribution)

This configuration course of SAP SD covers the latest release of SAP ERP Central Component 5.0 and 6.0. The course focuses on the complete end-to-end implementation of functionality related to the Sales and Distribution (SD) module. It will be helpful to SAP professionals who desire to utilize the SD module to its fullest capability.


Sales Overview

  • Process in Sales and Distribution
  • Basics in Sales and Distribution transaction
  • Sales doc structure
  • Presales process to complete sales doc.
  • Sales transaction and its basics
  • Sales Organizations and enterprise architecture
  • Sales org's units and its contents creation and assigning
  • Org units in sales process and objectives

Enterprise overview and creation with cross module overview

  • Overview of Enterprise structure and its relationship with MM and FI view
  • Transaction process and its relation ship
  • Relation between Fi and SD
  • Creation of org structures in Sales area and its corresponding units

Sales order creation and understand the business needs and information process and its relation

  • Sales order processing from the SAP point of view
  • Information process in sales view: Where and how the sales order is being processed
  • Understand and create Business partners and master data
  • Automatic information process in sales view: e.g. : plants
  • Exploring business process in sales order: changes to sales order docs
  • Understand the sales process blocks

The behavior and control of sales docs with sales doc types

  • The business objectives and its importance
  • Function and process in controlling and customizing sales doc types
  • Business process in sales and its functions
  • Phases in sales and its doc category types and how to control sales doc types
  • Doc types functions
  • Customizing doc types for sales process and assigning to specific sales areas
  • Process and functions and customizing of the sales doc types
  • Sales doc types and its comparison

Modifying the sales doc types with item category according to the business needs

  • Key Process in determining and customizing the item categories and its examples and its purpose.
  • Item category functionality overview, and variation, and its outcome
  • Creating of Item category and linking them to customized sales doc types
  • Item Categories and item Category Determination
  • BOM : Bills of materials in sales doc and its purpose in sales process
  • How to create and process with different functionality and its rules

Sales document and item schedule control

  • The nature of the doc type and its categories: schedule line and its functionality
  • Exploring schedule line categories
  • The process and functions in creating and linking schedule line categories to sales doc types

The flow of screens in sales and data transformation from doc type to doc type

  • Understanding of doc flow and completion status of the doc process
  • Copying control in Sales docs and its usage

Special Business sales process and its transaction

  • Order types, output types, and how delivery is planned if certain goods are to be free or priced
  • Consignments: business process and its various special issues in business process
  • The nature of the order type and the business requirements. Fill-up, pick-up, issues, billing

Document process in Incompletion

  • What are the impacts of incompletion rule and its behavior in sales docs
  • How to customizing the incompletion for a given sales doc
  • Controlling the Incompletion log
  • At what level it is used and how

What and who are business partners and its determination

  • How to configure the business partners and its business needs.
  • Partner functions and nature of relation ship
  • Partners in sales process
  • Customers Master and Account Group
  • Role of partner function per account groups
  • Partner determination and its procedures
  • Partner determination for sales docs

Outline agreements and its overview

  • Understanding of outline agreements
  • Sales doc types for different outline agreements
  • How to schedule outline agreement
  • Quantity contract
  • Messages about open outline agreements
  • How the data is activated for contracts; and how to determine the dates for these kind of contract agreements
  • Creation of Material Determination Master Record
  • Procedure in condition technique listing and exclusion
  • Hands on material determination and product selection and material Listing and material Exclusion

Free goods and its sales process

  • Understanding business process and needs in free goods concept overview
  • Exploring free goods and customizing free goods
  • Hands on free goods process. Condition technique, free goods master data, free goods calculation rule
  • Enjoy SAP Reward: Sales Scenarios. Test your skills


Quality Assurance with QTP


The proper testing of software can save an organization time, effort and money. In this course, software professionals and managers gain thorough knowledge of testing approaches that can be integrated into the software life cycle. Through hands-on exercises, you learn how to build testing methods into your work process to correctly design products that are functionable and maintainable.

In this course, you apply software testing methods throughout the development life cycle, ensuring software functions properly and are more easily maintainable-thereby saving your organization time, effort and money.


Specifically, you will learn how to:

  • Apply general software testing principles and fundamental test processes
  • Implement test levels and types to various software development models
  • Conduct static techniques using proper roles, responsibilities and tools
  • Perform specification- and structure-based test design techniques
  • Manage tests including planning, estimating, monitoring and controlling


Who Should Attend

Software testers, programmers, test leaders and quality specialists, involved with developing, testing or improving the development of systems and have a familiarity with software development concepts.



Fundamentals of Software Testing

  • Software Development Life Cycles
  • Waterfall Models
  • RUP Iterative Process
  • Agile / SCRUM
  • Testing throughout the SDLC
  • Common Testing Principles
  • Basic Test process
  • Types of testing


Test Management

  • Test Planning
  • Test Case Development
  • Test Execution
  • Test Reporting
  • Defect Tracking


Test Design Techniques

  • Requirements based testing
  • Risk based testing
  • Black Box vs. White Box testing
  • Use cases and scenario based testing
  • Agile based testing


Real Life Examples

  • Writing test cases based on real life projects
  • Test cases examples based on Windows applications
  • Web based testing

Testing Tools Support

  • Various vendors and their testing tools support
  • HP Mercury testing tools
  • Win Runner and QTP
  • Test Director and MQC (Quality Center)
  • Load Runner

IBM Rational testing tools

  • Rational Functional Tester
  • Rational Test Manager
  • Rational Quality Manager

Microsoft testing tools

  • MS Visual Test Suite

Open Source Testing Tools

  • JIRA
  • Bugzilla
  • Selenium

Automated Testing tools

  • Detail learning of QTP (separate course outline)
  • Detail learning of MQC (separate course outline)

Course Wrap-up

  • Prep for QA jobs
  • Prep for QA certifications


Quick Test Professional (QTP) Fundamentals

Introduction to Test Automation

  • What to automate?
  • Manual Vs. Automated testing
  • Automation strategies
  • Automation frameworks
  • Tools available for automation
  • Introduction to Mercury QTP (QTP training)

Preparing to Record

  • Review documented user steps
  • Identify the application under test (AUT)
  • Prepare the test environment

Creating a Basic Test

  • Create and execute basic tests
  • Understand QuickTest results

Working with Objects

  • Identify objects and their properties
  • Discuss basics of the Object Repository

Adding Synchronization

  • Add synchronization steps
  • Set Global Synchronization Timeout

Verifying with Standard Checkpoints

  • Enhance tests with checkpoints
  • Use regular expressions

Using Parameters and Data Driven Tests

  • Use input and output parameters
  • Create Data Driven tests
  • Enhance checkpoints with parameters

Making Reusable and Multiple Actions

  • Create a Single Reusable Action
  • Create multiple actions from a single action
  • Use Global and Local Data Sheets

Adding Steps without Recording

  • Add steps using keyword view
  • Add steps using the Step Generator

Writing Custom Checkpoints

  • Create a custom checkpoint
  • Compare captured values with expected values
  • Use debugging tools
  • Report the step outcome with a Reporter Event

Using Database Checkpoints

  • Define Database checkpoints
  • Create SQL queries
  • Insert a Database checkpoint
  • Parameterize a database query

Utilizing a Shared Object Repository

  • Describe local versus shared object repositories
  • Use the Object Repository Manager

Utilizing Recovery Scenarios

  • Create a recovery scenario
  • Associate a recovery scenario with a test

Introduction to Expert View

  • Understanding Expert View
  • Introduction to VBScript or OOP
  • Translating Steps

Using Expert View

  • Using the Step Generator
  • Entering Steps Manually
  • Debugging the Script


Working with Object Properties

  • Retrieving Properties of an Object
  • Using Constants and Variables
  • Using the Report Utility Object

Working with Dynamic Objects

  • Using Dynamic Objects
  • Building a Programmatic Description

Using VBScript Operators, Statements, and Functions

  • Using VBScript Operators, Statements, and Functions

Working with Dynamic Data

  • Retrieving Data
  • Using Looping Statements
  • Using the Data Table Object

Retrieving External Data

  • Importing Data
  • Working with Databases

Managing QuickTest Exception Handling

  • Overview of Exception Handling
  • Handling Exceptions Through Recovery Scenarios
  • Handling Exceptions Programmatically

Project - Test a commercial CRM product


ETL Development (Ab Initio)

The Ab Initio software is a Business Intelligence platform containing six data processing products: Co>Operating System, The Component Library, Graphical Development Environment, Enterprise Meta>Environment, Data Profiler and Conduct.  It is a powerful graphical user interface-based parallel processing tool for ETL data management and analysis.

Who Should Attend
The primary audiences for this course are: ETL Admins, ETL and BI Developers




  • Ab Initio Architecture
    • Ab Initio Product Architecture
    • Client server Communication
    • Ab Initio - Process Flow
    • Co>operating System
    • Graphical Development Environment
  • Overview of Graph
  • o   The Graph Model
  • o   Parts of Typical Graph
  • o   Layout and Phase of Graph
  • o   Anatomy of a running job
  • De-partitioning Components
    • o    Input Table
    • o   Output Table
    • o   Update Table
    • o   Truncate Table
    • o   Run SQL
    • Advance components
  • Ab Initio Functions
    • Data Manipulation Language
    • Built-in Functions
    • Lookup File
    • Transform Functions
  • Basic Components
    • Reformat
    • Filter by Expression
    • Redefine Format
    • Replicate
    • Aggregate
    • Sort
    • Join
    • Dedup sorted
  • Partitioning and De-partitioning Components
    • Multi-files
    • Parallelism Concepts
      • Component Parallelism
      • Pipeline Parallelism
      • Data Parallelism
    • Partitioning Components
      • Broadcast
      • Partition by Key
      • Partition by Expression
      • Partition by Round-Robin
      • Partition by Range
      • Partition by Percentage
      • Partition by Load Balance
    • Gather
    • Concatenate
    • Interleave
    • Merge
  • AI Graph Environment
    • Environment Set up
    • Sandbox & graph parameters
    • Private and Public Sandbox
    • Parameters sourcing technique
  • DB components & connectivity
  • DBC File
    • Normalize
    • De-normalize Sorted
    • Meta Pivot
    • Multi Reformat
    • Inflate
    • Deflate
    • Assign Keys
    • Scan
    • Sort within Group
    • Match Sorted
    • Rollup
    • Conditional Components
    • Vectors
    • Custom Layouts
    • Control Statements (if, for, while, etc.)
  • Performance Tuning Tips
  • EME basics
    • Check-in
    • Check-out
    • Tagging
  • MFS
    • MFS Commands
  • Debugging


  • EME Administration
    • Features of EME
    • Sandbox and projects
    • Checking out graphs, files and projects
    • Checking in projects, sandboxes, graphs and files
    • Dependency analysis
    • Using web to access EME datastore
    • Reports, Versioning and Tagging
    • Air commands


Course Number:


Print Print | Sitemap
© COMNet GROUP INC. 2020 All Rights Reserved.