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.
This course is intended for those who want to work as Software Performance Test Analyst/Engineer.
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
Identify names, purposes and characteristics of computer components:
Disk Operating System - (Instructional hours: 01, Lab hours: 01, Total: 02 hours)
Operating System - (Instructional hours: 02, Lab hours: 0, Total: 02 hours)
Windows System Tools
Identifying tools, diagnostic procedures and troubleshooting techniques for operating systems
Lesson 01: Organizing with Outlook.
Lesson 02: E-mailing with Outlook.
HTML & XML - (Instructional hours: 01, Lab hours: 01, Total: 02 hours An Introduction to Website Development
Network Basics - (Instructional hours: 02, Lab hours: 0, Total: 02 hours)
Network Technologies - (Instructional hours: 04, Lab hours: 0, Total: 04 hours)
Linux/Unix- (Instructional hours: 01, Lab hours: 01, Total: 02 hours)
Understanding the Unix OS
Unix File System
The Vi Editor
More Advanced Commands : Grep, find, sort, tee, head, tail, ps, vmstat, sar, ps -ef, tar, ftp, telnet, gzip
Unix Shell Scripting
Microsoft Office SharePoint - - (Instructional hours: 02, Lab hours: 02, Total: 04 hours)
Introduction to Windows SharePoint Services 3.0 (WSS)
Using SharePoint Document Libraries
Using Outlook with SharePoint
Integrating External Data
Manual Testing - (Instructional hours: 16, Lab hours: 08, Total: 24 hours)
Quality Center/ALM - (Instructional hours: 16, Lab hours: 08, Total: 24 hours)
As a Site Administration
As a Project Administrator
As a User
SQL, PL/SQL & TOAD - (Instructional hours: 16, Lab hours: 08, Total: 24 hours)
Oracle Database Administration - (Instructional hours: 08, Lab hours: 04, Total: 12 hours)
Oracle Database Architecture & Configuration
Oracle database management
Oracle Database Maintenance
Performance Management- Bottleneck performance analysis
Windows Server 2008 R2- (Instructional hours: 08, Lab hours: 04, Total: 12 hours)
Introduction to Windows Server 2008 and Windows Server 2008 R2
Managing Active Directory Domain Services
Monitoring and Maintaining Windows Server 2008
Oracle object management - (Instructional hours: 08, Lab hours: 04, Total: 12 hours)
The History of SQL Server and relational databases
Installing and configuring SQL Server
SQL Server data storage management
Managing data with the DTS utility
SQL Server Security management
SQL Server Backup & Recovery
SQL Server Job scheduling
SQL Server SSIS
SQL Server Advanced Tools
HP Load Runner - (Instructional hours: 16, Lab hours: 08, Total: 24 hours)
Overview of Load Testing
Overview of HP Load Runner
Load Runner Scripting Planning a Script
Jmeter - (Instructional hours: 12, Lab hours: 06, Total: 18 hours)
Managing performance testing project
Building Test Plans
Analyzing and Interpreting Load Test Results
Visual Studio -Load Testing - (Instructional hours: 12, Lab hours: 06, Total: 18 hours)
Overview of the web performance and Load test
Prerequisite steps to start your Load test
Web Server and Monitoring Tools - (Instructional hours: 08, Lab hours: 04, Total: 12 hours)
Overview of Performance Testing Monitoring
Java Application deployment on Web Sphere
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.
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.