SQL Value Window Functions | LEAD, LAG, FIRST_VALUE, LAST_VALUE | #SQL Course 25

Data with Baraa 19,540 lượt xem 11 months ago

Video Not Working? Fix It Now

🎬 SQL Full (30-Hours) Course https://youtu.be/SSKVgrwhzus
🎁 Free Downloads & Materials: https://datawithbaraa.substack.com
👉 Support & Subscribe to Channel: http://bit.ly/3GiCVUE

☕ Stay Connected
► Subscribe: http://bit.ly/3GiCVUE
► Newsletter: https://bit.ly/BaraaNewsletter
► LinkedIn: https://www.linkedin.com/in/baraa-khatib-salkini/
► Website: https://www.datawithbaraa.com
► PayPal: https://paypal.me/baraasalkini
► Join: https://www.youtube.com/channel/UC8_RSKwbU1OmZWNEoLV1tQg/join

📚 Free Courses
✅ Tableau : https://youtu.be/K3pXnbniUcM
✅ SQL Playlist : https://www.youtube.com/playlist?list=PLNcg_FV9n7qZY_2eAtUzEUulNjTJREhQe
✅ SQL Project1 : https://youtu.be/9GVqKuTVANE
✅ SQL Project2 : https://youtu.be/2jGhQpbzHes
✅ Tableau Project 1 : https://youtu.be/dahrmqT5GD4
✅ Tableau Project 2 : https://youtu.be/UcGF09Awm4Y
✅ MySQL :https://youtu.be/NTgejLheGeU

🎓 If You Need Certifications
► Udemy SQL: https://bit.ly/4hH947P
► Udemy Tableau: https://bit.ly/3xFiDDk

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

⏱️ Timestamp
00:00 Intro
00:00:33 What are Window Value Functions?
00:04:12 MIN & MAX
00:14:01 MIN & MAX: Month-Over-Month Analysis
00:20:50 MIN & MAX: Customer Retention Analysis
00:29:36 FIRST_VALUE & LAST_VALUE
00:19:45 ROW_NUMBER: TOP-N Analysis
00:41:46 Summary

#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

Comment