0

QA Advance with Automation+SQL+API In-class

This course covers Manual, Automation, Postman API, and SQL, is designed to provide a comprehensive introduction to the field for beginners. You will gain a thorough understanding of how organizati...

Instructor Name

Super admin

Category

Quality Assurance

Reviews

0 (0 Rating)

Course Requirements

CERTIFICATION

Quality Assurance – Advanced Level [Manual Testing + Automation Testing + Postman + SQL]

Course Description

This course covers Manual, Automation, Postman API, and SQL, is designed to provide a comprehensive introduction to the field for beginners. You will gain a thorough understanding of how organizations effectively execute manual and automated testing projects. Additionally, our Advanced Level Software Quality Assurance Course will equip you with the knowledge and expertise required to begin a career as a QA Analyst by teaching you advanced concepts, procedures, projects, and standards related to Quality Assurance testing.

This is Manual + Automation + Postman API + SQL, a complete course for a beginner to get into the field and you will learn everything about how manual and automated testing projects done well at the organizations. Our Advanced Level Software Quality Assurance Course will teach you the knowledge and understanding of the advanced level of Quality Assurance testing concepts, procedures, projects, and standards needed to start a career as a QA Analyst. This is a classroom and LIVE training course for any Canadian city. Once you register for these courses, we will send you admission confirmation and an invitation to attend training. This course does not contain a work practicum.

