Once again I have been saved by random indian guy on youtube. I am on my final interview at my dream job because of you. I really appreciate the help sir!
Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.
I got tired searching through internet to find a simple explanation clustered and non clustered index. And my search ended with this video. Couldn't expect better. Kudos !
sir i think there is a mistake in slide on time 15:57 ,there should be ..the NON clustered index has to refer back to the table as u explained on 15:05 to 15:35
You are the best!! This is the easiest way to learn SQL that I have found. You are very clear, concise, and give real examples on how to use SQL. Thanks so much.
Many links, videos, teachers explain these concepts in such a complicated way, maybe because they want to show off their knowledge or intelligence by making it complicated and then explaining it. But you Venkat have made it so simple to understand and Digest, that I love watching all these videos. I think this world is a better place because of people like you who make complicated stuff easy.
One of the best explanation about indexes. For non clusters index Christian song book, songs are ordered alphabetical order wher you can find the page number of the songs. Since songs are printed in topic order.
You are generating lights in each home and family of a software guy... Because of Your explanation which we are living life right now... Thankyou so much.. Expecting many more videos from you
it's the best tutorial for clustered index and non-clustered index I've ever seen. I can totally understand the definition through your lecture. thanks!!!
1. Yes, it is suggested to create a clustered index on a column that will be queries the most. 2. The column in the where clause should be included in the index. 3. SQL server uses unique index to enforce the primary key. So, if you already have a clustered index on a column other than the primary key, then a unique non-clustered index needs to be created on the primary key column to enforce the uniqueness.
Hi venkat, Thanku very much for this vedio,I have searched so many articals about non clusterd indexes but still not understood.But this day after watch u r video, I have been understood fully about indexes,and it would be helpfull to me to go furthure into sql.once again thanku very much
Hi Venkat, In the differences slide, in point 2, could you please correct the statement "clustered index has to refer back to table" to "non clustered index has to refer back to the table." Thank you!
Great explanation. I had a few issues with this topic so far, but your teaching has eliminated those doubts. The examples you consider are very easy to replicate and the way you describe is really awesome. Again a big thanks for the excellent work which you have undertaken.
This tutorial is very helpful i've tried studying this but didn't completely understand the difference between the indexes , your examples really helped me understand thanx!
Hello Rahiel - Thank you very much for the feedback. Means a lot. I have included all the SQL Server tutorial videos, slides and text articles in sequence on the following page. Hope you will find it useful. www.pragimtech.com/courses/sql-server-tutorial-for-beginners/ If you have time, can you please leave your rating and valuable feedback on the reviews tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.
Hi, there might be a typo in the slide that summarizes the "Difference" between Clusterred and NonClusterred. Non clustered index has to refer back to the data table if the column is not found in the index. In the slide, it reads that clustered index has to refer back... is that correct? Thanks.
I enjoyed watching this video and I would suggest others to watch since topic has been clearly explained and also at the end there is an interview question was mentioned, which I experienced in my interview. Thanks a lot for educating the community.
Hi Shiva, sorry for the delayed response. You are 100% correct. Thank you very much for offering to help answer questions posted by others. May I ask you for a favour. I want these tutorials to be helpful for as many people as possible. Please feel free to share the link with your friends and family who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video.
your videos are awesome man. You're a great teacher, and that's coming from another fellow teacher who is trying hard to find good SQL materials that actually teach the content well. Your videos are just that. Great job sir!
hi venkat ,thank u very much for ur time and clear explanation about the clustered and non clustered index i been learn a lot of thing from ur video thanks again
@4:02 you talk about inserting rows of data where the ID is out of sequence. You mentioned that the table in the data is stored in sequential order by the ID. But how does SQL do that? 1. Does SQL do a sort on the ID field, after each row of data in the INSERT INTO statement?2. Does SQL insert all rows of the INSERT statement, then do a sort on the ID field?3. Does SQL insert each row of the INSERT INTO statement into the proper row of the table (thereby not using a sort on the ID field)?
Hey great work @kudvenkat. Guess what... i'm working for a database company and manager suggested me to see your videos to clear my basics of SQL Server. :)
+YT LWT Thank you for taking time to give us your feedback. This means a lot. I am very glad you found the videos useful. Free Dot Net & SQL Server video tutorials to help you become a web developer ua-cam.com/users/kudvenkatplaylists?view=1&sort=dd DVDs with all the videos and slides for offline viewing www.pragimtech.com/Order.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. ua-cam.com/video/y780MwhY70s/v-deo.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. ua-cam.com/users/kudvenkat If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. Best Regards Venkat
Hello Alm - Thank you very much for the feedback. Means a lot. I have included all the sql tutorial videos, slides and text articles in sequence on the following page. Hope you will find it handy. www.pragimtech.com/courses/sql-server-tutorial-for-beginners/ When you have some time, can you please leave your rating and valuable feedback on the REVIEWS tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.
Once again I have been saved by random indian guy on youtube. I am on my final interview at my dream job because of you. I really appreciate the help sir!
Did you get the job?
Tomorrow is my interview
Hi Venkat
You are gifted and talented teacher. I think people who want to learn SQL they first open your videos.
Man!... you have taught me so much and it's not just the quantity but the quality of your content is priceless!
Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.
Thank You! How do you highlight an entire line at once in sql server?
@@abdullahmohammad5613 ctrl+shift+End key
I got tired searching through internet to find a simple explanation clustered and non clustered index. And my search ended with this video. Couldn't expect better. Kudos !
sir i think there is a mistake in slide on time 15:57 ,there should be ..the NON clustered index has to refer back to the table as u explained on 15:05 to 15:35
thats what i thought
I was about to mention the same. Thanks.
I agree. It should be changed. I thought I was going mad...
I did not catch the mistake, has that been fixed?
Thank you so much, your tutorial from 11 years ago still teaches me a lot!
You are the best!! This is the easiest way to learn SQL that I have found. You are very clear, concise, and give real examples on how to use SQL. Thanks so much.
Thanks.... Today first time I have been able to understand this topic... Properly.... Thanks a lot...u r a boon to students....
Many links, videos, teachers explain these concepts in such a complicated way, maybe because they want to show off their knowledge or intelligence by making it complicated and then explaining it.
But you Venkat have made it so simple to understand and Digest, that I love watching all these videos. I think this world is a better place because of people like you who make complicated stuff easy.
This is the best explanation I've found so far for this subject. Thank you so much for all your tutorials, they've really help me a lot.
Brilliant explanation! I've read dozen of pages and still had question, but you explained everything in 15 minutes!
One of the best explanation about indexes. For non clusters index Christian song book, songs are ordered alphabetical order wher you can find the page number of the songs. Since songs are printed in topic order.
You are generating lights in each home and family of a software guy... Because of Your explanation which we are living life right now... Thankyou so much.. Expecting many more videos from you
it's the best tutorial for clustered index and non-clustered index I've ever seen. I can totally understand the definition through your lecture. thanks!!!
This is a superb video which helps the people who doesn't have any idea about indexs
Best Explanation on UA-cam by far. Great Job!
1. Yes, it is suggested to create a clustered index on a column that will be queries the most.
2. The column in the where clause should be included in the index.
3. SQL server uses unique index to enforce the primary key. So, if you already have a clustered index on a column other than the primary key, then a unique non-clustered index needs to be created on the primary key column to enforce the uniqueness.
Yes, we can think it that way. Smart thinking. Thanks for taking time to leave your thoughts.
Excellent explanation of the concept of how Indexes are used in SQL.
Appreciate you sharing this video free for the entire community.
As usual, this topic was well explained. Not all smart people can teach. Thank you, Venkat.
especially you used a textbook as an example to explain the non-clustered index. really vivid and awesome!!!
Simply superb. I have been struggling to learn about this from long time & u made it clear with in 15 min.
Hey man , i never thought any one can explain this in clear and easy way . Thank youuuuuuuu
you clear the concepts of why and how both theory and in use case. This 7th video i watched on topic and finally understood the topic
Your explanation of clustered and nonclustered indexes was a GREAT help.
Dear Venkat,
as usual, all your videos are very clear and to the point. THANK YOU so much for all your efforts to make this happen.
lucid, clear and to the point! Learning is fun. Thanx and Regds. Sudhanshu
Hi venkat, Thanku very much for this vedio,I have searched so many articals about non clusterd indexes but still not understood.But this day after watch u r video, I have been understood fully about indexes,and it would be helpfull to me to go furthure into sql.once again thanku very much
Hi Venkat, In the differences slide, in point 2, could you please correct the statement "clustered index has to refer back to table" to "non clustered index has to refer back to the table." Thank you!
Yes this statement is incorrect and is very misleading
That was so clear and easy to understand! I love seeing the examples of the actual sql code to create the clustered index table. Thanks so much :D
I was just wandering for this and my searching finished here. Thanks for the wonderful content Mr. Author. Best wishes
Hello Venkat, great tutorials ! and You are such a great teacher !
Excellent teaching sir!! Great ! my pranams to you
you're my favorite online programming tutor, thank you very much and keep it up, you help a lot of people!
Can't find better explanation than this. Simple and understandable. Thanks a lot :)
Mr Venkat im very impressed, that you made this videos. Thank you a lot, you are great guy.
Greetings from Poland.
My most favorite online tutor!!!!!!!!!!
Great explanation. I had a few issues with this topic so far, but your teaching has eliminated those doubts. The examples you consider are very easy to replicate and the way you describe is really awesome. Again a big thanks for the excellent work which you have undertaken.
This tutorial is very helpful i've tried studying this but didn't completely understand the difference between the indexes , your examples really helped me understand thanx!
was ignoring this video, as it was long, but after watching many videos, and reading articles, i came here, and my search is finally over.
You managed to explain a subject that I really was struggling with. Thank you very much!!
Thank you for taking the time to explain this so clearly. Using your videos to support my SQL Server classes all the time!
Hello Rahiel - Thank you very much for the feedback. Means a lot. I have included all the SQL Server tutorial videos, slides and text articles in sequence on the following page. Hope you will find it useful.
www.pragimtech.com/courses/sql-server-tutorial-for-beginners/
If you have time, can you please leave your rating and valuable feedback on the reviews tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.
You are telling the thing for which we are looking . Excellent 👍
Hi, there might be a typo in the slide that summarizes the "Difference" between Clusterred and NonClusterred. Non clustered index has to refer back to the data table if the column is not found in the index. In the slide, it reads that clustered index has to refer back... is that correct?
Thanks.
Yes, you are right...
I always come back to your tutorials ...SQL, c#... Very easy to follow and good explanations by example. Thank you!
Hi Venkat,
very detailed explanation , it really helped me and cleared all my doubts. U r a gifted teacher.
Fantastic explanation, couldn't really get to grips with indexing before watching this video, thanks very much for posting
Differences were explained well. I enjoyed watching this video. I recommend to watch this video by anybody. Thanks
Love your way for clarification of the concepts..
I enjoyed watching this video and I would suggest others to watch since topic has been clearly explained and also at the end there is an interview question was mentioned, which I experienced in my interview. Thanks a lot for educating the community.
You explain stuff really well. Thanks for making me understand SQL.
Explained in the best possible manner.
Now only I got perfect idea about indexes. Thank you so much
great videos and explained in details, keep it up the good work as you are helping a lot people.
Hi Shiva, sorry for the delayed response. You are 100% correct. Thank you very much for offering to help answer questions posted by others. May I ask you for a favour. I want these tutorials to be helpful for as many people as possible. Please feel free to share the link with your friends and family who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video.
All videos are superb..👌. Thanks a lot Venkat.
Really nice explanation for clustered and non clustered indexes. Thank you Venkat Sir!
your videos are awesome man. You're a great teacher, and that's coming from another fellow teacher who is trying hard to find good SQL materials that actually teach the content well. Your videos are just that. Great job sir!
Thank you venka..for explaining in clear manner..
Thank you very much sir for u r kind information.This information is very useful to me..
hi venkat ,thank u very much for ur time and clear explanation about the clustered and non clustered index i been learn a lot of thing from ur video thanks again
Venkat thanks for the lecture. it's very lucid and to-the-point.
There's a mistake at 15:58 point no.2
"Because the non clustered index has to refer back to table"**
Thanks a lot, for this nice explanation of Clustered Index and Non-Clustered Index.
Thank you so much for this video ! It explains the concept very clearly. Thanks a lot !
Thankyou Venkat. we are so thankful for your videos
Very clear, to the point. Thanks Venkat.
Im pretty sure that couldn't be explained better. Thank you so much :)
Voice is so sweet . U seem to be so gentle and good....
Kiska kya to kiska kya
Hi Kunal, the PPT's are available on my blog. You can find the link to my blog in the description of this video.
@4:02 you talk about inserting rows of data where the ID is out of sequence. You mentioned that the table in the data is stored in sequential order by the ID. But how does SQL do that?
1. Does SQL do a sort on the ID field, after each row of data in the INSERT INTO statement?2. Does SQL insert all rows of the INSERT statement, then do a sort on the ID field?3. Does SQL insert each row of the INSERT INTO statement into the proper row of the table (thereby not using a sort on the ID field)?
More info for those interested -
The keys of the index are internally stored as a structure ( B - tree ) that is associated with a table/view
Love your accent. Content is also top-notch.
Fantastic video my friend. I was struggling to understand this concept until I found your video. Well done! I owe you for creating this video.
Very good teaching. Can you post a playlist about advanced sql server.
You explained well... thanks... finally I understood indexes 😊
Thank you for dedicating the time to educate on this topic. its a very detailed and clear.
Brilliant explanation I have ever seen.
Thank you Kudvenkat sir...Awesome explanation...May God bless you..
This was REALLY excellent!
Awesome! Very Clear n Crisp!
Hey great work @kudvenkat.
Guess what... i'm working for a database company and manager suggested me to see your videos to clear my basics of SQL Server. :)
Great content. This and part 35 really helped a lot. Thank you!!
This is explained clearly and perfectly.
I really appreciate such content! It is amazing, please keep it up and be the one of the most awesome guys in YT!
very good video helped me with my mcipt sql 2008 , thanks bro fro your community offering
What a noble man 👏🏻
Owww amazing explanation bro. it´s help me a lot, thanks you so much. :D
+YT LWT Thank you for taking time to give us your feedback. This means a lot. I am very glad you found the videos useful.
Free Dot Net & SQL Server video tutorials to help you become a web developer
ua-cam.com/users/kudvenkatplaylists?view=1&sort=dd
DVDs with all the videos and slides for offline viewing
www.pragimtech.com/Order.aspx
Slides and Text Version of the videos can be found on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use my youtube channel.
ua-cam.com/video/y780MwhY70s/v-deo.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
ua-cam.com/users/kudvenkat
If you like these videos, please click on the THUMBS UP button below the video.
May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
Best Regards
Venkat
Brilliant. Highly appreciate it!
This is great, thanks Venkat!
Your explanations are great, THANK YOU for this quality content
Hello Alm - Thank you very much for the feedback. Means a lot. I have included all the sql tutorial videos, slides and text articles in sequence on the following page. Hope you will find it handy.
www.pragimtech.com/courses/sql-server-tutorial-for-beginners/
When you have some time, can you please leave your rating and valuable feedback on the REVIEWS tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.
Hi, it depends on the execution plan that is generated by the sql server. Hope this answers your question.
Good explanation of concepts with examples
Now I finally undertand! Thank you Venkat
Very clear explanation brother, thanks a lot!
Thankyou so much Venkat for such a clear Explanation..
Super super super super
You are a genious
Love you
really well explanation, thanks alot.
to the point and crisp explanation. Thanks. wish you covered examples for design patterns too in recent versions.