Ironically your advice of watching YouTube videos and reading SO posts sounds more like those "Teach Yourself in 24 Hours" books. There's no easy shortcuts to truly learning any topic.
I only read one of those (Teach Yourself Microsoft Access 97 in 24 Hours). It was 25+ years ago obviously. First of all it's about 24 hour-long chapters with exercises to follow. That's a good amount of material to pick up something like MS Access, and it's not like you'll learn everything within 24 hours from now, but after 24 hours of learning in a week or so.
(You might laugh at MS Access but it was useful at least 3 times in my career, but mostly in the 25-15 year ago range.)
(You might laugh at MS Access but it was useful at least 3 times in my career, but mostly in the 25-15 year ago range.)