Data Warehouse and Database and OLTP Difference and Similarities

What is a database? The database is an organized collection of data. Databases store the data and help in managing the data efficiently. It supports many operations such as update data, deletes data, modifies, view data. Some examples of databases are a hospital patient’s database, telephone directory, and social networking sites data, etc. What is a data warehouse? A data warehouse is a database consisting of historical data ranging from 5-10 years old data. A data warehouse is populated from multiple heterogeneous sources. It is a subject oriented, time-variant, involatile…

How to do Backend Testing?

STC Admin
June 27, 2018
Basics of Software testing / Database Testing / Types of 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…

Step by Step Guide on Database Testing using Selenium

STC Admin
March 28, 2018
Automation Testing / Database Testing / 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…

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…

ETL Testing / Data Warehousing Testing

STC Admin
June 17, 2015
Data Warehousing Testing / Database Testing / ETL 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…

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?…

Older Posts →

Data Warehouse and Database and OLTP Difference and Similarities

How to do Backend Testing?

Step by Step Guide on Database Testing using Selenium

Simple Guide to Install MySQL Database And Workbench

ETL Testing / Data Warehousing Testing

What is database and why do we need them?

Selenium

Database

UFT - QTP

Software Testing

JMeter

Mobile Testing

Test Complete

TestLink

JIRA