"I frequently encounter a lack in what I would call foundational computer science knowledge."

I was being paid to write code for over 15 years before I needed to interact with a database or know anything about a network. What you would call foundational knowledge others would call niche.