A broad outlook for a professional programmer?

Question

Career in IT

Let's say you need to interview for a developer at $super_cool_company for a php developer position (python/java are also possible).
In addition to the language itself, you need to know
1. How the interpreter works inside (at least superficially)
2. How various data structures are implemented
3. Different programming paradigms
4. Using different databases
5. Debugging methods
6. Code optimization, database optimization
7. Networking (sockets , TCP/UDP)
8. Locks (mutexes/semaphores)
9. Multi-threaded programming, synchronization issues
10. etc. etc.
Not sure if there is something similar in one book.
Advise what to read to broaden your horizons / remember various nuances (not necessarily based on PHP, C ++ / Java / Python is suitable)
Some kind of reference books / cheat sheets, as it were, for preparing for exams, where you can refresh your knowledge on many basics of everything that one way or another associated with programming, so as not to re-read thousands of pages of Talmuds on each topic, because much of the indicated has already been read / used / studied, but due to rare use, it has been forgotten.
It doesn't have to be employment related. I want to remember / refresh in memory many of the basics. Something, perhaps, is remembered in an incorrect interpretation.
I have written in php/python/c/c++/js/perl (somewhere more, somewhere less, with and without frameworks), write distributed computing, optimize code for certain platform features, configure networks, ip-telephony, server administration, but some of the knowledge is superficial enough for serious work, although it is enough to write working solutions.

Answer 1

Understand a simple thing, you are not going to take exams, for an interview. It makes no sense to read the night before the interview and write spurs. Only your real experience will count, not theoretical knowledge.
Do you want a list of questions that people have skidded over at my interview?
- What editor do you use? What version, what plugins are worth? What is the hot key for ... (If a person is slipping, then he does not sit at the editor much).
- What version of MySQL (or PostgreSQL) are you using, how is it different from the previous version?
- In what situations it is necessary to use interfaces, but categorically it is impossible to use abstract classes. Conversely, in what situations is it necessary to use abstract classes, but interfaces, or trades, are not allowed?
- I give a piece of paper and write a long number 4923872788828228453. I give the task, write a regular expression to divide this number by three through a space: 4 923 872 788 828 228 453. The number can be arbitrary. If a person is not able to do this with one regular expression, then I suggest solving the problem for him in any other way, but on paper and without the Internet. Just wondering how he will compose the algorithm. Problems are different, there were always about a couple of dozen similar examples at hand.
Therefore, you cannot prepare for an interview by reading books.

Answer 2

answer on this very toaster in profile tags the last 100 questions in each

Answer 3

A broad outlook comes with experience.

Answer 4

Damn, for about 15 years, everything has probably gone to search engines on any issue to find out and read, I was even taken into account at school as a search engine in 2000.