I just completed the last day of this software testing tutorial, and I couldn't be more thankful for the incredible resource it has been! As someone diving into the world of software testing, I found the content comprehensive, well-structured, and incredibly valuable.
**Title: Database Testing - Software Testing Tutorial #48** **Understanding Databases:** - Databases store and manage data for software applications. - They act as digital filing cabinets, storing information in tables on a server. - Databases play a crucial role in web applications, managing user data and application information. **Front End vs. Back End:** - The front end is what users see and interact with in a web application. - The back end is where data processing and storage occur. - Data entered in the front end is sent to and stored in the database. **Database Testing Overview:** - Database testing ensures the correct functioning of databases, including their design, schema, and logic. - It verifies that data is accurately stored, retrieved, updated, and deleted. - Database testing also checks business rules and integrity to maintain data accuracy. **Key Aspects of Database Testing:** 1. **Database Schema:** Examining how tables are structured, data is organized, and tables relate to each other. 2. **Data Integrity:** Ensuring data remains accurate and consistent during insert, update, and delete operations. 3. **Business Rules:** Testing rules implemented within the database to maintain data quality. **Activities in Database Testing:** 1. **Data Mapping:** Verifying that data input on the front end is correctly mapped and stored in the database. 2. **ACID Properties Verification:** Ensuring Atomicity, Consistency, Isolation, and Durability in database transactions. - **Atomicity:** Transactions treated as a single unit, succeeding or failing together. - **Consistency:** Database remains consistent before and after a transaction. - **Isolation:** Multiple transactions do not interfere with each other. - **Durability:** Data persists after a transaction is complete. 3. **Data Integrity:** Validating CRUD operations (Create, Read, Update, Delete). 4. **Business Rules:** Testing database-implemented business logic. **Conclusion:** - Database testing is essential for ensuring data accuracy and functionality in software applications. - It involves activities like data mapping, ACID properties verification, data integrity checks, and testing business rules.
Today completed entire Software Testing Tutorial series!😊 Now I feel more confident.😎 Thank you so much Manish sir for making such type of videos.👏 Keep up the good work. 🙏🙏🙏
Epic Sir🎉 I have finished all your videos, sir, you have taught me very well.👍🏻👍🏻👍🏻👍🏻👍🏻 Keep teaching like this Sir. Thank You!!!!😄 Understood all concepts clearly. Keep guiding like this 🎉
Thank you! This is good start to be a part to know the basics of DB testing. All will be informative if we get to know the detailed things about the Backend testing.
I watched the whole course. and its very helpful and now currently i am working in technical support with 1.9 year exprience in product base company and want switch to technical support to mannual tested Please guide me sir #now what next to study >>>>>> Thanks for this valuable series
Good video. May I recommend breaking the video up in to two sections? One for introduction to Databases. Second for testing Databases with actual demo. Reason is newbies to Databases wouldn't know what to do with Database testing until they've spent time in Databases
Hello, thanks for the information shared. I will use your course as guide for an interview, i hope will make it. Thanks for all videos from this course.
I just completed the last day of this software testing tutorial, and I couldn't be more thankful for the incredible resource it has been! As someone diving into the world of software testing, I found the content comprehensive, well-structured, and incredibly valuable.
**Title: Database Testing - Software Testing Tutorial #48**
**Understanding Databases:**
- Databases store and manage data for software applications.
- They act as digital filing cabinets, storing information in tables on a server.
- Databases play a crucial role in web applications, managing user data and application information.
**Front End vs. Back End:**
- The front end is what users see and interact with in a web application.
- The back end is where data processing and storage occur.
- Data entered in the front end is sent to and stored in the database.
**Database Testing Overview:**
- Database testing ensures the correct functioning of databases, including their design, schema, and logic.
- It verifies that data is accurately stored, retrieved, updated, and deleted.
- Database testing also checks business rules and integrity to maintain data accuracy.
**Key Aspects of Database Testing:**
1. **Database Schema:** Examining how tables are structured, data is organized, and tables relate to each other.
2. **Data Integrity:** Ensuring data remains accurate and consistent during insert, update, and delete operations.
3. **Business Rules:** Testing rules implemented within the database to maintain data quality.
**Activities in Database Testing:**
1. **Data Mapping:** Verifying that data input on the front end is correctly mapped and stored in the database.
2. **ACID Properties Verification:** Ensuring Atomicity, Consistency, Isolation, and Durability in database transactions.
- **Atomicity:** Transactions treated as a single unit, succeeding or failing together.
- **Consistency:** Database remains consistent before and after a transaction.
- **Isolation:** Multiple transactions do not interfere with each other.
- **Durability:** Data persists after a transaction is complete.
3. **Data Integrity:** Validating CRUD operations (Create, Read, Update, Delete).
4. **Business Rules:** Testing database-implemented business logic.
**Conclusion:**
- Database testing is essential for ensuring data accuracy and functionality in software applications.
- It involves activities like data mapping, ACID properties verification, data integrity checks, and testing business rules.
Thank you!!!!!
Thanks ..your notes helped me
Today completed entire Software Testing Tutorial series!😊 Now I feel more confident.😎 Thank you so much Manish sir for making such type of videos.👏 Keep up the good work. 🙏🙏🙏
You are welcome😊
Keep watching for more videos and tutorials.
Epic Sir🎉 I have finished all your videos, sir, you have taught me very well.👍🏻👍🏻👍🏻👍🏻👍🏻 Keep teaching like this Sir.
Thank You!!!!😄 Understood all concepts clearly. Keep guiding like this 🎉
I watched the whole course. Even now after 3 years this information was very helpful. Thank you !
Is this course enough to get job Or internship
Thank you so much for this course. It has been extremely helpful!
Thank you! This is good start to be a part to know the basics of DB testing. All will be informative if we get to know the detailed things about the Backend testing.
Thank you so much for these super great tutorials, sir. You've helped me a lot.
Glad to hear that! Keep watching and sharing.
I will not hesitate to enroll into any of your classes.
I watched the whole course. and its very helpful and now currently i am working in technical support with 1.9 year exprience in product base company and want switch to technical support to mannual tested
Please guide me sir #now what next to study >>>>>>
Thanks for this valuable series
Hi Sir, With this Video I completed the course and prepared self notes . Now I will go through the Python with selenium videos.
Awesome @Naveen! Keep learning!! Thanks, Manish
How did you practice manual testing such as functional, system test types?
Good video. May I recommend breaking the video up in to two sections? One for introduction to Databases. Second for testing Databases with actual demo. Reason is newbies to Databases wouldn't know what to do with Database testing until they've spent time in Databases
Hello, thanks for the information shared. I will use your course as guide for an interview, i hope will make it. Thanks for all videos from this course.
Glad it was helpful! Keep watching and sharing.
Best Tutorial of Software Testing for Beginners
Many many thanks.
Keep watching for more videos and tutorials.
wonderful video, I think you really a dear and one of great gift to fresh testers. always very professional and very kind of you, thank you sir!
Sir What a explanation excellence thank you sir..
Great videos! Which videos do you suggest I see in order to learn about data testing?
Really appreciate your awesome work sir! Can you please advise when you will be uploading the next sessions? Thanks
how is the durability different from consistency , i have to write automation on this .. give coverage on this
Thank you for this video sir🥰
Sir i want to switch from database admin to database testing role ! , Please guide me with the same
Sir can i switch from DBA to Database testing ??
sir how to write database related test cases, test scenario. which standard template follow to write test cases, test scenario
Is there any difference between you tube video and your given link video?
Thank you sir
Welcome!😊
Keep watching for more videos.
Sos un genio, loco
Thanks a lot.
Hi..is this only one video on database testing or more ??
Hi Shraddha, Currently this is the only one but I will posting complete database testing tutorial series in couple of months. Regards,Manish
where r more videos sir .please reply
How many topic of SQL require for software testing
Sir this is the last topic of this course???
Hi Senthil, no, many more to come in this series. Stay tuned. Thanks, Manish