Database Testing MYSQL using Selenium Webdriver,Testng,Java,JDBC,Data Driven Framework,@DataProvider

Data Driven Framework using MYSQL Database:
--------------------------------------------------------------------
Data Driven Framework :

To maintain the data in a third party resource file and use the data to execute the tests in Selenium WebDriver.
xlsx
xls
xml
database-MYSQL

Data is not hardcoded in the testcases.

public void login()
{

}

public void login(String uname,String pword)
{

}

login("Selenium","########");

MYSQL:
is mainly useful to store the data in tables where it contains rows and columns.
SQL stands for Structured Query languages, where we write queries to manipulate the data.
Relational database
Open Source

Steps:
Downloading & Installation of MYSQL is provided in our blog

Port:
3306

username & password:
root/root

Start/Stop the Server:

Workbench:
To connect to the server and view the contents of the server we have already an GUI which is provided by MYSQL
called Workbench

Maven dependencies:
mysql-connector-java
mysql-connector-java

MYSQL:
schema/database: testdb

tables: emp & dept
emp:
rows & cols

col1[1] col2[2]
row1
row2

[gigamaisuradze]

I want to say huge thanks. U really helped me a lot. I wish u all the best in life

[HasnathAli]

Thanks a lot for this type of important video share.

[alka]

Thanks a lot! Video is really helpful.

[abel]

Thanks for your help. Your channel is awesome.

[MamunKhan-kkcf]

Thank you so much, this tutorial is a great help for me. keep it up.

[naveenbv]

Awesome 👍 Thanks for your effort and hard work in makinfbus understand easily. Again Thanks 🙏
I have a some queries -
1- Don't you feel that we would still be depending on the MySQL DB server and the time consuming would be more while transforming the data from Excel or CSV into db tables!!! - how about instead transferring into hashmap and use it rather than consuming memory and RAM for db server.
2 - Adding for your thoughts, nowadays I hear a lot about In-Memory DB even in automation testing, if you can make a video on the same would be more helpful as it is hot trend in automation.
3. Regarding the approach you explained, will this be more effective with large test base when dataset is huge and it would vary from test to test, which would be creating huge tables or databases!!!!
4 - Can we use this approach for End-to-End test cases as we might be depending on same workflow multiple times, so how would you suggest me to approach for the same.
I'm sorry for my queries but this is just for my knowledge purpose only.
Please help me in understanding 🙏

[kunalmodi]

Is it possible to compare the data from two different tables and queries and also, we can parametrize the queries for different etl jobs

[purvidholakia]

Thanks for uploading such a very useful video. I am working on local database of my company, how do I get Port number, Username & Password? Do I have to ask company for that? I have not downloaded JDBC driver but using maven dependency for same, And working with Microsoft SQL Server Management Studio 18 . Please guide me.

[harmanmaan]

Hi, I need some advise or guidance on Database testing, can you please share your email, I am looking for dedicated classes to learn this or can you guide who can be helpful? Thank you!