SQL Tutorial 4: Filtering Rows(Where Clause), Operators & Pattern Matching

Topics
-----------
1) Where (Filtering records based on conditions)
2) DISTINCT ( Displays unique records from a table)
3) and, or ,not
4) between , not between
5) Pattern matching(wild card characters)
#########################
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...
####################################
KZbin 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
#SQLTutorial
#SQLBasics
#FilteringRows
#WhereClause
#SQLOperators
#PatternMatching
#SQLQueries
#DatabaseTutorial
#SQLFilter
#SQLSelection
#SQLLogic
#DataFiltering
#QueryLanguage
#DatabaseSkills
#SQLPatterns
#ConditionalStatements
#SQLMastery
#SQLForBeginners
#DatabaseManagement
#LearnSQL
#SQLTips
#SQLTricks
#QueryOptimization
#DataManipulation
#SQLExamples
#DatabaseQuery
#SQLSyntax
#PatternMatchingInSQL
#FilteringData
#SQLOperatorsGuide
#AdvancedSQL
#SQLTraining
#SQLDatabase
#SQLSkills
#SQLSyntaxGuide
#WhereClauseExplained
#SQLCoding
#DatabaseFiltering
#SQLPatternsExplained
#QueryOptimizationTips
#SQLPatternsTutorial
#SQLExpertise
#DatabaseOperators
#SQLCodingSkills
#QueryPatterns
#SQLPatternMatching
#SQLLogicalOperators
#FilteringWithSQL
#SQLPatternsExamples
#SQLPatternsExploration

[@amandubey6512]

There are many channel on KZbin and they provide content free but no one can compare with you, Your content is really really helpful

[@sdetpavan]

Thanks

[@GiftAkoto]

you are certainly the best tutor i have seen on youtube.

[@nageshwarrao8629]

A true and correct way of teaching, rest videos confuses viewers, just to gain likes. By your lectures i am Learning easily and quickly no rush simple and politely explaining sir.

[@hemlatabisht3771]

I love Your way of teaching Sir You are a excellent teacher. Thank you so much 🙏🙏

[@sdetpavan]

most welcome

[@Addistoday]

you are second to none🏆🏆🏆🏆

[@basanagoudabiradar8669]

Very useful knowledge for using SQL operaters.,👍

[@sdetpavan]

Thanks

[@samarthkulkarni4912]

Very neat & clear explanation, it was very helpful for me. Thank you, sir. Keep sharing the knowledge.

[@sdetpavan]

Always welcome

[@manoshm1]

sir its very very easy and understanding your session the way you explained ...really super sir ...

[@sdetpavan]

Thanks

[@ketankhapekar70]

Big thank you for sharing

[@sdetpavan]

You are so welcome!

[@manjeetchoudhary8064]

Hello sir, You talked about sharing a PDF link to download HR database in previous video, can you please guide us on that?

[@sharanyaramani3494]

Awesome explanation Sir thank you very much!

[@sdetpavan]

Most welcome!

[@mohsinhasanmerchant6242]

You are truly awesome.. Learnt a lot from you..

[@sdetpavan]

Thanks

[@ravigoni]

Good content !! Can you please provide ppt doc that you were used for explanation ?

[@BhargaviGolla-dw1kn]

really its an awesome explanation

[@sdetpavan]

Glad you liked it

[@ragavendranrko5941]

that is WILD CARD sir you mentioned that whiled card... just a minor mistake

[@yasmeenhasan9925]

Awesome and easy explanation. Thank you so much!!

[@sdetpavan]

most welcome

[@nileshade75]

'is' is operator feching for record value "null" since it's not real value we unexpect in any requirement so , SQL lang considered that situation and to handle that provided special operator called -is

[@nanduuday7509]

Thank you so much sir

[@Eng-Mohamed-Ahmed]

great explanation thanks more sir.

[@sdetpavan]

You are welcome

[@pandikuntamaidhili]

Excellent teaching.

[@sdetpavan]

Glad it was helpful!

[@subhamsikdar6263]

Fantastic presentation. Simple, detailed and clear

[@sdetpavan]

Thanks

[@GameswithDadu3021]

@@sdetpavan CAN U PLEASE GUID US FOR DOWNLODING HR DATA BASE

[@meerambimohammed7048]

Awesome tutorial sir

[@sdetpavan]

Glad you liked it

[@romanyakymets738]

Thank you so much

[@sdetpavan]

You're most welcome

[@muhammadjunaidmajeed1211]

Excellent!

[@sdetpavan]

Thanks

[@mvenkatesh3602]

Good explanation sir tq very much

[@sdetpavan]

Welcome

[@saranyachandrabos3541]

Thank you soo much

