SQL Tutorial 9: SQL Joins and Sub Queries

No video

SQL Tutorial 9: SQL Joins and Sub Queries

Рет қаралды 236,122

Күн бұрын

Topic : SQL Joins and Sub Queries
#########################
Udemy Courses:
#########################
Manual Testing+Agile with Jira Tool
************************************
► shorturl.at/xNXZ4
Selenium with Java+Cucumber
********************************
► shorturl.at/aIKMW
Selenium with Python & PyTest
********************************
► shorturl.at/ELW09
Selenium with python using Robot framework
****************************************
► shorturl.at/bcDPZ
API Testing(Postman, RestAssured & SoapUI)
*****************************************
► shorturl.at/uAWY7
Web & API Automation using Cypress with Javascript
********************************************
► rb.gy/4uum2n
Playwright with Javascript
**************************
► shorturl.at/gALZ1
Jmeter-Performance Testing
************************
► rb.gy/ocj7r2
SDET Essencials(Full Stack QA)
*************************
► rb.gy/hlnf2v
Appium-Mobile Automation Testing
************************************
► rb.gy/wmzv64
Java Collections
*****************
► bit.ly/3S66ezE
Python Programming
*********************
► urlis.net/gdsf...
Cucumber BDD Framework
***************************
► bit.ly/3F7d69r
Protractor with Javascript
***************************
► urlis.net/4udd...
####################################
KZfaq Playlists:
####################################
Manual Testing & Agile
***********************
► bit.ly/3ujvaYa
► bit.ly/3OYzxQj
SQL
*************************
► bit.ly/3R6XjeG
► bit.ly/3nE0a1s
► bit.ly/3IeKuuJ
linux & Shell Scripting
**********************
► bit.ly/3up1Z6a
► bit.ly/3nzvGxx
Java
**********************
► bit.ly/3R9QfOs
► bit.ly/3AoRMKM
► bit.ly/3IbTTDn
► bit.ly/3ybXInv
► bit.ly/3yCoHdw
Selenium With Java+Cucumber
********************************
► bit.ly/3P2FMm4
► bit.ly/3yhiIt4
► bit.ly/3uokzet
► bit.ly/3a7XIND
► bit.ly/3umN2S9
► bit.ly/3aar7GW
► bit.ly/3y9kD2S
► bit.ly/3uhLskn
Python
********************************
► bit.ly/3agNgU0
► bit.ly/3NJNnoy
► bit.ly/2CTQ4mR
► bit.ly/3OIYWh1
Selenium With Python,Pytest&Behave
***************************************
► bit.ly/3OHHoC9
► bit.ly/3IeNLdv
► bit.ly/2J4tPeT
► bit.ly/3ydSkAq
Selenium With Python Using Robert Framework
(Web&API Testing)
*************************************************
► bit.ly/3nUvlpr
► bit.ly/3nUvE3z
API Testing (Postman,SoapUi,&Rest Assured)
**********************************************
► bit.ly/3OXacWY
► bit.ly/3yh0UhE
► bit.ly/3nC9DWQ
► bit.ly/3yGfhNS
► bit.ly/3OJa11H
► bit.ly/3P2slCC
Mobile App Testing Appium
****************************
► bit.ly/3Al49HG
Performance Testing Jmeter
*******************************
► bit.ly/3nz4fE7
Maven,Jenkins,Git,Github,CI/CD
*******************************
► bit.ly/3P16HPj
► bit.ly/3yhlUVA
► bit.ly/3afYfwT
► bit.ly/3yGzweG
► bit.ly/3yF73Ws
► bit.ly/3NCOmH7
SQL,DB Testing&ETL,Bigdata
*******************************
► bit.ly/3NKOcNY
► bit.ly/3OVpDyI
► bit.ly/3NEvUy0
► bit.ly/3IryxlT
► bit.ly/3RkWBLh
JavaScript Based Automation Tools
********************************
► bit.ly/3nUx51X
► bit.ly/3AqI6Q0
► bit.ly/3yeurbT
► bit.ly/3ujzpTK
Selector Hub Tools
********************
►rb.gy/h3h424
GraphQL
******************
► rb.gy/sj3gys
Cypress API Testing
********************
► shorturl.at/fjKPX
Cypress Web Testing
**********************
► shorturl.at/agjlK
Playwright with Javascipt
**************************
► shorturl.at/adSTY
#SQLJoins
#SubQueries
#SQLTutorial
#DatabaseJoin
#InnerJoin
#OuterJoin
#LeftJoin
#RightJoin
#FullOuterJoin
#SelfJoin
#CrossJoin
#NaturalJoin
#SQLQueries
#QueryOptimization
#DatabaseSkills
#LearnSQL
#SQLBasics
#SQLMastery
#SQLDatabase
#StructuredQueryLanguage
#SQLSyntax
#DatabaseManagement
#SQLSkills
#JoiningData
#SQLCoding
#SQLForBeginners
#SQLTips
#SQLTricks
#SQLExamples
#SQLCommunity
#DatabaseDesign
#SQLDevelopment
#DataAnalysis
#SQLLearning
#SQLPractice
#DatabaseQueries
#SQLServer
#SQLExpress
#DataManipulation
#SQLPerformance
#DatabaseNormalization
#AdvancedSQL
#SQLQuerying
#QueryOptimization
#SQLConcepts
#DatabaseJoining
#SubQueryExamples
#SQLStudents
#JoiningTables
#SQLPro

