Must Know JAVA concepts | Selenium Automation | PART - 1 | Working with Databases

Working with databases is one of the most important and critical operations which every selenium automation developers must know. There are variety of databases available on the market like MySQL, Oracle SQL, MS-SQL and so on. Almost all the relational database management systems (RDBMS) are more or less the same. The Java code varies a bit for each database.
What will we learn in this video:
1. Why database testing is important?
2. What is database testing?
3. How to use Java for testing our database?
4. Java MySQL connection.
Installation Reference links:
---------------------------------------------
1)Download URL for XAMPP - bit.ly/1lmUscR
2) How to install Xampp - • How to Install XAMPP S...
3) Create database and table in MySQL - • create a database with...
4) JDBC connector Jar for MySQL - bit.ly/2VXDEl2
#Java #MySQL #SeleniumAutomation #LearnAutomationOnline
Best way to reach me (replies will be faster): KZbin comment section
Also, you can follow me on Facebook and Instagram.
Facebook: bit.ly/2TqPlis
Instagram: bit.ly/2Ez36rH

[@karthikdon6076]

U r really a superb teacher bro.....

[@udayakumar-raja]

You told in your previous video that we should not print the data inside the loop 😉.. Any how, thank you so much for your great explanation

[@LearnAutomationOnline]

For the sake of example I would have done it. Also it depends. If it’s a list then there is no point in printing inside a loop. If it’s a string, and if the value may not be available after coming out of the loop, then we should print or do the necessary action inside the loop itself.

[@sangamithrap6775]

please post videos how to write queries in the mysql so it will be useful for all the other concepts

[@ganeshmynampati1607]

Thank you very well explained..Easy to understand

[@divyavarman5858]

Hi AP, Index value starts from zero only right, why we are using 1 and 2 as index value instead of 0 and 1?

[@LearnAutomationOnline]

This index represents the column number. It's not like an array starting from zero.

[@divyavarman5858]

@@LearnAutomationOnline Understood AP :-)

[@karthikdon6076]

Thank you so much bro really easy to understand 😊😊😊😊😊😊😊

[@prasathraj947]

I get ClassNotFoundException how to handle

[@sasi11889]

Really good explanation sir

[@kanmani3894]

Hi Sir, i want to learn automation engineering. But my qualification is M.A.,B.ed.,M.phil(English). Am I able to learn this course? If yes, please tell me where to start?

[@LearnAutomationOnline]

You can learn irrespective of your educational background as long as you know how to operate a computer. But the question is, if you are learning for IT job, chances are low for your qualifications to get hired. If u are willing to learn start from selenium basics Playlist

[@kanmani3894]

@@LearnAutomationOnline Thank you sir.

[@udhayausha5615]

Connection epdi kudukanum slunga bro

[@Sai-px5dn]

Already i have MYSQL how to connect JDBC sir?

[@diwyadevi5914]

Hi bro,after entering the class.forname it is showing error that- Syntax error on token':';expected and another error as Syntax error on token "class" invalid expression.Can you please provide solution what mistake I did.Thanks bro

[@learnwithveeksha8797]

Hi bro, need to automate the Database testing .... any best guidence?

[@valliappanmani3013]

Hi Sir, How to retrieve whole table using ResultSet Class?

[@attitudelove4517]

Hi bro… Give a real time example with database testing….

[@vasanthanR]

Driver.getconnection path correct ah eduka mudiyala

[@dineshselvi5]

Sir i have MySQL how set the path for that ..

[@benittoraja5957]

Thank you.

[@lokiloki1370]

Hi bro, i have one dout getconnection la eppdi bro connection wrote paniga and Java connector jar file eppdi add panrathu project la

[@sureshsubramaniyan3201]

First of all thanks for the concept. If we want to perform insert/update/delete and group by function means how to do that?

[@LearnAutomationOnline]

Same no difference in java part except, SQL queries. Insert into, update and delete queries will work.

[@LearnAutomationOnline]

You have dropped some comments and deleted it seems. If how to insert, update and delete records via java is your question, I would like to let you know that For test automation we will only do select operations. However, when covering the SQL concepts, I will take all these.

[@ParthiPlays]

unknown database error selinium users nu varuthu na

[@chunky910]

all okay ji. But index for second and third rows needs to be mentioned as which??

[@LearnAutomationOnline]

There will be one result set object and it will be used in resultset.next while loop. I means as long as there are records which means rows are present, retrieve the column mentioned. You don't have to iterate rows.

[@tamilselvanm7418]

In while loop condition we use Setname.next My doubt is for checking the data available that case why we not use Setname.hasNext Bcz we use this for iterator also

