If that's common advice, it's bad advice. Most beginners don't need to start studying the intricacies of opening theory because they don't have the tactical or strategic foundation needed. Much more important is to follow the basic opening principles:
1.) Stake a claim in the center, either by occupying it with a pawn or attacking it with pieces.
2.) Develop your minor pieces (bishops and knights) before your major pieces. The kingside knight almost always goes to either f3 or (much less often) e2. The queenside knight almost always goes to either c3 or d2 (more equal that f3/e2). Since this is true for most openings, you usually want to develop a knight before you develop a bishop on the same side. It's harder to tell where a bishop belongs than a knight.
3.) Don't move the same piece more than once in the opening, unless you have a clearly good reason (winning a piece, e.g.)
4.) Don't move more than one or two pawns before your development is complete.
5.) Get that king out of the center and castle. This also helps connect your rooks.
I'm doing these from memory, so I may be missing one or two. If you follow these opening principles (and you're no longer dropping pieces due to simple tactics), then you'll probably find that you're following the mainlines of some opening or another.
Once you're well versed in the opening principles you can learn one or two openings each for white and black, maybe the first 5 or 6 moves. As you play those openings regularly, you'll see what tactics and strategies are usually used in them.
I have some basic questions if someone will be patient with me...
One of the common pieces of advice for improving one's game is to learn and study openings. I confess that, though I'm not a rank beginner, my eyes still glaze over when someone mentions any opening by name. What makes it worse is that there are zillions of openings. So I am constantly wondering what defines an opening, how many I should study, how many of them are actually just variations on other openings, and above all how to study them?
I started reading a primer on openings, but sort of gave up (I might start it up again) because, well, it didn't seem very efficient. Besides, the author wasn't really defining what the openings were. He'd just start talking about games without saying, "This precise sequence of moves is the Ruy Lopez" or whatever. Like I can figure out how far into the game is "Ruy Lopez" and what, after that, is variation.
Also, why should I learn the main line? Why should I play it?
Is there a really good book or essay or video (on this site even) where all these mysteries are revealed?