SQL Tutorial 9: SQL Joins and Sub Queries
Вставка
- Опубліковано 21 жов 2024
- 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...
####################################
UA-cam 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
OMG THIS VIDEO LITERALLY SAVED MY LIFE!!! I have an exam on SQL tomorrow and I feel a lot more confident
Good luck!!
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
@@cashali4747 yahi kam kr beta 🤦
Kitna khokha Mila hai 😂
Best study channel in the whole UA-cam study channels
Thanks
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
You are most welcome
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.
What a wonderful explanation of the complex topic in SQL. I am really thankful to you. I have learnt a lot from your other videos too. Thank you so much!
Among all videos on you tube, you made me understand these things better.
very true ,im now starting to follow up on all his videos now
you are the best in this industry... no tutorial can beat this one in particular... Thanks a ton sir
welcome
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.
I understood this joins concept by him after watching hundred other videos.. Thank you
Yes super explanation
It is helpful to understand the concept for beginners. Superb....
Hi guys why you dislike ? HE SHARING his knowledge please like like like positivity is better
Sir your teaching is very good.I appreciate it ❤
It's my pleasure
wow excellent content very easy to follow
Glad you liked it
Best join and sub query video in UA-cam. Thanks a lot sir. It's help me a lot for my interview.
R u become software test engineer
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.
My pleasure
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.🙏🙏🙏
My pleasure
Thanks a lot sir for tutorials, helped me a lot to understand joins🙏
Welcome
I am thankful for you sir. This will help me in my SQL class.
Welcome
u r the best sir,i learnt lot from ur testing videos
Thanks
Hats off to you...
You made complex queries so smooth...anyone can understand and perform....
Thanks
one of the best tutor i found thank u sir for giving this kind of deep knowledge
Welcome
Wow super explanation sir
Thank you so much
realy your explaination is better than any other platform , realy amazing
Thanks
Thanks a lot for such a clear explanation 🙏 I have understood it clearly....
Hi Sir, I never seen like this kind of explanation. Can you please make python logical programming videos?
Thank you very much sir for ur wonderful explanation
You are most welcome
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.
most welcome
Excellent lecture
Thanks
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.
Hi sir the video is very useful and awesome.can we get data which ur using into the video for using queries.
I am just beginner and it was really helpful
Glad it was helpful!
Superb explanation Thank you so much sir👍
Welcome
Excellent lectures... 👏
thanks
Tq sir tq so much I really like ur way of explanations.. it is very clear and understanding
welcome
it's very helpful video to fresher.
thanks
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
www.pavantestingtools.com/p/sql-tutorials.html
Tq so much sir
Sir aapko bahut bahut pranam
thanks
Thank you sir . It was very helpful sir.
Most welcome
Will u please provide the important interview questions on this topic just like mcqs
Thank you so much
You're most welcome
awesome explanation sir!tomorrow i can perform well in my lab examination
Thanks
Thanks Pavan sir 21:00 sec
Welcome
this is we call the perfect explanation. Thank you so much sir.
You are most welcome
Tq so much sir really very awesome contributions to make vedio
Im appreciate
It's very to understand and lern
welcome
Thank you for the detailed explanation Sir
Welcome
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
yeah u are crct
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
This will make more sense and will be helpful if you can provide HR database link from where we can import. thanks
github.com/nomemory/hr-schema-mysql/find/master
SELECT * FROM EMPLOYEE WHERE SALARY
but some salary in > any is not correct as per my understanding could you please help me to to understand this one
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
SIR SUPER EXPLANATION,, IF YOU PROVIDE SAME DATA,, IT WILL BE BEST FOE US TO PRACTISE THE SAME..
very detailed explanation thank you
Welcome
thanks for the explanation video it's really useful
You are welcome
Sir my humble request please increase quality(360p)
Sir if we want to know the second high salary we can keep assending order and the result will come know sir
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 ??
Same doubt, think it's writing error
Sir, In multi row query any is giving all the department_id not just 30... I don't understand why??
@1:19:36,
Kindly provide comma(,) between FIRST_NAME and SALARY. Because at output SALARY has become as Alias name to FIRST_NAME column
Was searching for this comment.😀
Awesome explanation😄😃
Thanks
There is a typo in left outer join. Left join =inner join +any additional records in the left table. not the right table,
Yes correct, I was pitching my head looking at the wrong results😬
Excellent!
Many thanks!
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
"Ä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.
How can I purchase full courses from your channel please ?
at 1:21:46 why in rsult colum didnt mention first_name ,which was commended
sir, cam we please get the presentation if possible?
Thanks ,could you please tell what is the difference between MySQL ,SQL and Oracle.
MySQL and oracle are the RDMS were in sql is a query language used to create and maintain RDMS.
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
Sir can you please provide more examples means like different examples so that we can practice
sir can you please share link of Demo database hr link so we can practice on that
Table A having float as data type and Table B having varchar as a data type can we join these table?
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
why do we bother using self join, we can anyways just use where clause and get the work done?
someone :- Pavan how do you know joins soo clearly
Me :- i follow my man SDET 😛
Hi Sir, can i get these SQL queries with db test data?
How to find 6th maximum salary ?
Hi guys how to find the 3rd highest salary from employee table using joins.
How to find 7th max highest salary in Employee table ?
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
Sir I have a doubt .. can u please clear it out?
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
Sir where are the rest my sql videos ?
How I get all SQL videos ? Plz share a link of all videos
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
sir please provoid hr data .link sir
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
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
It's good
Thanks
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 ?
where do i get hr database
i need hr database sir
When we use only join command
can you plz provide the ppt
38:12
For 2nd max salary, select salary from employees order by salary desc limit 2,1;
Display the employees who all earning the highest salary here can we use this
SELECT * FROM EMPLOYEES WHERE SALARY=MAX(SALARY);
Hi Sir can you please add me in the google group please