Database Indexing Explained (with PostgreSQL)

Published: 30 September 2020
on channel: Hussein Nasser
380,069
10k

Get my Fundamentals of Database Engineering udemy course to learn more , link redirects to udemy with coupon applied https://database.husseinnasser.com

This is a practical video on Database Indexing where I explain what is an index, why do we need it and how it can improve the performance of the queries. Also how (if used incorrectly) it can slow down your queries


intro 0:00
What is an index 0:30
Describe Table 2:15
SELECT [ID] WHERE ID 4:00
SELECT [NAME] WHERE ID 6:30
SELECT [ID] WHERE [NAME] (No index) 9:20
SELECT [ID] WHERE NAME LIKE 11:12
CREATE INDEX ON [NAME] 12:00
SELECT [ID] WHERE NAME (Indexed) 12:50
SELECT [1D] WHERE NAME LIKE (Indexed) 14:30
Summary 16:00

Support my work on PayPal
https://bit.ly/33ENps4

Become a Member on YouTube
   / @hnasr  

🧑‍🏫 Courses I Teach
https://husseinnasser.com/courses

🏭 Backend Engineering Videos in Order
https://backend.husseinnasser.com



💾 Database Engineering Videos
   • Database Engineering  

🏰 Load Balancing and Proxies Videos
   • Proxies  

🏛️ Software Archtiecture Videos
   • Software Architecture  

📩 Messaging Systems
   • Message Queues & PubSub Systems  

Become a Member
   / @hnasr  

Support me on PayPal
https://bit.ly/33ENps4

Stay Awesome,
Hussein


On this page of the site you can watch the video online Database Indexing Explained (with PostgreSQL) with a duration of hours minute second in good quality, which was uploaded by the user Hussein Nasser 30 September 2020, share the link with friends and acquaintances, this video has already been watched 380,069 times on youtube and it was liked by 10 thousand viewers. Enjoy your viewing!