This collection of videos covers major system design concepts and fundamentals that every backend engineer needs to understand. This will help you in your design interviews. The videos are ordered in the way they should be consumed. This playlist is designed for advanced viewers List of all Backend Engineering Playlists 👨💻Backend Engineering (Beginner) https://www.youtube.com/playlist?list=PLQnljOFTspQUNnO4p00ua_C5mKTfldiYT 👩💻Backend Engineering (Intermediate) https://www.youtube.com/playlist?list=PLQnljOFTspQWGuRmwojJ6LiV0ejm6eOcs 👨🏻💻Backend Engineering (Advanced) https://www.youtube.com/playlist?list=PLQnljOFTspQUybacGRk1b_p13dgI-SmcZ
Curated by: Hussein Nasser (79 videos)
In this episode, we will discuss NULLs in database systems. I’ll go through the following: What is Null? NULLs persistence - Whether you store a 0 or 2 billion value in the field 32bit integer field it costs 32 bit - when you store a NULL in 32 bit integer field we save 32 bit but add overheads When NULLs are naughty - Semantics and inconsistent result - Select count(*). Includes nulls - count(column) ignores nulls - T is NULL returns the null rows - T is NOT NULL returns, not null rows - T In (NULL) returns nothing - T not in NULL returns nothing - Some database don’t index nulls When NULLs are useful - I don’t have value, I don’t wish to provide a birthday - not applicable field for certain use cases but not others fat tables (denormalization) - Fat tables with many columns makes your rows longer which means fewer rows fit on your page. NULLs help here .. that is NULL, it yields shorter rows, instead of storing a default 0 value 🎙️Listen to the Backend Engineering Podcast https://husseinnasser.com/podcast 🏭 Backend Engineering Videos 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