| S.N. | User-Interface testing | Database or Data testing |
| 1. | This type of testing is also known as Graphical User Interface testing or Front-end Testing. | This type of testing is also known as Back-end Testing or data testing. |
| 2. | This type of testing chiefly deals with all the testable items that are open to the user for viewership and interaction like Forms, Presentation, Graphs, Menus, and Reports, etc. (created through VB, VB.net, VC++, Delphi Frontend Tools) | This type of testing chiefly deals with all the testable items that are generally hidden from the user for viewership. These include internal process and storage like Assembly, DBMS like Oracle, SQL Server, MYSQL, etc. |
| 3. | This type of testing includes validating the: – Text boxes – Select dropdowns – Calendars and buttons – Navigation from one page to another – Display of images – Look and feel of the overall application | This type of testing involves validating: – The schema – Database tables – Columns – Keys and indexes – Stored procedures – Triggers – Database server validations – Validating data duplication |
| 4. | This tester must be thoroughly knowledgeable about the business requirements as well as the usage of the development tools and the usage of automation framework and tools. | The tester in order to be able to perform backend testing must have a strong background in the database server and Structured Query Language concepts. |
Thank you for sharing this blog. It really help me clearing out my basics.