Пікірлер: 145

@shamikaredkar837 3 жыл бұрын

OMG THIS VIDEO LITERALLY SAVED MY LIFE!!! I have an exam on SQL tomorrow and I feel a lot more confident

@sdetpavan 3 жыл бұрын

Good luck!!

@cashali4747 3 жыл бұрын

I guess Im asking randomly but does any of you know a way to log back into an instagram account?? I stupidly lost my password. I would appreciate any tips you can give me

@Bangloreblogs 2 жыл бұрын

@@cashali4747 yahi kam kr beta 🤦

@vijayyadavvlogs5614 Жыл бұрын

Kitna khokha Mila hai 😂

@shivachary6764 2 жыл бұрын

Best study channel in the whole KZfaq study channels

@sdetpavan 2 жыл бұрын

Thanks

@ilohakingsley8100 Жыл бұрын

Wow, just wow.... With you sir, I would say I am a proud QA Engineer/Data Analyst/Developer in view. All your videos are well explained. More grease to your elbow. Thanks so much.

@atlanticwriters5908 Жыл бұрын

Among all videos on you tube, you made me understand these things better.

@alexiojunior7867 Ай бұрын

very true ,im now starting to follow up on all his videos now

@lakshmyjayalakshmy2326 2 жыл бұрын

you are the best in this industry... no tutorial can beat this one in particular... Thanks a ton sir

@sdetpavan 2 жыл бұрын

welcome

@aaronmorber1943 4 жыл бұрын

Thank You. I can actually understand you The SqL boot camp intro one was good but after that it took me a while to find a good video that goes more in dept about nested query and or advanced query searches. Than I stumbled on to yours. you are one of the best instructors I found so far and I will keep watching yours.

@mekidtube4404 4 жыл бұрын

Hi guys why you dislike ? HE SHARING his knowledge please like like like positivity is better

@r.rajalakshmi369 5 ай бұрын

Thanks a lot sir 🙏. Your explanations are incomparable. Many would've faced lot of issues in understanding complex queries. But you made it understand like a piece of cake. You are awesome sir

@sdetpavan 5 ай бұрын

You are most welcome

@heenashaikh3350 4 жыл бұрын

I understood this joins concept by him after watching hundred other videos.. Thank you

@prasadgummadi5451 3 жыл бұрын

Yes super explanation

@alleebabaz763 3 жыл бұрын

It is helpful to understand the concept for beginners. Superb....

@swarnavamseekrishna5011 3 жыл бұрын

Sir, your explanation is fantastic even a dumb guy can understand in that way , thanks a lot sir you deserve guru. Guru Brahma guru vishnu guru devo maheshwara guru sakshath parabrahma thasmaishree guravenamaha.🙏🙏🙏

@sdetpavan 2 жыл бұрын

My pleasure

@alexiojunior7867 Ай бұрын

wow excellent content very easy to follow

@sdetpavan 29 күн бұрын

Glad you liked it

@abhishekkhare6175 3 жыл бұрын

very good explanation. the best part about his explanation was that he divided the question into small parts so that it was very easy to understand.

