Please change the answer of 4th question(Find the 3rd to 6th character of a column). It should be "SELECT SUBSTR(credit_card_no,3,3) FROM credit_card_detals;" as it is asking till 6th character not the 6 character in substring.
the last question can also be simplified if we run a windows function sort it by date and partition it by wifi id and then take the avg as such select avg(wifi_speed) over(partition by wifi_id order by dt rows between 2 preceding and current row), wifi_id ,dt from table_name group by 2,3 order by 3 desc
I had forgotten I had been watching this video at 1.75x and I was terrified the way and the speed Satyajit had been answering, it made me feel like a noob 😢
@Krish How do you predict that what we want to learn? yesterday I was searching some best SQL resources for my upcoming interview. And today you are going to upload SQL Q&A video. I think you are better visionary.
Just as Rohit said, @Krish is one of the few great tutors that understands what you need and how u need it. Most people who post content dont know how to communicate with their students but he does.
krish please create a intermediate sql playlist as to be honest even one one query not used , I mean covering all basics initial 1-2 you can make it all in 10 vedios also giving atleast glimpse stored procedurs execution 10 queries one shot , some common comolez queries asked interviews as world again movs sql approach hive etc, we will be really grateful bro one concept interview q or application of that comcept same query and also complex one as it will just combine few simple tasks like asked VISA etc as per above vedio. sql is asked in almost all interviews
Krish, this videos is fastforwading with 16x, like rapid fire round. It would have been good if he had taken some time to explain slowly and clearly. Albeit, appreciate the effort.
Hi Krish, I just subscribed now and started to watch the videos and its just wow. Can you please help with the Statistics and ML end to end videos or any link
Hi, i want to do a certification in data science with job.. there are upgrad IIITB pg for data science, certificate from XLRI Xavier's, PG for DS and BA from great lakes, from Jigsaw academy... Can you please put some light on the importance of these certifications.
Certificates are of no use, total waste of money/time, rather than collecting certificates gain knowledge, upskill yourself, do some projects and start applying for jobs.
Hello Sir, The video was great. But, I have a doubt in the last Facebook question where the date column comes in. What if I write the query like this: SELECT AVG(wifi_speed), wifi_id, date FROM wifi_details GROUP BY wifi_id ORDER BY date DESC LIMIT 2; Is my query wrong?
Please change the answer of 4th question(Find the 3rd to 6th character of a column). It should be "SELECT SUBSTR(credit_card_no,3,3) FROM credit_card_detals;" as it is asking till 6th character not the 6 character in substring.
the last question can also be simplified if we run a windows function sort it by date and partition it by wifi id and then take the avg as such
select avg(wifi_speed) over(partition by wifi_id order by dt rows between 2 preceding and current row), wifi_id ,dt from table_name
group by 2,3 order by 3 desc
What is by dt row?
Worthy 30 mins session...
Thanks bro ... Keep posting such videos
Interview starts at 9:30, theory discussion until 9:30
I love videos like this. Very helpful! Hope you can make more SQL vids and maybe even one for Excel skills assessment for Data Analytics. :)
Pls make extra videos on sql in your playlist.
3rd question we will do like this
Select stuff(emp_name, 5,4,'*') from employees
Question No.2 . Can we use the SUBSTR function? SUBSTR(COlumn name, starting postion, length of characters)
Thank you sir... ❤️
He is a gem
Thank you sir❤️
I had forgotten I had been watching this video at 1.75x and I was terrified the way and the speed Satyajit had been answering, it made me feel like a noob 😢
@Krish How do you predict that what we want to learn? yesterday I was searching some best SQL resources for my upcoming interview. And today you are going to upload SQL Q&A video. I think you are better visionary.
He has seen all the ups and downs of this journey, and that makes him connect with us at a much closer level
Krish is magician.
Just as Rohit said, @Krish is one of the few great tutors that understands what you need and how u need it. Most people who post content dont know how to communicate with their students but he does.
krish please create a intermediate sql playlist as to be honest even one one query not used , I mean covering all basics initial 1-2 you can make it all in 10 vedios also giving atleast glimpse stored procedurs execution 10 queries one shot , some common comolez queries asked interviews as world again movs sql approach hive etc, we will be really grateful bro one concept interview q or application of that comcept same query and also complex one as it will just combine few simple tasks like asked VISA etc as per above vedio. sql is asked in almost all interviews
Bhai kehna kya chahte ho?
@@xylyx_ bhai krish bhai request ki hai wo ek sql ki playlst dal de , wapis s jese ye snowflake aaya to sql spark baki chiz kaam ho jata
Krish, this videos is fastforwading with 16x, like rapid fire round. It would have been good if he had taken some time to explain slowly and clearly. Albeit, appreciate the effort.
Hi Krish, I just subscribed now and started to watch the videos and its just wow.
Can you please help with the Statistics and ML end to end videos
or any link
Thank you
Hello sir 5no question may RAMESH SAHOO kiun nehi ayega
Hi Krish, could you please ..make a playlist for all transfer learning techniques in deep learning
cross join diagram in Join introduction slide is incorrect.
Though very good video.
very good teaching..your videos motivates me.. ❤️
Am I the only one seeing this:
For wifi Id=1 we have 120+111+89 = 320 , 320/3=106.(6) and this is NOT equal to 110.
In which case which type of join is use??
Hi, i want to do a certification in data science with job.. there are upgrad IIITB pg for data science, certificate from XLRI Xavier's, PG for DS and BA from great lakes, from Jigsaw academy... Can you please put some light on the importance of these certifications.
Certificates are of no use, total waste of money/time, rather than collecting certificates gain knowledge, upskill yourself, do some projects and start applying for jobs.
Where is sql script to practice along
will there be SQL questions or some theoretical questions
bhai isse aati hi nahi sql, khn s utha late ho
Cant see the screen properly..
Hi please let me know if there is a possibility of having 1:1 session with you
Hello Sir, The video was great. But, I have a doubt in the last Facebook question where the date column comes in. What if I write the query like this:
SELECT AVG(wifi_speed), wifi_id, date FROM wifi_details
GROUP BY wifi_id
ORDER BY date DESC LIMIT 2;
Is my query wrong?
group by dt not by wifi_id maybe
the mentor is bengali
Who is teacher in the video???
Sir video is not clear