HomeОбразованиеRelated VideosMore From: Software and Testing Training

Database Testing in Software Testing | SQL Tutorial for Beginners | Software and Testing Training

1400 ratings | 287776 views
Learn database testing concepts, database testing basics and how to perform database testing manually with this database testing tutorial with examples in SQL Server. Sample DB Test Plan at http://inderpsingh.blogspot.com/2010/05/sample-database-test-plan.html See First Normal Form video at https://youtu.be/m67fCU-Dmhg See Second Normal Form video at https://youtu.be/3vOAKZwyC6M See Third Normal Form video at https://youtu.be/WB0ONKK_y68 See Database migration testing video at https://youtu.be/eQG4W4Zr8eo Testing Tutorials complete : https://www.youtube.com/playlist?list=PLc3SzDYhhiGWuMK03uYO-UENAx0s2woWM Test Automation : https://www.youtube.com/playlist?list=PLc3SzDYhhiGXVcy8EcrTSfwsC-v8EUZvg Follow me on: Website: http://inderpsingh.blogspot.com/ Messages: https://plus.google.com/+InderPSingh Twitter: https://twitter.com/inder_p_singh * useful for database testing for beginners, manual database testing
Html code for embedding videos on your blog
Text Comments (247)
Vijeta Chauhan (6 days ago)
Thanks sir
You're welcome. You may like my other tutorials on Database Normal Forms and how to test them. The link is https://www.youtube.com/watch?v=m67fCU-Dmhg&t=0s&list=PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE&index=3
sonal kulkarni (17 days ago)
Thankyou sir. This video helped me alot.
Good to know. Sonal, you can view the 5 other database testing tutorials in my playlist at https://www.youtube.com/watch?v=m67fCU-Dmhg&list=PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE&index=3&t=0s
Riderz 4 u (1 month ago)
how you can say than name field may be null.. its depend on project requirements name field null or required.
Do you mean the Customers table or Products table in the database example? If the former (I explain it at 15:00) then it may be blank for customers who make small or cash purchases. I do mention that it may be a defect depending on the stated project requirements. But, technically, a customer row with a Null Name can live in the Customers table because another column, the CustomerId is the primary key which does not allow Nulls.
Swathi M.B (2 months ago)
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, https://www.youtube.com/watch?v=m67fCU-Dmhg&t=0s&list=PLc3SzDYhhiGXDgSwZxhNUmCYX7uAFN1Uu&index=2
Lakshmi Prasanna (3 months ago)
Awesome..Thanq so much
Delipan G (6 months ago)
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, https://www.youtube.com/watch?v=eQG4W4Zr8eo&list=PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE&t=0s&index=3
Sandeep Sohal (7 months ago)
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, https://www.youtube.com/watch?v=N9olq42z-AE&index=4&list=PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE&t=0s
2009serfer (7 months ago)
I can't understand what is there to unlike this post you 61 idiots
Vinay Kumar Penigalapati (9 months ago)
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 https://www.youtube.com/watch?v=m67fCU-Dmhg&index=1&t=0s&list=PLc3SzDYhhiGXDgSwZxhNUmCYX7uAFN1Uu
Tripti juneja (9 months ago)
Thanks for the puting this video
Welcome. You can view my more advanced Database Testing tutorials at https://www.youtube.com/watch?v=eQG4W4Zr8eo&index=2&list=PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE&t=0s
Hassan Saleem (11 months ago)
Great tutorial. PRO TIP: Set the video speed to 1.25
Many thanks. My other Database testing tutorials are available at https://www.youtube.com/watch?v=eQG4W4Zr8eo&t=0s&list=PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE&index=2
Shashank Kulkarni (11 months ago)
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 https://www.youtube.com/watch?v=eQG4W4Zr8eo&list=PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE&index=2
MD RAHMAN (11 months ago)
Great !
Thank you.
vinod jadhav (1 year ago)
Hi.please send me ETL testing notes using informatica [email protected]
Hi Vinod, I don't have Informatica tutorial. I have a video on ETL testing at the link at https://youtu.be/eQG4W4Zr8eo
Yeshitilla Yigezaw (1 year ago)
Thank you!
Yeshitilla, welcome to my channel. The other Database Testing tutorials are available at the link, https://www.youtube.com/watch?v=eQG4W4Zr8eo&index=2&list=PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE
Mizanur Rahman (1 year ago)
great tutorial , thxxx
Thank you. You can check out my other 5 database testing tutorials at the link, https://www.youtube.com/watch?v=eQG4W4Zr8eo&index=2&list=PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE
Mihiretu Misganu (1 year ago)
Good video 4 database learners thank you
Hi Mihiretu, the other five database testing tutorials are at the link, https://www.youtube.com/watch?v=eQG4W4Zr8eo&list=PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE&index=2
Frank Boahene (1 year ago)
Thank you Sir!
Appreciate your comment Frank. All my Database Testing tutorials are available at the link, https://www.youtube.com/watch?v=eQG4W4Zr8eo&index=2&list=PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE
N M (1 year ago)
Great job in overall explanation....Thank you!
Thanks, you can view the remaining 5 database testing tutorials at https://www.youtube.com/watch?v=eQG4W4Zr8eo&list=PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE&index=2
Sathyavelu Pv (1 year ago)
Best video till date I have seen in YouTube 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
Gaurav Goyal (1 year ago)
sir can we run the database of excel sheet in eclipse via selenium Web driver
Sure but using Excel is unrelated to WebDriver because WebDriver deals with browsers only. In Java, reading and writing to Excel is possible using the POI library. Thank you for your question.
Ashish Yadav (1 year ago)
please don't watch this video if you want to learn database testing..
Don't post false and misleading comments. This tutorial explains database testing terms, database schema, database data in tables and columns, database testing challenges, database testing approach and database test plan. Then this tutorial demonstrates numerous working simple database tests.
PRABHJOT SINGH (1 year ago)
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!
This tutorial deals with database challenges like frequent changes and possible solutions from 38:37 onward.
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, https://www.youtube.com/playlist?list=PLc3SzDYhhiGWW0TzISFKqAN_ic8DnZvVc
Rimpy Pannu (1 year ago)
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😊👍
Taneea Mitra (1 year ago)
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?
Thank you. You may like my other Database Testing Tutorials too. All links are at https://www.youtube.com/playlist?list=PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE
Please find my sample db test plan at http://inderpsingh.blogspot.com/2010/05/sample-database-test-plan.html
Erlina Ocdao (1 year ago)
Very Informative! but 15mins after it is blurry.. I cant' see your examples.. hope to see your other videos in Database testing.
Sorry, I missed to provide the link of my videos in Database testing. The last three videos explain database normalization and how to test it. The link is https://www.youtube.com/playlist?list=PLc3SzDYhhiGVVb76aFOH9AcIMNAW-JuXE
Erlina Ocdao (1 year ago)
Thank you so much for this video,, much appreciated! keep up the good work.
Sorry to know that you faced this problem. By default, the YouTube player selects the display resolution automatically. But, you can explicitly set the display resolution (click Settings (gear icon) > Quality > 720p HD. Then the screen would not be blurry.
Shea Love (1 year ago)
How are you? I have a question that hopefully you can and will answer.. I want to open an approved purchase order and drill down into distributions.. There are 2 distributions on line 1. I cannot for the life of me figure out HOW to remove the second distribution that was added in error [email protected] Please and thank you.
Is your question about a specific software like Oracle apps? You should view the user guide to see how to use a particular feature. Thank you.
lojeen - (1 year ago)
Thank you so much!
Shikuran Abdulai (1 year ago)
thank you
Romita Thakur (1 year ago)
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 !!
Sehel Sid (1 month ago)
contact me +923150422568
Abdul Quadhar (1 year ago)
Romita Thakur
Olena (1 year ago)
Great tutorial! Thank you!
neeha lodha (2 years ago)
Informative...Thank You...
loading. m (2 years ago)
Your videos are amazing
loading. m (2 years ago)
Thank you so much
Nitant Vlogs (2 years ago)
Very useful. Thanks a lot!
gkt csc (2 years ago)
Brave Nick (2 years ago)
Very nice and informative !
Pooja Nayak (2 years ago)
very nicely explained sir. thank u
Narendra Kashyap (1 year ago)
pooja nayak Have u use practically
Sujini Kumari (2 years ago)
Hi pooja
Natarjan Shanthu (2 years ago)
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 http://inderpsingh.blogspot.in/2010/03/how-to-do-database-migration-testing.html
Fedos Thinker (2 years ago)
Thank you!
mohini pathare (2 years ago)
Hey thanks so much for this vedio....It was very helpful.. ☺
mohini pathare (2 years ago)
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..
Thanks, Mohini. You can send your questions in Google Plus at https://plus.google.com/+InderPSingh
mohini pathare (2 years ago)
Thank you.. ☺
Glad to know. Best wishes, Inder
Arty Sky (2 years ago)
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!!!
Typically, only the data is tested, unless your test scope includes testing all the applications that connect to the new database.
Arty Sky (2 years ago)
Thank you for your response! Do you test frontend of the application after data migration? To check for correct data mapping? Or do you just test the data to ensure its all transferred? If so, do you do frontend testing when new or existing data is added/changed?? If you could please assist me with this question. Thank you for all your support! I really appreciate it..
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.
Arty Sky (2 years ago)
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!!
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.
Arty Sky (2 years ago)
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.
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).
Arty Sky (2 years ago)
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!
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.
Arty Sky (2 years ago)
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..
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.
Arty Sky (2 years ago)
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.
Gabriel Nadar (2 years ago)
you conduct training on database testing?, how I can enroll for it.
Gabriel Nadar (2 years ago)
you can be successful by conducting online training, as your good in training and you have the skills to be a trainer, good luck..
I don't have any online training course on database testing. If you want to learn more, please see my articles on Database Testing at http://inderpsingh.blogspot.in/search/label/Database%20Testing
Arty Sky (2 years ago)
So when looking at the scheme that has to be in the test case? Stating what you did? How would a test case look like for this situation if that's what you have to do? What role does a Lead and the tester have in this situation? What will the lead be doing? Will be be gathering the requirement and setting the stone of how to test it? And the tester will be making test cases and executing it based of the leads view for the best approach? When testing in general does a tester look at both the front and backend all the time? Besides the fact of testing the functionality if I am correct? Thank you!
In database testing, the tester needs to test both the schema and the data. For example in schema testing, a test case to test the tables may have all table names as rows and Complete, Correct keys, No unnecessary columns etc as columns. The tester can execute this test case by inspection of the database schema, one table design at a time. Similarly, there may be separate schema test cases to test views, stored procedures, functions, jobs and other database objects. In larger teams, I imagine that it is possible to have a database test lead role separate from the database tester role. These roles may exist in the development team or the DBA team. Also, keep in mind that one database may service multiple applications. Typically, the database requirements are technical (non-functional) requirements. Therefore, these requirements are not sourced from users but from the technical design of systems. Database testing is back-end testing only. Thank you for your questions.
Srividhya Sudhakar (2 years ago)
very informative for beginners, thank you
Sumitha Krishnamurthy (2 years ago)
No clarity
You could view it a second time and let me know your questions. Also, for clarity please see my article, Sample database test plan at http://inderpsingh.blogspot.com/2010/05/sample-database-test-plan.html
Jubril Wilson (2 years ago)
Thanks . I start a SQL course tomorrow
rajnish verma (2 years ago)
It's really helpful !Where I can find full tutorial for database testing @Software and Testing Training
rajnish verma (2 years ago)
Thank you @Software and Testing Training
See the database testing articles at http://inderpsingh.blogspot.in/search/label/Database%20Testing
Rajnish - You can see my video, Introduction to Databases at http://youtu.be/f6gNDskSjEE
VB NET (2 years ago)
Thank You
Monish Tarai (2 years ago)
Thank You Inder for the informative video☺☺
Hi Monish, you are welcome.
arun kumar patel (2 years ago)
Very simple and well explained..Thanks Mate.
Chetali Anand (2 years ago)
nice vedio 4 beginners
Endal Kassa (2 years ago)
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 (2 years ago)
+Software and Testing Training  may I have your email Id please or can you contact me at [email protected]
+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.
Endal Kassa (2 years ago)
+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 (2 years ago)
+Software and Testing Training I am using UFT so for testing point of view.
+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?
Sanjai Mathew (2 years ago)
Very good work.. thanku sir for your informative video and description..
Syed Mohamed Muhzin (2 years ago)
Thanks for your tutorial, How to do performance testing in database?
+Syed Mohamed Muhzin We can measure the average execution times of frequently run queries, stored procedures etc. Thank you for your comment.
Vishal Satsangi (2 years ago)
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.
Adam Horner (2 years ago)
That's good to know!
Gaurav Munjal (2 years ago)
Supub explanation sir. Thanks a lot
Anuja Kukatkar (3 years ago)
Thank you sir This is video is great help for me..:)
ranjit nayak (3 years ago)
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 https://www.youtube.com/playlist?list=PLc3SzDYhhiGXVcy8EcrTSfwsC-v8EUZvg
jetti pravin (3 years ago)
hello sir....your tutorials are clear,easily understandable...testing techniques examples helped me alot in understanding...Thanks a lot..
Alex B. (3 years ago)
very good man , well explained
Nadia (3 years ago)
I had left DB testing 3 years ago and looks like all my memory is back...very good video indeed thanks for your effort..
praveen varma (3 years ago)
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.
Sarikaben Patel (3 years ago)
Sarika - Very good videos.  These videos are easy to understand and provides very good information.
neha sahai (3 years ago)
Thanks sir very nice tutorial,great help :)
neha sahai come soon
Nora D (3 years ago)
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.
Herman Bykov (3 years ago)
Hi! I'm trying to get into testing and your video was very helpful: it's simple, it shows a lot of basic stuff and the examples of queries helped me understand what SQL is about. Thank you very much!
+German Bykov Many thanks to you, German.
Morshedul Islam (3 years ago)
wow!! it's very precious lecture
Olu Oladimeji (3 years ago)
This is highly educative. Thanks
+Olu Oladimeji I am glad that you find my video useful. Thank you.
Neharika Kotha (3 years ago)
Thank You. Very informative and clearly put article.
MerLyn Tugano (3 years ago)
Simple yet very helpful video.
+MerLyn Tugano MerLyn, glad to help.
frappuccino01 (3 years ago)
Nice Video, very informative
+frappuccino01 Thank you. You may like the other videos in the Test Automation playlist at https://www.youtube.com/playlist?list=PLc3SzDYhhiGXVcy8EcrTSfwsC-v8EUZvg
Madhu Nepal (3 years ago)
Really simply the best explained video .. thank you so much and expecting same type of Video of ETL testing in informatica ....
Mukesh Kumar (3 years ago)
That is very well descriptive and practical. Thanks a lot..
shilpi Agarwal (3 years ago)
your video is very explanatory and very well described. Do you have ETL Testing videos to share?If yes please share the link.
+shilpi Agarwal Thank you, Shilpi. I don't have any ETL testing videos. But, I have an article on data migration testing at http://inderpsingh.blogspot.com/2010/03/how-to-do-database-migration-testing.html
swati mishra (3 years ago)
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 https://www.youtube.com/playlist?list=PLc3SzDYhhiGU6fbp6JlTU8GPbEw_-eQFx
Archana Swaminathan (3 years ago)
Neat presentation
+Archana Swaminathan Hi Archana, many thanks for your comment.
md mia (3 years ago)
Good video, Thanks
+md mia Thank you. Appreciate your comment.
shareefuddin v (3 years ago)
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.
Siddharth Shukla (3 years ago)
Very Helpful Videos
Ankit Shukla (3 years ago)
Very Good video.............Nicely explained, easily understandable.
+Ankit Shukla Many thanks, Ankit.
bhargav eswar (3 years ago)
Really good video
+bhargav eswar Hi Bhargav, Glad that you like my video. Regards, Inder
Ashwini Kulkarni (3 years ago)
amazing worth the watch very sincere effort
+Ashwini Kulkarni Thanks, Ashwini.
bps kishore (3 years ago)
Awesome Tutorial...Thanks
+bps kishore Thanks, Kishore.
aleksandar maric (3 years ago)
Your presentation is really excellent! Thank you very much!
+aleksandar maric You are very welcome, Aleksandar.
Suja A (3 years ago)
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 https://www.youtube.com/playlist?list=PLc3SzDYhhiGXVcy8EcrTSfwsC-v8EUZvg
Test Test (3 years ago)
Hi your video tutorials are too good.Do you have any online training..
+Test Test Please check out my playlist named Manual Testing Tutorials. It has 25 software testing tutorials.
Test Test (3 years ago)
I don't need jmeter videos.I need software testing tutorial and sql training.
+Test Test Please see the details of my Selenium training videos at http://inderpsingh.blogspot.com/2013/10/SeleniumTraining.html
+Test Test Thank you. Yes, I have JMeter training videos. Please see the details at http://inderpsingh.blogspot.com/2013/10/JMeterVideos.html
Habib Khandaker (3 years ago)
+Habib Khandaker Thanks
oladeji olawumi (3 years ago)
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.
Sahil Suri (4 years ago)
Hello Sir, First of all Thanks for sharing this video I want to know whether this tutorial is sufficient to go for interviews .Can you please provide the full syllabus so that we can explore it on internet Thanks again
Sahil Suri (4 years ago)
Thanks a  lot Sir
+Sahil Suri My video introduces databases and database testing. It shows how to do database testing hands-on. In an interview, I would expect the person to know the Select statement clauses, types of joins, UNION operator, sub-queries and data migration testing. In addition, the tester should be able to identify problems in database schema, problems in data and issues in SQL queries. They should be able to re-write SQL queries to run without problems and faster too. I have written about some of these topics at http://inderpsingh.blogspot.com/search/label/Database%20Testing
Nice video, it is very helpfully for beginners. Thank you so much..
Sehel Sid (1 month ago)
contact me
Raman Malkania (4 months ago)
Idowu Sholanke (4 years ago)
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 http://inderpsingh.blogspot.com/search/label/Database%20Testing
Baskaran Chandran (4 years ago)
Thanks for this wonderful Video...i need lot of SQL Beginner video...plz provide some useful link..because i am the beginner in SQL..
+Baskaran Chandran Thanks for your comment. Please see my following articles on SQL and database testing at http://inderpsingh.blogspot.com/search/label/Database%20Testing
Nishan Dhillon (4 years ago)
Inder - you are simply the Best..!! Thanks bunch keep up your good work and God Bless !!
Thank you for your awesome comment and support.
Kumar Jadhav (4 years ago)
thank you sir  for showing database testing it help me lot
Kumar Jadhav (4 years ago)
Kumar - You are welcome. Thank you for your comment.
Poonam Singh (4 years ago)
Its really helpful video!!
Poonam - many thanks for your comment.
Suchi Aggarwal (4 years ago)
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 Aggarwal (3 years ago)
Suchi - Glad that you liked this video. Many thanks. Inder.
Prashant C (4 years ago)
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.
gnamakoudji (4 years ago)
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.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.