Automation QA

SQL Fundamentals

• DDL Statements – CREATE, DROP, ALTER, etc.
• DML Statements – UPDATE, RENAME, DELETE, TRUNCATE, ALTER, MODIFY, etc,
• DQL Statement – SELECT
• Restricting and Sorting Data –
• Date and Time
• Join, Merge Tables
• VIEWS, INDEX, Stored Procedures, Managing synonyms, and sequences.

 Core Java

• Introduction to Java
• Class and Object, Variables and Methods in java
• Constructor in Java
• Object Oriented Concepts
• Polymorphism
• Operators and type casting
• Loop control, and decision making
• Reading I/P from keyboard and wrapper classes
• Array in Java
• Two-dimensional array and jagged array
• Strings handling in Java
• String methods and command line arguments
• Abstract class and interface
• Packages and Access modifiers
• Exception handling in Java
• Custom exception throw and throws
• Collections in Java
• Collections – List and queue
• Collections Set
• Map interface
• Generics in Java
• Generic methods and wild card
• Multithreading in Java
• Multithreading in Java
• Threads miscellaneous
• Thread communication
• Deadlock in multithreading
• Input/Output streams
• Class hierarchy of Java.io package classes
• File Handling in Java
• Filewriter and filereader class
• Compressing and uncompressing files
• Serialization and Deserialization
• Java Networking
• Chatting application using Socket programming
• Downloading a file – How to download a file at server machine into client machine using Socket Programming?
• Multiple client and One server application
• Reflection API
• Object creation using a new instance
• Java AWT
• Event handling
• Swing
• Java Annotations
• Java i18 regular expression
• Nested Classes, Java Bean Class and Lambda Expression
• Java Database connectivity (JDBC)
• Java Miscellaneous

Manual/functional Testing

• Software and its advantages in application, Types of Software, Types of Application software
• Principles of Software Testing, Fundamental Test Process, Introduction of Software Testing, Why Software has issues, How to find these defects, Error Terminologies, Goal of software Tester, Quality, QA, QC, Cost of Quality, Software development life cycle, SDLC Models – Waterfall & Agile
• Major Testing Activities, who can perform testing, Types of testing – Verification & Validation, V Model, Level of testing – Unit, Integration, System, UAT, Testing team structure
• Software Testing process, Test Plan document, Methods of Testing – Black box & white box.
• Test Scenario and test case, Test case review checklist – Common test case mistakes, Test Data introduction
• Test case design techniques for Black box testing – ECP, BCA, Error Guessing, Decision table
• Negative testing, Entry criteria for test execution, Smoke Testing, Retesting, Regression Testing, Exit criteria
• Defect Introduction, Severity, Priority, Defect Life Cycle
• Other Non-functional testing – Database Testing, User Interface testing, Usability testing, Accessibility testing, Localization testing
• Performance testing, Installation testing, Cross browser compatibility testing
• Introduction to Agile
• JIRA Introduction, JIRA Dashboard, JIRA Project, Kanban Board & Sprint Board, what is sprint
• JIRA Issue Template, JIRA issue and types, JIRA Search
• JIRA Test case management
• Project – requirement study, test case creation & review
• Project – test case execution, defect reporting
• Presentation

Selenium and Appium Testing tools

• What is Automation testing? Why do I need automation testing? Disadvantages of automation testing? Few Popular Automation tools, when to start automation How to automate.
• Maven Introduction, Maven Installation, Maven Repository
• Selenium Introduction and components – Selenium IDE, RC, Web driver, Grid, Limitations of Selenium.
• Selenium Locators.
• Introduction to Xpath, Css Selector, Find element methods in selenium.
• Work with various Web elements.
• Mostly used Selenium methods.
• JavaScript in Selenium, Iframe in Selenium.
• Keyboard and mouse handling, Alert handling in Selenium, Exception handling.
• Implicit Wait & Explicit Wait in Selenium, Data driven testing using Apache POI. POM.
• TestNg Introduction, Advantage of testNg , testNG Annotations.
• TestNG Assertions, TestNG dependency and groups, Run test cases by xml file.
• TestNg Listeners, TestNg Data provider and parameter.
• TestNg Parallel Execution, Log4J Logger.
• Capture application Screenshot for test report. Cookie handling.
• Headless browser testing. Verify tooltip.
• Appium Introduction, Appium Architecture.
• Appium Installation step by steps, Desired Capability.
• Appium Locators, Press device back and Home button.
• Different way to Scroll down, Swip. Native Mobile Applications and Mobile Web Applications.