[@sangamithrap6775]

hi sir how to get the url for the class.forname and connection and we have to remember that for all the same url only please tell me that

[@LearnAutomationOnline]

U don't have to remember that. A simple search will bring that up.

[@karthikeyanm3127]

Vera level bro 🔥🔥🔥

[@jr-sx2cq]

Automation testing ku java fulla learn pannanuma..illa nenga potruka must know java concepts matum learn panna pothuma ? Then I know manual testing concepts..ipo selenium learn pannitu java ku vara va illa enna Panna brother

[@thirupathythiru3883]

Super bro

[@haseens-ph9to]

thanks anna

[@venkatasubramaniam3643]

I want to know how to fetch data from database and enter it in the web application ? Can anyone explain.

[@venkatasubramaniam3643]

Assume there is sign-up page in the web application. I want to fill all the fields in the application by fetching data for every field from the database. How to do it ?

[@abdul2001]

Bro...ithula epdi bro JOINS use pannurathu.....

[@LearnAutomationOnline]

Join has nothing to do with java, if you write the sql query for join then it can be sent to execute query method.

[@venkatesh273]

Hi bro. I got the following error. please let me know how to resolve it Exception in thread "main" java.sql.SQLException: The server time zone value 'Eastern Summer Time' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specifc time zone value if you want to utilize time zone support.

[@venkatesh273]

problem solved.

[@LearnAutomationOnline]

In your connection string, use time zone property. Pls see this example jdbc:mysql://localhost:3306/dbname?serverTimezone=UTC

[@LearnAutomationOnline]

Great

[@venkatesh273]

@@LearnAutomationOnline hi brother. got this error when trying to work with MSSQL database. please help com/microsoft/sqlserver/jdbc/SQLServerDriver has been compiled by a more recent version of the Java Runtime (class file version 58.0), this version of the Java Runtime only recognizes class file versions up to 57.0

[@venkateswarann6659]

Hi Anna , i completed msc computer science in 2017 and due to some reason I working as marketing executive for the last 5 years. Now i want to switch domain and take job in it anna.please guide me...

[@LearnAutomationOnline]

start learning agile, jira and manual testing from the playlist tab. finish these first and let me know.

[@venkateswarann6659]

@@LearnAutomationOnline ok anna thank you for your response ❤️

[@ramyaravi5779]

@@LearnAutomationOnline After finishing this which concepts I have to learn sir?

[@LearnAutomationOnline]

Selenium basics, selenium advanced , testng, selenium interview questions

[@venkateswarann6659]

@@LearnAutomationOnline 👍

[@prabhuk5902]

For automation tester how much SQL knowledge need

[@LearnAutomationOnline]

For automation testing u don’t need much sql knowledge. Just basic querying, min, max functions and other frequently used functions should be good. If possible, you can master joins.

[@prabhuk5902]

@@LearnAutomationOnline thanks bro

[@Priyadharsini.N]

Bro i have one doubt.LAMP thana ippa XAMPP ? Do ubundu users really need to download xampp? because wouldn't they be inbuild?

[@LearnAutomationOnline]

I think for most Linux distribution it’s in built. LAMP and xampp have minute diff cue I guess but more or less same. If I don’t see the download options for Ubuntu see if it’s already installed on your machine

[@rajarathinam1965]

Sir testingku endha java mattum padicha pothuma sir

[@rajarathinam1965]

Nan ipa fresher job thedumna edhallam padikanuma sir

[@LearnAutomationOnline]

Agile, jira, manual testing, java, java interview programs, maven, github, rest web services, postman, page object model, keyword driven

[@johnvicky6561]

Itha excel ah panamudiyuma bro

[@LearnAutomationOnline]

Database kum excel kum enna connection iruku? Excel and DB are not same

[@johnvicky6561]

@@LearnAutomationOnline bro excelworkbook la rows and columns irukum athala some data irukum la atha retrieve pana mudiyatha

[@LearnAutomationOnline]

As I said before, excel and db are different. If you want to read or write excel, refer my data driven playlist.

[@johnvicky6561]

@@LearnAutomationOnline ok bro thanks bro

[@Elliot-792]

Hi Arul, One small doubt . is Xampp is used in industry for database @www.youtube.com/@LearnAutomationOnline

[@LearnAutomationOnline]

No xamp is not used as database. I showed it as an easy way to get things done.

[@trunkcall_tamil]

Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver error message came. and what will do anna

[@vishwanath6929]

Add the Java connector jar file in to your project

[@lokiloki1370]

@@vishwanath6929 how bro