Every knot I know now, I originally learned in Boy Scouts. Because I actually sat down and practiced them for a week+.

Best advice for learning: get a convenient (2-4' depending on knots) piece of rope, thin enough to be portable, thick enough to be manageable, and practice tying knots as a fidget spinner

Initially it will be tough and require thought, but for a lot of the patterns you can do it without looking after a bit of practice. And repetition breeds memory.