datacenter – How does servers work?

I am very new with the concept of servers of the type here. The only servers I really heard of is SQL Servers, and I don’t have an idea how they function. I want to use some someday, but I want to know the basic info first.

So what are the servers discussed in this site and what’re the functionalities? How do those servers actually work?