Education

Software Testing Tutorial #48 - What is Database Testing

by Software Testing Mentor

📚 Main topics

What a database doesData submitted through a website or app is stored in a database and can later be retrieved to display or update a user’s information. 3:04
What database testing coversIt checks the database schema, tables and relationships, data integrity and consistency, triggers, stored procedures, and business logic—not just the website’s visible functionality. 5:07
Four areas to verifyThe tutorial highlights data mapping, ACID properties, data integrity, and business rules as key areas of database testing. 8:18

✨ Key takeaways

Data mappingCheck that information entered on the front end is saved in the correct database columns. 9:49
Data integrity and CRUDVerify that creating, reading, updating, and deleting data works as expected, including that updated values are stored and deleted records are removed. 10:51
Business rulesTest database logic such as validation rules, which might reject a negative discount value. 12:53
ACID propertiesAtomicity means a transaction completes as a whole; consistency preserves valid data; isolation prevents concurrent transactions from interfering; durability ensures completed changes persist. 14:26

🧠 Lessons learned

Use practical examplesFollowing data from a registration form into the database and back to a profile page helps explain how database testing works. 9:18
Front-end testing is not enoughTesting the user interface alone does not confirm that database structures, operations, and business logic work correctly. 7:45

🏁 Conclusion/next steps

Prepare and continue learningRemember data mapping, ACID, data integrity, and business rules; the presenter says practical database testing and SQL will be covered in future tutorials. 18:37

what is database testing what is database testing in software testing database testing tutorial database testing database testing tutorial for beginners what is database testing? manual database testing database testing introduction how to do database testing manually how to do database testing software testing tutorial software testing tutorial for beginners software testing mentor rcv academy

Transcript excerpt

0:00 hello everyone welcome again in this software testing tutorial we are going to learn about what is database testing now before we get into the details of database testing i would like to explain a little bit with the example what exactly is a database in the real scenario if you're completely new to software testing or the concepts about the front-end backend database etc so i'll give a brief example of the database what exactly it means and

0:30 when we say database testing what it stands for so same example i'll take so nowadays you would have used lot many social media website ecommerce website right so there is a front-end that you usually coordinate with so you open the browser and on the browser you type in say for example facebook.com or if you are trying to buy any items you go to amazon.com or flipkart.com

1:00 and you open those websites in a browser so that is what the front end is so when you can see the website in a browser you can browse the product you can add the product you can do the purchase so anything that you see on the front end or you can access on in the browser or it is available to you as a mobile app is a front end because you can directly interact with that particular instance right

🔒 The full, searchable transcript is available with Pro.

Suggestions