Back end & front-end Testing

Front-end Testing

Front-end testing validates what the user sees and interacts with—UI layout, navigation, input validation, and whether actions produce the expected visual results.

Back-end (Database) Testing

Back-end testing verifies what happens underneath the UI—whether data entered through the front-end is correctly stored, updated, or deleted in the database, and whether stored procedures and triggers behave as expected.

Why Both Matter

A form might show a "Success" message (passing front-end testing) even if the data was never actually saved correctly in the database—only back-end verification catches this class of defect.

Typical Back-end Checks

• Confirming data integrity and correct values after an operation.
• Verifying transactions commit or roll back correctly.
• Checking stored procedures, triggers, and constraints work as designed.