How can a Frontend developer enter the Backend (retrain)?

Question

Backend

Despite the name, I am not going to leave the Front, but at the same time I really want to understand the Backend, since there is not the slightest understanding of working with the server, databases, and so on.
Advise where to start, what to read. I decided to choose Node for myself, for obvious reasons: I don’t want to go completely into the backend, but at the same time I have good prospects in the future, if I have any knowledge of JS.
So I don’t think there’s anything special to advise on the language, we need basic and general concepts. I don’t understand the server, ssh / ftp, database (as I said), Docker, nginx servers and others! (but I want at least a base)

Answer 1

SQL 92 and beyond specific to a particular database. Orm for the selected language. By the way, the fashion for the node has passed, the letters there seem to be the same, but in practice, hemorrhoids are a wagon. So choose better from php go c#. Nginx is probably a week, docker let it be a month. Ssh and more as they become available. Finally there is man ssh man scp.

Answer 2

The backend is basically reading data from the database and returning it to the client. If there is no SPA on the client and you need to generate a full-fledged html on the back - a little more complicated, you will need to study the template engine used by the selected system. Everything else is the same as the frontend in terms of working with data. Therefore, read about the database and the SQL query language, make simple databases with 3-4 tables. Try to receive requests from the client and give information. Nothing very complicated. Despite the fact that back-end programmers like to bend their fingers and call front-end developers form-slaps, the modern front-end seems to me more complicated than the back-end.