Best video till date I have seen in RUclips for database testing. You are really blessings for people like me who wants to know complete details on database testing..hat's off to you
Thank you Inder, Your videos are of great help to testers.. You will be glad to know that by only learning from your videos I have cracked some of the interviews also This Database Testing video covers almost everything which a tester needs to know. Keep up the good work.. Thanks once again.
Many thanks, Vinay. You can also view my tutorials on Database Normalization and how to test it. The link is ruclips.net/video/m67fCU-Dmhg/видео.html&list=PLc3SzDYhhiGXDgSwZxhNUmCYX7uAFN1Uu
I never knew SQL testing was this straight forward. Thanks for your unselfishness to share your thoughts and expertise. I read your blog too, wonderful! Can I have more please?
Idowu Sholanke Glad to know that you liked my video. Further, using variables, logic and print statements, one can put SQL queries in a script and test every database build with this script. Please refer my database testing articles, SQL quizzes and more at inderpsingh.blogspot.com/search/label/Database%20Testing
Great 👍 I have watched your videos on Decision Table and Boundary Value Testing which are well explained. I have learned those tastings just out of your videos😊👍
@pardon mhlanga - Thank you for your wonderful comment. You may like other Database Testing Tutorials, especially on testing database normal forms and database quality concepts. The link is ruclips.net/p/PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE
Many thanks, Delipan G. You may like my other database testing tutorials that are available at the link, ruclips.net/video/eQG4W4Zr8eo/видео.html&index=3
excellent video on database testing. thank you very much for posting it. i really appreciate your hardwork. i was looking for some video on DB testing and this is the one which explains everything .. thanks again!!
Very Nicely presented Video, with simple SQL queries that really enhanced the ease for the beginners to go ahead with database testing effectively. I really liked your way of putting examples in such a simple manner. Thanks for the same. Regards, Suchi
Nora D If the categorization is black-box/ white-box, it would be under white box testing because we need to interact with the database internal objects like tables, views and so on. If the categorization is functional/ non-functional testing, it would be under both because we can test the functional aspects and non-functional aspects (like performance and security) both. Thank you for your question.
Hello Inder, Thank you for posting these beautiful videos. These are very simple and detailed. Can you please do a video about ETL testing if you have time. Thank you...
Hello Sudip, thank you for your suggestion. I would like to do a video on ETL testing in the future. In the meantime, please refer my article on ETL/ data migration testing at inderpsingh.blogspot.com/2010/03/how-to-do-database-migration-testing.html
as of very beginner point of view, I did not understand 1. Where did you get "customers" /"products" data, that appeared in the table already? 2. How did you get there on 12:18 ?
1) You can add the data, as shown from 3:48 using insert SQL statements. I added that data directly in SQL Server Management Studio 2) At 12:18, I have shown the database schema as a Database Diagram. Thank you for your questions.
Hello sir, quick question how would you test for data mapping? Let's say there is a Update data field mapping how would you test that? Thank you! So much for your assistance!! In helping me understand.
This is a basic test. The tester needs to verify if each front-end field maps with the corresponding back-end field in some table in the database correctly. This can be tested by the create, read, update and delete operations in the UI screen. These operations should result in the changes to the corresponding rows in the database table. Thank you.
Thank you so much for your response! I just would like to know 1 more thing. When creating a test case how would that look? Would you have steps for the UI and steps for the backend? I'm un-sure about how this would happen? Would I check the frontend data field first and after I'm done I move to the backend and verify the results? If you could please assist me with this..
The test case for data mapping testing would look like this. The steps would mention the actions to do in the UI. The expected results would mention the script/ query to run in the back-end. For example, in the create user test case, the steps would mention how to add the test data to add a new user. The expected results would mention the query to retrieve the record for the newly added user. Thank you.
The testing for data mapping involves a testing environment? What if the testing environment does not work then how would you test the data mapping?? I would like to Thank you so very much for your responses!! You are truly amazing! I appreciate all your responses and you are helping me grow into a field I would like to master one day. Thank you!
Of course, testing it requires a test environment. If the testing environment does not work, data mapping cannot be tested but it can only be reviewed by inspection of the data mapping document (part of system design documentation).
Thanks for this wonderful tutorial. Could you please help me by providing directions on how to check the health of a SQL Database that is in production. Basically, I am trying to come up with some sort of fast test or tools that can detect corrupted DBs that potentially slow down systems/applications. Could you please help me with that?
One way to do this is to note the initial average execution times of the frequently run SQL queries. In future, if these execution times increase greatly, you could investigate the reason and apply the suitable fix e.g. re-build the indexes. Thank you for your question.
If name is the same and other fields are different then it's not a duplicate value. There can be many people with same name but address and other credentials will be different.
At what time into the video did you notice this? I tend to write stored procedures much more often than functions. Because there are so many things we can do with stored procedures. Like accept inputs, select some data set and perform calculations based on inputs, implement business rules, produce outputs and return a data set. Thanks for your comment.
Hello sir, just curious to know what type of database testing is there? How do you define what type of test your performing? Like scheme testing, data testing and etc.. What terms can define each type of test and which ones are like routinely? Thank you! So much for all your responses.. There is so much to learn from all this and your amazing at it and explaining it. Thank you
There are different types of database testing like data migration testing (ETL testing), schema testing, data testing, also performance testing and security testing of databases. Out of these, I would say that data testing is more regular. Data migration testing is needed when data is moved from one system to another. Schema testing is needed when the database is first designed and whenever there are are changes to database schema. Thank you.
+ranjit nayak Thank you for your comment. If we need to test the performance of a web application, we can use a tool like JMeter or LoadRunner. Our business transaction (the workflow) can have the login step in the beginning. This can be implemented by providing username, password etc. to the login request. You can see my JMeter and LoadRunner videos under my playlist at ruclips.net/p/PLc3SzDYhhiGXVcy8EcrTSfwsC-v8EUZvg
Its good although some important topics such as Joins are missing and should have more elaborate with example specially incase of Procedure and Functions. Index is also missing
Hello sir, I have a question. As a tester do you test functions? If so, how do you test functions? Say code is being changed and a function is being added then how would that work? What if unit testing is not done by testers then how would that go? How is the test case going to look like? Sorry for all the questions but your honestly the best there is! Thank you!!!
Do you mean database user-defined functions? Basically, the functionality of the function can be tested by providing it different kinds of inputs e.g. no input, minimum/ boundary inputs, typical input, maximum/ boundary input, greater than maximum input. Then, compare the output received with the excepted output. I think that I have already given you an example of a database test case. Of course, a function has to be submitted to the tester for the testing to begin. Thank you.
Can all stored procedures be tested solo? What if a stored procedure is activated by a user action then how can you test that? What if the function in the developers data calls that stored procedure? What if the stored procedure is activated from a user action? Can that be tested without the frontend user action and invoke that solo from the backend? if you could please assist me with this that would be woundedful!! Thank you for all your support
The answer is yes. In this video, I have shown how to invoke a stored procedure directly in the back end (using Microsoft SQL Server Management Studio). This is shown around 27:00 into the video. We can test the functionality of the stored procedure by providing different types of inputs and comparison of outputs with excepted outputs. In addition, we can test the security and performance of stored procedures too.
Thank you so much for your response! How can you do security testing on a stored procedure? If you can give me an example? And one huge question I was wondering how/what kind of testing do you do for a developer code change? If unit testing is something that developers do? Thank you sir!!
Basically, we can review if a database object is secure or not. As you know, security is at different levels - the database server level, the database level and individual database object level. The stored procedure should have minimum privileges set for every group and user that needs it. For example, if an application needs to run a stored procedure, it should just have execute permission but not read or write permissions. If a developer changes code, the tester should first find out the impact of those changes. I have already explained this to you in an earlier question. Thank you.
Nice Informative Video, Good pace & sequence of taking through the topics. Excellent information shared in a short duration of time. Keep going Inder....thanks
Thanks for the amazing video! This has been an amazing point to start for budding database testers. I was wondering if you could suggest some resources where we could find information about how testing can be done on complex stored procedures and how to deal with frequent changes by developers and the large size of the database with respect to the number of objects and the data volume as well. Really appreciate your help!
Hi Prabhjot. Happy to know that you found this tutorial useful. We should test stored procedures' inputs, logic and outputs, performance and security. Please refer my videos on test design, especially Equivalence partitioning and Boundary value analysis (for input testing), Decision table testing (for logic testing) and others at the link, ruclips.net/p/PLc3SzDYhhiGWW0TzISFKqAN_ic8DnZvVc
@diksha malhotra - Thanks for your comment. You can view my (more advanced) videos on Database Normalization at the link, ruclips.net/video/m67fCU-Dmhg/видео.html
Many thanks, Swathi. You can also view my Database Normalization and how to test normal forms tutorials. They are at the link, ruclips.net/video/m67fCU-Dmhg/видео.html&list=PLc3SzDYhhiGXDgSwZxhNUmCYX7uAFN1Uu&index=2
+Endal Kassa Sorry, but not sure about your question. Do you want to know about integrating GUI and API from a development point of view or a testing point of view?
+Software and Testing Training if possible I would like to send you the error message I am getting when I try to add both data and checkpoint by clicking "Data Drive Entire Step"
+Endal Kassa Thank you for clarifying this. Yes, you may send the error message and I will try to offer a suggestion. However, it will be better to post your question on some UFT video.
Hello, Sir, I saw your database testing video. It was very helpful and you explained very clearly, I appreciate it. Sir, Can you please provide me the video for data migration testing so that it will be very helpful for me. Thanks
Glad to know that you liked my video. Sorry, I don't have any video on data migration testing. But, I have a blog post on data migration testing at inderpsingh.blogspot.in/2010/03/how-to-do-database-migration-testing.html
Yes, I have an article on ETL testing at inderpsingh.blogspot.com/2010/03/how-to-do-database-migration-testing.html Many thanks for your comments. Keep them coming.
Best video till date I have seen in RUclips for database testing. You are really blessings for people like me who wants to know complete details on database testing..hat's off to you
Thank you Inder, Your videos are of great help to testers.. You will be glad to know that by only learning from your videos I have cracked some of the interviews also
This Database Testing video covers almost everything which a tester needs to know.
Keep up the good work.. Thanks once again.
That's good to know!
I had left DB testing 3 years ago and looks like all my memory is back...very good video indeed thanks for your effort..
What is the career in database testing
I did not expect this much of coverage on database testing in one video. Thanks a lot...
Many thanks, Vinay. You can also view my tutorials on Database Normalization and how to test it. The link is ruclips.net/video/m67fCU-Dmhg/видео.html&list=PLc3SzDYhhiGXDgSwZxhNUmCYX7uAFN1Uu
Simple, Short, Step by Step, what is required for testing DB..... awesome these kind of videos are very valuable. Well Done dude!
@Prasad Thutta - Many thanks. When testing DB, we should test both the schema and the data.
excellent sir,this will help full the people who dnt have minimum knowledge in db testing thnks for providing this document
Goparaju, many thanks for your comment :)
Thank you so much 🙏🙏
You are the best!
I’m really grateful to your help, time and efforts
Sending love from Egypt! 🖤
A very helping video....Thanks a lot !
Alok, you are welcome.
Thanks . I start a SQL course tomorrow
Inder - you are simply the Best..!! Thanks bunch keep up your good work and God Bless !!
Thank you for your awesome comment and support.
Excellent presentation. Logical, concise with practical examples. Clear communication too. Thank you so much!
Many thanks Stephen. Glad that you liked this video. Inder.
Excellent explaination.Very informative in short span...Thanks for all your effort!!!
I never knew SQL testing was this straight forward. Thanks for your unselfishness to share your thoughts and expertise. I read your blog too, wonderful! Can I have more please?
Idowu Sholanke Glad to know that you liked my video. Further, using variables, logic and print statements, one can put SQL queries in a script and test every database build with this script. Please refer my database testing articles, SQL quizzes and more at inderpsingh.blogspot.com/search/label/Database%20Testing
very nice video..beginner can get the required info from ur videos
Many thanks. The full playlist is at ruclips.net/p/PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE
Thanks for explaining in detail. This would be helpful to all DB testers which gives an overview on DB testing.
@Umapathy M - Many thanks for your comment. You can view the other 5 Database Testing tutorials at the link, ruclips.net/video/m67fCU-Dmhg/видео.html
Hi Inder Singh,Thanks a lot for sharing this...Its really superb.... :)
Anilkumar, thank you. Will continue to upload more videos.
Thanks for sharing your precious knowledge with us looking forward to further testing video. :)
swati mishra Thank you for your support. Next, I will upload LoadRunner training videos at ruclips.net/p/PLc3SzDYhhiGU6fbp6JlTU8GPbEw_-eQFx
very useful...thankyou...need some more session with practical example...
You did well go thoroughly step by step..... really enjoyed it.
thanks
Pankaj, thanks a lot.
Great 👍 I have watched your videos on Decision Table and Boundary Value Testing which are well explained. I have learned those tastings just out of your videos😊👍
Really simply the best explained video .. thank you so much and expecting same type of Video of ETL testing in informatica ....
Thank you its a good piece of information which is very important for testers
@pardon mhlanga - Thank you for your wonderful comment. You may like other Database Testing Tutorials, especially on testing database normal forms and database quality concepts. The link is ruclips.net/p/PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE
Super explained, with exa and real use.. rather than theory..👍👍👍 keep it up
@Pankaj Kumar Gupta - Many thanks for such an encouraging comment 😀 You are always welcome in Software and Testing Training channel 🙏
hello sir....your tutorials are clear,easily understandable...testing techniques examples helped me alot in understanding...Thanks a lot..
Nice video, its very helpfully for beginners. Thank you
Awesome, many thanks for your comment.
Hey thanku so much for such beautifully explained DB testing..only one thing missed is index testing, but overall video is so much helpful thanku !!
Romita Thakur
contact me +923150422568
very informative for beginners, thank you
ITs fantastic knowledge sharing Thank you so much for this video..
shareefuddin v I am glad that you liked this video. Thank you for your comment.
Very well explained in an organized way... thanks a lot (Y)
Very nice to know that you liked this video :)
Software and Testing Training
Thanks for sharing this video Sir ji
Very good work.. thanku sir for your informative video and description..
Thank You. Very informative and clearly put article.
Very simple and well explained..Thanks Mate.
Awesome Tutorial...Thanks
***** Thanks, Kishore.
So informative and clear explanation about database testing thank you very much sir
Many thanks, Delipan G. You may like my other database testing tutorials that are available at the link, ruclips.net/video/eQG4W4Zr8eo/видео.html&index=3
excellent video on database testing. thank you very much for posting it. i really appreciate your hardwork. i was looking for some video on DB testing and this is the one which explains everything .. thanks again!!
Thank you very much. My other Database Testing tutorials are available at the link, ruclips.net/video/N9olq42z-AE/видео.html
Super, has all the details a tester should know.
Hi Inder Singh Ji,Thanks a LOT for sharing your knowledge and information with us.Please keep up the Good Work.May GOD BLESS YOU...
Madiraju, thank you.
Very Nicely presented Video, with simple SQL queries that really enhanced the ease for the beginners to go ahead with database testing effectively. I really liked your way of putting examples in such a simple manner. Thanks for the same.
Regards,
Suchi
Suchi - Glad that you liked this video. Many thanks. Inder.
Abcdefghijklmnopqrstuvwxyz
Thankyou very helpful video
Quite an informative piece of information... thanx
Thank You! presentation was precise and exactly what I was searching for.
Suja A You are welcome. You may also like the videos in my playlist Test Automation at ruclips.net/p/PLc3SzDYhhiGXVcy8EcrTSfwsC-v8EUZvg
I really liked the video and now i have got the clear idea of database testing.
Thanks
Prashant
Many thanks, Prashant. It makes this upload worthwhile. Inder.
Thank you sir This is video is great help for me..:)
First of all. I would like to thank you for this helpful video,I have a question :Database testing categorized under which type of testing.
Nora D If the categorization is black-box/ white-box, it would be under white box testing because we need to interact with the database internal objects like tables, views and so on. If the categorization is functional/ non-functional testing, it would be under both because we can test the functional aspects and non-functional aspects (like performance and security) both. Thank you for your question.
Hello Inder, Thank you for posting these beautiful videos. These are very simple and detailed. Can you please do a video about ETL testing if you have time. Thank you...
Hello Sudip, thank you for your suggestion. I would like to do a video on ETL testing in the future.
In the meantime, please refer my article on ETL/ data migration testing at inderpsingh.blogspot.com/2010/03/how-to-do-database-migration-testing.html
as of very beginner point of view, I did not understand
1. Where did you get "customers" /"products" data, that appeared in the table already?
2. How did you get there on 12:18 ?
1) You can add the data, as shown from 3:48 using insert SQL statements. I added that data directly in SQL Server Management Studio 2) At 12:18, I have shown the database schema as a Database Diagram.
Thank you for your questions.
@@QA1 , How to get that diagram? Can you teach me all these staff over Internet? :-)
@EB - Surely, you can email me your requirement at isingh 30 at the rate g mail do t com (with no spaces in between).
Sarika - Very good videos. These videos are easy to understand and provides very good information.
Hello sir, quick question how would you test for data mapping? Let's say there is a Update data field mapping how would you test that? Thank you! So much for your assistance!! In helping me understand.
This is a basic test. The tester needs to verify if each front-end field maps with the corresponding back-end field in some table in the database correctly. This can be tested by the create, read, update and delete operations in the UI screen. These operations should result in the changes to the corresponding rows in the database table. Thank you.
Thank you so much for your response! I just would like to know 1 more thing. When creating a test case how would that look? Would you have steps for the UI and steps for the backend? I'm un-sure about how this would happen? Would I check the frontend data field first and after I'm done I move to the backend and verify the results? If you could please assist me with this..
The test case for data mapping testing would look like this. The steps would mention the actions to do in the UI. The expected results would mention the script/ query to run in the back-end. For example, in the create user test case, the steps would mention how to add the test data to add a new user. The expected results would mention the query to retrieve the record for the newly added user. Thank you.
The testing for data mapping involves a testing environment? What if the testing environment does not work then how would you test the data mapping?? I would like to Thank you so very much for your responses!! You are truly amazing! I appreciate all your responses and you are helping me grow into a field I would like to master one day. Thank you!
Of course, testing it requires a test environment. If the testing environment does not work, data mapping cannot be tested but it can only be reviewed by inspection of the data mapping document (part of system design documentation).
Thanks for this wonderful tutorial. Could you please help me by providing directions on how to check the health of a SQL Database that is in production. Basically, I am trying to come up with some sort of fast test or tools that can detect corrupted DBs that potentially slow down systems/applications. Could you please help me with that?
One way to do this is to note the initial average execution times of the frequently run SQL queries. In future, if these execution times increase greatly, you could investigate the reason and apply the suitable fix e.g. re-build the indexes. Thank you for your question.
thank you so much from london bhai!
Thanks sir very nice tutorial,great help :)
neha sahai come soon
If name is the same and other fields are different then it's not a duplicate value. There can be many people with same name but address and other credentials will be different.
Hi Inder Ji,
Thanks a lot for sharing this wonderful video
Krishna, thank you for your comment :)
Thank You Inder for the informative video☺☺
Hi Monish, you are welcome.
Thanq for the excellent video sir
+praveen varma Hi Praveen, I am glad that you found this video on database testing useful. Thank you for your comment.
Great Video there :). very helpful..Just that..didnt we just say it the other way round funcs and procs!!..just I felt so!!..
At what time into the video did you notice this?
I tend to write stored procedures much more often than functions. Because there are so many things we can do with stored procedures. Like accept inputs, select some data set and perform calculations based on inputs, implement business rules, produce outputs and return a data set.
Thanks for your comment.
Hello sir, just curious to know what type of database testing is there? How do you define what type of test your performing? Like scheme testing, data testing and etc.. What terms can define each type of test and which ones are like routinely? Thank you! So much for all your responses.. There is so much to learn from all this and your amazing at it and explaining it. Thank you
There are different types of database testing like data migration testing (ETL testing), schema testing, data testing, also performance testing and security testing of databases. Out of these, I would say that data testing is more regular. Data migration testing is needed when data is moved from one system to another. Schema testing is needed when the database is first designed and whenever there are are changes to database schema. Thank you.
Awesome tutorial, thanks for sharing your knowledge.. :)
wow!!
it's very precious lecture
Excellent brilliant presentation with more specific and concise
Golam, happy to know that you liked this video. Regards, Inder.
Got confidence after watching this vedio
Thank you for this video it was really helpful! Great presentation.
@Catherine Capule - Dy - Thank you for your comment and sub. Appreciate it.
Best regards,
Inder P Singh
Thank you for uploading the video
Supub explanation sir. Thanks a lot
your videos most helpful.. need to know a complete procedure to test web application with 200 users load. how to login and the procedure. Thanks.
+ranjit nayak Thank you for your comment. If we need to test the performance of a web application, we can use a tool like JMeter or LoadRunner. Our business transaction (the workflow) can have the login step in the beginning. This can be implemented by providing username, password etc. to the login request. You can see my JMeter and LoadRunner videos under my playlist at ruclips.net/p/PLc3SzDYhhiGXVcy8EcrTSfwsC-v8EUZvg
Thank you.it really helps
Its good although some important topics such as Joins are missing and should have more elaborate with example specially incase of Procedure and Functions. Index is also missing
Great job in overall explanation....Thank you!
Thanks, you can view the remaining 5 database testing tutorials at ruclips.net/video/eQG4W4Zr8eo/видео.html
Very useful. Thanks a lot!
weww
Nice video. Thanks for sharing such videos. :)
your video is very explanatory and very well described.
Do you have ETL Testing videos to share?If yes please share the link.
Thank you. The ETL testing tutorial is at ruclips.net/video/eQG4W4Zr8eo/видео.html
Thank you Sir!
Appreciate your comment Frank. All my Database Testing tutorials are available at the link, ruclips.net/video/eQG4W4Zr8eo/видео.html
Simple yet very helpful video.
MerLyn Tugano MerLyn, glad to help.
Thank you so much!
Hello sir, I have a question. As a tester do you test functions? If so, how do you test functions? Say code is being changed and a function is being added then how would that work? What if unit testing is not done by testers then how would that go? How is the test case going to look like? Sorry for all the questions but your honestly the best there is! Thank you!!!
Do you mean database user-defined functions? Basically, the functionality of the function can be tested by providing it different kinds of inputs e.g. no input, minimum/ boundary inputs, typical input, maximum/ boundary input, greater than maximum input. Then, compare the output received with the excepted output. I think that I have already given you an example of a database test case. Of course, a function has to be submitted to the tester for the testing to begin. Thank you.
Can all stored procedures be tested solo? What if a stored procedure is activated by a user action then how can you test that? What if the function in the developers data calls that stored procedure? What if the stored procedure is activated from a user action? Can that be tested without the frontend user action and invoke that solo from the backend? if you could please assist me with this that would be woundedful!! Thank you for all your support
The answer is yes. In this video, I have shown how to invoke a stored procedure directly in the back end (using Microsoft SQL Server Management Studio). This is shown around 27:00 into the video. We can test the functionality of the stored procedure by providing different types of inputs and comparison of outputs with excepted outputs. In addition, we can test the security and performance of stored procedures too.
Thank you so much for your response! How can you do security testing on a stored procedure? If you can give me an example? And one huge question I was wondering how/what kind of testing do you do for a developer code change? If unit testing is something that developers do? Thank you sir!!
Basically, we can review if a database object is secure or not. As you know, security is at different levels - the database server level, the database level and individual database object level. The stored procedure should have minimum privileges set for every group and user that needs it. For example, if an application needs to run a stored procedure, it should just have execute permission but not read or write permissions.
If a developer changes code, the tester should first find out the impact of those changes. I have already explained this to you in an earlier question. Thank you.
Nice Informative Video, Good pace & sequence of taking through the topics. Excellent information shared in a short duration of time. Keep going Inder....thanks
Hi Shashank, many thanks for your comment. Check out my other Database Testing tutorials at ruclips.net/video/eQG4W4Zr8eo/видео.html
Thanks sir this video helpful for me.
@Rahul Manjramkar - Awesome. You can study SQL Queries, esp. SQL Joins with the tutorial at ruclips.net/video/BxMmC77fJ9Y/видео.html
Thanks alot sir 🙏🏻🙏🏻
It's really helpful !Where I can find full tutorial for database testing @Software and Testing Training
Rajnish - You can see my video, Introduction to Databases at ruclips.net/video/f6gNDskSjEE/видео.html
See the database testing articles at inderpsingh.blogspot.in/search/label/Database%20Testing
Thank you @Software and Testing Training
This is highly educative. Thanks
Olu Oladimeji I am glad that you find my video useful. Thank you.
Very nice explanation👌👌👌👌
Thanks for the amazing video! This has been an amazing point to start for budding database testers. I was wondering if you could suggest some resources where we could find information about how testing can be done on complex stored procedures and how to deal with frequent changes by developers and the large size of the database with respect to the number of objects and the data volume as well. Really appreciate your help!
Hi Prabhjot. Happy to know that you found this tutorial useful. We should test stored procedures' inputs, logic and outputs, performance and security. Please refer my videos on test design, especially Equivalence partitioning and Boundary value analysis (for input testing), Decision table testing (for logic testing) and others at the link, ruclips.net/p/PLc3SzDYhhiGWW0TzISFKqAN_ic8DnZvVc
This tutorial deals with database challenges like frequent changes and possible solutions from 38:37 onward.
Thanks sir , Your videos are useful and helpful ..
@diksha malhotra - Thanks for your comment. You can view my (more advanced) videos on Database Normalization at the link, ruclips.net/video/m67fCU-Dmhg/видео.html
The video presentation is fantastic and excellent
oladeji olawumi Thank you, Oladeji. I like to create videos with a lot of information presented in a short time.
Great explaination skill
thank you sir for showing database testing it help me lot
Kumar - You are welcome. Thank you for your comment.
WELL TRAINING FROM U HAVE TO DO DATABASE TESTING
Very useful video..Thank you so much
Many thanks, Swathi. You can also view my Database Normalization and how to test normal forms tutorials. They are at the link, ruclips.net/video/m67fCU-Dmhg/видео.html&list=PLc3SzDYhhiGXDgSwZxhNUmCYX7uAFN1Uu&index=2
Very Good video.............Nicely explained, easily understandable.
Ankit Shukla Many thanks, Ankit.
Good video 4 database learners thank you
Hi Mihiretu, the other five database testing tutorials are at the link, ruclips.net/video/eQG4W4Zr8eo/видео.html
amazing worth the watch very sincere effort
Ashwini Kulkarni Thanks, Ashwini.
Thank you!
Your videos are amazing
Great tutoring!
Very nice and informative !
Awesome..Thanq so much
nice video thank you, would you please explain how we can integrate GUI and API and also how we can drive the data from excel spread shit.
+Endal Kassa Sorry, but not sure about your question. Do you want to know about integrating GUI and API from a development point of view or a testing point of view?
+Software and Testing Training I am using UFT so for testing point of view.
+Software and Testing Training if possible I would like to send you the error message I am getting when I try to add both data and checkpoint by clicking "Data Drive Entire Step"
+Endal Kassa Thank you for clarifying this. Yes, you may send the error message and I will try to offer a suggestion. However, it will be better to post your question on some UFT video.
+Software and Testing Training may I have your email Id please or can you contact me at endalemp@yahoo.com
Hello, Sir, I saw your database testing video. It was very helpful and you explained very clearly, I appreciate it.
Sir, Can you please provide me the video for data migration testing so that it will be very helpful for me. Thanks
Glad to know that you liked my video. Sorry, I don't have any video on data migration testing. But, I have a blog post on data migration testing at inderpsingh.blogspot.in/2010/03/how-to-do-database-migration-testing.html
Very Helpful Videos
Very nice video and detailed explanation. Really thanks a lot. Do you have any video or article on ETL testing?
Yes, I have an article on ETL testing at inderpsingh.blogspot.com/2010/03/how-to-do-database-migration-testing.html
Many thanks for your comments. Keep them coming.
Thanks 🙂