@27:12 The reason why you were able to select a result set without error at first, but then second-time SQLServer threw error was, you highlighted the top select statement and executed it. :-) Good video though.
Thanks to this channel I was able to clear interview rounds of Visa and Sapiens (besides solving 200 problems on Leetcode as well lol), I now have an interview round at Commonwealth Bank of Australia the day after tomorrow, wishing it goes well too.
@@chandanikumari5332 I used to work in IT industry. I used to work as an Incident Handler. My job was not technical. I am now waiting for retirement. Now I am not working, so I started learning for fun and pass time. I was amazed by all the knowledge and aptitude shown by the different IT engineers. I am a matriculate. I have come to the conclusion that today on YOU TUBE you can find so many free courses and if you are determined and hard working, you can acquire a very handy skill set free and then get some sort of diploma. Having a diploma (this is for those of us, who did not go to the university) and real practical knowledge, you can get a job in the IT industry as a junior and then work your way up. All the best, work hard and be determined. You will succeed.
Angular, MVC core starting 16.07.20, Every Thursday at 9 PM. Syllabus explained in the video if needed the syllabus do email at questpond@questpond.com. If Interested share this video on your FB, Twitter, and Linkedin and avail today's training free. ruclips.net/video/MblRRqld1fg/видео.html
Case expression is the correct terminology. Pointing out if you are taking tests the terminology matters, they can try and trick you! Predicate, clause, statement, expression, search argument, try to make sure you understand the differences is my point.
hi bro did you find Practice SQL file then please provide me the link here...i think it was channel's strategy to attract and get personal details from viewers...
For Practice SQL example 2 anyone can help...? So far my query : select p.ProductName, sum(productcost) as TotalSales, count(t.Productid_fk) as [Count] from tblProduct p full outer join tblTotalSales t on p.ProductId= t.Productid_fk group by ProductName the problem is with totalsales for count 0 its showing ProductCost as I am taking sum of productcost how to solve this sir..please help me @Questpond
I'm getting this error: "Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\InvoiceDB.mdf" failed with the operating system error 3(The system cannot find the path specified.)."
Tqu.. So much sir.. Ur teaching skill ultimate and even also how can i say to thanks I feel very happy and even also ur explanation is very good.. Even single of doubts was b clear for all.. So tqu so much sir.. For ur previous time... I love it.. Ur explanation.. Thank 🌹🌹🌹 you Sir...
First I want to complement you with this video, it it clearly build up and takes the viewer through the steps in an ordered manner. I am using it to freshen up my SQL knowledge for a test coming up. Secondly I would like present you with an improvement for practice 23. The query you present is not compatible when products have the same cost. When two products share the same value nothing is returned. Using the 'SELECT TOP' statement make it so the query is not dependent on the hardcoded COUNT(*) statement. When using the code below you can play with the integer after SELECT DISTINCT TOP SELECT a.ProductName FROM tblProduct a WHERE a.ProductCost = (SELECT TOP 1 ProductCost FROM (SELECT DISTINCT TOP 3 b.ProductCost FROM tblProduct b ORDER BY b.ProductCost DESC) tblProduct ORDER BY ProductCost) I know their are obviously more ways to things nonetheless I wanted to point this out. I like you vids, keep up the good work
Thank you so much sir for this wonderful Sql tutorial. Your teaching is very clear and straight to the point. I also enrolled and practicing your msbi course. Thanks a lot for your dedication and hard work to teach us.
Hello Dear Instructor How can I get Your E-book Interview books? I have already shared the videos on face book that you give but still i can not Get your free practice interview files on thank You Sir
Thank you very much sir!!Its really really help full for us who r new learners for SQL and in future also please share ur knowledge videos with us thanks in advance and once again thanyou very much sir!!
Great stuff...there r many other ways of 2nd highest..like nested query or key words like top,limit,rownum or by rank...that should be also there in video other than correlation query.
i had try to my best. . .. . but i did not get it him. . . and also send it mail but this domain are not found it. . . . please help me how to get this share file . .
![SQL Course for Beginners [Full Course]](http://i.ytimg.com/vi/7S_tz1z_5bA/mqdefault.jpg)
SQL Step by Step - ruclips.net/video/uGlfP9o7kmY/видео.html
SQL Server Joins : ruclips.net/video/KTvYHEntvn8/видео.html
20+ SQL Server Interview Questions : ruclips.net/video/SEdAF8mSKS4/видео.html
Software Architecture Interview Questions : ruclips.net/video/AtTgcbLOqMM/видео.html
20 MSBI Interview Questions : ruclips.net/video/Nw_sHEKnOUE/видео.html
10+ Power BI Interview Questions : ruclips.net/video/Cozc9WNBRt4/видео.html
Angular Step by Step Tutorial for Beginners : ruclips.net/video/-9VcW7MBDs8/видео.html
25 Angular Interview Questions : ruclips.net/video/-jeoyDJDsSM/видео.html
35 Important JavaScript Interview Questions : ruclips.net/video/Zb4dPi7CANU/видео.html
30 Important C# Interview Questions : ruclips.net/video/BKynEBPqiIM/видео.html
25+ OOPS Interview Questions : ruclips.net/video/u99wAoBjDvQ/видео.html
25 Important ASP.NET Interview Questions : ruclips.net/video/pXmMdmJUC0g/видео.html
20 MySQL Interview Questions : ruclips.net/video/9hfjC-BpY20/видео.html
20 PHP Interview Questions : ruclips.net/video/1bpNSynUrl8/видео.html
5 MSBI Interview Questions : ruclips.net/video/5E815aXAwYQ/видео.html
TY SIR.
Sir can you share a video on Pattern matching in c sharp
sir where is the plsql i cannot find it
@27:12 The reason why you were able to select a result set without error at first, but then second-time SQLServer threw error was, you highlighted the top select statement and executed it. :-) Good video though.
lu li ada f
Thanks to this channel I was able to clear interview rounds of Visa and Sapiens (besides solving 200 problems on Leetcode as well lol), I now have an interview round at Commonwealth Bank of Australia the day after tomorrow, wishing it goes well too.
Thank you for sharing your success and best wishes for your next interview, nail it 👍👍
I am a beginner, excellent tutorial. Complete with great depth. Thank you very much
U not look like beginners
@@chandanikumari5332 I used to work in IT industry. I used to work as an Incident Handler. My job was not technical. I am now waiting for retirement. Now I am not working, so I started learning for fun and pass time. I was amazed by all the knowledge and aptitude shown by the different IT engineers. I am a matriculate. I have come to the conclusion that today on YOU TUBE you can find so many free courses and if you are determined and hard working, you can acquire a very handy skill set free and then get some sort of diploma. Having a diploma (this is for those of us, who did not go to the university) and real practical knowledge, you can get a job in the IT industry as a junior and then work your way up. All the best, work hard and be determined. You will succeed.
the best SQL video i have seen on youtube
thanks a lot
Angular, MVC core starting 16.07.20, Every Thursday at 9 PM. Syllabus explained in the video if needed the syllabus do email at questpond@questpond.com.
If Interested share this video on your FB, Twitter, and Linkedin and avail today's training free.
ruclips.net/video/MblRRqld1fg/видео.html
This is more helpful for beginner Thanks so much
YES INDEED.
Excellent course.. Learnt lot of things.. Thank you Questpond.
One the best tutorial I have ever seen thank you so much for your knowledge sir I really appreciate 👍👍👍👍👍
Excellent teaching style! Kudo to you, sir!
Very well explained. To the point!
Thank you !
Super teaching with good examples
Amazing tutorial, quite straight and great examples.
i guess it's quite randomly asking but do anybody know of a good site to stream newly released series online ?
Very useful video. Thank you so much!
Case expression is the correct terminology. Pointing out if you are taking tests the terminology matters, they can try and trick you! Predicate, clause, statement, expression, search argument, try to make sure you understand the differences is my point.
Thank you so much sir. 🥰
thanks for the video. where can i find the dataset for practice these queries
Thanks for the video. Please i am not able to get the practice sql database. Can some one help me?
I am unable to find the PracticeSql file, please provide a link
hi bro did you find Practice SQL file then please provide me the link here...i think it was channel's strategy to attract and get personal details from viewers...
quality of training very neat nd clear.... excellent
Good explanation the only thing that is annoying is those red underlines errors. I wished he had removed those errors.
I AGREE.
Any video for microservices?
Best tutorial for Beginners
Really helpful🙌🏻,!!!
Thanks for sharing this, greetings from Mexico.
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
Please can you share such lab for oracle database students as well
Where first u create all schema and tables and then we test these scenarios 1 by 1
Thank you so much sir...its really useful
For Practice SQL example 2 anyone can help...?
So far my query :
select p.ProductName, sum(productcost) as TotalSales, count(t.Productid_fk) as [Count]
from tblProduct p
full outer join
tblTotalSales t
on p.ProductId= t.Productid_fk
group by ProductName
the problem is with totalsales for count 0 its showing ProductCost as I am taking sum of productcost how to solve this sir..please help me @Questpond
I couldn't find the link, pls share
very good session sir....thank you
Plz help for How to get this all database tables sqlpractice , this can't saw in website.
Can someone help from where can we download the sql file ?
I'm getting this error: "Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\InvoiceDB.mdf" failed with the operating system error 3(The system cannot find the path specified.)."
Excellent course. really learned a lot. Thank you very much
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
Tqu..
So much sir..
Ur teaching skill ultimate and even also how can i say to thanks I feel very happy and even also ur explanation is very good.. Even single of doubts was b clear for all.. So tqu so much sir.. For ur previous time... I love it.. Ur explanation..
Thank 🌹🌹🌹 you Sir...
First I want to complement you with this video, it it clearly build up and takes the viewer through the steps in an ordered manner. I am using it to freshen up my SQL knowledge for a test coming up.
Secondly I would like present you with an improvement for practice 23. The query you present is not compatible when products have the same cost. When two products share the same value nothing is returned.
Using the 'SELECT TOP' statement make it so the query is not dependent on the hardcoded COUNT(*) statement.
When using the code below you can play with the integer after SELECT DISTINCT TOP
SELECT a.ProductName FROM tblProduct a
WHERE a.ProductCost =
(SELECT TOP 1 ProductCost FROM
(SELECT DISTINCT TOP 3 b.ProductCost
FROM tblProduct b
ORDER BY b.ProductCost DESC)
tblProduct
ORDER BY ProductCost)
I know their are obviously more ways to things nonetheless I wanted to point this out. I like you vids, keep up the good work
amazing!
How to save 3d matrix in database?
Kindly share PracticeSql , unable to find
Sounds good, kinda excited to learn this!
practise.sql is missing
Very clear and precise explanation.thanku
Query Design Editor Only Show CrOSS JOIN on every table why Not Others Join?
i had an exam tomorrow! thanks alot!!!
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
i really thank you verrrrrrryyyyyyyyy much from the bottom of my heart u gave me a clear understanding about the concept of all the video u did
thanks you. it is completed teaching and lab.
Your course is easy to understand and structured well. Thanks!
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
It is awesome but please i can't get that t1, t2 in self join and correlated querry .
That is why this t1 and t2??
Thanks , video clears my concepts.
It's alias name of customer table there is two alias name for same table bcoz it's self join
Excellent work.
Super duper teaching with good examples ....
Very very useful sir :-)
Thank u so much :-)
Amazing, Thank you very much.
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
Sir, which IDE u r using?..Please reaply..
Thank you so much sir for this wonderful Sql tutorial. Your teaching is very clear and straight to the point. I also enrolled and practicing your msbi course. Thanks a lot for your dedication and hard work to teach us.
hello sir could you provide me the sql sheet?
shubu watch this as many times as you can
I COULDNT AGREE LESS.
Thank you! Merci! Obrigada!
Thank you
Thnx sir for this video 👍👍
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
A lot of thanks sir... Now I am able to work on SQL.
can u plz upload the database that u have created so that we can refer your DB ?
Did u got that one
Where I will get the practice db sql
Send us an email for the same.
Thank you so much sir... Pls keep on ur service..
Good questions
Very helpful. Thanks
Can anyone share the example file(InvoiceDB) here?
this is awesome!
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
Superb video tutorial
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
Good explanation
does anyone has the link to download the file to create the database for practicing?
I cant get it too
Good explanation Sir 👏
well done go ahead sir
Hello Dear Instructor How can I get Your E-book Interview books? I have already shared the videos on face book that you give but still i can not Get your free practice interview files on
thank You Sir
Hi where I can find the practice.sql file?
Kindly share database creation queries
Hello Meenakshi you can send email to get the same.
Where do i get the practiceSQl file ?
send email at questpond@questpond.com
sir where is practice file
I really thank you very much. . . . i need one help how to get the share file . . .
i had try but i did not get him. . . .please me. . .
Time saving one ! ..thanks :-)
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
Thanku amazing
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
Thank you very much sir!!Its really really help full for us who r new learners for SQL and in future also please share ur knowledge videos with us thanks in advance and once again thanyou very much sir!!
Great stuff...there r many other ways of 2nd highest..like nested query or key words like top,limit,rownum or by rank...that should be also there in video other than correlation query.
Thanks you so much very useful video
Can anybody say who to write aa query to display of those students who joined on the same date
You have to select date
Thank you it helped a lot
Anyone with the link for the file?
Send email at questpond@questpond.com to get the practice file.
Good tutorial. Thanks.
Sir telugu lo kuda chepadaniki try cheyandi sir please
sir hindi me bhi btane ki kripa kren👍👍👍
Your display screen is so tiny
Awesome
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
@@questpondvideos You teach the best.
Could please share that file
Anyone know where i can get hold of the database?
SQL install ni ho raha kya karu?
Whats the error
Any body here can pls let me know if learning from this video is enough for software testers for interview purpose?
IT SURE IS.
@@shravansrinivasan4982 okay, Thanks.
THANK YOU SIR,
FOR TEACHINING. :-)
GOOD UNDERSDENDING THIS VIDEO CONCEPT FOR SQL,
i had try to my best. . .. . but i did not get it him. . . and also send it mail but this domain are not found it. . . . please help me how to get this share file . .
please try to send to questpond@questpond.com
Waleikoum Salaam brother
34:00
Spending 1hr worthy of reading 4hrs about basic and some complex queries which can build up on...
I think I'm going to watch that video that teaches me brain surgery in an hour
I didn't get that what u told to use