Standard: 10-25% weekly for stocked tanks. Lightly stocked or planted: every 2-3 weeks. Reef tanks: 10% weekly with reef-grade salt. Nano reefs: 15-20% weekly. Skip water changes only in mature tanks with stable parameters and ULNS dosing - and only after 6+ months of demonstrated stability.
Water changes accomplish three things: nitrate dilution (the easiest fix for high nitrates), trace element replenishment (calcium, magnesium, potassium, iodine, etc.), and dissolved organics removal (the stuff that causes yellow water and skimmer foam).
The "no water changes ever" approach (popular among some reef-keepers running ultra-low-nutrient systems) requires advanced testing, dosing, and stability monitoring. It's not a beginner approach.
Only if the tank is heavily planted (plants outpace nitrate production), low-tech (no CO2), and lightly stocked. Most planted tanks need at least 25% weekly during the active growth phase.