Database Indexing Explained (with PostgreSQL)
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
https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join
🧑🏫 Courses I Teach
https://husseinnasser.com/courses
🏭 Backend Engineering Videos in Order
https://backend.husseinnasser.com
💾 Database Engineering Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQXjD0HOzN7P2tgzu7scWpl2
🏰 Load Balancing and Proxies Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQVMeBmWI2AhxULWEeo7AaMC
🏛️ Software Archtiecture Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQXNP6mQchJVP3S-3oKGEuw9
📩 Messaging Systems
https://www.youtube.com/playlist?list=PLQnljOFTspQVcumYRWE2w9kVxxIXy_AMo
Become a Member
https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join
Support me on PayPal
https://bit.ly/33ENps4
Stay Awesome,
Hussein
Видео Database Indexing Explained (with PostgreSQL) канала Hussein Nasser
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
https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join
🧑🏫 Courses I Teach
https://husseinnasser.com/courses
🏭 Backend Engineering Videos in Order
https://backend.husseinnasser.com
💾 Database Engineering Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQXjD0HOzN7P2tgzu7scWpl2
🏰 Load Balancing and Proxies Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQVMeBmWI2AhxULWEeo7AaMC
🏛️ Software Archtiecture Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQXNP6mQchJVP3S-3oKGEuw9
📩 Messaging Systems
https://www.youtube.com/playlist?list=PLQnljOFTspQVcumYRWE2w9kVxxIXy_AMo
Become a Member
https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join
Support me on PayPal
https://bit.ly/33ENps4
Stay Awesome,
Hussein
Видео Database Indexing Explained (with PostgreSQL) канала Hussein Nasser
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Things every developer absolutely, positively needs to know about database indexing - Kai Sassnowski](https://i.ytimg.com/vi/HubezKbFL7E/default.jpg)
![Apache Kafka Crash Course](https://i.ytimg.com/vi/R873BlNVUB4/default.jpg)
![Column vs Row Oriented Databases Explained](https://i.ytimg.com/vi/Vw1fCeD06YI/default.jpg)
![10.2 B Trees and B+ Trees. How they are useful in Databases](https://i.ytimg.com/vi/aZjYr87r1b8/default.jpg)
![I ask this question to every Backend Engineer I interview](https://i.ytimg.com/vi/bDIB2eIzIC8/default.jpg)
![](https://i.ytimg.com/vi/sZOygEzAzOM/default.jpg)
![Full Text Search PostgreSQL](https://i.ytimg.com/vi/szfUbzsKvtE/default.jpg)
![SQL Index |¦| Indexes in SQL |¦| Database Index](https://i.ytimg.com/vi/fsG1XaZEa78/default.jpg)
![Cross Origin Resource Sharing (Explained by Example)](https://i.ytimg.com/vi/Ka8vG5miErk/default.jpg)
![The OSI Model - Explained by Example](https://i.ytimg.com/vi/7IS7gigunyI/default.jpg)
![Asynchronous vs Multithreading and Multiprocessing Programming (The Main Difference)](https://i.ytimg.com/vi/0vFgKr5bjWI/default.jpg)
![Вся правда об индексах в PostgreSQL / Олег Бартунов, Александр Коротков (PostgreSQL)](https://i.ytimg.com/vi/aaecM4wKdhY/default.jpg)
![iptables Demystified - Port Redirection and Forwarding HTTP Traffic to another machine (part 1)](https://i.ytimg.com/vi/NAdJojxENEU/default.jpg)
![How to Become a Good Backend Engineer (Fundamentals)](https://i.ytimg.com/vi/V3ZPPPKEipA/default.jpg)
![Microservices Explained and their Pros & Cons](https://i.ytimg.com/vi/T-m7ZFxeg1A/default.jpg)
![LEARN BITMAP INDEXES](https://i.ytimg.com/vi/5-JYVeM3IQg/default.jpg)
![Demystifying the Browser Networking Tab in Developer Tools With Examples](https://i.ytimg.com/vi/LBgfSwX4GDI/default.jpg)
![PostgreSQL Indexing : How, why, and when.](https://i.ytimg.com/vi/clrtT_4WBAw/default.jpg)
![Indexing in PostgreSQL vs MySQL](https://i.ytimg.com/vi/T9n_-_oLrbM/default.jpg)
![SameSite Cookie Attribute Explained by Example (Strict, Lax, None & No SameSite)](https://i.ytimg.com/vi/aUF2QCEudPo/default.jpg)