Database Design 39 - Indexes (Clustered, Nonclustered, Composite Index)

Подписаться 618 тыс.

Просмотров 180 тыс.

50% 1

Start your software dev career - calcur.tech/dev-fundamentals 💯 FREE Courses (100+ hours) - calcur.tech/all-in-ones
🐍 Python Course - calcur.tech/python-courses
✅ Data Structures & Algorithms - calcur.tech/dsa-youtube
~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~
✉️ Newsletter - calcur.tech/newsletter
📸 Instagram - / calebcurry
🐦 Twitter - / calebcurry
🔗 LinkedIn - / calebcurry
▶️ Subscribe - calcur.tech/subscribe
👨🏻‍🎓 Courses - www.codebreakthrough.com
~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~
↪ My Amazon Store - www.amazon.com/shop/calebcurry
🅿 Patreon - calcur.tech/patreon-calebcurry
🅖 GitHub Sponsors - github.com/sponsors/CalebCurry
Ⓟ Paypal - paypal.me/calcur
🅑 Bitcoin - 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
🅔 Eth - 0x350139af84b60d075a3a0379716040b63f6D3853
📈 Buy Bitcoin - calcur.tech/crypto
Reserve the Ruby Steel crypto rewards card and get a $25 bonus (use affiliate code "Caleb") - calcur.tech/crypto

Наука

Опубликовано:

16 янв 2015

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 177

@jw11432 6 лет назад

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!

@derekthomas1623 7 лет назад

Very clear explanations with great examples. Better than the college professors I pay for.

@codebreakthrough 7 лет назад

Thank you very much! :)

@alungiletshangela3051 6 лет назад

You can say that again dud

@scribbleguy3657 3 года назад

i agree lol

@josecastanhas3497 3 года назад

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

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)

@rvscootin3457 6 лет назад

P.S. The great part about this video is that I will NEVER again forget the difference between Clustered and Non-Clustered Indexes.

@benreg5953 8 лет назад

Bro...Yours is probably the best I could find so far. Good work !!

@HenrySpivy 6 лет назад

agreed... and he didn't even have to use any fancy animations, just straight up used 2 books.

@krishanudev7573 6 лет назад

mate, you give the most summarized, simplified and elaborated lecture in entire youtube database.

@MrTreshev 8 лет назад

The best explanation which I have ever seen. Thank a lot, man.

@JayeSonia 7 лет назад

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.

@ahmadbahrami9437 3 года назад

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

@shawnhu8150 3 года назад

Thanks so much man! Even after 6 years, your video is still the best out there

@GuitarreroDaniel 3 года назад

Hands down to the best index explanation that I've ever seen in my life. Thanks Caleb!

@realjackofall 5 месяцев назад

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.👍

@MMABeijing 8 лет назад

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!

@PurdueBrad61 6 лет назад

Great video! This really helps breakdown a somewhat complicated subject in a way that is easy to picture and understand. Thanks!

@LexKul 7 лет назад

Man, I've tried to understand this sh*t for three days now, and you explain it for like 13 minutes :) THANK YOU!

@nigelmtb 6 лет назад

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!)

@colinrhee98 2 года назад

I find your educational videos extremely elucidating! Also, I love the traditional chalkboard setup!

@ChupaquixD 5 лет назад

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.

@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

@munshiverma8990 5 лет назад

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!

@nthn135 9 лет назад

Best beginners explanation I've seen so far. Thanks man

@johnaugust6414 8 лет назад

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!

@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.

@lexus99cl 2 года назад

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

@rikep.479 4 года назад

Thank you! You're a lifesaver. Best video about indexes I could find.

@harmonicaman79 7 лет назад

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!

@christophersanders7483 4 года назад

Great video great explanation. Better than anything I have seen. Explained and understood in seconds.

@burropoco 9 месяцев назад

This plain English explanation just made so much sense to my 40 odd year old brain. Thanks

@hoonbae244 6 лет назад

This has been such a helpful explanation of indexes. Thank you so much!

@hubertpiatek4805 5 лет назад

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

@MadForCs16 3 года назад

One of the best explanations I have heard for a topic.

@awallaustin 5 лет назад

most amazing explanation i've found thus far. thank you

@ILoveMyFrau 9 лет назад

Dude.. you are awesome!

@SisiraSomaratne 9 лет назад

You are a very good intelligent teacher.

@amanriaz1769 6 лет назад

Brilliant! You seem so young, still explained better than most old professors...

