Видео

Let me know your queries!

@@engineermind1651 not really. Iske baad left, right outer joins ke concepts explain kiye hain. But in future main aur videos daalunga. Filhaal ye videos bhi database testing ke liye more than enough hai, but I will keep adding more soon. Also, let me know if you are enjoying and learning from my videos :)

No, it will not give error and it will update the other John’s salary as well. But because in this example there is only one John (which is unique), we will not have any problem. But let’s say if you have multiple records with name John, then use the primary key (EmployeeID) to update the salary as it has the unique value.

@@theqaguy96 mere me to error de raha hai John name se update karu to aesa kyu ?

@@engineermind1651can you tell me what is the error? And have you entered any other record with name “John”? I would suggest to update using EmployeeID. And also can you tell me what operation you are trying to do

​@@theqaguy96 Error Code:1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. I think ye kuch slow mode on hai isiliye ye error aa rahi hai. Ye slow mode only primary key se hi value update Karane deta hai. Mere me John name se dusara koi record nahi hai.

@@engineermind1651 okay got it. Safe mode disable karne se ye issue resolve ho jaayega, because UPDATE/DELETE commands are usually considered to be dangerous as it might affect data. Safe mode disable karne se hojana chahiye theek.

Thanks :)

Sir ek question hai jahape SQL File 5 tab hai wahase change karke mera khudaka name likhana ho to kese likhe ?

@@engineermind1651ctrl+S karke ya fir Save as karke name change kar sakte ho SQL scripts ka.

Sure

Thanks :)

Sure, will automate the application using Scenario outline in my next video

Hi, I have uploaded the video explaining scenario outline. Hope you like it :)

Thankyou! 😊

You can add in your resume, the details like you have done projects like these

@@theqaguy96 🙏❤

As prerequisites, you should have basic knowledge of database (basically what is a database and why we use it). Other than this you should have basic knowledge of excel because just like we interpret tables in excel, same way they are interpreted in SQL. Lastly, you should have interest in learing SQL :)

Its not complete yet, but as a QA whatever things we would need to perform database testing, I will be adding all those topics. But basic topics (and yet most important ones) have already been covered.

JMeter supports Java version 8 and above. If you have this prerequisite, you can run your test cases in JMeter easily. However, it is recommended to use Java version 17+ as older versions might not support latest JMeter features. Let me know if you have further questions.

@@theqaguy96 thanks 👍

can you let me know what's the issue

I have installed Java 11 in my machine. You may install Java version 8 or above which will be compatible with Selenium. However, for TestNG and Cucumber, please download the latest stable dependency from mvn repository, to integrate it with your selenium maven project.

@@theqaguy96 i use Java 17 but some problem I suggest can you make video details install of Cucumber, testNG, used pom.xml , may usefull everyone 👍

It will work fine with Java 17 as well. I have already made videos on how to install Cucumber, TestNG from pom.xml. Both of these videos are on my channel :) If you want me to make a video on any particular issue that you’re talking about, please let me know :)

@@theqaguy96Sure. Thanks 👍

Hi, you can import Selenium Java from pom.xml file using its maven dependency. I will show you how it’s done in my upcoming video.

@@theqaguy96 yes please make video.

@@QaSt-ho9uu Hi, I have uploaded that video. Please check for the latest video with Title: End-To-End- Selenium Java Project with TestNG framework. Along with selenium Java integration, you will learn an important concept called TestNG. Hope you like it! :)

Hello! You mean add numbering in all thumbnails?

@@theqaguy96 yes, please add like part1, part2, part3.....

@@QaSt-ho9uu Sure will do.

Sure man, will do in my next video.

As per your request, I have uploaded the video on Test Plan. Like, comment, share and subscribe if you like it :)

Thankyou for the appreciation! :) Sure will do.

Thakyou! 😃

Sure, will do it!