Course Outcomes

  • Online or Inclass sessions with plenty of practice  on real-time projects
  • LIVE trainer (only weekends and weekdays)
  • Theory + Practical exposure to Quality Assurance course content
  • Information-packed practical training starting from basics to advanced testing techniques.
  • Best suitable for beginners to advanced level users who learn faster when demonstrated.
  • Course content is designed by considering current software testing technology and the job market.
  • Practical assignments at the end of every session, work on a real-time project to apply your learning
  • Working experience on Jira/Zephyr tool for test case and defect management
  • A Session on Canadian Workplace Culture and How to survive on the job from Industry Experts (New
  • Resume Writing Assistance
  • Guidance on LinkedIn Profile Update
  • An online library full of all resource contents, study materials, journal articles, and conference webinar videos
  • Recruitment Agency personal referrals (Optional – one time and based on individual’s performance)
  • Starting salary after completing this course (Calgary/Edmonton/Toronto/Vancouver): 65k per year or $35 per hour

Course Self Paced

1 Detail Topic
Preview 1 Hour

Introduction (teacher/students) What is the Information Technology area? How is this working in real time? How projects made to IT What is software testing What are the gaps/how people are learning/why not getting jobs? Take an example of a current job from indeed.ca and go through roles and responsibilities (we will be doing the same learning what is asked in the job description) Importance of projects/practical approach in QA Role of QA Skills needed for the QA job Software Development Life cycle Agile / waterfall and its difference START LEARNING ABOUT PROJECT 1


1 Detail Topic

Principles of QA What is the Story/Requirement (take an example) What is the test plan/test strategy? And all other documents important in the project/enhancement Test Development Life cycle Testing Process and Different Modules What is release management/change management Types of test cases Different types of testing What is a scrum meeting/sprint planning / retrospective meeting? Take project/enhancement: Project 1 – Enhancement Walkthrough sprint planning Walkthrough test case design technique What is a test case and how to design it from requirement(s)? Walkthrough test execution and its templates Design test cases for a requirement /story (take an example from real-time)


1 Detail Topic

Review test cases designed by students Walkthrough where are we on the agile project / what is the status currently? Practice a scrum meeting (ask students to write down – what they achieved yesterday and what is the plan for the day?) Give access to Jira/Zephyr Walkthrough of the tool – main areas Issues: epic/story/test cases/bug/tasks Create a test case Create a test cycle Create a query All bugs All test cases All test cases, bugs, stories, tasks, etc. Save the query and share it with other members Create test cases from BRD / student’s work (excel) in Jira Create regression and integration test cycles Ask to execute regression test cases from their regression cycle


1 Detail Topic

Talk about test execution in the regression test cycle Walkthrough test execution summary Create a dashboard report using add-ons Defect life cycle Create a bug Defect triage meeting Defect assignment and review of the work Test types: Functional, non-functional, security testing, SQL database testing, usability testing, exploratory testing Test closure: What reports go here? Test Summary / Bug Summary Sign-off Emails etc. Reports – test execution reports Reports – bug summary Scrum meeting – again Test Cases Reviews START LEARNING ABOUT PROJECTS 2 AND 3


1 Detail Topic

Installing automation tool, language packs Setting up a brand-new project Learning the basic structure of Visual Studio Understanding the test automation framework Methods and properties Benefits of using Automation Framework Different types of Automation Framework What is Data-Driven Framework What is Modular Driven Framework What is Keyword Driven Framework What is Hybrid Framework Launching Chrome Driver() WebDriver Interface Web Element Interface Another way of Navigating to a specific Page What are Web Element Commands? Difference between Find Element & Find Elements Enter & Clear text from the Input field How to Click action works differently on different elements Managing Input fields, Buttons & Links Finding all links on the Page Strategy to check dead links on the page Extracting More than one object from a page Extracting Objects from a specific area of a web page Check if the element is Present, Displayed, Enabled, or Selected Different Locators and using Firefox, IE, and Chrome to find them What are locators – ID, Name, Link Text, XPath, CSS, etc? Difference between Absolute & Complete XPath START LEARNING ABOUT AUTOMATION PROJECT


1 Detail Topic

Finding your first element Web Element Commands Element Inspector in Mozilla, Chrome, and IE Element locator tool for FF Firebug & Fire Path Add-Ons in Mozilla Various HTML locator strategies XPath Helper Plug-in for Chrome Add test methods () Console WriteLine Test Input from external Data Source CSV files Record results in external text files Capture screenshots for PASS/FAILURE steps Checkbox, Input box, Button, Radio Button, Dropdown elements Implicit and Explicit waits Learn how to implement and work Selenium Webdriver with Java and Eclipse Test Automation Job details and regression test automation needs Interview, resume, and LinkedIn profile guides


1 Detail Topic

AP test automation fundamentals API tools – open source and licensed Installations of tools Project work: a set of API test frameworks for a web development project Reporting on API test automation Fundamentals of SQL Tools and installations SQL commands and use of commands Testing data validations: Project Reporting on data validations


1 Detail Topic

STAT accomplishments Linkedin Interview – soft skills Interview – QA skills


Batch Content

1st Session: Introduction
  • Introduction (teacher/students)
  • What is the Information Technology area? How is this working in real time?
  • How projects made to IT
  • What is software testing
  • What are the gaps/how people are learning/why not getting jobs?
  • Take an example of a current job from indeed.ca and go through roles and responsibilities (we will be doing the same learning what is asked in the job description)
  • Importance of projects/practical approach in QA
  • Role of QA
  • Skills needed for the QA job
  • Software Development Life cycle
  • Agile / waterfall and its difference
  • START LEARNING ABOUT PROJECT 1

2nd Session: Workflow (Test Planning, Test Analysis, Test Design, Test Execution, And Test Sign-off)
  • Principles of QA
  • What is the Story/Requirement (take an example)
  • What is the test plan/test strategy?
  • And all other documents important in the project/enhancement
  • Test Development Life cycle
  • Testing Process and Different Modules
  • What is release management/change management
  • Types of test cases
  • Different types of testing
  • What is a scrum meeting/sprint planning / retrospective meeting?
  • Take project/enhancement: Project 1 – Enhancement
  • Walkthrough sprint planning
  • Walkthrough test case design technique
  • What is a test case and how to design it from requirement(s)?
  • Walkthrough test execution and its templates
  • Design test cases for a requirement /story (take an example from real-time)

3rd Session: Review of tools, test scenarios, Assignments
  • Review test cases designed by students
  • Walkthrough where are we on the agile project / what is the status currently?
  • Practice a scrum meeting (ask students to write down – what they achieved yesterday and what is the plan for the day?)
  • Give access to Jira/Zephyr
  • Walkthrough of the tool – main areas
  • Issues: epic/story/test cases/bug/tasks
    • Create a test case
    • Create a test cycle
    • Create a query
      • All bugs
      • All test cases
  •  All test cases, bugs, stories, tasks, etc.
    • Save the query and share it with other members
    • Create test cases from BRD / student’s work (excel) in Jira