How to do Backend Testing?

In today's class, we are going to learn about What is backend testing and how to perform such testing. Almost every software application retrieves or stores data at backend which could be a server or database or both. Software application could store data as files on server or store data in a tabular manner into RDBMS (Relational Database Management System) database. The backend database could be SQL Server, MySQL, Oracle, Sybase, DB2, etc. which are capable to store data and organize data in the tables as records. Alternatively, there are…

Continue Reading

Step by Step Guide on Database Testing using Selenium

Welcome back to Selenium Tutorial series. If you missed any article in Selenium series then you can also check the article on Selenium WebDriver In this chapter, we are going to discuss on how to do the Database Testing using Selenium WebDriver. As we are aware that WebDriver API is only good to test a web application using various web browsers, therefore, in order to include database testing i.e. storing or retrieving test data from the database we need to use the JDBC Connection ("Java Database Connectivity"). What is JDBC…

Continue Reading

Simple Guide to Install MySQL Database And Workbench

In this tutorial, we are going to learn about how to install MySQL Database and workbench Installation. Install MySQL Database Steps: STEP 1: Download MySQL installer from below link and install it into your system. http://dev.mysql.com/downloads/mysql/ After loading the above URL, you will see a web page as shown below. From this page click on the download link button to download MySQL installer.     STEP 2: Once download gets completed, you will observe a file with the below file name. It will be of around 320 MB. Double click…

Continue Reading

ETL Testing / Data Warehousing Testing

In previous article we learned about "What Is Difference Between SDET And TESTER?" In today's class we are going to cover What is importance of ETL testing and Data Warehousing, importance, testing classifications, testing procedures etc. Introduction on ETL Testing: ETL stands for Extraction, Transformation and Loading of data. In data warehousing, data from multiple data sources is extracted, transformed (as per the business logic and data definition of target database) and loaded into cohesive database. Data warehouse efficiently handles day to day data along with organization's historic data which…

Continue Reading

What is database and why do we need them?

Welcome to next post related to Database. Everyone know about the database, it is used to store the data. However the data can be stored in the excel file or in flat files. Have you think about "What is actually meaning of database and why do we need them?" If you want to understand database then don’t start with the features of database first, rather you should go with other way round. Database are used to solve few problems. Now question in your mind is that what kind of problems?…

Continue Reading

SQL Functions

In previous articles we have seen about different SQL commands to get store and retrieve the data from database. We have also learned about how to manipulate the data before saving or getting the data. The SQL supports number of useful functions and in this article we concentrating on those SQL functions with detailed description with Sql function examples & how to write function in sql.   What are Functions? The SQL Functions are different built in special type of commands in SQL. Functions are one-word command set which return…

Continue Reading
Close Menu