Software Testing With Performance

You Are In:Home/Software Testing With Performance

Software Testing With Performance

This Performance Test Engineering with Database Administration course is an intensive hands-on course is designed to provide an introduction to the complexities of software performance testing and delivers testing skills that participants can immediately apply back on the job. Using a real-world case study, students will encounter issues, decisions, and testing experiences comparable to those in real-world work environment. Working through a series of discussion-based exercises students will develop a workable strategy for performance testing an application/system. The focus of the exercises is on analysis of a situation and understanding the planning and design issues associated with performance testing. This course will also focus on problem analysis, tuning, debugging, or tools. This course extends beyond the simple use of a tool to look at the nature of performance testing, the challenges surrounding performance testing and how to overcome these challenges to make the performance testing more effective. This course focuses on what performance testing really is, how it should be carried out and how it should be managed.

This course will provide Performance Testing Tools like HP Load Runner , HP Performance Center , JMeter ,MS Visual Studio and monitoring tools like HP SiteScope , MS SCOM .

This course will cover Database Administration ( Oracle and MS SQL Server ) and Operating System Administration ( MS Windows Server and Unix ) and will provide database professionals with an in-depth understanding of the DBA features of Oracle, and MS SQL Server.

Hands-on exercises are used to demonstrate each feature and the student will gain first-hand experience in the lab required to become a successful performance test engineer.

Intended Audience:

This course is intended for those who want to work as Software Performance Test Analyst/Engineer.

Prerequisites:

Students are required to have at least Bachelor in Computer Science (or related field) along with some software programming knowledge OR Associates with at least three years of work experience in IT field with some software programming knowledge. Students are also required to have a good knowledge of Microsoft Word, Excel, Access, PowerPoint, and Internet, extensive knowledge in computer hardware, software & Advance Networking.

Course Duration: 264 Hours

