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

Подписаться 82 тыс.

Просмотров 47 тыс.

50% 1

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): RU-vid comment section
Also, you can follow me on Facebook and Instagram.
Facebook: bit.ly/2TqPlis
Instagram: bit.ly/2Ez36rH

Опубликовано:

18 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 71

@karthikdon6076 3 года назад

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

@ganeshmynampati1607 5 лет назад

Thank you very well explained..Easy to understand

@udayakumar-raja 2 года назад

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 2 года назад

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.

@sasi11889 5 лет назад

Really good explanation sir

@karthikdon6076 3 года назад

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

@sangamithrap6775 10 месяцев назад

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

@karthikeyanm3127 2 года назад

Vera level bro 🔥🔥🔥

@thirupathythiru3883 2 года назад

Super bro

@divyavarman5858 5 лет назад

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 5 лет назад

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

@divyavarman5858 5 лет назад

@@LearnAutomationOnline Understood AP :-)

@prasathraj947 2 года назад

I get ClassNotFoundException how to handle

@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

@lokiloki1370 2 года назад

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

@vasanthanR 2 года назад

Driver.getconnection path correct ah eduka mudiyala

@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

@benittoraja5957 2 года назад

Thank you.

@Sai-px5dn Год назад

Already i have MYSQL how to connect JDBC sir?

@sangamithrap6775 10 месяцев назад

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 10 месяцев назад

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

@haseens-ph9to Год назад

thanks anna

@udhayausha5615 Год назад

Connection epdi kudukanum slunga bro

@kanmani3894 3 года назад

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 3 года назад

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 3 года назад

@@LearnAutomationOnline Thank you sir.

@valliappanmani3013 2 года назад

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

@dineshselvi5 Год назад

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

@ParthiPlays 2 года назад

unknown database error selinium users nu varuthu na

@learnwithveeksha8797 3 года назад

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

@Priyadharsini.N 2 года назад

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

@LearnAutomationOnline 2 года назад

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

@venkatesh273 4 года назад

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 4 года назад

problem solved.

@LearnAutomationOnline 4 года назад

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

@LearnAutomationOnline 4 года назад

Great

@venkatesh273 4 года назад

@@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

@abdul2001 4 года назад

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

@LearnAutomationOnline 4 года назад

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

@venkatasubramaniam3643 2 года назад

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

@venkatasubramaniam3643 2 года назад

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 ?

@attitudelove4517 3 года назад

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

@sureshsubramaniyan3201 5 лет назад

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 5 лет назад

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

@LearnAutomationOnline 5 лет назад

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.

@chunky910 4 года назад

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

@LearnAutomationOnline 4 года назад

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 2 года назад

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

@rajarathinam1965 2 года назад

Sir testingku endha java mattum padicha pothuma sir

@rajarathinam1965 2 года назад

Nan ipa fresher job thedumna edhallam padikanuma sir

@LearnAutomationOnline 2 года назад

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

@prabhuk5902 2 года назад

For automation tester how much SQL knowledge need

@LearnAutomationOnline 2 года назад

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 2 года назад

@@LearnAutomationOnline thanks bro

@venkateswarann6659 2 года назад

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 2 года назад

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

@venkateswarann6659 2 года назад

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