Database Testing-Data Testing In Software Testing-SQL Tutorial for Beginners-Database Test Plan-SQL

[@sathya-enjoy_lifetothefullest]

Best video till date I have seen in KZbin 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

[@VinayKumar189]

I did not expect this much of coverage on database testing in one video. Thanks a lot...

[@QA1]

Many thanks, Vinay. You can also view my tutorials on Database Normalization and how to test it. The link is kzbin.info/www/bejne/o2eal3aLYqmgnsk&list=PLc3SzDYhhiGXDgSwZxhNUmCYX7uAFN1Uu

[@afreennadia]

I had left DB testing 3 years ago and looks like all my memory is back...very good video indeed thanks for your effort..

[@mohammedajazquadri7869]

What is the career in database testing

[@vishals7160]

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.

[@adamhorner7076]

That's good to know!

[@Glowvation-7]

Thanks for sharing your precious knowledge with us looking forward to further testing video. :)

[@QA1]

swati mishra Thank you for your support. Next, I will upload LoadRunner training videos at kzbin.info/aero/PLc3SzDYhhiGU6fbp6JlTU8GPbEw_-eQFx

[@show2780]

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?

[@QA1]

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

[@jubrilwilson9244]

Thanks . I start a SQL course tomorrow

[@prasadthutta9903]

Simple, Short, Step by Step, what is required for testing DB..... awesome these kind of videos are very valuable. Well Done dude!

[@QA1]

@Prasad Thutta - Many thanks. When testing DB, we should test both the schema and the data.

[@stephenfoster9009]

Excellent presentation. Logical, concise with practical examples. Clear communication too. Thank you so much!

[@QA1]

Many thanks Stephen. Glad that you liked this video. Inder.

[@goparajuanil2763]

excellent sir,this will help full the people who dnt have minimum knowledge in db testing thnks for providing this document

[@QA1]

Goparaju, many thanks for your comment :)

[@shareefuddinv4826]

ITs fantastic knowledge sharing Thank you so much for this video..

[@QA1]

shareefuddin v I am glad that you liked this video. Thank you for your comment.

[@mahaanandharaj8741]

very useful...thankyou...need some more session with practical example...

[@sahithya28]

very informative for beginners, thank you

[@sarithag3757]

Excellent explaination.Very informative in short span...Thanks for all your effort!!!

[@sanjaipm]

Very good work.. thanku sir for your informative video and description..

[@sehse100]

Thank you so much 🙏🙏 You are the best! I’m really grateful to your help, time and efforts Sending love from Egypt! 🖤

[@alokkumarsingh4992]

A very helping video....Thanks a lot !

[@QA1]

Alok, you are welcome.

[@krishnar4127]

Hi Inder Ji, Thanks a lot for sharing this wonderful video

[@QA1]

Krishna, thank you for your comment :)

[@nishandhillon787]

Inder - you are simply the Best..!! Thanks bunch keep up your good work and God Bless !!

[@QA1]

Thank you for your awesome comment and support.

[@PankajKumar-mb1yy]

You did well go thoroughly step by step..... really enjoyed it. thanks

[@QA1]

Pankaj, thanks a lot.

[@MUTHYALAA]

Thanks for explaining in detail. This would be helpful to all DB testers which gives an overview on DB testing.

[@QA1]

@Umapathy M - Many thanks for your comment. You can view the other 5 Database Testing tutorials at the link, kzbin.info/www/bejne/o2eal3aLYqmgnsk

[@TheLiveZone]

Super explained, with exa and real use.. rather than theory..👍👍👍 keep it up

[@QA1]

@Pankaj Kumar Gupta - Many thanks for such an encouraging comment 😀 You are always welcome in Software and Testing Training channel 🙏

[@MadhuNepal4u]

Really simply the best explained video .. thank you so much and expecting same type of Video of ETL testing in informatica ....

[@sumasumaa789]

very nice video..beginner can get the required info from ur videos

[@QA1]

Many thanks. The full playlist is at kzbin.info/aero/PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE

[@pardonmhlanga2192]

Quite an informative piece of information... thanx

[@gauravpranesh1537]

Super, has all the details a tester should know.

[@arunkumargetarun]

Very simple and well explained..Thanks Mate.

[@anushkashrestha9632]

Thankyou very helpful video

[@nani1052005]

Hi Inder Singh,Thanks a lot for sharing this...Its really superb.... :)

[@QA1]

Anilkumar, thank you. Will continue to upload more videos.

[@rushiupadhyay4012]

Nice video. Thanks for sharing such videos. :)

[@chetalianand1168]

nice vedio 4 beginners

[@sandeepsohal1543]

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!!

[@QA1]

Thank you very much. My other Database Testing tutorials are available at the link, kzbin.info/www/bejne/hGrSnaRqZ99gd6c

[@niha1923]

Thank You. Very informative and clearly put article.

[@vys2574]

