| User Interface Testing is also known as Front-end Testing. |
Backend Testing or also known as data testing. |
| Tests all testable items that are visible to the user in the application such as forms, buttons, menus etc. |
Tests all testable items that are not visible to the users but are essential for the proper functioning of the system. |
| Tester need not know SQL. |
Tester needs to know the database technologies like SQL to run the queries and validate the data. |
| Majorly deals with the look and feel of the software application. |
Mostly deals with the data integrity, validation of schema of the structures where the data resides, validating data duplication, referential integrity and everything that deals with data. |
| Some of the tools that we use for GUI testing are: Katalon Studio, RAPISE by Inflectra, TestComplete, Abbot Java GUI Test Framework, AutoIt UI testing |
Some of the tools are Database Rider, Db stress, DbUnit, DB Test Driven etc |