[@sdetpavan]

Most welcome!

[@atanupaul8803]

Sir, can you please let us know how to get the HR databse that you are mostly using for the explanations. Along with me many others are asking for this information. Please help us out Sir. Thank You

[@satishkumarkunchanapalli9225]

we too

[@shriwagdare3737]

It will be easy for practice if you give access of the hr data base

[@priyankapundir9449]

Hi Sir, Your videos are very helpful. Could you suggest where i can import the HR database which you are using. I will also execute query.

[@AdityaYadav-ov6mi]

The lecture is very helpful , can you share the slides too

[@kalaimahesh2387]

Hi Pavan, If possible can you please share the hr database for the MySQL training video queries to run? I sent the email to you as well. Thanks in advance

[@GameswithDadu3021]

sir from WHERE we can download that hr database

[@malikachoudhry8333]

From where I can fetch the data that you are using?

[@Nancy-kp4vb]

How can I reach hr data tables?

[@subhajitchakraborty8724]

Sir ... Suppose I have one column holding one or two in it... is BETWEEN opp. Works on that particular column?

[@TeluguNethra]

In logical operator topic., Fr the text put in single quote. Actually before u say double quotes right. No prblm wat it is?

[@umairunc7053]

sir how your added hr database in workbench

[@harshitraj8132]

Directly search on Google for the HR table SQL query and check the git repository link and then paste or import the same query in the MySQL workbench.

[@ravitejaalapati3536]

Sir, Can you pls provide the link to download the PPT

[@gauravingale1013]

Hello @ SDET - QA Automation Techie Sir HR database link is pointing to Blogger's Signup page.

[@vamsikrishna9558]

sir, is all these operators can be able to use in any type of database(oracle SQL, ms SQL,etc.,) or only for MySQL ???

[@akashsontake1440]

How to find hr databse. It is not available in the mentioned url by tutor

[@mabbusk653]

Sir can u plss help me in my system only sys data base was available then what can i do😢

[@vijaydehade7790]

Sir can you plz share PPT . Which are you using in this video

[@123afgh]

Hello, Sir, thank you for providing useful courses, there is no one making exciting like you the entire lectures, Sir, how to get the note please.

[@mohammedamaanhashmi6867]

Hi sir, can you please guide how to download hr database

[@user-jo4lv9sp8r]

where is the hr file? for practice where it is attached

[@vishalb6427]

Hi sir, How to get the hr table you said you will share one link to download that hr table.

[@Vjnanni25]

Where i can get hr database pdf please help me out to get this

[@shrinivas1086]

WHEN U USE (SELECT DISTINCT *FROM EMPLOYEES) @14:55 , JOB ID , SALARY, COMMISSION, ID ALL ARE NOT DISTINCTED. WILL U EXPLAIN Y?

[@badsanta7356]

It selects the distinct combination of fields. Even if one field has different values, while the rest have same , it will be selected

[@PenumutchuKanvitha]

Can you guide me how to get hr database

[@payalpatel-ft1df]

How to get this data base So that we can practice Is thare any site from where we can get database for practice

[@UCIUbaf3b8lN7Q5GA8qO]

where can we find this powerpoint pptx file, thanks for teaching!

[@RaviShankar-ih9zh]

Hi Sir, i want to query records where name=' ' those records are not accessible by using soql query. Is it possible

[@user-cq5gp4sq3e]

Can you turn on the subtitles? because I am Vietnamese.

[@milindamilkanthwar5548]

trying to practice but cant as i cant find hr database. Please help with link to download hr database

[@subhashinichittemreddy8845]

Sir in this select distinct * from employee;u said it gives all the unique data from the table give it right. But in output it shows the department id has repeated values not unique. Why it will come like this

[@viveksikarwar7462]

If the department IDs appear to be repeated in the results, it's because those rows are considered unique when looking at all columns combined.

[@Keerthi0323]

Sir,how can we get the hr schema?

[@edilmonica386]

Where to get notes sir?

[@pujasaha5452]

How can we have the hr database

[@tareqsqatech1222]

Hello sir, could you please provide HR database link? Thanks

[@shubhangiramteke579]

hello sir from wer i will get HR database file

[@labbdogg2929]

Sir! Why didn't you include REGEXP in the tutorial?

[@sadaffathima7761]

Hi Sir , please provide HR Database , the given link is pointing to Blogger's signup page.

[@tareqsqatech1222]

Did you get the HR database link? if yes could you please provide me the link. ? Thanks

[@user-st3xg5xl2q]

Plz share the HR database file @SDET-QA SIR

[@user-dd8xm8hk9f]

WHERE HR dataset;

[@saitejayellamanchili2269]