@NehaGupta-lf1sr 8 лет назад

Loved the explanation . Thanks for clearing my doubts

@merickax 5 лет назад

Hi Caleb; You are honestly a very good teacher!

@mrginn 5 лет назад

You're such a great teacher. Thank you so much dude!

@omarmiah7496 4 года назад

I wish all of my professors explained things the way you do, good work.

@ianchui 4 года назад

LOL 4:34 forEVER!! Great video! Very helpful, and I love this more relaxed style of lecture. Actually makes it fun to learn.

@jittenddra 4 года назад

clustered - Key are sorted unclustered - Key-value pairs are in a Hash Map

@ruiluo7848 8 лет назад

Best tutorial I've ever seen! Thank you!

@jbryant789 6 лет назад

The best explanation I've seen re: cluster/noncluster. 1:42 says it all. Just got a new subscriber!

@chanvanber9857 7 лет назад

can't stop watching your Database related videos..you are the best I could find so far !

@drpankaja369 7 лет назад

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

@amacdougal1 5 лет назад

So well explained. Thanks mate.

@beltek01 4 года назад

amazing explanation..crisp precise and very easy to grasp

@htetmyomyint2365 6 лет назад

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.

@angelriera4970 7 лет назад

always a simple and clear explanation. thanks man

@UpYours101 6 лет назад

Great video, helped me understand quite a bit.

@rvscootin3457 6 лет назад

Seriously!!! This is a great video! I love the simplistic analogies. AAA+++

@petraslobodova4979 Год назад

Very good explanation, the only one I understood, did not get the one from my paid course.. thank you!

@raghavkandubai7865 2 года назад

thank you, great explanation. keep teaching!

@surajkumarsingh4857 11 месяцев назад

Very nice explanation of Clustered and Non clustered index

@hank91918 3 года назад

excellent explanations, thanks Caleb!

@rajkaransingh4770 3 года назад

the best explanation ever I got on this topic

@robertgaudreau2520 5 лет назад

Greatly explained, bravo.

@leoliu8546 8 лет назад

best DB tutorial Ever!!! Thanks a lot

@noahpineda3419 6 лет назад

Keep it up! So easy to understand.

@paolotin6785 5 лет назад

Really helpful man! Thank you for this!

@godfathermikal 5 лет назад

Very good analogies. Spot on.

@kunaldeokar6666 8 лет назад

You are the worlds best teacher...

@chridal 8 лет назад

You're awesome. Great teaching! Thanks!

@Zelakus 7 лет назад

This is what i was looking for. Thanks bro 😁

@catsarereallycool 7 лет назад

Excellent video. Thank you!

@yl4034 6 лет назад

seriously you explain very well thank you for the video

@ganeshhegde4049 3 года назад

That was really well explained!

@saintmark3979 9 лет назад

Thanks for your video buddy, I learn so much from that

@siddharthj82 8 лет назад

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 :)

@nehajaiswal21 8 лет назад

very simple explanation & to the point

@ashokkumarjami3997 7 лет назад

Good work. Really appreciated.

@fernandoarce804 Год назад

Sublime explanation, thanks

@logarathinam1782 6 лет назад

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...

@davestorm6718 2 года назад

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.

@OmyTrenav 8 лет назад

Great great explanation. Thanks!

@robertoenriquechavezrodrig731 4 года назад

Awesome video bro, thank you so much! Much love to you from Innopolis, Russia :) Thursday, July 11th, 2019.

@djnihal2 8 лет назад

like everybody said.. job well done bro..

@latoyaclarke6792 6 лет назад

very best video i have seen thus far

@sangeetasahu4134 7 лет назад

Very nice explanation. You are really great..

@Tattysnuc 7 лет назад

Those are really great analogies - ref: Index vs a phone book- thank you for sharing :)

@komlanagbote7100 2 года назад

Well I love this… Thank you sooo much

@shingyau2 8 лет назад

Interesting teaching, keep on!

@jesflo4 3 года назад

Great job!

@pauldechampignon2287 5 лет назад

Very well explained. Thanks

@TheDeathtrapON 6 лет назад

great job man, thank you

@ladedadedaschlobonmeknob7850 7 лет назад

who needs college when we have CalebTheVideoMaker

@stevenwimberly6133 6 лет назад

Great explanation!!

@shupesmerga4694 4 года назад

the sound of the chalk ... ughhhhh ... I got goosebumps and I feel like my teeth are going to fall off but GREAT JOB MAN!

@ink5473 8 лет назад

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?