Database Lesson #7 of 8 - Database Indexes

Dr. Soper gives a lecture on database indexes. Topics covered include index concepts, linear vs. binary search strategies, estimating index storage space requirements, B-tree indexes, bitmap indexes, hash indexes, and clustered vs. non-clustered indexes.

[@jimc1499]

Dr. Soper, Thank you for this series for SQL Database Indexes. The series has great detail, clarity and presentation.

[@johnlockie]

Raise your hand if you listen to these on 2x 🖐

[@RicardoFerreira-rc7ux]

this was by far the best index explanation I have ever seen

[@rajendrasinghbisht6165]

A simple and nice and presentation about how database indexes works ! Thanks Dr. Soper !

[@channabasappaheralgi5723]

Gave a clear cut understanding on lot of DBMS concepts!!!!!!!!!! Thanks for that superb video.

[@sent4dc]

Good lecture. Although let me save you 20 minutes -- watch at x2 speed.

[@jefftrimmer3221]

Excellent information. Though I had to increase the play speed to 1.5 to maintain my sanity.

I'm glad I was not the only one.

[@walidzein1]

try at 0.25 speed, it will become ASMR

[@ColdFuse96]

I go 1.5 normally on all of his videos, but then that became the "normal speed", so I went to 1.75 and was still able to follow him with no problem. His content is great, but I need that speed boost to for it to maintain my attention 😂

[@shivankchopra8552]

Best video for understanding indexing on youtube! It compliments well with the indexing lessons given in Korth (Database System Concepts).

[@kishankumarJha]

sir, it was the best tutorial I ever had. please keep updating ur tutorials

[@fillheimer]

Best argument for organization I have ever understood.

[@Luccient]

This video helped me immensely, many thanks!

[@hiteshjain986]

Excellent Lecture !Lot of Basics covered ! Thank you so much !

[@didierfolly]

Thanks for the very well explained topic. Many things popped up to my mind after listening to your video. Keep doing such as great and interesting videos.

[@tokierekowei9796]

Thank you So much Dr. Daniel. Very informative and very clear to understand

[@Jorrissie]

Very well explained with practical examples. Thanks!

[@mksmurff]

Worth every minute. Thank you

[@thulanimoyana6626]

Straight to the point. Perfect.

[@bojanzivkovic8934]

Great job, very nice explanation of very important topic for any DBA.

[@dainova]

Magnifico!!! Thanks much Doc. Absolutely super!

[@niranbhandari1327]

Thanks for all the efforts in distributing your knowledge.............

[@ibtisamj4035]

Thanks Dr. Soper.

[@davejoseph9799]

Nice presentation and the tone (voice ) is perfect for a demo

[@1Watchmerock]

You video was excellent. I really learned a lot from your explanation. Thank you so much for uploading this video.

[@hugecraig]

Thank you Dr Soper

[@aselabiz3757]

thank you so much sir :) i watched many videos coudnt understand but your one helped me a lot :)

[@danistdaniel]

i like this lessons Database keep it up guys

[@nigh7ynigh7]

Thanks. This video helped a lot!

[@danielalmeida7140]

This is the second time I come back to this video. Still amazes me how great the whole playlist is. I don't understand, however, why there must be only one clustered index per table.... can't we just update the leaf nodes whenever we update the table?

[@anuradhaprabhathkadurugasy4515]

Great video. well explaining.

[@taab84]

Great video

[@2everywhere285]

Thank you sir. Very good lecture.

[@kidz_code]

Thank you :)

[@avalon2199]

Great stuff.

[@maryjain1762]

great presentation for beginners....

[@chineseprogrammer]

thanks alot doc. You did a better job than my uni lecturer. I doubt he taught us indexes unless I'm mistaken. I don't have a particularly good memory

[@opti420sk]

Super good explanation and very clear

[@AnjaliChadha]

Thank you Dr.Daniel for the lucid explanation. I have a doubt though; the B Tree Index you explained in the video, isn't that B+ Tree in actual ?

[@Web3ForDevs]

Thank you sir. nice lecture

[@laynovaed3219]

Very informative.

[@satishgupta470]

Awesome lecture, to be honest it's a very helpfull lecture, thanx alot sir for making such a awesome tutorials. Can i get the pdf of your notes for quick revision during exam or interview time

[@MrJonnis13]

Amazing tutor! (by a tutor)

[@na0m1fes51]

thanks bro

[@amanajib]

thx

[@ShantamBhavsar]

Awesome

[@jakubwszokowski1294]

Maximum search time in ordered table should be rounded up, isn't it? For instance: There're 5 steps needed to find Al Rabeeah. But the most thing - your course is awesome & helped me a lot, thanks!

[@t-poseriku6265]

I'm not the best at algebra, and I wanted to understand on 5:52, in average = (22+1) / 2 =11.5, what does the '1' stand for?

[@elham-elliem7123]

Very great , thank you , as a suggestion if there were series of added exercises as quizzes with solutions and explanations under video of exams and exercises about each topic they would be very helpful as well Very great , thank you , as a suggestion if there were series of added exercises as quizzes with solutions and explanations under video of exams and exercises about each topic they would be very helpful as well

[@Ninadeniso]

Good and well structured information. But the speech is very slow. Listening at speed of 1.25 or 1.5 worked well.

[@allynooallynoo5983]

When doing a linear average for a database why is it (n+1)/2 instead of (n)/2????

[@ShivPrateekSharma]

good ..

[@marywise3462]

x2 SPEED is a must YA'll

[@racialwhale]

been watching youtube on 1.75. just tried normal speed to see how it was and bruh. that is not happening for me.

[@bartpeters7682]

valt tegen daniel

[@joshuaburnworth8611]

My instructor provided links to your videos for us to listen to. They chose poorly. You talk SO SLOWLY. I can read ten times faster (at least) than you talk. It. Drives. Me. CRAZY!!!