how to get HR database Please suggest a source. please hr.sql file so that we can practice.

[@trivenipatil9699]

Sir it is awesome session can you please provide the data set used by you

[@ashwinkumarac2095]

sir please tell how to import hr database please,pavan sir

[@nagarajrao9664]

hello sir, i see your content is very good but attaching the pdfs can really help many people.

[@sdetpavan]

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

[@satyaprasadbokka272]

​@@sdetpavan Hi Sir, Your classes are very good, and could you please share the HR Schema file so, It is very useful for our practise.

[@user-fb3yh7xj2n]

@@sdetpavan Thank you soo much sir for providing the link of Notes.

[@prakashpotdar6861]

How to import file

[@jadhavajay15]

Sample file sir Hr database

[@saimahesh5545]

Sir, I have a doubt...In pattern Matching u told for %m% means m should come in the middle of the word but i can see m in the starting and also in ending..could you tell sir again how it takes

[@Rohit-kj9kr]

Actually % means zero, one or many characters

[@madhavi.penumatsa]

all words matching with 'm' will display do you know how to get hr scheme or any schemes plz explain how to get its help for us

[@mohitbudgaya5537]

we use % for many numbers of charters and here we are using % in the starting or ending so easily it can be come in the start or end .

[@AMITSINGH-nd2fy]

Hi Sir, can you upload Employee database file for practice live..

[@shavezalam9086]

Kindly provide me this SQL file for pratice purposes

[@Abhisek0595]

Thank you for explaining it so well. One of the best tutorials I have been through sir. And GUYS, IF ANYONE WANTS TO HAVE A PRESENTATION OF THE NOTES, LET ME KNOW. I WILL HELP YOU GUYS WITH IT :)

[@karripraveen4564]

I want bro

[@yousefmonceur3472]

yes if possible

[@Jobs670]

I want.

[@Praj123able]

Could you please send the notes to me too please.

[@priyapatel7605]

I need it

[@harishchittari9498]

Sir please send me a PDF

[@harishchittari9498]

Sir please send me pdf file

[@SHUBHAMTRIPATHI-vg5lq]

maybe this link will help you guys to get data of hr database and employee's table.

[@jovenmoreno7258]

Sir where i can find your HR database ?? How to include HR database in MYSQL

[@ukstravelenthusiast6355]

i am also facing the same problem , @ SDET - QA Automation Techie PLEASE help sir

[@PenumutchuKanvitha]

HI sir..Can you please guide me how to download hr database

[@meghashreebhat7596]

can you please give me hr database import file?

[@sharanabasappapadashetty9940]

Hello sir ,pls share the hr database

[@bilalsyed6428]

looking for sql file for HR database to import the database into my client.

[@sdetpavan]

You can get it here: www.pavantestingtools.com/p/sql-tutorials.html

[@hafizaaminakarmani6826]

@@sdetpavan not available here

[@SHUBHAMTRIPATHI-vg5lq]

not available here @@sdetpavan

[@balajikottawar1990]

i want mysql ppt

[@surajkamble3538]

Sir please provide hr database

[@sourabhagrawal200sa]

What is the use of going through the entire tutorial when the HR DB is itself not available for practice. Request the creator to provide the links for the resources used. Same behavior has been observed on other videos of this channel. The resources used are itself not available.

[@ankursarkar4976]

please explain %m%. ;

[@artipatel6809]

Sir could you pls provide us HR database for practice?? Pls pls reply I really need it

[@shivarajkenganur5372]

Sir me too please tell me sir how to get hr schema 🙏

[@sdetpavan]

You can get it here: www.pavantestingtools.com/p/sql-tutorials.html

[@YogeshKumar-os3pl]

@@sdetpavan Sorry to inform HR Database is pointing to www.blogger.com/u/1/blog/page/edit/196205546010114473/410613303576536234 So not able to download. Please help.

[@ukstravelenthusiast6355]

@@YogeshKumar-os3pl yes facing the same issue

[@ratnalatriveni3614]

@@sdetpavan Sir could you please guide us how to download HR DATABASE ......

[@swagatikapanigrahi6855]

What about 17:20 SET SQL_SAFE_UODATES=0;

[@rakesht8162]

Yuh cant update or delect the record without key

[@swapnajit92]

You are truly awesome.. Learnt a lot from you..

[@sdetpavan]

Thank you.

[@John12685]

@@sdetpavan Sir content is awsumly explained but u have used HR database. How can we practice those queries i don't have that huge employee table. Bcz u have created it somewhere ago

[@ravigadekar3801]

i want this database if you have please provide me

[@John12685]

@@sdetpavan Sir can i have this DB please?

[@abhishekkumarsingh611]

Sir, how to download the SQL file