How do different programs communicate with each other?

Question

Windows

Good time everyone!
I have a question, perhaps a stupid one, that I can't formulate correctly.
I'm interested in how programs (applications) communicate with each other in Windows?

In particular, I'm interested in communication between the DBMS and the client program.

For example:
I use MySQL DBMS and work with it using HeidiSQL or Workbench.
And so, I write request (SELECT...), the DBMS sends me the table.

How it works?
My knowledge is limited to advanced calculators.
And I would like to try to write my own client program like HeidiSQL working with MySQL DBMS.

How do Windows programs communicate with each other?

What to read? A theory is desirable, and if there are examples, then it is desirable in C ++.

Answer 1

You can try to start with this article .
It's not entirely accurate, but it gives a general idea.