Best video till date I have seen in TH-cam 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 th-cam.com/video/m67fCU-Dmhg/w-d-xo.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
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
Many thanks, Delipan G. You may like my other database testing tutorials that are available at the link, th-cam.com/video/eQG4W4Zr8eo/w-d-xo.html&index=3
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.
@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 th-cam.com/play/PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE.html
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.
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😊👍
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.
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!!
Many thanks, Swathi. You can also view my Database Normalization and how to test normal forms tutorials. They are at the link, th-cam.com/video/m67fCU-Dmhg/w-d-xo.html&list=PLc3SzDYhhiGXDgSwZxhNUmCYX7uAFN1Uu&index=2
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.
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.
@diksha malhotra - Thanks for your comment. You can view my (more advanced) videos on Database Normalization at the link, th-cam.com/video/m67fCU-Dmhg/w-d-xo.html
Nice Informative Video, Good pace & sequence of taking through the topics. Excellent information shared in a short duration of time. Keep going Inder....thanks
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
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.
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.
Before learning stored procedures, you should know other important database topics like SQL queries, normalization, ETL and data quality (important). The course is available at th-cam.com/video/BxMmC77fJ9Y/w-d-xo.html
@@QA1 thanks for the quick response moreover i want to know ,,,if iam manual tester will i have to have expertise in store data procedure ? i might sound childish in this but what else a fresher could ask.,,plz gimme reply of this doubt thanks
@vaib patill - I don't think that you need to have expertise in stored procedures' testing if you only test the application from the UI. Stored procedures are in the data access tier of the system and not visible to the end-users. However, if you are a database tester, you may need to have a grasp of stored procedure testing (meaning testing the output parameters and result set based on input parameters). Hope this helps!
+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 th-cam.com/play/PLc3SzDYhhiGXVcy8EcrTSfwsC-v8EUZvg.html
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.
IMO, both have their pros and cons. DBA openings may be fewer and the work is more intense but salaries and security may be higher. You should consider which one you like to do, your skills and the hiring organization too. Best wishes!
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, th-cam.com/play/PLc3SzDYhhiGWW0TzISFKqAN_ic8DnZvVc.html
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
Thank you..Actually tomorrow is my interview in cybage for Manual testing and database testing profile..So was preparation for that..This vedio helped so wanted to thank you for that..
![Beginner to T-SQL [Full Course]](http://i.ytimg.com/vi/cACat4KNncg/mqdefault.jpg)
Best video till date I have seen in TH-cam 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
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 :)
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 th-cam.com/video/m67fCU-Dmhg/w-d-xo.html&list=PLc3SzDYhhiGXDgSwZxhNUmCYX7uAFN1Uu
Thanks . I start a SQL course tomorrow
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 presentation. Logical, concise with practical examples. Clear communication too. Thank you so much!
Many thanks Stephen. Glad that you liked this video. Inder.
very nice video..beginner can get the required info from ur videos
Many thanks. The full playlist is at th-cam.com/play/PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE.html
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.
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 useful...thankyou...need some more session with practical example...
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
very informative for beginners, thank you
Hi Inder Ji,
Thanks a lot for sharing this wonderful video
Krishna, thank you for your comment :)
A very helping video....Thanks a lot !
Alok, you are welcome.
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 explaination.Very informative in short span...Thanks for all your effort!!!
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, th-cam.com/video/eQG4W4Zr8eo/w-d-xo.html&index=3
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).
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 th-cam.com/play/PLc3SzDYhhiGU6fbp6JlTU8GPbEw_-eQFx.html
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
Quite an informative piece of information... thanx
Nice video, its very helpfully for beginners. Thank you
Awesome, many thanks for your comment.
Very Good video.............Nicely explained, easily understandable.
Ankit Shukla Many thanks, Ankit.
Very good work.. thanku sir for your informative video and description..
You did well go thoroughly step by step..... really enjoyed it.
thanks
Pankaj, thanks a lot.
Thank you so much 🙏🙏
You are the best!
I’m really grateful to your help, time and efforts
Sending love from Egypt! 🖤
hello sir....your tutorials are clear,easily understandable...testing techniques examples helped me alot in understanding...Thanks a lot..
Very simple and well explained..Thanks Mate.
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, th-cam.com/video/m67fCU-Dmhg/w-d-xo.html
Hi Inder Singh,Thanks a lot for sharing this...Its really superb.... :)
Anilkumar, thank you. Will continue to upload more videos.
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 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 th-cam.com/play/PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE.html
Awesome Tutorial...Thanks
***** Thanks, Kishore.
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).
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
Super, has all the details a tester should know.
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.
Really simply the best explained video .. thank you so much and expecting same type of Video of ETL testing in informatica ....
Nice video. Thanks for sharing such videos. :)
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 🙏
Excellent brilliant presentation with more specific and concise
Golam, happy to know that you liked this video. Regards, Inder.
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😊👍
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.
amazing worth the watch very sincere effort
Ashwini Kulkarni Thanks, Ashwini.
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.
Thank You. Very informative and clearly put article.
Thankyou very helpful video
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.
Thanks sir very nice tutorial,great help :)
neha sahai come soon
Supub explanation sir. Thanks a lot
Simple yet very helpful video.
MerLyn Tugano MerLyn, glad to help.
Sarika - Very good videos. These videos are easy to understand and provides very good information.
Thanks sir this video helpful for me.
@Rahul Manjramkar - Awesome. You can study SQL Queries, esp. SQL Joins with the tutorial at th-cam.com/video/BxMmC77fJ9Y/w-d-xo.html
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.
This is highly educative. Thanks
Olu Oladimeji I am glad that you find my video useful. Thank you.
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, th-cam.com/video/N9olq42z-AE/w-d-xo.html
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 th-cam.com/video/eQG4W4Zr8eo/w-d-xo.html
Awesome tutorial, thanks for sharing your knowledge.. :)
Good video 4 database learners thank you
Hi Mihiretu, the other five database testing tutorials are at the link, th-cam.com/video/eQG4W4Zr8eo/w-d-xo.html
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, th-cam.com/video/m67fCU-Dmhg/w-d-xo.html&list=PLc3SzDYhhiGXDgSwZxhNUmCYX7uAFN1Uu&index=2
Nice explanation....I would like to know about Data Migration Test also....
Hi Amit, please see my article on database migration testing at inderpsingh.blogspot.com/2010/03/how-to-do-database-migration-testing.html
thanks ...
Thank you sir This is video is great help for me..:)
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 th-cam.com/video/f6gNDskSjEE/w-d-xo.html
See the database testing articles at inderpsingh.blogspot.in/search/label/Database%20Testing
Thank you @Software and Testing Training
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.
Thank You Inder for the informative video☺☺
Hi Monish, you are welcome.
Very nice explanation👌👌👌👌
thank you so much from london bhai!
Thank you for uploading the video
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.
Nice Video, very informative
frappuccino01 Thank you. You may like the other videos in the Test Automation playlist at th-cam.com/play/PLc3SzDYhhiGXVcy8EcrTSfwsC-v8EUZvg.html
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
wow!!
it's very precious lecture
Great job in overall explanation....Thank you!
Thanks, you can view the remaining 5 database testing tutorials at th-cam.com/video/eQG4W4Zr8eo/w-d-xo.html
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, th-cam.com/video/m67fCU-Dmhg/w-d-xo.html
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 th-cam.com/video/eQG4W4Zr8eo/w-d-xo.html
Very useful. Thanks a lot!
weww
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
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.
Got confidence after watching this vedio
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.
as a manual tester fresher
do i have to know about store procdure ?
Before learning stored procedures, you should know other important database topics like SQL queries, normalization, ETL and data quality (important). The course is available at th-cam.com/video/BxMmC77fJ9Y/w-d-xo.html
@@QA1 thanks for the quick response moreover i want to know ,,,if iam manual tester will i have to have expertise in store data procedure ? i might sound childish in this but what else a fresher could ask.,,plz gimme reply of this doubt thanks
@vaib patill - I don't think that you need to have expertise in stored procedures' testing if you only test the application from the UI. Stored procedures are in the data access tier of the system and not visible to the end-users. However, if you are a database tester, you may need to have a grasp of stored procedure testing (meaning testing the output parameters and result set based on input parameters). Hope this helps!
@@QA1 yeah thanks a lot ,,,i aint preparing for db in particular i just have got to learn about it because of manual testing .thanks again
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 th-cam.com/play/PLc3SzDYhhiGXVcy8EcrTSfwsC-v8EUZvg.html
Neat presentation
Archana Swaminathan Hi Archana, many thanks for your comment.
Hi your video tutorials are too good.Do you have any online training..
Test Test Thank you. Yes, I have JMeter training videos. Please see the details at inderpsingh.blogspot.com/2013/10/JMeterVideos.html
Test Test Please see the details of my Selenium training videos at inderpsingh.blogspot.com/2013/10/SeleniumTraining.html
I don't need jmeter videos.I need software testing tutorial and sql training.
Test Test Please check out my playlist named Manual Testing Tutorials. It has 25 software testing tutorials.
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 th-cam.com/play/PLc3SzDYhhiGXVcy8EcrTSfwsC-v8EUZvg.html
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.
very nicely explained sir. thank u
Hi pooja
pooja nayak
Have u use practically
Very nice and informative !
Very Helpful Videos
Dear sir which is best Oracle DBA or software testing?
IMO, both have their pros and cons. DBA openings may be fewer and the work is more intense but salaries and security may be higher. You should consider which one you like to do, your skills and the hiring organization too. Best wishes!
@@QA1 thank you so much sir
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
very good man , well explained
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, th-cam.com/play/PLc3SzDYhhiGWW0TzISFKqAN_ic8DnZvVc.html
This tutorial deals with database challenges like frequent changes and possible solutions from 38:37 onward.
Thank you.it really helps
I loved your video. I am wondering how do I find Database Test Plan and how can I learn to intigrate my quary report to SSRS?
Please find my sample db test plan at inderpsingh.blogspot.com/2010/05/sample-database-test-plan.html
Thank you. You may like my other Database Testing Tutorials too. All links are at th-cam.com/play/PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE.html
Nice explanation sir
@Vinay K - Thank you for your like.
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
Hey thanks so much for this vedio....It was very helpful.. ☺
Glad to know.
Best wishes,
Inder
Thank you.. ☺
Thanks, Mohini. You can send your questions in Google Plus at plus.google.com/+InderPSingh
Thank you..Actually tomorrow is my interview in cybage for Manual testing and database testing profile..So was preparation for that..This vedio helped so wanted to thank you for that..