First 3 mins I got what I needed. Why are so many people averse to solid, clear examples? Phone book and book index very clearly defining how each index works. Thank you for this explanation, you are the man!
@derekthomas16237 жыл бұрын
Very clear explanations with great examples. Better than the college professors I pay for.
@codebreakthrough7 жыл бұрын
Thank you very much! :)
@alungiletshangela30516 жыл бұрын
You can say that again dud
@scribbleguy36574 жыл бұрын
i agree lol
@josecastanhas34973 жыл бұрын
TRUE, i was looking at their power points for an hour with a friend and couldnt understand shit and now i understand it with just this video
@benreg59539 жыл бұрын
Bro...Yours is probably the best I could find so far. Good work !!
@HenrySpivy6 жыл бұрын
agreed... and he didn't even have to use any fancy animations, just straight up used 2 books.
2 жыл бұрын
Wow... we need more people like YOU in this world! - You actually KNOW what you are talking about, and WANT TO MAKE IT CLEAR to your audience. Man, THANKS! (I'm your new subscriber)
@MrTreshev8 жыл бұрын
The best explanation which I have ever seen. Thank a lot, man.
@JayeSonia7 жыл бұрын
These are great. I could see a whole series called "Caleb Explains Stuff" (seriously though, you nailed it on clustered indexes, as well as on normalization). Good job sir.
@shawnhu81503 жыл бұрын
Thanks so much man! Even after 6 years, your video is still the best out there
@rvscootin34576 жыл бұрын
P.S. The great part about this video is that I will NEVER again forget the difference between Clustered and Non-Clustered Indexes.
@GuitarreroDaniel4 жыл бұрын
Hands down to the best index explanation that I've ever seen in my life. Thanks Caleb!
@MMABeijing8 жыл бұрын
Caleb, I have to comment one more time and tell you how impressed I am about your teaching style, I am impressed. Is it because I was brought in an area where teachers wrote on black-board? No it;s more than the noise of the chalk-piece, you just have a strange mix of enthusiasm, youth mixed with principled precision. Everybody is special but you are just a level higher, thank you!
@krishanudev75736 жыл бұрын
mate, you give the most summarized, simplified and elaborated lecture in entire youtube database.
@LexKul7 жыл бұрын
Man, I've tried to understand this sh*t for three days now, and you explain it for like 13 minutes :) THANK YOU!
@ILoveMyFrau9 жыл бұрын
Dude.. you are awesome!
@realjackofall8 ай бұрын
It took me 4-6 videos before I landed on this one while trying to understand clustered and non-clustered indexes. This is all I needed. Thanks.👍
@nigelmtb7 жыл бұрын
What everyone else said - excellent definitions and examples. I will be back for more as I am studying databases at the moment. You are doing a much better job than the lecture from a certain Irish university! (Yes, we have those. Don't mock!)
@k333ys2 Жыл бұрын
Maaaan this video is great! Took me 10 videos to understand this concept. Appreciate the knowledge being taught in a NON BORING WAY!!! Great job
@munshiverma89906 жыл бұрын
I loved the analogy of the book index and a phone book to explain the Non-Clustered and Clustered indexes respectively. Good job dear Caleb!
@JoaoRCastro55 жыл бұрын
This is the first video of yours that I watch and I have to say I really liked it. Thanks very much for the explanation.
@johnaugust64149 жыл бұрын
I have an interview later today and this topic will surely be a part of the interview. You are the best, thank you so much!
@chanvanber98578 жыл бұрын
can't stop watching your Database related videos..you are the best I could find so far !
@lexus99cl2 жыл бұрын
First video I've seen that finally explains this well. Must have seen about 7 or 8 ,still didn't have a clue until now. Thnx
@ahmadbahrami94374 жыл бұрын
I've been searching for the differences between Clustered and Nonclustered for half an hour and understood nothing until I watched your explanation. Thank you
@colinrhee983 жыл бұрын
I find your educational videos extremely elucidating! Also, I love the traditional chalkboard setup!
@PurdueBrad616 жыл бұрын
Great video! This really helps breakdown a somewhat complicated subject in a way that is easy to picture and understand. Thanks!
@robertpreston7272 Жыл бұрын
Great video. This coupled with studying the syntax yourself is a great learning method. Very focused on the 'why?' of it all. Well done.
@jittenddra4 жыл бұрын
clustered - Key are sorted unclustered - Key-value pairs are in a Hash Map
@amanriaz17696 жыл бұрын
Brilliant! You seem so young, still explained better than most old professors...
@davestorm67182 жыл бұрын
best explanation - think "clustered index" as being "clustered" with the actual data(this is the way I had to think of it). Therefore, non-clustered would simply be a pointer to the actual data (it's NOT "clustered" with the data). funny, I've done DBs for 20 years and intuitively setup databases/relationships (hands on), but still get tripped up, now and then, on the theory (and lexicon) - as I found out the hard way in an interview.
@ruiluo78488 жыл бұрын
Best tutorial I've ever seen! Thank you!
@petraslobodova49792 жыл бұрын
Very good explanation, the only one I understood, did not get the one from my paid course.. thank you!
@harmonicaman798 жыл бұрын
Very good. I really like the comparison of the two metaphors of a book index (non-clustered) vs. a phone book (clustered). When you compared the two, it all clicked. Thanks!
@christophersanders74834 жыл бұрын
Great video great explanation. Better than anything I have seen. Explained and understood in seconds.
@Max-my6rk4 жыл бұрын
Wow subbed u need to do more advanced stuff on dB... like btrees hashing sorting query optimization
@MadForCs163 жыл бұрын
One of the best explanations I have heard for a topic.
@oscararmandocisnerosruvalc85032 ай бұрын
The best video ever created !!!
@surajkumarsingh4857 Жыл бұрын
Very nice explanation of Clustered and Non clustered index
@ianchui4 жыл бұрын
LOL 4:34 forEVER!! Great video! Very helpful, and I love this more relaxed style of lecture. Actually makes it fun to learn.
@jbryant7897 жыл бұрын
The best explanation I've seen re: cluster/noncluster. 1:42 says it all. Just got a new subscriber!
@omarmiah74964 жыл бұрын
I wish all of my professors explained things the way you do, good work.
@SisiraSomaratne9 жыл бұрын
You are a very good intelligent teacher.
@rajkaransingh47704 жыл бұрын
the best explanation ever I got on this topic
@dima883222 күн бұрын
Very clear explanation ! Thank you
@ladedadedaschlobonmeknob78507 жыл бұрын
who needs college when we have CalebTheVideoMaker
@ink54738 жыл бұрын
The best, I must have looked at 10 videos on this topic and you just nailed it 1) video is not in 480p 2) visual examples 3) SQL explanation But how do you use them in a query SELECT statement?
@nthn1359 жыл бұрын
Best beginners explanation I've seen so far. Thanks man
@burropoco Жыл бұрын
This plain English explanation just made so much sense to my 40 odd year old brain. Thanks
@raghavkandubai78653 жыл бұрын
thank you, great explanation. keep teaching!
@siddharthj829 жыл бұрын
very good video , your pronunciation is very clear..I am Indian and whenever I refer any tutorial I only understand around 75% of words because of accent, but in your tutorial I have not missed a single word..what a great crystal clear accent :) .........create more videos I am very bad in database :)
@merickax5 жыл бұрын
Hi Caleb; You are honestly a very good teacher!
@rikep.4795 жыл бұрын
Thank you! You're a lifesaver. Best video about indexes I could find.
@drpankaja3697 жыл бұрын
this is awesome .... superb explanation.. 😃😊👌👍👏✌ .... your tutorials special is, you explain the concepts with examples . it makes the students to get the practical knowledge ..rather than ... roaming around the books .... really good explanation.... it helped
@godfathermikal5 жыл бұрын
Very good analogies. Spot on.
@htetmyomyint23657 жыл бұрын
Thank you for your explanation. I'm new to index although I knew about database. You explanation is clear and it's easily understandable by providing. examples.
@beltek014 жыл бұрын
amazing explanation..crisp precise and very easy to grasp
@hoonbae2446 жыл бұрын
This has been such a helpful explanation of indexes. Thank you so much!
@chinmayravindran2868 жыл бұрын
Great video! 1 small thing you missed : 05:52 forgot to add a "FROM " after SELECT and before WHERE.
@meetdave333 жыл бұрын
Bhavnao ko samjho!!
@hank919183 жыл бұрын
excellent explanations, thanks Caleb!
@lynndemarest19026 жыл бұрын
Back in the olden days, news reporters and others used cross indexes that sorted the phone book by phone number -- so if you knew the number you could find out who it belonged to and what their address was. There was also an address index book, so you could get the phone number (and name) from the address.
@hubertpiatek48056 жыл бұрын
Man.. absolutely amazing! Thanks a million. This is what I wanted to structure in my head for a long time shown in easy, friendly and funny way. Carry on! will go thru others
@komlanagbote71002 жыл бұрын
Well I love this… Thank you sooo much
@SiyamandRashid7 жыл бұрын
thanks a lot, now I know why use index and what is difference between clustered and non clustered index
@rvscootin34576 жыл бұрын
Seriously!!! This is a great video! I love the simplistic analogies. AAA+++
@amacdougal16 жыл бұрын
So well explained. Thanks mate.
@fernandoarce804 Жыл бұрын
Sublime explanation, thanks
@awallaustin6 жыл бұрын
most amazing explanation i've found thus far. thank you
@Zelakus7 жыл бұрын
This is what i was looking for. Thanks bro 😁
@nehajaiswal219 жыл бұрын
very simple explanation & to the point
@mrginn5 жыл бұрын
You're such a great teacher. Thank you so much dude!
@ganeshhegde40493 жыл бұрын
That was really well explained!
@angelriera49708 жыл бұрын
always a simple and clear explanation. thanks man
@kunaldeokar66668 жыл бұрын
You are the worlds best teacher...
@UpYours1016 жыл бұрын
Great video, helped me understand quite a bit.
@Tattysnuc7 жыл бұрын
Those are really great analogies - ref: Index vs a phone book- thank you for sharing :)
@robertoenriquechavezrodrig7315 жыл бұрын
Awesome video bro, thank you so much! Much love to you from Innopolis, Russia :) Thursday, July 11th, 2019.
@noahpineda34196 жыл бұрын
Keep it up! So easy to understand.
@burnt34362 ай бұрын
this is actual gold
@spider-man11205 жыл бұрын
Very good man!
@yl40346 жыл бұрын
seriously you explain very well thank you for the video
@Connie.3466 жыл бұрын
very best video i have seen thus far
@shupesmerga46944 жыл бұрын
the sound of the chalk ... ughhhhh ... I got goosebumps and I feel like my teeth are going to fall off but GREAT JOB MAN!
@NehaGupta-lf1sr8 жыл бұрын
Loved the explanation . Thanks for clearing my doubts
@RandomVideos-ll6jz5 жыл бұрын
Caleb, I want to buy Database Design book, what book do you recommend?
@robertgaudreau25205 жыл бұрын
Greatly explained, bravo.
@jesflo43 жыл бұрын
Great job!
@hanneslpd50346 жыл бұрын
You answered all my questions in the first three sentences :D
@kwemishuza733 жыл бұрын
very very well explained!! Kudo Bro
@ashokkumarjami39977 жыл бұрын
Good work. Really appreciated.
@sangeetasahu41347 жыл бұрын
Very nice explanation. You are really great..
@niteshyadav21125 жыл бұрын
1.Hi can you explain if i have table employee there is three col,empid,empname,address, if i use without index and with index which is more faster and why? 2.cluster index and non cluster which index performance faster and why ?
@mak.ak.uk.4 жыл бұрын
I'm not a developer, but occasionally dabble in data analysis and database development. I always end up coming back here to get a primer on indexes. DON'T EVER REMOVE THIS VIDEO!
@JHatLpool2 жыл бұрын
Great explanations. Very comical. (Have you ever tried using a phone book in South Korea ? It is very hard work. Everybody has the surname 'Kim'.).
@leoliu85468 жыл бұрын
best DB tutorial Ever!!! Thanks a lot
@saintmark39799 жыл бұрын
Thanks for your video buddy, I learn so much from that
@chridal8 жыл бұрын
You're awesome. Great teaching! Thanks!
@Luca_sgl4 жыл бұрын
amazing, thanks man
@catsarereallycool7 жыл бұрын
Excellent video. Thank you!
@paolotin67855 жыл бұрын
Really helpful man! Thank you for this!
@djnihal28 жыл бұрын
like everybody said.. job well done bro..
@logarathinam17827 жыл бұрын
I run this complete day by just watching your video...And my book is nearby sleeping..lol..so helpful!!! THANK YOU...This is last video I watched today...I am ending my preparations with this...