SQL Indexes | Clustered vs. Nonclustered Index |

Опубликовано: 15 Декабрь 2024
на канале: Data with Baraa
3,713
224

🎬 Full Advanced Course:    • How I'd Learn Advanced SQL and Why (I...  
This video, you'll learn what are indexes, and deep dive into Clustered and Nonclustered Index.

⬇️ Free Materials (Downloads): https://datawithbaraa.substack.com
👉 Support & Subscribe to Channel: http://bit.ly/3GiCVUE

☕ Stay connected
► Subscribe: http://bit.ly/3GiCVUE
► LinkedIn:   / baraa-khatib-salkini  
► Website: https://www.datawithbaraa.com
► Newsletter: https://bit.ly/BaraaNewsletter
► PayPal: https://paypal.me/baraasalkini
► Join:    / @datawithbaraa  

📚 Free Courses
✅ Tableau:    • Complete HR Tableau Project End-to-En...  
✅ Tableau Project:    • Complete HR Tableau Project End-to-En...  
✅ SQL Basics:    • SQL Tutorial for Beginners [Ultimate ...  
✅ SQL Advanced:    • How I'd Learn Advanced SQL and Why (I...  
✅ ChatGPT:    • ChatGPT Tutorial for Beginners [Ultim...  

🎓Other Platforms (Certifications)
► Udemy: https://bit.ly/BaraaUdemy
► Skillshare (1 Free Month): https://bit.ly/BaraaSkillshare

⭐ My favorite books: https://kit.co/DataWithBaraa/my-favor...
💻 My gear: https://kit.co/DataWithBaraa/my-deskt...

⏱️ Timestamp
00:00 - Intro
00:28 - What are Indexes?
02:19 - Index Types
04:00 - Heap Structure
10:01 - Clustered Index
16:12 - Non-Clustered Index
20:58 - Clustered vs NonClustered Index
29:06 - Syntax of Index
31:00 - How to Create Index
37:50 - Composite Index

#sql #sqlserver #data #analytics
*Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!*
*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*