Intro
Water is the enemy of all building materials. Concrete floors, particularly those at or below grade, are especially vulnerable. Don't install any kind of tile on a slab until you fix water problems.
Condensation on water pipes and walls occurs in hot weather and is not technically a water problem. Increase ventilation to relieve condensation.
Install or fix gutters and slope soil away from the foundation so water runs away from it. If this doesn't fix the problem, consult a drainage specialist.
Cover isolated, inactive cracks with an isolation membrane "bandage." Completely cover new concrete and any floors suspected of developing cracks. Fix active cracks before tiling -- don't cover them up.
Checklist
Time
From 30 to 45 minutes per square yard
Tools
Repair or degloss surface: 4-foot level, hammer, cold chisel, margin and mason's trowels, grinder, sanding block, vacuum, brush, mop
Repair structural defect: sledge, crowbar, wheelbarrow
Install membrane: roller, mason's trowel, rented floor sander.
Skills
Using a level, trowel, and power grinder
Prep
Remove or repair existing flooring
Materials
Repair/degloss surface: hydraulic cement or thinset, muriatic acid, rubber gloves
Repair structural defect: gravel, reinforcing wire, concrete mix, 2x4 screed
Install membrane: membrane, adhesive