I had planned to write on the topic. In his book, Steve McConnell advocates for PPP = Pseudocode Programming Process
Basically, he says you should outlines the structure of your code first, before writing your actual code.
IMHO this is even more relevant in the age of AI assisted programming. Pseudocode Programming Process is becoming Prompt Programming Process.
The process is the same, it's just the tooling around it that has evolved.
That book hasn’t aged as well, but it had some parts that are still quite relevant, today.
I always thought that Rapid Development was better than Code Complete.
I’ve probably read all of McConnell’s stuff (and I’ve taken a lot of Construx courses). At one time, I was quite the fanboi.
A lot of folks around here don’t seem to like him, which I find odd.
Even if the book would be hopelessly outdated, that's usually informative too. It tells you which specific parts of the industry change slowly and which evolve rapidly. That will help you figure out where we are headed and what you can count on will be roughly the same for the next 25 years of your career.
It's very hard to rank books precisely, because how much people get out of them also depends on past experiences.
If you already have the book or can get free access to it -- why not try? Even just the preview on Amazon is usually good to give a sense of what it is like. Read a few chapters and see if it's something you think you want to continue with.
But what's important is not that you pick The Right Book now, it's that you pick up another book when you are finished with this one.
So, it's relevant and still excellent in guiding you how to write and manage code, but make sure you don't let it lead you to a conclusion that you should write your own code for all aspects of your system.
I'd take their recommendations about code style and documentation and whatnot with a grain of salt though, languages, tools and styles have changed since then. Don't skip them, but don't adhere to them religiously; add them to your arsenal of knowledge.
It's also a bit of a slog to read front to back, so consider picking one chapter at a time or only looking up a subject you're curious about; I'd consider it more of a reference.
However seeing as the better frameworks/languages/IDEs have internalised a lot of the learnings and that the specific conventions may be outdated - so just follow the recommendations for your platform/framework.
- Rapid Application Development (also by McConnell)
- Soul of a New Machine by Kidder
- Mythical Man Month by Fred Brooks
- Programming Pearls by John Bentley
- Applied Cryptography (2e) by Bruce Schneier
- The Cuckoo's Egg by Cliff Stohl
- Structured Computer Organization by Tanenbaum & Todd
- Design Patterns: Elements of Reusable Object-Oriented Software by Gamma, Helm, etc
- A New Kind of Science by Wolfram
And many more could be added to this list
Sure, some of them use acronyms or reference technology that you've either never heard of or has been supplanted
But you could [nearly] do a find-and-replace on those "outdated" terms with a "current" term, and the books would [effectively] be up-to-date
Don't get hung-up on specific examples - they're just there to illustrate the problem domain
There is a lot of value in reading different things even if you aren't sure about the value to see what you pick up. Sometimes you will learn something or see a situation you never would have expected.
I work as a data engineer and I always wanted to enforce some rules for the team:
1. DAGs must have a section that describes what it does and have link to jira ticket and documentation if applicable. Stakeholders should be named too.
2. DAGs must have a created by and modified by section with a summary of what they did. Yes we can track changes in GitHub but if we do a lift and shift upgrade of Composer instances all trackable changes are gone.
3. Comment the sql queries wherever hacky. There is no way I know why the original author put up some conversions in the code.
4. Every etl should check source data before and check loaded data after. Put up some test cases there. For critical processes, failure should always trigger emails and slack message sent to at least two places: DE team and related stakeholder team. God there are SO MANY cases we can get rid the trouble to pick and clean the data because we did not reject obviously wrong source data.
5. Think about potential errors. If you have to SUM a column of large integers, watch for overflows. If your column is nullable, watch for unexpected nulls. Such and such.
The best way is still, reading and writing lots of code. You'll pick the right way quite naturally.