About a year ago, I prepared my concrete floors to be covered first with an overlay and then stained. My situation was a bit different, but I bet the prep needs to be about the same. You can read my blog post about the preparation we did on lauramakes.com.
For your situation, you will want to use a floor scraper to remove anything loose on the floor, like paint chips and the glue, or you won't get your paint or overlay to stick well. I found that wetting down the floor made the scraping go much faster.
You will definitely need to get the carpet glue up. I was interested in non-toxic products, so I looked into two soy based strippers. I tested Soy It, and it definitely worked for paint and is supposedly good for adhesives too.
After you get up the glue, you will need to take care of the grease stains. If you don't, it may show through your paint. The Eco Safety Products support person recommended that we use a floor buffer that you can rent to clean the floor first with orange degreaser and then water. Our grease stains didn't come completely out, but I don't think we found a heavy enough buffer to rent.
I can't really answer much about etching because I decided early on that the process was too toxic for us because we would be living in the house with our pets at the same time as we were prepping the floors.
Anyhow, I hope that helps a bit and let me know if I can elaborate on anything.
There are (at least) two different types of stains for concrete. One is a surface coating, the other is acid etching.
The former can work, but isn't as durable/lasting. I believe most of the products you get at the big-box stores are more of a top-coat type of stain.
Acid etching is just that, it's a stain containing an acid that actually etches the concrete. This is the typical type of stain you see in home magazines and such. The etching provides a deeper stain that is more durable and not prone to flaking.
I've done the latter, and applying it is super-easy. It's the prep work that can be a chore--namely if you have adhesive on the concrete already. In our case, we has tile mastic, which we had to dissolve using soybean based stripper. It worked great but was incredibly messy.
If you don't have glue to deal with, however, you should be good to go. Order up the stain (lots of places online to get it). You then dilute it per instructions and spray it on the concrete. I used a garden sprayer for this. You then let it sit for a period of time, and then you apply a neutralizer to stop the reaction.
After that, you apply water and mop/squeegee/wet-vac it up.
Then, you apply a sealer of some sorts. Common options are wax-based, polyurethane, and epoxy. I went with poly as it was relatively easy to apply (roll it on). That said, I don't think it was ever truly waterproof. For your needs, you may want to go the epoxy route.
Best Answer
I painted my deck last year with Behr stain, water based, but looked like paint because I wanted color. Later I noticed that some of the boards seemed like they didn't get as much coverage. So the next day I simply added a second coat on the spots and the boards where I felt it was too thin. It still looks great over a year later and I never had to deal with any sticky spots. I would just add a second coat after it is thoroughly dried on the spots you feel need a bit more.