@sdetpavan 2 жыл бұрын

My pleasure

@bristiadhikary7441 3 жыл бұрын

Best join and sub query video in KZfaq. Thanks a lot sir. It's help me a lot for my interview.

@ganeshghule1223 2 жыл бұрын

R u become software test engineer

@DilshanSandeepa-wh9dv 6 ай бұрын

Sir your teaching is very good.I appreciate it ❤

@sdetpavan 6 ай бұрын

It's my pleasure

@PinkHouseIdeas Жыл бұрын

u r the best sir,i learnt lot from ur testing videos

@sdetpavan Жыл бұрын

Thanks

@deadflower2289 Жыл бұрын

I am thankful for you sir. This will help me in my SQL class.

@sdetpavan Жыл бұрын

Welcome

@subhajitchakraborty8724 Жыл бұрын

Hats off to you... You made complex queries so smooth...anyone can understand and perform....

@sdetpavan Жыл бұрын

Thanks

@markandeypandey3227 3 ай бұрын

Thanks a lot sir for tutorials, helped me a lot to understand joins🙏

@sdetpavan 3 ай бұрын

Welcome

@tejasree8246 11 ай бұрын

Wow super explanation sir

@sdetpavan 11 ай бұрын

Thank you so much

@bhushanchaudhari8522 2 жыл бұрын

one of the best tutor i found thank u sir for giving this kind of deep knowledge

@sdetpavan 2 жыл бұрын

Welcome

@gayathris4422 3 жыл бұрын

Thanks a lot for such a clear explanation 🙏 I have understood it clearly....

@user-om2jr5ut9s Жыл бұрын

Sir in the last example you missed a ,comma before salary and after first name . So the salary name was applied as alias for the first name instead of getting salary table.

@hemlatabisht3771 2 жыл бұрын

Thank you so much Sir you are the best teacher in youtube i have done manual testing course from your channel and now learning MySQl.

@sdetpavan 2 жыл бұрын

most welcome

@sathya1716 29 күн бұрын

Hi Sir, I never seen like this kind of explanation. Can you please make python logical programming videos?

@mathematicson Жыл бұрын

Sir your are teaching is wonderful you are saved my life. I have one suggestion sir please provide the mysql material pdf sir. That pdf is also helpful to many people

@sdetpavan Жыл бұрын

www.pavantestingtools.com/p/sql-tutorials.html

@mathematicson Жыл бұрын

Tq so much sir

@kittunayak4251 Жыл бұрын

realy your explaination is better than any other platform , realy amazing

@sdetpavan Жыл бұрын

Thanks

@srikargudla1517 10 ай бұрын

Thank you very much sir for ur wonderful explanation

@sdetpavan 10 ай бұрын

You are most welcome

@pareshmahajan261 2 жыл бұрын

Found Mistake in your Tutoiral 9. You said Right outer join as "Returns matched records + unmatched from right table Tab1". So here I am making correction as "Returns matched records + unmatched from right table Tab2" Also, in the same way for left join. Please correct me if I am wrong

@jayanth1191 2 жыл бұрын

yeah u are crct

@soumya8926 2 жыл бұрын

Tq sir tq so much I really like ur way of explanations.. it is very clear and understanding

@sdetpavan 2 жыл бұрын

welcome

@amritsinghania2722 2 жыл бұрын

I am just beginner and it was really helpful

@sdetpavan 2 жыл бұрын

Glad it was helpful!

@ojasvagupta766 2 жыл бұрын

SELECT * FROM EMPLOYEE WHERE SALARY

@shavezalam9086 Жыл бұрын

but some salary in > any is not correct as per my understanding could you please help me to to understand this one

@tusharsonwane8468 Жыл бұрын

Superb explanation Thank you so much sir👍

@sdetpavan Жыл бұрын

Welcome

@BUDUMURUKAVYAA 3 жыл бұрын

awesome explanation sir!tomorrow i can perform well in my lab examination

@sdetpavan Жыл бұрын

Thanks

@pavanakepati8320 2 жыл бұрын

Excellent lectures... 👏

@sdetpavan 2 жыл бұрын

thanks

@meenaselvam8282 2 жыл бұрын

Thank you sir . It was very helpful sir.

@sdetpavan 2 жыл бұрын

