Where to read about basic knowledge of software architecture?

Question

Software design

I have been working in IT for many years. Currently in the position of System Analyst. Unfortunately, there is no quality education.
There is a certain amount of knowledge about technologies, software architecture... but now I understand that all knowledge is not systematized at all.
for example: the architecture of the deployed site on the MVC Framework. I remotely understand what a framework is and why it needs a database. But how to put it all together at a logical level and what software products are used is difficult to answer.
Advise literature or any other source of information so that you can understand everything:

• where is the code written
  
• what helps to write code
  
• how and where frameworks are used
  
• what are they
  
• What do you need to make the website or desktop application work?
  

Thank you!

Answer 1

Of course, I'm not answering your specific question, but I still recommend this video .
I really liked it, settled some understanding in my head.

Answer 2

For the first four questions, information is changing rapidly, so it’s more relevant to follow the forums, sites like the same Habrahabr. Organize a subscription to the sites you are interested in in the same feedly.com and read the selection every day.
Regarding question 5. Here, in my opinion, it is better to read books on the topic of general principles of operation of sites / applications. Just search the Internet for the best literature in the area of ​​interest - books of the " Computer Science Classics " series , books by the O'reilly publishing house (available in Russian, in translation ), some other books recognized as reference in your environment (Web / hardware / something something else).