Day 5 Learning SQL to Get Hired
Welcome to Day 5 of my "Learning SQL to Get Hired" series!
Today, I’m working through two LeetCode SQL problems:
- #577 Employee Bonus
- #1280 Students and Examinations
What you'll learn:
- Using LEFT JOIN and handling NULL values in result sets
- Combining multiple tables with JOINs and GROUP BY
- Real-world use cases like reporting missing data and summarizing student performance
As always, I’m walking through my thought process, showing how I debug mistakes and explaining what I’d expect if this came up in an interview. Try these problems yourself and let me know how you approached them!
Problem links:
https://leetcode.com/problems/employee-bonus/
https://leetcode.com/problems/students-and-examinations/
Timestamps:
0:00 - Introduction
0:42 - Employee Bonus
6:28 - Students and Examinations
27:59 - Conclusion
#SQL #LeetCodeSQL #SQLInterview #LearnSQL #DataEngineer #MySQL #LeftJoin #GroupBy #DataAnalytics
Видео Day 5 Learning SQL to Get Hired канала Nicholas Facciola
Today, I’m working through two LeetCode SQL problems:
- #577 Employee Bonus
- #1280 Students and Examinations
What you'll learn:
- Using LEFT JOIN and handling NULL values in result sets
- Combining multiple tables with JOINs and GROUP BY
- Real-world use cases like reporting missing data and summarizing student performance
As always, I’m walking through my thought process, showing how I debug mistakes and explaining what I’d expect if this came up in an interview. Try these problems yourself and let me know how you approached them!
Problem links:
https://leetcode.com/problems/employee-bonus/
https://leetcode.com/problems/students-and-examinations/
Timestamps:
0:00 - Introduction
0:42 - Employee Bonus
6:28 - Students and Examinations
27:59 - Conclusion
#SQL #LeetCodeSQL #SQLInterview #LearnSQL #DataEngineer #MySQL #LeftJoin #GroupBy #DataAnalytics
Видео Day 5 Learning SQL to Get Hired канала Nicholas Facciola
SQL Learn SQL SQL tutorial SQL for beginners LeetCode SQL LeetCode solutions SQL interview prep LEFT JOIN GROUP BY NULL handling data analytics employee bonus student performance data engineer data analyst MySQL PostgreSQL SQL Server SQL practice SQL challenges get hired with SQL database queries LeetCode problem 577 LeetCode problem 1280 SQL walkthrough SQL debug tips join conditions aggregate queries
Комментарии отсутствуют
Информация о видео
19 ч. 4 мин. назад
00:28:38
Другие видео канала