Most welcome

@tejasree8246 11 ай бұрын

Will u please provide the important interview questions on this topic just like mcqs

@kanak7725 2 жыл бұрын

it's very helpful video to fresher.

@sdetpavan 2 жыл бұрын

thanks

@nehathakkhar1956 4 жыл бұрын

This will make more sense and will be helpful if you can provide HR database link from where we can import. thanks

@deepakyangaldas1 3 жыл бұрын

github.com/nomemory/hr-schema-mysql/find/master

@Craze_Lifter 10 ай бұрын

Excellent lecture

@sdetpavan 10 ай бұрын

Thanks

@edwin918 2 жыл бұрын

There is a typo in left outer join. Left join =inner join +any additional records in the left table. not the right table,

@jessiepinkman9987 2 жыл бұрын

Yes correct, I was pitching my head looking at the wrong results😬

@mohittripathi1029 2 жыл бұрын

Sir aapko bahut bahut pranam

@sdetpavan 2 жыл бұрын

thanks

@shankarfutane191 Жыл бұрын

this is we call the perfect explanation. Thank you so much sir.

@sdetpavan Жыл бұрын

You are most welcome

@manthenianurag9721 Жыл бұрын

I think at 8:55 duration of this video, Left Outer join = Returns matched records + unmatched from left table table 1 right outer join = Returns matched records + unmatched from right table table 2 can you clarify it ??

@sanjeevkumarmishra8754 10 ай бұрын

Same doubt, think it's writing error

@javashashavali 11 ай бұрын

Thanks Pavan sir 21:00 sec

@sdetpavan 11 ай бұрын

Welcome

@atulshinde5343 3 ай бұрын

Hi sir the video is very useful and awesome.can we get data which ur using into the video for using queries.

@ninuritu9312 5 жыл бұрын

Thank you for the detailed explanation Sir

@sdetpavan Жыл бұрын

Welcome

@AtaurRahman-ft2nh 3 жыл бұрын

video is helpful but you gave only overview of join and did not do problems on that ....although my subquery concept is now more clearer

@ganeshghule1223 2 жыл бұрын

Tq so much sir really very awesome contributions to make vedio Im appreciate It's very to understand and lern

@sdetpavan 2 жыл бұрын

welcome

@vinothkumar4142 2 жыл бұрын

@1:19:36, Kindly provide comma(,) between FIRST_NAME and SALARY. Because at output SALARY has become as Alias name to FIRST_NAME column

@pujasaha5452 2 жыл бұрын

Was searching for this comment.😀

@saranyachandrabos3541 2 жыл бұрын

Thank you so much

@sdetpavan 2 жыл бұрын

You're most welcome

@alshadsk1412 2 жыл бұрын

SIR SUPER EXPLANATION,, IF YOU PROVIDE SAME DATA,, IT WILL BE BEST FOE US TO PRACTISE THE SAME..

@PradipYogi59 5 жыл бұрын

very detailed explanation thank you

@sdetpavan Жыл бұрын

Welcome

@yuviarts8475 4 жыл бұрын

thanks for the explanation video it's really useful

@sdetpavan Жыл бұрын

You are welcome

@mayowaoyesetan7337 4 жыл бұрын

sir when I run this query SELECT E.employee_id, M.manager_id, E.first_name, M.first_name, E.job_id FROM employees E, employees M WHERE E.employee_id = M.manager_id; I got different record for the first_name field. I think the field record for E.first_name, and M.first_name should be the same so far both alias are referring to the single firs_name field in employees table Awaiting your response sir. Thanks

@bindhunadh 2 жыл бұрын

Sir if we want to know the second high salary we can keep assending order and the result will come know sir

@MultiBirthdayWishes 2 жыл бұрын

Sir, In multi row query any is giving all the department_id not just 30... I don't understand why??

@anushadavuluri5558 Жыл бұрын

I have a doubt at 36:35 I.e., when you are deriving data from both the tablets it should be like from e.employee, m.manager right but you have mentioned as from e.employee, m.employee.. am bit comfused

@Raj-si5yz 4 жыл бұрын

Thanks ,could you please tell what is the difference between MySQL ,SQL and Oracle.

@chaithrab9648 2 жыл бұрын

