What is back-end Testing?

 

https://www.guru99.com/frontend-testing-vs-backend-testing.html

Backend testing is a type of testing that checks the Application and Database layer of a 3 Tier Architecture.

API Testing -> Business Layer

Database Testing -> Database Layer

Database Testing

 It means that data entered in the front end will be checked in the back-end database. 

Databases are checked for ACID properties, CRUD operations, their Schema, Business rule conformance. Databases is also checked for Security and Performance.

In back-end testing, there is no need to use the GUI. You can directly pass the data using a browser with the parameters required for the function to get the response in some default format. For Example, XML or JSON. You also connect to the database directly and verify the data using SQL queries.

• Structural testing deals with the database inner structure (i.e. metadata). It involves validation of Tables and all the other database objects that aren’t directly accessible by users, like Columns, Keys, Indexes, Schema, Triggers, Functions, etc. It can also involve testing your DB servers.
• Functional testing focuses on the way data is mapped from the frontend to the database. (e.g. whether clicking a button correctly affects the related tables/columns).
• Non-functional testing checks how the database performs under the expected loads and extreme levels of stress. Security tests also belong here 

•