Posts

Top SQL Queries to practice for Interviews

During interviews , instead of directly asking questions on theoretical concepts, now a days interviewers ask SQL queries that test both the theoretical as well as practical understanding and usage of the different SQL concepts. In this post, we discuss some of the most common SQL queries for the interviews that you should prepare. So, let’s begin. Q1. Write a query to update a field’s values by removing any leading and trailing spaces.  Ans.  UPDATE command with LTRIM() and RTRIM() functions. UPDATE Table1 SET Name = LTRIM(RTRIM(Name)); Q2. Write an SQL query to return the count of occurrence of a character in a particular field.  Ans. For this query, we will use the Length() function with the subtraction operator and aReplace function.  SELECT Name, LENGTH(Name) - LENGTH(REPLACE(Name, 'k', '')) FROM Employee; Q3. How can we create a new table with data and structure the same as an existing table?  Ans. Creating a new table just requires us to use the CREATE TABLE comm

Complete software testing tutorial

Image
In this tutotial, we will learn about the basic of Software Testing concepts. With our software testing tutorial series , you will learn different types of  testing concepts with a practical approach. In order to increase the quality of software , it is very important to make sure the effectiveness of software application. What is Software Testing The present universe of innovation is totally overwhelmed by machines, and their conduct is constrained by the product controlling it. software testing gives a financially savvy answer for every one of our concerns.  software Testing is an interaction of assessing the usefulness of a product application to discover any product bugs. It checks whether the created programming met the predefined necessities and recognizes any imperfection in the product to accomplish a quality item. It is fundamentally executing a framework to recognize any holes, blunders, or missing prerequisites as opposed to the real necessities. Different Types of Software

How to learn selenium automation

Testing is a way to verify the working of an application by testing it against the expected outcome. Software testing is done in two ways- Manual and automated. Although Manual testing has been reliable for the longest time it is also tiring and monotonous. To overcome this problem maximum companies have shifted to automation testing. It is necessary to learn selenium  as it helps in automating test cases repeatedly in less time and more reliable as well.  What is Selenium? Whenever automated testing is talked about, Selenium is the most common name that comes to mind. It is one of the automation tools used for web applications. Let us dive into the article to know- ‘how to learn selenium automation?’ Selenium is an automation tool to automate web applications. Selenium is an open-source platform that makes it readily available to everyone. Selenium is a suite that contains multiple tools to assist with different automation. These are  Selenium Integrated Development Environment (IDE) 

Top 5 manual testing interview questions

 Prepare for interview with our list of top 5  manual testing interview questions with answers  that you can use to boost your confidence before sitting down for any interview. Q1.What is manual software testing, and how it is different from automated software testing?  Ans.Manual testing is a process where human testers manually run test cases, then generate resulting test reports. With automation software testing, these functions are executed by automation testing tools such as test scripts and code. The tester takes the end user’s role to determine how well the app works. Q2. Why is Software Testing Required? Ans. Software testing is a process that guarantees that the product is safe and good enough to be released to the market.  We need software testing for the following reasons-:  It points out the defects and errors that were made during the development phases.  Avoidable defects leaked to the customer without proper testing adds a bad reputation to the development company. Ensur

Top 5 Resources to Learn Selenium

Over the past few years, Selenium has gained a lot of popularity. When it comes to automation, Selenium is the most popular automation tool .Web developers can use that to test their applications. In this article, we have talked about the Top 5 Resources To Learn Selenium. Selenium WebDriver Training with Java Basics ( udemy course )  Automation testing is in huge in the testing industry. It makes tasks easier. . This course is self-paced course available for life-time. It come with 150 hours of online lecture videos, live projects, a certificate of completion, and 60+ downloadable resources. It is well suited for people that are searching for Java-based automation course. The course is not expensive but with the inclusion of topics from beginner level to the advance level, the course is worth the money. The course starts from scratch therefore keep your worries aside and start learning. Software Testing Help ( Youtube Channel )  This is one of the most popular sites and YouTube channe

Sample Test Cases for Pen

  It is often asked in interviewers to write the sample test cases for the pen  . It becomes quite harder to write them unless we break the test cases down into multiple categories like – , specification, negative tests, usability tests and  performance  etc. So in this article, I’m sharing some of the sample test cases, both positive and negative, for the pen.  Going through these test cases will  help you in understanding the process of making test case which you can use while creating test cases of any kind of application. Performance Test Scenarios of pen  Verify if tip or nib of the pen is not destroyed after continuous working for hours. Verify how fast you can write with this pen. Verify ‘How much can be written in one refill?’ Verify if the pen will perform the same even though you use continuously for hours. Negative Test Cases for Pen Check pen stress testing by dropping pen down from practical height and verify if something is breaking. Keep the pen in water and try to writ

Software Automation Testing Basics | All You Need To Know About Automation Testing

 Undertakings across businesses keep on requesting quicker deliveries and quality programming to withstand the steadily changing business sector situation and rivalry.  With undertakings following DevOps and nimble techniques of programming advancement, programming testing structures a vital piece of it. The previous manual strategy for testing doesn't get the job done the present-day associated gadgets and confounded engineering applications with industry 4.0 set up.  what is automation testing? As per WIKI, automation testing is the utilization of programming separate from the product being tried to control the execution of tests and the correlation of real results with anticipated results.  Test automation can robotize some redundant however vital errands in a formalized testing measure effectively set up, or play out extra testing that may be hard to do physically.  What does Test Automation Do? Test computerization is basic for persistent conveyance (CD) and ceaseless testing