Software Quality Assurance and Testing Analyst

Program details

1. Introduction to computer: Microsoft Excel

This Module covers the requirements to master the skill of how to use Excel very well at work. A Trained QA Analysts should know how to work and format worksheets, work with charts, doing test cases in Excel, and work with databases, templates and validating data.

• Know the basic concepts and techniques of Microsoft Excel
• Know the basic skills of using Microsoft Excel
• Knowledge of how to create charts for test cases in Excel
• Ability to save and manipulate excel workbook as static webpage
• Ability to save and manipulate excel workbook as a dynamic webpage
• Create worksheet and embedded charts, formulas, functions and web quarries
• Create static and dynamic web pages using Excel
• Create Templates and working with multiple worksheets and workbooks

2. Introduction to Internet

This module covers the requirement to master the skills of using the internet at work. The trainer QA Analyst will learn how to use and customize the Internet Explorer browser and investigate the various components of the internet, including the World Wide Web, Email, Newsgroup ,Mailing lists, discussion group, etc.

• Knowing the basic concepts and techniques of the internet
• Knowing the skills of using Internet at work
• Internet Knowledge that later on in the course  contributes to web testing

3. Methodologies/strategies software testing

The demand of the software industry requires full scale testing of the product before release to the customer. This module is designed to teach students from basics to structured software testing methodologies. Topics include manual testing theory and methodologies, ability to create test tree and identify bugs . You will learn key testing concepts, such as Regression, GUI, Security, and User Acceptance Testing, all stages of the SDLC and etc and will be able to practice those theoretical concepts in real life projects.

• Knowledge of the 5 most commonly used stages in the SDLC process
• Understanding of the importance of testing/QA role in the SDLC process
• Understanding Black Box Vs White Box approaches in SDLC process
• Ability to incorporate Expected Result Coverage Methodology in performing test execution
• Ability to incorporate Equivalent Partition methodology in creating a test tree
• How to use the Boundary condition methodology in order to create test cases
• Being able to understand the importance of test coverage and the purpose that trace ability Matrix has been created
• Ability  to generate basic statistics for test cases coverage
• Ability to understand requirement or FRS and covering each sentence of the requirement with test cases

4. Hands-On Software Testing – 5 projects

This module covers introduction to one of the most important QA manual testing tools HP Quality Center. After students are familiar with this tool, we are starting to write the necessary documentation. So students will have hand on experience in writing test plan, divide documentation to test tree and writing test cases.

• Theoretical knowledge of the theory of Equivalent partition and how it is used in dividing FRS
• Knowledge of test types and test scenarios used for most applications
• Understanding and inquiring experience in this methodology by practicing writing it in the following projects
• Understanding and applying the theoretical framework into creating test cases
• Ability to create Positive and Negative test cases
• Inquiring great hands on experience by practicing to create test cases five given applications
• Understanding and applying the theoretical framework into doing test execution
• Inquiring experience in this methodology by practicing to test execute five given applications
• Demonstrating ability to write appropriate bug reports

5. Automated Testing Tools QTP

Knowledge of automation tools has become a very important part of QA. HP Quick Test Professional (QTP) is one of the most popular tools available in the market right now. In the QA Industry to have knowledge and expertise in Automation is considered a great competitive advantage. In this module we will gain theoretical and practical hands on experience with QTP. We will learn the main basic functions of QTP such as Record and Run scripts and move on to more complicated ones such as output values ,VB Scripting and adding objects to repository.

• Knowledge of what is the benefit of automation
• Knowing when is QTP implemented in the SDLC process
• Understanding Regression Testing and the role of automation
• Ability to creating Loop and double Loop in VB scripting
• Ability to add objects to object repository by VB scripting
• Ability to add objects to object repository by VB scripting
• Ability to add  Recovery Scenarios so that nothing will be able to stop the test from being fully automated and running smoothly
• Being Consistent with the script and make sure no errors occur due to inconsistency

6. Performance Testing in LoadRunner

HP LoadRunner is the industry standard for performance testing. Load Runner is extremely flexible for organizations and projects of all sizes. LoadRunner software testing tool enables you to test a range of applications. In this module we will learn the theoretical components of performance testing with LoadRunner such as terminology only used in LoadRunner. We will also have an opportunity to create some real life Load and stress scenarios using this tool.

• Understanding load and stress testing
• Understanding the 3 main stages for Performance testing in Load Runner such as : User_init, Action, User_ End
• Good understanding of Load Runner Testing Process such as: Planning the test and Creating Vusers scripts and etc
• Performing Load Performance Testing scenarios
• Performing Stress Performance Testing scenarios
• Performing Ramp up or Ramp down scenarios
• Ability to parameterize data entered at login
• Ability to add more virtual users
• Ability to parameterize credit card values entered at payment screen

7. SQL Database Testing

Databases is the collection of interconnected files on a server, storing information, as a result, many kinds of implementation and integration errors may occur in large database systems, which negatively affect the system’s performance, reliability, consistency and security. Thus, it is important to Test databases and the most common way of testing them is with SQL. In this module we will learn what is SQL and how to make database queries in SQL. We will learn some basic functions such as Insert , update and delete and move on to more complicated queries such as joint 2 to three tables .

• Understanding why Datebase Testing is so important
• Good understanding of the RDBMS  process
• Understanding the theoretical framework of SQL and Database
• Demonstrating the ability to delete unnecessary information in order to fix an error in a SQL table
• Demonstrating the ability to update queries and fix errors
• Demonstrating ability to create a table and  insert values in each row
• Demonstrating ability to Join tables
• Demonstrating ability to have multiple queries

8. Job Search and Career Development

This course helps students to prepare for employment, conduct a successful campaign to find employment and to be successful in their career as a QA Analyst/ Tester.Topics covered include preparation of a resume, covering letter and thank you letter to use in the job search as well as the importance of life-long learning.

• Explain how to effectively write resumes, cover letters and thank you letters
• Understanding the importance of cover letters and thank you letter
• Exhibit effective time management, accountability, following established dress and work code and acting in a courteous, confident and dependable manner
• Present an enthusiastic, self confident attitude
• Recognize and build on transferable skills
• Create an effective Resume
• Be able to handle and diffuse objections
• Create effective Cover and Thank You letters

9. Work Placement

Near the conclusion of the program, students are required to complete 300 hours of work placement in a medium to large sized Software company in any industry that posses an Information Technology department. Activities performed will vary depending on the Work Placement site, however key responsibilities of each student include being supervised by a Placement Host at all times, observing all necessary workplace safety and security procedures, dressing appropriately, interacting respectfully with placement staff and treating the work placement site’s property with necessary confidentiality and appropriate respect. The students will have an opportunity to learn and observe Work Placement staff’s jobs, environment and daily routine.