Database Indexing Explained (with PostgreSQL)
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
Watch video Database Indexing Explained (with PostgreSQL) online without registration, duration hours minute second in high quality. This video was added by user Hussein Nasser 30 September 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 330,501 once and liked it 9.5 thousand people.