You don't need mic Ankit. The content is anyways top notch to keep us waiting for the videos and watch them , ending up learning something new and important to impress the interviewers 😅
Brilliant video! So clear. I struggled to grasp these concepts with both my uni lectures and the prescribed textbook. Will definitely be returning for more of your content.
This is beautiful Ankit! Thank you for sharing! I have request, could you please make a video on how to find a grain in any given fact table? Specially sometimes when we are not equipped with business knowledge, how do we find the grain in an unknown fact table? It will be very valuable. Thanks in advance!
quick Q),what type of syntax that you used in 2:37 (select null country,null city etc..) This is the first time i saw a syntax like this .Can you please further explain on this.
Is sound quality better? I am using a mic for the first time :)
Yes, we could also hear mixer in background
Perfect it is
Yes perfect
Crystal clear. 😉
You don't need mic Ankit. The content is anyways top notch to keep us waiting for the videos and watch them , ending up learning something new and important to impress the interviewers 😅
Your explaination is the best I seen till date from schooling to now, best teacher ever Sir hatsoff
Great explanation Ankit!
I swear nobody in this TH-cam platform can explain like you did....your TH-cam channel made me kind of pro in SQL.
Your way of explanation is next level Bro
Thank you so much
You are most welcome
Best one. These concepts are there in Snowflake. finally, these topics are clear to me. .
The way you are explaining step by step is Amazing.
Glad to hear it!
00:00 - Rollup
05:30 - Cube
07:16 - Grouping Sets
Brilliant video! So clear. I struggled to grasp these concepts with both my uni lectures and the prescribed textbook. Will definitely be returning for more of your content.
Glad it was helpful!
Ankit these are the contents i have ben waiting for , this is top notch , need more content on advance SQL and data engineering
this is exactly what I was looking for! great explanation. Thank you :)
Great to hear!
Such an excellent video Ankit! Keep up the great work!
Exactly what I needed to prepare for my test. Great job.
Best of luck!
Superb explanation
So beautifully explained. Thanks a lot.
You are most welcome
Really brilliant all key points where addressed
As usual great content. One should only learn what you do, and One will be as great as you are
Thanks for such beautiful videos. Always grateful to you
My pleasure 😊
Yup it clear all my concepts regarding roll up
nice really helpful
Thanks sir for teaching this kind of concepts 🎉
Really great
Voices is best 👌
very good explanation.. keep posting an amazing content 👌👌🎉🎉
Thanks a lot 😊
Brilliant 👍
Amazing ❤
thanks for this scenario 😊
Clear explanation
clear explanatation
Awesome content!
Hi Ankit, thx for posting these videos, your content is great. Can you plz make videos on advanced concepts like materialized views and indexing?
Yes, sure
Yes it is better
Bohot mast
Thank you 😊
This is beautiful Ankit! Thank you for sharing! I have request, could you please make a video on how to find a grain in any given fact table? Specially sometimes when we are not equipped with business knowledge, how do we find the grain in an unknown fact table? It will be very valuable. Thanks in advance!
Sure
quick Q),what type of syntax that you used in 2:37 (select null country,null city etc..) This is the first time i saw a syntax like this .Can you please further explain on this.
Just hard coding null value to columns..like.null as country
you are awesome !
nice
❤❤very good sir!! Please also upload the insert script for the pervious video on business intelligence where tou show ytd etc
Uploaded . Check description
just a question sir... are all these topics covered under your SQL zero to hero course ?
Covered here in this video 😊
will this feature available across all the databases ?
or restricted to SQL SERVER ?
Mostly all
are these commands supported in MySQL??
Mostly yes
Please tell me what all RDBMS supports these functions. I am interested in Oracle and SQL server
Hello Ankit,
I want to enroll for the recorded session course of SQL. Can you please share the link of the same..
www.namastesql.com/courses/SQL-For-Analytics-6301f405e4b0238f71788354
nice