Confined aquifers under pressure
A confined aquifer is sandwiched between two impermeable layers (clay or shale). Water in a confined aquifer is under pressure from the weight of overlying rock. If you drill a well into a confined aquifer, water may flow to the surface without pumping (an artesian well) because the pressure pushes it up. Recharge (new water entering) happens slowly, only where the aquifer is exposed at the surface miles away.
Unconfined aquifers and water tables
An unconfined aquifer has a permeable top, exposed to the atmosphere through soil. The water table is the upper surface where soil becomes saturated. Unconfined aquifers recharge rapidly from rainfall but also deplete faster if pumped heavily. Most groundwater extraction happens from unconfined aquifers because they're accessible and responsive to recharge, but this also makes them vulnerable to contamination from surface pollutants.