Very well explained in an organized way... thanks a lot (Y)

[@QA1]

Very nice to know that you liked this video :)

[@vys2574]

Software and Testing Training Thanks for sharing this video Sir ji

[@delipang2531]

So informative and clear explanation about database testing thank you very much sir

[@QA1]

Many thanks, Delipan G. You may like my other database testing tutorials that are available at the link, kzbin.info/www/bejne/m4KqZYpqj9drm9E&index=3

[@bpskishore]

Awesome Tutorial...Thanks

[@QA1]

***** Thanks, Kishore.

[@suyeshsoni5015]

Nice video, its very helpfully for beginners. Thank you

[@QA1]

Awesome, many thanks for your comment.

[@jettipravin6635]

hello sir....your tutorials are clear,easily understandable...testing techniques examples helped me alot in understanding...Thanks a lot..

[@suchiaggarwal8354]

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

[@QA1]

Suchi - Glad that you liked this video. Many thanks. Inder.

[@suchiaggarwal8354]

Abcdefghijklmnopqrstuvwxyz

[@sumildepala9932]

thank you so much from london bhai!

[@pardonmhlanga2192]

Thank you its a good piece of information which is very important for testers

[@QA1]

@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 kzbin.info/aero/PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE

[@user-mb5bc2dk6k]

Great explaination skill

[@GolamSarwar16]

Excellent brilliant presentation with more specific and concise

[@QA1]

Golam, happy to know that you liked this video. Regards, Inder.

[@merlyntugano3534]

Simple yet very helpful video.

[@QA1]

MerLyn Tugano MerLyn, glad to help.

[@desertstar7664]

Thank you for uploading the video

[@panchsan6473]

Awesome tutorial, thanks for sharing your knowledge.. :)

[@rimpypannu9539]

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😊👍

[@gnamakoudji]

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?

[@QA1]

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.

[@olumideoladimeji3727]

This is highly educative. Thanks

[@QA1]

Olu Oladimeji I am glad that you find my video useful. Thank you.

[@MadirajuKChaitanya]

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...

[@QA1]

Madiraju, thank you.

[@Pingsmingu]

amazing worth the watch very sincere effort

[@QA1]

Ashwini Kulkarni Thanks, Ashwini.

[@sujaa5911]

Thank You! presentation was precise and exactly what I was searching for.

[@QA1]

Suja A You are welcome. You may also like the videos in my playlist Test Automation at kzbin.info/aero/PLc3SzDYhhiGXVcy8EcrTSfwsC-v8EUZvg

[@ankitshukla6010]

Very Good video.............Nicely explained, easily understandable.

[@QA1]

Ankit Shukla Many thanks, Ankit.

[@mihiretumisganu7170]

Good video 4 database learners thank you

[@QA1]

Hi Mihiretu, the other five database testing tutorials are at the link, kzbin.info/www/bejne/m4KqZYpqj9drm9E

[@NitantVlogs]

Very useful. Thanks a lot!

[@gktcsc7332]

weww

[@praveenvarma44]

Thanq for the excellent video sir

[@QA1]

+praveen varma Hi Praveen, I am glad that you found this video on database testing useful. Thank you for your comment.

[@prashantc9401]

I really liked the video and now i have got the clear idea of database testing. Thanks Prashant

[@QA1]

Many thanks, Prashant. It makes this upload worthwhile. Inder.

[@TheMonish114]

Thank You Inder for the informative video☺☺

[@QA1]

Hi Monish, you are welcome.

[@shitalkd4766]

Very nice explanation👌👌👌👌

[@BNM0826]

Great job in overall explanation....Thank you!

[@QA1]

Thanks, you can view the remaining 5 database testing tutorials at kzbin.info/www/bejne/m4KqZYpqj9drm9E

[@weekendsongs]

Neat presentation

[@QA1]

Archana Swaminathan Hi Archana, many thanks for your comment.

[@Raouf4eva]

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.

[@QA1]

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.

[@Raouf4eva]

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..

[@QA1]

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.

[@Raouf4eva]

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!

[@QA1]

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).

[@ITWITHSIDD]

Very Helpful Videos

[@swathim.b7641]

Very useful video..Thank you so much

[@QA1]

Many thanks, Swathi. You can also view my Database Normalization and how to test normal forms tutorials. They are at the link, kzbin.info/www/bejne/o2eal3aLYqmgnsk&list=PLc3SzDYhhiGXDgSwZxhNUmCYX7uAFN1Uu&index=2

[@gauravmunjal113]

Supub explanation sir. Thanks a lot

[@limachandran7831]

Thank you.it really helps

[@nehasahai155]

Thanks sir very nice tutorial,great help :)

[@rakeshshahnirakeshshahni3944]

neha sahai come soon

[@bravenick]

Very nice and informative !

[@oladejiolawumi6560]

The video presentation is fantastic and excellent

