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.
'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
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
@@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
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
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
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
@@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.
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 :)
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.
There are many channel on TH-cam and they provide content free but no one can compare with you,
Your content is really really helpful
Thanks
you are certainly the best tutor i have seen on youtube.
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.
Very useful knowledge for using SQL operaters.,👍
Thanks
you are second to none🏆🏆🏆🏆
I love Your way of teaching Sir
You are a excellent teacher. Thank you so much 🙏🙏
most welcome
Good content !!
Can you please provide ppt doc that you were used for explanation ?
Very neat & clear explanation, it was very helpful for me.
Thank you, sir.
Keep sharing the knowledge.
Always welcome
Hello sir, You talked about sharing a PDF link to download HR database in previous video, can you please guide us on that?
Fantastic presentation. Simple, detailed and clear
Thanks
@@sdetpavan CAN U PLEASE GUID US FOR DOWNLODING HR DATA BASE
Awesome explanation Sir thank you very much!
Most welcome!
sir its very very easy and understanding your session the way you explained ...really super sir ...
Thanks
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.
really its an awesome explanation
Glad you liked it
'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
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
we too
It will be easy for practice if you give access of the hr data base
Awesome tutorial sir
Glad you liked it
Excellent teaching.
Glad it was helpful!
The lecture is very helpful , can you share the slides too
Big thank you for sharing
You are so welcome!
great explanation thanks more sir.
You are welcome
You are truly awesome.. Learnt a lot from you..
Thank you.
@@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
i want this database if you have please provide me
@@sdetpavan Sir can i have this DB please?
that is WILD CARD sir you mentioned that whiled card... just a minor mistake
Awesome and easy explanation. Thank you so much!!
most welcome
Good explanation sir tq very much
Welcome
sir from WHERE we can download that hr database
Thank you so much sir
Sir ...
Suppose I have one column holding one or two in it...
is BETWEEN opp. Works on that particular column?
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.
In logical operator topic.,
Fr the text put in single quote. Actually before u say double quotes right. No prblm wat it is?
From where I can fetch the data that you are using?
WHEN U USE (SELECT DISTINCT *FROM EMPLOYEES) @14:55 , JOB ID , SALARY, COMMISSION, ID ALL ARE NOT DISTINCTED. WILL U EXPLAIN Y?
It selects the distinct combination of fields. Even if one field has different values, while the rest have same , it will be selected
Can you guide me how to get hr database
Sir can you plz share PPT . Which are you using in this video
where can we find this powerpoint pptx file, thanks for teaching!
sir how your added hr database in workbench
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.
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
Sir, Can you pls provide the link to download the PPT
Excellent!
Thanks
Thank you soo much
Most welcome!
Hi sir,
How to get the hr table you said you will share one link to download that hr table.
sir, is all these operators can be able to use in any type of database(oracle SQL, ms SQL,etc.,) or only for MySQL ???
Hi sir,
can you please guide how to download hr database
Sir,how can we get the hr schema?
How can I reach hr data tables?
Did you got hr table
How to find hr databse. It is not available in the mentioned url by tutor
How to get this data base
So that we can practice
Is thare any site from where we can get database for practice
Can you turn on the subtitles? because I am Vietnamese.
Where to get notes sir?
Hello @
SDET - QA Automation Techie Sir HR database link is pointing to Blogger's Signup page.
where is the hr file? for practice where it is attached
Where i can get hr database pdf please help me out to get this
Sir can u plss help me in my system only sys data base was available then what can i do😢
trying to practice but cant as i cant find hr database. Please help with link to download hr database
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
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.
Hi Sir, i want to query records where name=' ' those records are not accessible by using soql query. Is it possible
How can we have the hr database
Sir, how to download the SQL file
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
Actually % means zero, one or many characters
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
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 .
Sir where i can find your HR database ?? How to include HR database in MYSQL
i am also facing the same problem , @
SDET - QA Automation Techie PLEASE help sir
HI sir..Can you please guide me how to download hr database
hello sir from wer i will get HR database file
Sir! Why didn't you include REGEXP in the tutorial?
Hello sir, could you please provide HR database link? Thanks
Sir it is awesome session can you please provide the data set used by you
WHERE HR dataset;
Hi Sir , please provide HR Database , the given link is pointing to Blogger's signup page.
Did you get the HR database link? if yes could you please provide me the link. ? Thanks
sir please tell how to import hr database please,pavan sir
Kindly provide me this SQL file for pratice purposes
How to import file
Plz share the HR database file @SDET-QA SIR
Link of PPT
hello sir, i see your content is very good but attaching the pdfs can really help many people.
www.pavantestingtools.com/p/sql-tutorials.html
@@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.
@@sdetpavan Thank you soo much sir for providing the link of Notes.
looking for sql file for HR database to import the database into my client.
You can get it here: www.pavantestingtools.com/p/sql-tutorials.html
@@sdetpavan not available here
not available here @@sdetpavan
Hi Sir, can you upload Employee database file for practice live..
how to get HR database
Please suggest a source.
please hr.sql file so that we can practice.
Hello sir ,pls share the hr database
i want mysql ppt
Sir could you pls provide us HR database for practice??
Pls pls reply I really need it
Sir me too please tell me sir how to get hr schema 🙏
You can get it here: www.pavantestingtools.com/p/sql-tutorials.html
@@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.
@@YogeshKumar-os3pl yes facing the same issue
@@sdetpavan Sir could you please guide us how to download HR DATABASE ......
can you please give me hr database import file?
Sir please provide hr database
Sir please send me a PDF
Sample file sir
Hr database
maybe this link will help you guys to get data of hr database and employee's table.
Sir please send me pdf file
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 :)
I want bro
yes if possible
I want.
Could you please send the notes to me too please.
I need it
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.
What about 17:20
SET SQL_SAFE_UODATES=0;
Yuh cant update or delect the record without key
please explain %m%. ;
Salary is very low😂😂😂
This video is useless if you cannot provide the gr table to viewers
You are truly awesome.. Learnt a lot from you..
Thanks
Thank you so much
You're most welcome
How can i reach hr table??