Course Outline

  • MODULE - 1: Computer components (02 hours)

    Identify names, purposes and characteristics of computer components:

    • Identify the names, purposes and characteristics of computer components
    • Identify the names, purposes and characteristics of mother boards - ATX / BTX, micro ATX / BTX, Integrated I/Os, USB , IEEE 1394, Modem, NIC, Bus Architects, SATA, SCSI, BIOS, CMOS, External Cache, Video and Sound Cards
    • Identify names, purposes and characteristics of power supplies. Identify names, purposes and characteristics of processors / CPUs - Hyper threading, Dual Core, Quad Core , Over clocking, Cache, VRM, Speed and 32 vs. 64 bit
    • Identify names, purposes and characteristics of memory- DRAM, SRAM, SDRAM, DDR , DDR2, RAMBUS, ECC vs. non-ECC, Parity vs. Non Parity
    • Identify names, purposes and characteristics of display devices- CRT, LCD, connector types, VGA, DVI / HDMi, S-Video, Component / RGB, V-hold, refresh rate and resolution.
    • Identify names, purposes and characteristics of input devices- mouse, keyboard, bar code reader, digital cameras. MIDI, touch screen and biometric devices.
    • Identify names, purposes and characteristics of adapter cards - Video cards, multimedia, I/O (USB, Serial, Parallel and SCSI) and communicating with network and modem.
    • Identify names, purposes and characteristics of cooling systems- heat sinks, CPU and case fans, liquid cooling and thermal compound
    • Oral presentation test

  • MODULE - 2: DOS (02 hours)

    Disk Operating System - (Instructional hours: 01, Lab hours: 01, Total: 02 hours)

    • What is DOS
    • Overview of DOS Pause a Directory Listing
    • Set the Date and Time
    • Directory Command
    • Scroll Through the Directory Listing
    • View a Wide Listing of Files
    • Recall a DOS Command
    • Check for a Single File
    • Check for a Group of Files
    • List Files with the Same Extensions
    • Create a File with DOS
    • Copy a File Type a File with DOS
    • Copy a file with a new extension
    • Rename a File
    • Create a Directory and Subdirectory
    • Move to the Parent Directory
    • Delete a Single File
    • Delete a Group of Files
    • Delete all Files in a Subdirectory
    • The use of XCPOY command
    • Create and execute batch file
    • DOS functions
    • Lab Practice
    • Interview questions and answers discussion
    • Written test
    • Oral presentation test

  • MODULE - 3: Operating System (02 hours)

    Operating System - (Instructional hours: 02, Lab hours: 0, Total: 02 hours)

    • Overview of Operating System
    • Identify differences between operating systems, revisions, GUI, system requirements for Mac, Windows and Linux.
    • Identify names, purposes and characteristics of the primary operating system components including registry, virtual memory and file system
    • . Overview of Windows 2000, Windows XP /Vista, Windows 7 32bit vs. 64bit
    • Windows Explorer ,My Computer ,Control Panel ,My Network Places ,Task bar
    • Windows Administrative tools: Performance monitor, Event Viewer, Services, Computer Management , MMC ,Task Manager .Windows Registry ,System Restore ,Remote Desktop
    • Windows File System : FAT32 ,NTFS , Folder sharing and NTFS security
    • Virtual Memory and Page file
    • Windows Environmental Variables
    • Windows Registry
    • Performance Monitor

    Windows System Tools

    • Disk Defragmenter
    • Disk Cleanup
    • Files and Setting transfer Wizard
    • System Restore
    • System Information
    • Security Center
    • File Signature Verification Utility
    • DirectX Diagnostic Tools
    • Dr Watson
    • Disk Management C
    • omputer Management

    Identifying tools, diagnostic procedures and troubleshooting techniques for operating systems

    • Identify basic boot sequence and utilities for recovering operating systems
    • Identify and apply diagnostic procedures and troubleshooting techniques
    • Recognize and resolve common operational issues such as blue-screen, system lock-up and application install.
    • Explain common error messages and codes - event viewer, Windows reporting, Boot and Start up.
    • Identify the names and locations, purposes and characteristics of operating system utilities
    • Interview questions and answers discussion
    • Written test
    • Oral presentation test

  • MODULE - 4: Microsoft Outlook(02 hours)

    Lesson 01: Organizing with Outlook.

    • View Outlook Components.
    • Schedule an Appointment.
    • Schedule a Recurring Appointment.
    • Schedule an Event.
    • Plan a Meeting.
    • Create a New Contact.
    • Create a New Task.
    • Add a Note.
    • Organize Outlook Items.
    • Perform an Instant Search.
    • Customize the To-Do Bar.

    Lesson 02: E-mailing with Outlook.

    • Compose and Send a Message.
    • Read an Incoming Message.
    • Control the Reading Pane.
    • Reply to or Forward a Message.
    • Add a Sender to Your Address Book.
    • Delete a Message.
    • Attach a File to a Message.
    • Clean Up the Mailbox.
    • Screen Junk E-mail.
    • Create a Message Rule.
    • Interview questions and answers discussion.
    • Written test.
    • Oral presentation test.

  • MODULE - 5: HTML & XML (02 hours)

    HTML & XML - (Instructional hours: 01, Lab hours: 01, Total: 02 hours An Introduction to Website Development

    • How Web Servers Work
    • What is a Web Server?
    • How Web Servers Work
    • Web Site Components
    • The Internet Protocol
    • The Transmission Control Protocol
    • The Hyper Text Transfer Protocol
    • The DNS Server
    • Uniform Resource Locators
    • The Proxy Cache Server
    • An Introduction to HTML
    • HTML Elements
    • HTML Element Attributes

    HTML Basics

    • Working with Hyperlinks
    • Using the Anchor Element
    • Working with URLs and Paths
    • Linking to a Specific Point in an HTML Document
    • Adding Hyperlinks to Images
    • Working with Forms
    • Using the Form Elemen
    • t Adding Form Components with the Input Element

    XML Basics

    • What is XML?
    • Writing XML
    • XML and Browsers
    • Formatting XML
    • XML Spy
    • Interview questions and answers discussion
    • Written test

  • MODULE - 6: Network Basics (02 hours)

    Network Basics - (Instructional hours: 02, Lab hours: 0, Total: 02 hours)

    • Describe the purpose of networking protocols and networking in general
    • Identify features of various network operating systems and the clients used to access them.
    • Describe the OSI networking model and its relationship to networking components.
    • Describe the network components relating to the Physical layer of the OSI model.
    • Describe the function of the Data Link layer of the OSI model.
    • Explain how data is transmitted over a network.
    • Describe the function of the Network layer of the OSI model.
    • Describe the function of the Transport layer of the OSI model.
    • Describe the function of the Session layer of the OSI model.
    • Explain the fundamental concepts of the TCP/IP protocol suite.
    • Explain the use of TCP/IP addresses and subnets.
    • Access and use a TCP/IP network.
    • Describe the requirements for remote network access.
    • Explain the need for and ways to implement network security and fault tolerance.
    • Describe the types of information that need to be gathered prior to installing or updating a network operating system.
    • Explain ways to monitor and manage a network.
    • Describe a systematic approach for troubleshooting network problems.
    • Interview questions and answers discussion
    • Written test
    • Oral presentation test

  • MODULE - 7: Networking Advance(04 hours)

    Network Technologies - (Instructional hours: 04, Lab hours: 0, Total: 04 hours)

    • Explain the function of common networking protocols
    • Identify commonly used TCP and UDP default ports
    • Identify the following address formats
    • Given a scenario, evaluate the proper use of the following addressing technologies and addressing schemes
    • Identify common IPv4 and IPv6 routing protocols
    • Explain the purpose and properties of routing
    • Compare the characteristics of wireless communication standards
    • Network Media and Topologies
    • Categorize standard cable types and their properties
    • Identify common connector types
    • Identify common physical network topologies
    • Given a scenario, differentiate and implement appropriate wiring standards
    • Categorize WAN technology types and properties
    • Categorize LAN technology types and properties
    • Explain common logical network topologies and their characteristics
    • Install components of wiring distribution

    Network Devices

    • Install, configure and differentiate between common network devices
    • Identify the functions of specialized network devices
    • Explain the advanced features of a switch
    • Implement a basic wireless network

    Network Management

    • Explain the function of each layer of the OSI model
    • Identify types of configuration management documentation
    • Given a scenario, evaluate the network based on configuration management documentation
    • Conduct network monitoring to identify performance and connectivity issues
    • Explain different methods and rationales for network performance optimization
    • Given a scenario, implement the following network troubleshooting methodology
    • Given a scenario, troubleshoot common connectivity issues and select an appropriate solution

    Network Tools

    • Given a scenario, select the appropriate command line interface tool and interpret the output to verify functionality
    • Explain the purpose of network scanners
    • Given a scenario, utilize the appropriate hardware tools

    Network Security

    • Explain the function of hardware and software security devices
    • Explain common features of a firewall
    • Explain the methods of network access security Explain methods of user authentication
    • Explain issues that affect device security
    • Identify common security threats and mitigation techniques
    • Differentiate between the different ports & protocols, their respective threats and mitigation techniques.
    • Distinguish between network design elements and components.
    • Determine the appropriate use of network security tools to facilitate network security.
    • Apply the appropriate network tools to facilitate network security.
    • Explain the vulnerabilities and mitigations associated with network devices.
    • Explain the vulnerabilities and mitigations associated with various transmission media.
    • Explain the vulnerabilities and implement mitigations associated with wireless networking.
    • Interview questions and answers discussion
    • Written test
    • Oral presentation test

  • MODULE - 8: Windows Server 2008 Configuration (02 hours)

    • Windows Server 2003/2008 Configuration- (Instructional hours: 01, Lab hours: 01, Total: 02 hours)
    • TCP/IP network addressing and routing
    • Windows Server 2008 Installation and Upgrade
    • Installing Windows Server 2008 Server Core
    • Virtualization : Hyper-V installation and configuration
    • Setting Up a VPN Server
    • Installing Server 2008 and Active Directory - The First Domain Controller
    • Setting up Remote Desktop on Your Personal Vista Client
    • Creating OU's, Users, Computers and Groups in Active Directory
    • Setting Up Share Folders and Printers, Mapping Drives, and Creating Permissions
    • Install and Configure Internet Information Services (IIS)
    • Interview questions and answers discussion
    • Oral presentation test

  • MODULE - 9: Firewall Configuration (02 hours)

    • Firewall Configuration-(Instructional hours: 02, Lab hours: 0, Total: 02 hours)
    • TCP/IP network addressing and routing
    • IP subnetting
    • Providing Local Area (LAN), Wide Area (WAN), and remote access services
    • Advanced network theory, including Virtual Private Networks (VPN), Content Delivery Networks (CDN), Intranetsand extranets, and wireless networking
    • Introduction to Cisco Internet Operating System (IOS) Initial configuration of Cisco Catalyst Switches and Routers
    • Network discovery and management using Cisco Discovery Protocol (CDP), telnet, and Trivial FTP (TFTP)
    • Interconnect networks using TCP/IP
    • Spanning Tree Concepts of VLANs and trunking
    • Review how to configure and troubleshoot a switch and router in a small network environment
    • Expand the switched network from a small to medium network environment
    • Implementing VLSM
    • Configure, verify, and troubleshoot OSPF
    • Configure, verify, and troubleshoot EIGRP
    • Determine when to use access control lists (ACLs)
    • Configure, verify, and troubleshoot ACLs Configure NAT and PAT
    • Interview questions and answers discussion
    • Written test

  • MODULE - 10: Storage media and Backup Strategy(02 hours)

    • Storage media and Backup Strategy-(Instructional hours: 02, Lab hours: 0, Total: 02 hours)
    • What is a SAN ? Hardware components of a SAN .
    • Understanding the RAID system . RAID 5 vd RAID 1+0
    • How to use a SAN backup solution to offload backup operations
    • Backup Stategies . Full ,Differential and Incremental.
    • Tape backup Media
    • How to build a scalable SAN architecture
    • Interview questions and answers discussion
    • Written test
    • Oral presentation test

  • MODULE - 11: Linux/Unix(02 hours)

    Linux/Unix- (Instructional hours: 01, Lab hours: 01, Total: 02 hours)
    Understanding the Unix OS

    • Structure and Architecture of Unix OS
    • Different types of Unix systems
    • Unix supported hardware
    • Installing and configuring Unix on a virtual machine

    Unix File System

    • Basic Unix commands
    • Creating , Deleting ,Moving ,copying ,linking files
    • File ownership and security
    • Unix File permission
    • Changing the File permission

    Pipes, redirections

    • Input, output and error streams
    • Pipes in Unix
    • Some utilities: sort, cat and tail
    • Searching with grep
    • Sed and awk
    • Regular expressions

    The Vi Editor

    • Moving within a file
    • Searching Files
    • Exiting and Saving a File
    • Editing Files
    • Alternatives to Vi

    More Advanced Commands : Grep, find, sort, tee, head, tail, ps, vmstat, sar, ps -ef, tar, ftp, telnet, gzip

    Unix Networking

    • Network Address, Subnetworks, Netmasks, and Routing
    • Setting Up a Unix System for a TCP/IP Network
    • DHCP and Static addressing
    • Sending a TCP/IP Network Request
    • Answering a TCP/IP Network Request
    • Network Management Tools
      • Tracking the Performance of a Network with Traceroute
      • Firewalls
      • Routinely Checking Network Latency

    Unix Shell Scripting

    • Introduction to Unix shell scripting
    • How to write and execute shell script
    • Conditional & Looping Statement
    • if statement
    • if -else statement
    • 'While' Loop
    • 'For' Loop
    • CASE
    • Creating a function
    • Calling a function in file
    • Calling a function in another file
    • Scheduling a job - using 'Crontab'
    • Scheduling a job - using 'at'
      • Interview questions and answers discussion
      • Written test
      • Oral presentation test

  • MODULE - 12: Microsoft Office SharePoint(04 hours

    Microsoft Office SharePoint - - (Instructional hours: 02, Lab hours: 02, Total: 04 hours)

    Introduction to Windows SharePoint Services 3.0 (WSS)

    • Explain the purpose of Windows SharePoint Services
    • Describe the navigation features of a SharePoint site
    • Explain the interaction between a SharePoint site and Microsoft Office

    Using SharePoint Document Libraries

    • Access document libraries
    • Create and save files to a library
    • Check out and modify documents
    • Check in documents and access versioning
    • Create custom views Using SharePoint Lists
    • Explain the purpose of lists
    • Describe the different type of lists and their usage
    • Work with lists

    Using Outlook with SharePoint

    • Connect Outlook to SharePoint task lists
    • Schedule and create meeting workspaces through Outlook
    • Setup calendar sharing

    Integrating External Data

    • Use Excel Services
    • Work with Report Center
    • Work with Dashboards
    • Use Business Data Catalog
      • Interview questions and answers discussion
      • Written test
      • Oral presentation test

  • MODULE - 13: Manual Testing

    Manual Testing - (Instructional hours: 16, Lab hours: 08, Total: 24 hours)

    • Software Development Life Cycle
    • Testing Methodologies (Waterfall, RUP Iterative, Agile)
    • Different Testing Types: System, Black Box, End-to-end, Integration, Beta, GUI, Load, Performance, Stress, Volume, Endurance, Regression, Smoke, Ad hoc, Functional, Positive, Negative, Usability, 508 Compliance, User Acceptance Testing
    • Testing Methodology / QA Process
    • Business Requirement Document (BRD)
    • System Requirement Specification (SRS)
    • Design Documents (DD)
    • Design Mockup/ Wire frame/Prototype
    • Requirement Assessment/Validation
    • Documents: Test Strategy, Test Plan, PMP, CMP, SDP, RAR, TAR, LOE, Executive Summary, Test Cases, Test Scenarios etc.
    • Manual Testing vs. Automation
    • Risk Analysis
    • IV & V
    • Use Cases
    • Requirement Traceability Matrix (RTM)
    • Test Matrix
    • Interview questions and answers discussion
    • Written test
    • Oral presentation test

  • MODULE - 14: Quality Center/ALM

    Quality Center/ALM - (Instructional hours: 16, Lab hours: 08, Total: 24 hours)

    As a Site Administration

    • Create Domain, Project, Users, Project Admin
    • Assign users to the projects
    • Configured Wait_Before_Disconnect feature
    • Configure mail interval, mail format, version control settings

    As a Project Administrator

    • Setup/assign user to the project
    • Assign role/privilege to the user.
    • Created new users for project
    • Set-up groups/create new group role
    • Changed permission of the new role
    • Add users to the new role
    • Customized project entities
    • Defect field customization i.e. making a field as a required field
    • Create new user field i.e. test environment (DEV, ALPHA, BETA, PROD, QUAL) in defect window.
    • Requirement field customization i.e. making a required field
    • Requirement field customization like modified requirement type from the default (Hardware, Software) to Functional, Non-Functional, System Change Request etc.
    • Configuring mail

    As a User

    • Enter requirements in the requirement section
    • Prepare excel sheets for require to export in the requirement field
    • Export requirement to export in the requirement folder
    • Convert requirements from the requirement section to test in the test plan section
    • Develop design steps or test cases in the test plan section
    • Attach the screenshot for the steps, if necessary.
    • Create template for the common steps
    • Call template to the tests
    • Calling a manual test with parameters
    • Perform requirement coverage or linking one test case to one requirement in the Test Plan section or performing requirement traceability
    • Perform requirement coverage or linking one test case to many requirements in the Test Plan section or performing requirement traceability
    • Create test sets in the test lab section
    • Import test cases in the test set
    • Execute test sets in the test lab section
    • Log defect in the test lab section
    • Log defect in the Defect section
    • Attach the screenshot for the defect
    • Track/ filter defect in the defect section
    • Enter comment in the comment section after retesting the bug like 'retest passed' recommending to close this defect or retest failed, recommending to re-open
    • Generate graph and reports in the Requirement, Test plan, Test Lab & Defect section
    • Schedule automated test to execute or running automated test scripts in batch mode
    • Create and automated QTP scripts using TestDircetor or Quality Center/ALM
    • Test using QTP (Quality Test Professional)
    • Interview questions and answers discussion
    • Written test
    • Oral presentation test

  • MODULE - 15: SQL, PL/SQL & TOAD

    SQL, PL/SQL & TOAD - (Instructional hours: 16, Lab hours: 08, Total: 24 hours)

    • Getting started with SQL
    • SQL language to create and manipulate SQL database objects.
    • Database creation and management
    • Stored Procedures
    • SQL QUERIES: UNIONS, JOINS, QUERIES, SUBQUERIES
    • Character String Functions: LPAD, ASCII, RPAD, CHR, LTRIM, CONCAT, RTRIM, INITCAP, TRIM, INSTR,REPLACE, LENGTH, SOUNDEX, LOWER, SUBSTR, UPPER, VSIZE
    • Aggregate/ Group functions: STDDEV, AVG, SUM, COUNT, VARIANCE, MAX, Group By, MEDIAN, Incorrect Usage, MIN
    • Date Timestamp Functions: ADD_MONTHS, ROUND, CURRENT DATE, SESSIONTIMEZONE, CURRENT TIMESTAMP, SYSDATE, DBTIMEZONE, SYSTIMESTAMP, EXTRACT, TO_CHAR, LAST_DAY, TO_DATE, LOCALTIMESTAMP, TO_TIMESTAMP, MONTHS_BETWEEN, NEW_TIME, TRUNC, NEXT_DAY
    • Numerical Math Functions: Log, ABS, MOD, POWER, ROUND, CEIL, SQRT, EXP, FLOOR, TRUNC
    • Conversion Functions: ROWIDTONCHAR, DECODE, TO_CHAR, NVL, TO_NUMBER, NVL2, TRANSLATE, ROWIDTOCHAR
    • Analytical Functions: ROWNUM, CUBE, Group by, HAVING
    • Miscellaneous Functions: GREATEST, LEAST
    • Intro to DBMS, RDBMS, Normalization, SQL, PL-SQL
    • Inserting, Deleting, and Updating Data
    • Commit and Rollback
    • DM, DDL, DCL
    • SELECT, WHERE clauses, Sorting, Wildcards, Distinct
    • Create, Alter, Drop Tables
    • Different data types for fields
    • Constraints: Primary keys, Foreign keys, Unique, Not Null
    • Group and Have clause
    • Joins: inner join, outer joins, self join
    • Introduction to Functions, Procedures, Triggers, Cursor, Sequence
    • Interview questions and answers discussion
    • Written test
    • Oral presentation test

  • MODULE - 16: Oracle Database Administration

    Oracle Database Administration - (Instructional hours: 08, Lab hours: 04, Total: 12 hours)

    Oracle Database Architecture & Configuration

    • Oracle as a flexible, complex & robust RDBMS
    • The evolution of hardware and the relation to Oracle
    • Oracle Database Architecture ( SGA, PGA )
    • Environment management (network, CPU, disk and RAM)
    • Instance management (managing SGA regions)
    • Oracle table and index management

    Oracle database management

    • Parameter files (init.ora, listener.ora, tnsnames.ora)
    • Rules for sizing SGA components
    • Automated Oracle memory management (AMM)
    • Creating the init.ora file
    • Using spfile
    • Displaying init.ora values with v$parameter
    • Oracle object management
    • Types of Oracle tables (regular, IOT, sorted hash clusters, nested tables)
    • Oracle Views
    • Oracle materialized views
    • Types of Oracle indexes (b-tree, bitmap, bitmap join index)
    • Creating B*-Tree, bitmap and function-based Indexes
    • Function-based indexes
    • Finding indexing opportunities
    • Index maintenance
    • Costs & benefits of constraints
    • Types of Oracle indexes constraints (check, not null, unique, PK, FK)
    • Cascading constraints

    Oracle Database Maintenance

    • Reason for reorgs - chained rows, imbalanced freelists
    • Reorganizing Tables using Export and Import
    • Using CTAS to reorganize data
    • Index rebuilding
    • Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking)
    • Data pump (Imp and exp utilities)
    • Oracle DBA Utilities- SQL*Loader , LogMiner, DataGuard

    Monitoring Oracle

    • The dba_, all_ and user_ structures
    • Querying the tables, indexes, and segments views
    • Querying the AWR (STATSPACK) tables
    • Monitoring table extents and fragmentation
    • Using the dba_tables and dba_segments views
    • Monitoring table extents and fragmentation
    • Monitoring table & index growth
    • Monitoring index usage
    • Monitoring index fragmentation
    • Locating un-used indexes
    • Identifying IOT candidates
    • Reorganizing Indexes with alter index rebuild
    • Dropping Indexes
    • Getting Index Information from the Data Dictionary
    • Oracle automated workload tools
    • Using v$bh to monitor buffer activity
    • Using v$sql and v$sql_plan
    • Monitoring with the AWR and STATSPACK
    • Creating a time-series performance report
    • Using www.statspackanalyzer.com
    • Plotting performance data (Ion, Excel)
    • Finding performance trends and signatures
    • Displaying and managing Oracle sessions (v$session, v$process)
    • Using AWR to monitor disk, network and CPU consumption
    • Monitoring the alert log
    • Oracle trace/dump files

    Performance Management- Bottleneck performance analysis

    • Drill-down into AWR reports
    • Top-5 timed events
    • External Server Bottlenecks (Network, I/O, RAM, CPU)
    • Network troubleshooting
    • Interview questions and answers discussion
    • Written test
    • Oral presentation test

  • MODULE - 17: Windows Server 2008 R2

    Windows Server 2008 R2- (Instructional hours: 08, Lab hours: 04, Total: 12 hours)

    Introduction to Windows Server 2008 and Windows Server 2008 R2

    • Functionality of Windows Server 2008
    • Network Operating Systems: Product History
    • Windows Server 2008 Editions Microsoft Hyper-V Server 2008
    • Server Core Overview
    • New Features in Windows Server 2008 and Windows Server 2008 R2
    • New Features of SP1 for Windows Server 2008 and Windows 7
    • Understanding the Windows Server 2008 Environment
    • Windows Server 2008 Server Roles and Features
    • Windows Server 2008 Administration Tools
    • Managing Windows Server 2008 Server Core

    Managing Active Directory Domain Services

    • Active Directory Infrastructure
    • Working with Active Directory Administration Tools
    • Managing User Accounts
    • Managing Computer Accounts
    • Managing Groups Using Queries to Locate Objects in AD DS
    • Creating and Managing Group Policy Objects Group Policy

    Monitoring and Maintaining Windows Server 2008

    • Planning Maintenance Tasks Calculating a Server Baseline
    • Interpreting Performance Counters
    • Selecting Appropriate Monitoring ToolsTypeperf ,PAL , Process Explorer

    IIS

    • IIS Functional Overview
    • Creating IIS Web Sites and Applications
    • Managing IIS Web Sites and Applications
    • Creating IIS Web Sites and Applications
    • Configuring IIS Server Settings
    • Configuring an Application Pool
    • Creating and Configuring a Web Site
    • Configuring Basic Settings for a Web Application
    • Backing Up IIS Configuration Settings
    • Configuring a Virtual Directory
    • Managing IIS Web Sites and Applications
    • Configuring ASP.NET
    • Configuring ASP.NET Application Settings
    • Configuring ASP.NET Security

    Windows Utilities

    Registry

    Perfmon

    Task Manager

    Environment Variable

    Computer Management

    Services

    Disk Management

    Server Management

    Event Viewer

    • Interview questions and answers discussion
    • Written test
    • Oral presentation test

  • MODULE - 18: Oracle object management

    Oracle object management - (Instructional hours: 08, Lab hours: 04, Total: 12 hours)

    The History of SQL Server and relational databases

    • Relational database history
    • The evolution of SQL Server
    • SQL Server and ANSI standards

    Installing and configuring SQL Server

    • Pre-installation steps
    • Installing SQL Server
    • Configuring the run-time SQL Server system
    • Patching SQL Server - Service packs

    SQL Server data storage management

    • SQL Server file management architecture
    • Creating database files
    • Creating SQL Server log files
    • Using SQL Server file groups

    Managing data with the DTS utility

    • Using DTS to export and import SQL Server table data

    SQL Server Security management

    • Windows security management for the server
    • Windows authentication mode
    • SQL Server rights and role management

    SQL Server Backup & Recovery

    • Overview of SQL Server backup & recovery
    • Incremental backups
    • Restoring a SQL Server database
    • Standby database overview
    • Shipping SQL Server log files to standby databases

    SQL Server Job scheduling

    • Common database scheduled jobs
    • Configuring SQLMail
    • Setting SQL Server and server alert thresholds
    • Creating customized error conditions
    • Scheduling multi-step job streams

    Performance Tuning

    • SQL Server monitoring for performance
    • SQL Server startup parameter tuning
    • T-SQL tuning
    • SQL tuning for SQL Server
    • Diagnosing storage and system problems
    • Diagnosing session and O/S issues

    SQL Server SSIS

    • Overview of SSIS
    • Import and export files using ETL Process
    • Data Warehousing

    SQL Server Advanced Tools

    • SQL Profiler
    • SQL Server Tuning Adviser
    • SQL Mail
    • Interview questions and answers discussion
    • Written test
    • Oral presentation test

  • MODULE - 19: HP Load Runner

    HP Load Runner - (Instructional hours: 16, Lab hours: 08, Total: 24 hours)

    Overview of Load Testing

    • Introduction to web applications performance testing
    • Performance testing concepts : Stress, Load , Regression
    • What is Load Testing ,why real world need Load Testing
    • Overview of Tier-3 Enterprise Application infrastructure
    • Overview of Software Testing Environment- Dev , UAT, Pre-prod , Prod
    • Test Plan and Test Case

    Overview of HP Load Runner

    • Load Runner installation on a virtual server
    • Describe the Load Runner environment and architecture.
    • Explain how to install the Controller.
    • Explain how to install Load Generator
    • Explain how to add multiple LG to Controller

    Load Runner Scripting Planning a Script

    • Determining what steps to perform
    • Consider data and data usage Recording a Script
    • Recording Options - HTML vs. URL recording
    • Recording the test case

    Transactions

    • Add Transactions during recording
    • Add Transactions after recording using the transaction workflow tool, and manually via the keyword view.

    Verifications

    • Why is a verification point necessary
    • Add a verification during recording
    • Add a verification after recording using the keyword view screenshots
    • Global Verification Points

    Run-Time Settings

    • Setting appropriate logging option Controlling the number of iterations to playback
    • Think times and Pacing settings
    • Other settings

    Parameterization

    • Adding Parameters in the keyword view, and in the script view
    • Create a file type parameter
    • Examine other parameter types, e.g. Random type, date time type
    • File parameter access methods
    • Update Parameter value settings
    • Simulate Parameter Usage

    Correlation

    • Required Settings
    • Run the test, examine errors
    • Use the Scan for Correlations tool
    • Determine which values to correlate
    • Review the correlation functions added to the script

    Manual Correlations

    • Required settings
    • Run the test and examine the errors to determine which commands to focus on
    • Determine which of the values is the dynamic one
    • Determine where the server sent the dynamic value
    • Determine appropriate left and right boundaries and ordinal values
    • Add the web_reg_save_param function
    • Replace hard-coded dynamic values with the new parameter
    • Run the test to validate Correlation during Recording
    • Add a rule to the recording options
    • Test the rule Record the script Use of the regenerate script option

    Advanced Scripting

    • Condition statements and loops
    • Variable declarations
    • Common string manipulation functions
    • Data conversion functions
    • LoadRunner specific functions (lr_eval_string, output messages, lr_save_string) Custom Checkpoints
    • Examining the web_reg_find savecount option
    • Capturing data using the web_reg_save_param function

    String Manipulation

    • Using the sprintf function
    • strstr
    • strcpy
    • strcat
    • lr_save_string and lr_save_int
    • lr_save_datetime function
    • lr_advance_param vs. lr_next_row

    Scenario configuration

    • Configure different types of scenarios.
    • Define a load test schedule using the Scheduler.
    • Set up a Service Level Agreement.
    • Set up Performance Monitors.
    • Configure Scenario options based on test requirements.
    • Configure additional features
    • Identify steps within the Scenario Execution Process.
    • Work with the Controller Run tab.
    • Describe results collation.

    Results analysis

    • Use Root Cause Analysis to determine the likely cause of a bottleneck.
    • Analyze information on available graphs.
    • Use Drill-Down to determine lower level details.
    • Use Auto Correlation to identify probable cause.
    • Use filtering, set granularity to analyze results.
    • Compare or merge graphs to analyze results.
    • Describe the uses of the SLA and Analyze Transaction feature.
    • Describe Analysis module features under Options.
    • Describe how to use cross-scenario analysis to evaluate impacts of application.
    • Explain the reporting solution.
    • Identify diagnostic graphs.
    • Interview questions and answers discussion
    • Written test
    • Oral presentation test

  • MODULE - 20 : Jmeter

    Jmeter - (Instructional hours: 12, Lab hours: 06, Total: 18 hours)

    Jmeter Overview

    • Why use Jmeter ?
    • Ramp-up period
    • Thread groups and simulating real users using thread groups Other technical terms

    Managing performance testing project

    • Identify test environment
    • Identify performance test acceptance criteria
    • Modeling application usage
    • Determining individual user data and variances
    • Test execution
    • Key mathematical principles for performance testing
    • Performance test reporting fundamentals
    • Working with various stakeholders

    JMeter Basics

    • JMeter installation and configuration
    • Introducing JMeter GUI
    • Create a basic Test Plan
    • Introducing various elements in JMeter
    • Executing tests with various configurations
    • Reading test results
    • 6.3 Simulate dynamic user behaviors
    • Submitting Forms Generating sequence or random data
    • Extracting form IDs
    • Use of regular expressions extractors

    Building Test Plans

    • Building an advance web test plan
    • Building a FTP test plan
    • Building a Database test plan

    Managing Sessions

    • Session managers
    • Session per thread
    • Session per user
    • Cookie Manager
    • URL re-writer

    Load Distribution

    • Using web server log files to determine distribution
    • Analyzing distribution and creating appropriate test plans

    Timers

    • Use of timers in a test plan
    • Introduce various timers available in JMeter
    • Use of Java request as a timer
    • Selecting a timer

    Jmeter components

    • Logical Controllers
    • Listeners
    • Config Elements
    • Assertions
    • Post and Pre processors

    Resource Monitoring

    • Monitoring and analyzing CPU resources
    • Monitoring database queries
    • Monitoring memory utilization
    • Monitoring network traffic
    • Running monitoring tools periodically

    Analyzing and Interpreting Load Test Results

    • Running tests at night and creating periodical reports
    • Statistics available from JMeter
    • Sample, Average, Median, Deviation, Throughput
    • Response time graphs
    • Analyzing results with Excel
    • Interpreting statistical results

    Advanced

    • Distributed testing
    • Extending JMeter with Java, Bean Shell and JavaScript

  • MODULE - 21: Visual Studio -Load Testing

    Visual Studio -Load Testing - (Instructional hours: 12, Lab hours: 06, Total: 18 hours)

    Overview of the web performance and Load test

    • How to configure your visual studio environment to start web performance and Load test
    • Run results and how to analyzing the load performance result

    Scenario Information

    • Load pattern (constant load, step load)
    • Test Mix Model based on (total no. of tests, no. of virtual users, user pace or sequential test order)
    • Test Mix (add no. of previously created web tests and determined the distribution %)
    • Network Mix (add multiple network types and determined the distribution %)
    • Browser Mix (add multiple browser types and determined the distribution %)

    Prerequisite steps to start your Load test

    • Start to record many web performance tests that reflect your test cases that cover the user business cases
    • Each web test should cover only one test case (Flow)
    • Check and validate each flow separately
    • Existence of ?LoadTest? DB
    • Interview questions and answers discussion
    • Written test
    • Oral presentation test

  • MODULE - 22: Web Server and Monitoring Tools

    Web Server and Monitoring Tools - (Instructional hours: 08, Lab hours: 04, Total: 12 hours)

    Overview of Performance Testing Monitoring

    • HP Site Scope
    • MS SCOM
    • JConsole
    • CA Wily
    • Monitoring Java web application
    • Collecting and analyzing Java dump file to find out the memory leak

    Web Server

    • IBM Web sphere Application Server
    • Tomcat
    • IIS

    Java Application deployment on Web Sphere

    • Interview questions and answers discussion
    • Written test
    • Oral presentation test

  • MODULE - 23: BOOT CAMP BOOT CAMP- Lab hours: 12, Total: 12 hours

    Each student will be required to complete a real-time project lab that covers the entire course curriculum.

  • MODULE - 24: Comprehensive Interview training

    Comprehensive Interview training- (Instructional hours: 32)

    Our comprehensive Interview training will prepare you for any kind of job. 1:1 interview session, evaluation, improvement plan and follow up will boost your confidence and knowledge drastically. You will be an expert on all tips and techniques, mistakes people usually make, formulating best answers and dealing with difficult situation etc. It will also significantly improve your speech/presentation skill.

    • Typical Interview Format Discussion
    • Phone/Onsite Interview
    • The tricks and techniques of successful interview
    • What the Interviewers are looking for Questions to ask during Interview
    • DOs and DON'Ts for the interview
    • The 100 most commonly asked questions during any interview
    • How to write a professional, eye catching resume and cover letter
    • How to search and apply for jobs online
    • Interview Success Product (Books, CDs)
    • Researching Potential Employees
    • Interview Follow up/Thank You Letters
    • Personal 1:1 interview practice and coaching: Individual secret personal evaluation and recommendation
    • Interview questions and answers discussion
    • Written test
    • Oral presentation test

  • MODULE - 25: Real-Time Project Based Workshop and Presentation

    Real-Time Project Based Workshop and Presentation- Lab hours: 10, Total: 10 hours

    Each student will be required to complete a real-time project that covers the entire course curriculum as listed below. When their project is successfully completed, each student will then make a formal presentation of their entire work over 10 hours to an audience of fellow students under the supervision of the course instructor. The presentation will be conducted in five separate two-hour sessions. Each student is also required to attend an additional 30 hours participating as an audience member while their fellow student(s) are presenting their projects.

    • Requirement writing
    • Requirement Validation using SMART Criteria
    • Generating Requirement Analysis Report (RAR)
    • Creating Level of Efforts (LOE)
    • Creating Test Plan , then Check In to the Shared Folder using Microsoft SharePoint
    • Creating Domain, Project, Project Admin, User using Quality Center/ALM
    • Importing Requirements using Quality Center/ALM
    • Writing Test cases for Functional, Positive, Negative, Equivalence Partitioning, Integration, Database Testing, covering Traceability Matrix
    • Selecting right candidate for Smoke Testing and executing test cases
    • Executing Test Cases for Functional, Positive, Negative, Equivalence Partitioning, Integration, Database Testing
    • Logging defects, assigning defects to the developers, demonstrating full Bug Life Cycle, generating graphs and reports using Quality Center/ALM
    • Creating Test Matrix
    • Creating Test Analysis Report (TAR)
    • Creating an Executive Summary for the test
    • Creating Automation Test Plan , then Check In to the Shared Folder using Microsoft SharePoint
    • Creating Scenarios for Regression Testing, 508 Compliance and User Acceptance Testing
    • Creating QTP Scripts, developing Custom Functions, writing Descriptive Programming, Creating Keyword Driven,
    • Data-driven and Hybrid Frameworks, creating Optional Steps & Recovery Scenarios on the selected Scenarios for
    • Regression Testing, 508 Compliance and User Acceptance Testing
    • Importing QTP Scripts in Quality Center/ALM and executing the scripts
    • Writing a Traceability Matrix for Requirements, Test Cases and Defects
    • Creating Performance Test Plan , then Check In to the Shared Folder using Microsoft SharePoint
    • Creating Release Notes, then Check In to the Shared Folder using Microsoft SharePoint
    • Creating User Manual , then Check In to the Shared Folder using Microsoft SharePoint
    • Creating a Post Mortem Reports , then Check In to the Shared Folder using Microsoft SharePoint