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

Selenium with Java+Cucumber
********************************

Selenium with Python & PyTest
********************************

Selenium with python using Robot framework
****************************************

API Testing(Postman, RestAssured & SoapUI)
*****************************************

Web & API Automation using Cypress with Javascript
********************************************

Playwright with Javascript
**************************

Jmeter-Performance Testing
************************

SDET Essencials(Full Stack QA)
*************************

Appium-Mobile Automation Testing
************************************

Java Collections
*****************

Python Programming
*********************

Cucumber BDD Framework
***************************

Protractor with Javascript
***************************

####################################
Youtube Playlists:
####################################

Manual Testing & Agile
***********************

SQL
*************************

linux & Shell Scripting
**********************

Java
**********************

Selenium With Java+Cucumber
********************************

Python
********************************

Selenium With Python,Pytest&Behave
***************************************

Selenium With Python Using Robert Framework
(Web&API Testing)
*************************************************

API Testing (Postman,SoapUi,&Rest Assured)
**********************************************

Mobile App Testing Appium
****************************

Performance Testing Jmeter
*******************************

Maven,Jenkins,Git,Github,CI/CD
*******************************

SQL,DB Testing&ETL,Bigdata
*******************************

JavaScript Based Automation Tools
********************************

Selector Hub Tools
********************

GraphQL
******************

Cypress API Testing
********************

Cypress Web Testing
**********************

Playwright with Javascipt
**************************

#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

[amandubey]

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

[nageshwarrao]

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.

[GiftAkoto]

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

[basanagoudabiradar]

Very useful knowledge for using SQL operaters., 👍

[shrinivas]

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

[manjeetchoudhary]

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

[priyankapundir]

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.

[atanupaul]

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

[hemlatabisht]

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

[nileshade]

'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

[ravigoni]

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

[samarthkulkarni]

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

[subhajitchakraborty]

Sir ...
Suppose I have one column holding one or two <null> 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?

[mabbusk]

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

[ragavendranrko]

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

[GameswithDadu]

sir from WHERE we can download that hr database

[vishalb]

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

[akashsontake]

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

[kalaimahesh]

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