When somebody asks me how to solve a particular database problem, or an IT problem, or how to write an algorithm to do something, I will think about it in the back of my mind and "just spit it out after a while," unless it's something difficult enough to warrant a literature review.

That doesn't mean that those subjects aren't covered in detail in textbooks and university courses, or that people cannot learn how to do it.