MySQL and oracle are the RDMS were in sql is a query language used to create and maintain RDMS.

@rawvideos2266 Жыл бұрын

on the last problem, line 11 (,) comma is missing between First_Name and salary ... which is why is not printing the salary instead it's used as an alias name of the First_Name... Thanks

@akshatan4520 10 ай бұрын

"Äny " would print the same employee twice, is not it? because the employee having the salary 2000 is lesser than any of the department 30 salary.

@simransingla9397 4 жыл бұрын

Awesome explanation😄😃

@sdetpavan Жыл бұрын

Thanks

@kiranharijan2809 Жыл бұрын

Sir can you please provide more examples means like different examples so that we can practice

@deepparmar8 3 жыл бұрын

why do we bother using self join, we can anyways just use where clause and get the work done?

@muhammadjunaidmajeed1211 3 жыл бұрын

Excellent!

@sdetpavan Жыл бұрын

Many thanks!

@sharadjogdand5332 2 жыл бұрын

Table A having float as data type and Table B having varchar as a data type can we join these table?

@krupskunj Жыл бұрын

hey did you get the answer, i am jsut learning from these videos n as per my understanding, data type should b shame for join function, if i m wrong, please correct me

@powerupgamingyt Жыл бұрын

someone :- Pavan how do you know joins soo clearly Me :- i follow my man SDET 😛

@AHMEDAZEEMPBIOUG-BATCH Жыл бұрын

at 1:21:46 why in rsult colum didnt mention first_name ,which was commended

@priyankaavate6650 2 жыл бұрын

sir, cam we please get the presentation if possible?

@ahmedkhalil5008 Жыл бұрын

How can I purchase full courses from your channel please ?

@shamstabrez2986 2 жыл бұрын

smjh hi nhi aya 21:29 mein k department id is ambiguous dono table mein departmnt id jb h r maine table name b defined krdiya h to chup chap se dono table se deprtmnt id lekr inner join krdeta na

@badreswaribhadreswari7467 10 ай бұрын

Hi guys how to find the 3rd highest salary from employee table using joins.

@Ammugaja61 Жыл бұрын

How to find 6th maximum salary ?

@SameerAli-nm8xn 2 жыл бұрын

Every time, I am using this command I am getting an error like 1146, table doesn't exist. How to resolve it. Please help in resolving this issue

@oc7834 2 жыл бұрын

To be honest it wold have been so nice if you had shared all the datas you had. so many different datas and I have non of it

@vishnuprakash1016 3 жыл бұрын

Sir I have a doubt .. can u please clear it out?

@muzammilkarajgi7507 4 жыл бұрын

How I get all SQL videos ? Plz share a link of all videos

@prasaddevathi09 2 жыл бұрын

Hi Sir, can i get these SQL queries with db test data?

@rahulsharma-kd4dp Жыл бұрын

How to find 7th max highest salary in Employee table ?

@shamstabrez2986 2 жыл бұрын

sry lekin srusly kahun toh mjhe smjh hi nhi aya join aisa confuse krdiya aone yahan pr aakr jb mera employees table mein deprtmnet id h r department table mein department id h toh inner join jb kiye toh simply ans miljana chhye na qki ur query was SELECT FIRSTNAME, SALARY, DEPARTMENT ID FROM EMPLOYEES U HAVE MENTION HERE FROM EMPLOYEES TOH PHR ISME APNE KAHA K DEPARTMENT.DEPARMENT ID EMPLOYEES TABLE K ANDR DEPARTMENT TABLE R USKI DEPRTMNT ID

@Bangloreblogs 2 жыл бұрын

Sir where are the rest my sql videos ?

@user-um1of6fc5j 10 ай бұрын

sir can you please share link of Demo database hr link so we can practice on that

@gouthamimacharla2616 3 жыл бұрын

It's good

@sdetpavan Жыл бұрын

Thanks

@basanagoudabiradar8669 3 ай бұрын

sir please provoid hr data .link sir

@pareshmahajan261 Жыл бұрын

While executing same code in my system. It is showing error as Error Code: 1242. Subquery returns more than 1 row. Can any one tell reason ?

@shavezalam9086 Жыл бұрын

confusion from 1.02.55 someone please help me to understand this 'the whole salary is less Then 1400 ' but some salary is more then the salary of id_30