There are three forms of cognitive workload: Intrinsic, External and Germane.
Intrinsic is things you just *know*. How to write a class in java, how to write a query in SQL, ...
External is stuff you only need occasionally, and need to look up every time: How to deploy to X, how to set up CI/CD, ...
Germane is context knowledge. Usually referred to as business knowledge.
You want to keep external cognitive load a minimal as possible. You can really dig deployment and stuff, and then this becomes your intrinsic cognitive workload and coding becomes more or less external, but for somebody who just likes to code, it's best to once do a deep dive to deployment logics, write a scaffold and stick with an automated version forever.