Posts

How much SQL is needed for Test Engineer?

Often wondered how much database knowledge is must for a Test Engineer? Most of the case simple querying to database does the job. It is recommended to have some more than just simple  Select * from tablename; Basics concepts of when to use Group By clause.Also, aggregate functions like count, sum, NVL, etc. Know how to use joins and difference between inner and outer (left and right) joins . Some advance concepts like indexing like use of Primary and Foreign Key and Unique key . Executing the User defined function and Stored Procedure.Difference between Store Procedure and Function.   If you are comfortable learn about query optimization. ACID properties of transactions Often most of the time out of nervousness candidate mix up the concepts learned or are unable to demonstrate knowledge. Once such example is unable to write query on paper during face to face interview. Such situations can only be avoided by practice and practice writing queries on paper. One needs to creat...

Software Testing Course

 Software testing courses recommendations. Introduction What is Software testing?  How do you perform software testing? Are there specific tools used to perform software testing? Often a beginner have such questions in mind when he/she is starting out his career. Software testing is done by professionals having a specific mindset. It is just like any skills that the Testing professionals need to develop.Like any skills it needs time and practice to develop that mindset. For beginners and experienced candidates who have need to refresh his/her own understanding about the QA methodologies and testing techniques here are following recommendations for them. Guru99.com Refer the following article on the website to get the basic cleared. https://www.guru99.com/software-testing.html You will learn the basics of software testing and software testing techniques with examples. Also how to write test cases and test scenarios. Udemy Course  MasterClass Software Testing with Jira ...

Major testing types

Functional Testing  Ad-hoc Testing Ad-hoc testing is a form of software testing where the tester explores the software system in an unstructured manner. The objective is to discover defects and issues by interacting with the system randomly. Ad hoc testing is often conducted when there are limitations in terms of time or resources for formal testing, or when testers aim to quickly understand the system's behavior. Exploratory Testing   Exploratory testing is a dynamic and flexible approach to software testing that enables testers to actively explore the software system. Rather than adhering to predetermined test cases, exploratory testing leverages the tester's expertise, experience, and creativity to design and execute tests in real-time, as they delve into the system. Regression Testing   Regression testing is a vital software testing approach that validates whether modifications, updates, or bug fixes to a software system have unintentionally introduced def...

Java Collection Framework.

Collection framework divided into Classes and Interfaces Classes : Arrays, Collection Interfaces : Collection, Iterator and Map Classes implementing collection interface : 1. List - ArrayList, LinkedList, Stack and Vector 2. Set - EnumSet, HasSet, LinkedListSet and TreeSet 3. Queue - ArrayQueue, LinkedList and PriorityQueue.

Automation interview questions

 Interview Questions for Automation Testing 1.Which combination of automation tools and Application under test will form wrong combination?   Selenium - Desktop Application.   Note: One can use  WinAppDriver to automate windows application. It is based on webdriver of selenium. 2. Example of automation tool Selenium , Cypress - Web Automation Test Complete and QTP- Desktop,Web and Mobile. Appium - Mobile. RestAPI, Postman - API automation. 3.Which Test Cases to Automate? Test cases to be automated can be selected using the following criterion to increase the automation ROI High Risk - Business Critical test cases Test cases that are repeatedly executed Test Cases that are very tedious or difficult to perform manually Test Cases which are time-consuming The following category of test cases are not suitable for automation: Test Cases that are newly designed and not executed manually at least once Test Cases for which the requirements are frequently changing Test cases ...

Selenium Cheat sheet

If you are a Manual Tester /QA and aspiring to become a Automation Tester / Software Development Engineer in Test (SDET) and you are looking for a place where you can get all the command or basic commands through which you can accomplish your task then you are at the right place. Here, we will be discussing the selenium commands that we normally use in our automation journey.    It can be categorized in the three categories 1. Driver commands Driver commands are the ones that identify the browser and perform navigation in the browsers  Webdriver driver = new ChromeDriver(); System.SetPropery   2. Locators Locators are the one that allows us to perform and identify the elements on the web page;only condition is the elements should be visible and accessible on the web page. 3. Actions   Actions are the actual operations the can be performed on the html elements or controls.    

Working with cypress automation tool

  Cypress is an automation tool for web application. You can use javascript to develop automation scripts.It has inbuilt browser for testing application and takes automated screen shots for each test steps in the testcase. It runs on node.js. Following are the step you will need to follow to get started with Cypress.   1. Check the Version of Node.js Before you begin, it's important to check if Node.js is installed on your system. If Node.js is already installed, verify the version.     cmd.exe>node --version 2. Installing Cypress   Now that Node.js is installed, let's move on to installing Cypress, which is used for end-to-end testing of web applications.     cmd.exe>> npm install cypress  3. How to work with node.js.     Create a folder (cypressdemo) Create package.json file.to create the node.js project you require package.json.   The command is : cmd.exe>npm init    .Run...