Software and Testing Training brand is owned by Inder P Singh. We provide effective online training in Artificial Intelligence (AI), Python programming, VB scripting, Perl scripting, Big Data, SQL, HTML, XML, Selenium Python, Selenium with Java, SoapUI, LoadRunner and JMeter automated software testing tools, software testing training, Database testing, QA, domain knowledge and others.
* View the videos in my playlists: Python Tutorials, VBScript, Perl Tutorials, HTML and XML Tutorials, Software Testing Tutorials, Selenium Python Tutorials, Selenium Tutorials, Test Automation, Database Testing, Big Data Tutorials, LoadRunner, SoapUI and Domain Knowledge
Пікірлер
Hi Sir thanks for the information can we secure logs that outside tampering not happen, this an interview questions that my friend shared,asked by an interviewer.
Hi Debarun, yes, we can secure logs, test data or test results using encryption. I have explained this in Linkedin at www.linkedin.com/advice/0/how-do-you-use-encryption-decryption-techniques-automation?trk=cah1
Thank you for reply I read that article but is there any code snippet ?that would be helpful.
Surely you can write the code to encrypt and decrypt data. But, the easier option is to use tools, as I have explained in section 3 of that article.
hello. thanks for your video. would you be so kind to help me? I have got a VBS script which makes a folder from a File_Path variable. The variable is read from a txt file. I would like to insert a if -then actions that the script cheks if the folder exists or not. If so there is nothing to do, if the folder does not exist the script should make the folder to a special path. please be kind to help me. thank you! The path in which the folder should make is the following (example): X:\0_Measurement_Lab\Measurement results\2024 Here you are the script: Set objReadFile = CreateObject ("Scripting.FileSystemObject").OpenTextFile("C:\test\TEMP.txt",1,True) File_Path = objReadFile.ReadLine objReadFile.Close Set fso = CreateObject("Scripting.FilesystemObject") Set CreateFolder = fso.CreateFolder(File_Path) 'MsgBox File_Path Set objReadFile = Nothing Set CreateFolder = Nothing Set fso = Nothing
You can use the FolderExists method of the FileSystemObject. Here's an example script that includes the necessary if-then check. You can uncomment the code lines with MsgBox statement if you need to view the values. ' Read the file path from the text file Set objReadFile = CreateObject("Scripting.FileSystemObject").OpenTextFile("C:\test\TEMP.txt", 1, True) File_Path = objReadFile.ReadLine objReadFile.Close ' Define the special path where the folder should be created if it doesn't exist Special_Path = "X:\0_Measurement_Lab\Measurement results\2024" ' Create a FileSystemObject Set fso = CreateObject("Scripting.FileSystemObject") ' Check if the folder exists If fso.FolderExists(File_Path) Then ' If the folder exists, do nothing 'MsgBox "Folder already exists: " & File_Path Else ' If the folder does not exist, create it in the special path Set CreateFolder = fso.CreateFolder(Special_Path & "\" & fso.GetFileName(File_Path)) 'MsgBox "Folder created: " & Special_Path & "\" & fso.GetFileName(File_Path) End If ' Clean up Set objReadFile = Nothing Set CreateFolder = Nothing Set fso = Nothing
@@QA1 thank you.
@petersomogyi2418 - You're welcome. If you need support, you can join my channel as Member (Standard Member for about USD 4.79 per month only). The link to join is www.youtube.com/@QA1/join
Hello Sir Please share the template I need
Hello, I can share the template individually. Please send a message to me in LinkedIn first at www.linkedin.com/in/inderpsingh/
Please define DC
Sure! DC (Definition Clear Path) means that it's a DU path and the first node in the path is the only Define node in that path.
Hi sir, your video helps me so much to learn about the software. But currently I am facing "parse command line error : Execute reader requires an open and available connection. The connection's current state is closed. " Could you please provide a solution to it or create a video for it? It's really helpful for me if you do this from the last 2 weeks I am facing the same. Need your help sir.
Hi Surywanshi, thank you for your comment! I hope that you've subscribed to Software and Testing Training channel. It seems that in your script, the connection is closed when the particular line of code is executed. Ensure the connection is being opened before executing any operations. Your connection string, timeout setting or the connection variable scope may be causing this error.
Sir if we have 100 of tables then how we will test every table schema and how much time will be required for this ?Thanks in advance
In database testing, we typically test the database objects (such as views, stored procedures and triggers) using test data. But, if the scope is to test every table schema, we would need a script to read the table design and log the defects.
Can u make videos on it?
Very helpful!!
@ParkourRhett - Thank you!
Hello sir ,I am following your manual testing course videos . I want suggestions & guidance. Can I continue with manual testing in 2024 are jobs available in the market these days, i have done my graduation in BBA. Sir, I tried to learn coding and automation testing but I am unable to understand. I have worked in several companies in non-technical roles. but now i want to switch my careers in IT is manual testing is a good choice.i am very confused. kindly reply sir.
Hello, thanks for following my Software Testing course (manual testing course) videos! Why are you unable to understand coding or automation testing? You can view the job opportunities. They ask for skills with automation testing tools. Business Analyst is a (relatively) non-technical role.
thank you for reply and your time sir , I tried joining automation course selenium java in banglore but the pace of course is very fast as i am from non technical background unable to understand, so i choose manual testing is it a good carrer ?@@QA1
I can teach you automation testing in Selenium Java at your own pace. You can contact me in LinkedIn (the link is at the bottom of the video description) or email me on isingh30 at g mail Thank you!
🤔 *Promo SM*
Myron Bradish - How? Prove it.
Hi...Do you agree that Regression testing can be done in all levels of testing.....?
Hi, of course! But in order not to burn time continuously, regression testing is typically scheduled before major releases.
How to check href inside the for loop like we do in java selenium def LinksVerification(self): links = OI_Fun.GetElements(self, "TAG_NAME", "a") print("No of Links on the Page->", len(links)) for i in range(1, len(links)+1): StrCurrentHref = links[i].href
I don't know what you mean by "check href". But the for loop to click each link is shown in this tutorial later.
I need a help for load runner tool , can you please send me your email id? It's very urgent.
You can contact me in LinkedIn (the link is at the bottom of the video description) or email me on isingh30 at g mail Thank you!
Thank for sharing this amazing content! Dumb question: is data quality a area that a software QA can work in or is it a different position/role/profession?
Thiago Fragoso - Thank you for your positive comment! Though software QA can contribute to data quality, it's a specialized role focusing on data quality management and improvement. For example, the Data Quality Analyst may need extensive domain knowledge and provide high-quality data to Data Science teams, DevOps teams and of course QA.
need more videos on performancetesting, loadrunner and also please upload interview questions load runner please.
Sure, in due time. If you need performance testing interview preparation support, you can join my channel as a Standard Member. If you need priority support and 1-1 sessions, you can join as Premium Member. The link to join as Member is www.youtube.com/@QA1/join
Sir, iam working in data analytics ( power bi). Is there career scope in telecommunications domain...? Thanks for your efforts!!
Telecommunications domain is big and growing. Firstly, view OSS telecom video at kzread.info/dash/bejne/jHujzpWhhN3KY8o.html and then BSS telecom video at kzread.info/dash/bejne/nXx4rMOEm8uto6Q.html Learn about Big Data in various domains at kzread.info/head/PLc3SzDYhhiGWebfydYhtzoVo5sZPaJuPh
Atleast try to pronounce those word separately….jeez
Ha ha! I was trying to say all the material within the 1-minute limit set for shorts 😂
This video is good but need from scratch.. Like when to use capital double coat like this..
@Thippesh_TR Pani - If you need support, you can join my channel as a Standard Member. If you need priority support and 1-1 sessions, you can join as Premium Member. The link to join as Member is kzread.info/dron/8w8_H_1uDfi2ftQx7a64uQ.htmljoin
Thanks
thank you sir,very helpfull
What is the name of your channel
Software and Testing Training
Hi, Do u have any videos for data migration testing scenarios where source as oracle db & target as cloud ?
I should have the data migration testing scenarios, but I am not able to recollect the exact video, because I have uploaded more than 300 videos. But, here are the main scenarios (from my notes) for a successful transition from Oracle DB to the cloud. I hope that these help you: - Test comprehensive profiling of source data in Oracle DB to understand data types, constraints, and relationships. - Verify the compatibility of Oracle DB data with the target cloud platform. - Validate the accuracy of data mapping between Oracle DB and the cloud. - Confirm the success of data transformations during the migration process. - Verify that data integrity is maintained during the migration. - Confirm consistency between source and target data, including primary keys and unique constraints. - Ensure that the target cloud database schema matches the structure of the source Oracle DB. - Validate the creation of tables, indexes, and constraints. - Conduct data quality checks to identify anomalies or discrepancies. - Verify the accuracy of migrated data by comparing sample records. - Confirm the compatibility of the migrated data with the specific cloud database service (e.g., AWS RDS, Azure SQL Database, Google Cloud SQL). - Validate the support for Oracle data types in the chosen cloud platform. - Test the performance of data retrieval and storage in the cloud environment. - Ensure scalability by testing with varying data volumes. - Verify the implementation of data encryption during transit and at rest. - Validate access controls to ensure only authorized users can interact with the migrated data. - Develop automated scripts to validate large datasets efficiently. - Run regression tests to ensure ongoing data accuracy after subsequent migrations.
Very Helpful😊😊
Thanks u sir...
Gopi Bussa - Thanks for your comment! If you need any support, you can join this channel as Standard Member or Premium Member at www.youtube.com/@QA1/join If you want to join our community and view job openings, you can join the Software and Testing Training group in LinkedIn at www.linkedin.com/groups/5002609/
9 years ago? Is this as relevant today as it was? Or are there any additional stuff one needs to learn?
There's still a role called Test Lead, interviews are still conducted for hiring, viewers still comment that this video helped them prepare for their successful interview, so I would say Yes. But, the software development lifecycle is now called "Agile". The additional stuff is available in my Agile Methodology playlist videos at kzread.info/head/PLc3SzDYhhiGUQKahQnRT6_16BijvyJJYN
@@QA1 Awesome! Thank you fine sir
Hi lets say if i have 2 Identaical Link Text, how can I click on the 2nd linktext?
Hi, did you view this tutorial in full? In the loop, you can click on the 2nd link (not linktext) and exit the loop.
Thanks for letting me know.
for each scenario how many testcases we can write ?
There is no limit to the number of test cases for each scenario. But, we should write the test cases based on the importance to the users and also common scenarios. Thanks for your sub 🙏
Very informative video thank you so much 🙏🙏🙏🌺🌺
nice video brother
Ercan , thanks!
Question: As you mentioned Network operations is the part of OSS , what about SOC ?
Yes, the OSS focuses on both Network Operations and Service Operations: 1. NOC (Network Operations Center) is responsible for monitoring network performance, troubleshooting network problems, performing network maintenance, managing network inventory, provisioning network services, ensuring network security etc. 2. SOC (Service Operations Center) is responsible for monitoring service performance, troubleshooting service problems, managing service quality, managing customer interactions, ensuring service availability, ensuring service security.
Thanks for sharing valueable info.
You are most welcome. The related videos are: 1. Telecom Domain at kzread.info/dash/bejne/a66GzbGritrel7A.html and 2. BSS at kzread.info/dash/bejne/nXx4rMOEm8uto6Q.html
Excellent precise presentation.Thanks
😕 Promo-SM
This tool is a software to implement a basic estimation template.
Try my new Agile test estimation tool 🛠, based on well-known test estimation techniques: inderpsingh.blogspot.com/2023/10/test-estimator.html No sign-up required and it's free 🆓.
👏👌
@JHANSIBALMURI - Thank you 🙏
Thank you for this great explanation! I have really understood it now!
Great to know! There are 3 more confusing topics in White Box testing. See explanations and examples at Data Flow Testing: kzread.info/dash/bejne/n5OIs4-jo8m4p7A.html Mutation Testing: kzread.info/dash/bejne/c32DypOzk73TmJs.html Orthogonal Array: kzread.info/dash/bejne/q4yEvK6fosXFerg.html
Can we use database load testing using load runner.
Prabhat Gupta - Of course, we can do database load testing using LoadRunner on databases (e.g. Microsoft SQL Server, Oracle etc.) with operations like inserting new data, updating existing data or querying the data. Please feel free to ask any questions on LoadRunner. Best wishes, Inder P Singh
Sir if possible could u make the vidoes on that..take any db acc to ur choice and let us know how to perform db testng using load runner. In whole utube and udemy i could not find any video releated to this.@@QA1
@prabhatgupta6415 - You should view the complete set of LoadRunner videos at kzread.info/head/PLc3SzDYhhiGU6fbp6JlTU8GPbEw_-eQFx In db load testing, you just have to use a different protocol. The tool is the same.
Great video. I would have liked to see a code example of high vs low coupling. I'm trying to clean up my code and was wondering what high coupling looks like in software.
Thank you for your encouragement! High coupling means that the software system components are tightly interconnected and depend heavily on each other. This reduces modularity and flexibility. Sure, I will give a code example in Python since I have Python tutorials set at kzread.info/head/PLc3SzDYhhiGUZMFNSnn2YEzQ51-691VTA High coupling in Python: class Order: def __init__(self, customer, product): self.customer = customer self.product = product def calculate_total_price(self): # High Coupling: The Order class directly depends on the Product class. return self.product.price class Product: def __init__(self, name, price): self.name = name self.price = price customer1 = "Alex" product1 = Product("Laptop", 200) order1 = Order(customer1, product1) print(f"Total price for {order1.customer}'s order: ${order1.calculate_total_price()}") Note that Order class depends on the Product class to calculate the total price of an order. If you change the Product class or add new classes for products, you may need to modify the Order class. Conversely, low coupling occurs means that the software components have minimal dependencies on each other. This increases modularity and ease of maintenance. Low coupling in Python: class Order: def __init__(self, customer, items): self.customer = customer self.items = items def calculate_total_price(self): # Low Coupling: The Order class relies on the items themselves, not specific product classes. total_price = sum(item.get_price() for item in self.items) return total_price class Product: def __init__(self, name, price): self.name = name self.price = price def get_price(self): return self.price class Service: def __init__(self, name, cost_per_hour): self.name = name self.cost_per_hour = cost_per_hour def get_price(self): return self.cost_per_hour customer2 = "Brad" items = [Product("Laptop", 200), Service("Consulting", 50)] order2 = Order(customer2, items) print(f"Total price for {order2.customer}'s order: ${order2.calculate_total_price()}") Note that the Order class relies on a list of generic items, each of which implements a get_price method. This allows you to add new item types (e.g., Services, Shipping, Insurance) without modifying the Order class.
Level bro ❤
very great video. Thank you very much. Just a suggestion, please if you could change the black background because I feel my eyes cannot stand it. White background and black letters would be more nice visual. Thank you very much sir
@dorianjonsmusic - Thank you very much for your encouraging comment! From the next video, I will try to use white background. Thanks for your suggestion!
white bg is just ewwwwwww
Well explained sir !!
Aparupa basu roy - Thank you!
Are these vb script videos useful to install applications?
No, I have other VBScript scripts to install applications.
@@QA1 plz share that video link
Not video, but scripts that I have.
@@QA1 is it possible to share that scripts, plz share.
You can email me your application packaging requirement. If I have any suitable existing script, I can send you, else I'll have to write a new script.
I don't get it. When you 10:59 say "It doesn't matter" - how is this supposed to affect number of cases? Do we still test all alternating values or just pick random of them?
Graf MKristo - "how is this supposed to affect number of cases?" You would get the number of cases after simplifying the decision table. If you continue viewing this video, you would see that there are 4 columns after simplification. That means that you would have 4 cases. When I say at 10:59 that "It doesn't matter", it is the first case. When testing that case, you would pick a random value (because the output doesn't depend on it) or that field may just be disabled or blank in your application.
Hi how to do load testing on report? I want to test report migration from cognos to jasper how it is possible manually?
Hi, manual load testing may be done initially for a report migration from Cognos to Jasper can be done by running a large report or having multiple users accessing and generating reports concurrently. But, you may need to repeat the manual load testing a few times to get results with confidence.
Thank you for this. My question is that for Example 2 where A(2 vals), B(3 vals), C(3vals) Why did you choose Ortho-array of 9 rows and 4 columns? You could have chosen 4 rows and 3 columns?
Thank you for your question. The orthogonal array technique is to search for an Ortho-array (OA) with the smallest number of rows. The OA that I chose was the smallest published OA for the needed number of rows, max. number of vals taken and the number of columns. The OA with 4 rows and 3 columns only allows 2 vals for each variable. But the 9 rows OA allows 3 vals for each variable.
Very good explanation
Manoj, thanks! Best wishes, Inder P Singh
it is possible to copy multiple test lines and paste them in another position (contr C - Contrl V of multiple lines)
It is also not clear, who prepares the knowledge base in the initiation phase for whom. and it contains what?
AFAIK, the ERP implementation team prepares the knowledge base in the initiation phase for the ERP system end-users (as ERP system guide), management (for system overview), IT (for system architecture and integrations), vendors/ suppliers (for integrations), quality auditors etc. This knowledge base is specific to the ERP implementation project. It has the documentation, guidelines, and resources about the ERP system, its implementation, and its usage. The knowledge base (KB) is a "living" document because it is updated throughout the ERP implementation project and later during customization(s). The KB contains Introduction and overview, Project plan, ERP system information, User resources, Technical details, Support and troubleshooting, Quality standards, Change management, Appendices or other relevant sections.