Загрузка...

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
Яндекс.Метрика

На информационно-развлекательном портале SALDA.WS применяются cookie-файлы. Нажимая кнопку Принять, вы подтверждаете свое согласие на их использование.

Об использовании CookiesПринять