[@QA1]

oladeji olawumi Thank you, Oladeji. I like to create videos with a lot of information presented in a short time.

[@frankboahene3612]

Thank you Sir!

[@QA1]

Appreciate your comment Frank. All my Database Testing tutorials are available at the link, kzbin.info/www/bejne/m4KqZYpqj9drm9E

[@anujakukatkar8264]

Thank you sir This is video is great help for me..:)

[@sarikabenpatel6155]

Sarika - Very good videos. These videos are easy to understand and provides very good information.

[@olena3363]

Great tutorial! Thank you!

[@TheNishi42]

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 !!

[@abdulquadhar7149]

Romita Thakur

[@Appolocricketacademy]

contact me [phone]

[@MrShakul007]

Nice Informative Video, Good pace & sequence of taking through the topics. Excellent information shared in a short duration of time. Keep going Inder....thanks

[@QA1]

Hi Shashank, many thanks for your comment. Check out my other Database Testing tutorials at kzbin.info/www/bejne/m4KqZYpqj9drm9E

[@morsheddld]

wow!! it's very precious lecture

[@dikshamalhotra3450]

Thanks sir , Your videos are useful and helpful ..

[@QA1]

@diksha malhotra - Thanks for your comment. You can view my (more advanced) videos on Database Normalization at the link, kzbin.info/www/bejne/o2eal3aLYqmgnsk

[@theneophyte2989]

Got confidence after watching this vedio

[@catherinefcapule0302]

Thank you for this video it was really helpful! Great presentation.

[@QA1]

@Catherine Capule - Dy - Thank you for your comment and sub. Appreciate it. Best regards, Inder P Singh

[@lvfrmabv]

very good man , well explained

[@shilpiagarwal7956]

your video is very explanatory and very well described. Do you have ETL Testing videos to share?If yes please share the link.

[@QA1]

Thank you. The ETL testing tutorial is at kzbin.info/www/bejne/m4KqZYpqj9drm9E

[@amitsaxena4u]

thanks very much for this video

[@QA1]

You are very welcome :)

[@rahulmanjramkar3872]

Thanks sir this video helpful for me.

[@QA1]

@Rahul Manjramkar - Awesome. You can study SQL Queries, esp. SQL Joins with the tutorial at kzbin.info/www/bejne/eKmwnnZtbMt9b7s

[@Sarikapd]

Very nice video and detailed explanation. Really thanks a lot. Do you have any video or article on ETL testing?

[@QA1]

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.

[@1mer3y]

Thank you so much!

[@kumarjadhav2689]

thank you sir for showing database testing it help me lot

[@QA1]

Kumar - You are welcome. Thank you for your comment.

[@kumarjadhav2689]

WELL TRAINING FROM U HAVE TO DO DATABASE TESTING

[@frappuccino01]

Nice Video, very informative

[@QA1]

frappuccino01 Thank you. You may like the other videos in the Test Automation playlist at kzbin.info/aero/PLc3SzDYhhiGXVcy8EcrTSfwsC-v8EUZvg

[@asitbhalla]

Great Video there :). very helpful..Just that..didnt we just say it the other way round funcs and procs!!..just I felt so!!..

[@QA1]

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.

[@rajnish782]

It's really helpful !Where I can find full tutorial for database testing @Software and Testing Training

[@QA1]

Rajnish - You can see my video, Introduction to Databases at kzbin.info/www/bejne/nGfKf3epoLide6c

[@QA1]

See the database testing articles at inderpsingh.blogspot.in/search/label/Database%20Testing

[@rajnish782]

Thank you @Software and Testing Training

[@zonaidm2659]

Great tutoring!

[@deepthikadali9422]

Thanks alot sir 🙏🏻🙏🏻

[@itahari72]

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...

[@QA1]

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

[@tcsrimythilee1565]

Thanks 🙂

[@bhargaveswar2095]

Really good video

[@QA1]

bhargav eswar Hi Bhargav, Glad that you like my video. Regards, Inder

[@MrVinay547]

Nice explanation sir

[@QA1]

@Vinay K - Thank you for your like.

[@prabhjotlives]

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!

[@QA1]

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, kzbin.info/aero/PLc3SzDYhhiGWW0TzISFKqAN_ic8DnZvVc

[@QA1]

This tutorial deals with database challenges like frequent changes and possible solutions from 38:37 onward.

[@loading.m4469]

Your videos are amazing

[@myfun1870]

Good video, Thanks

[@QA1]

md mia Thank you. Appreciate your comment.

[@amitbose10]

Nice explanation....I would like to know about Data Migration Test also....

[@QA1]

Hi Amit, please see my article on database migration testing at inderpsingh.blogspot.com/2010/03/how-to-do-database-migration-testing.html

[@amitbose10]

thanks ...

[@poonamsingh312]

Its really helpful video!!

[@QA1]

Poonam - many thanks for your comment.