For the most part, well water is safe to drink, but a private well is not regulated, so testing it is your job. More than half the well tests my customers send in pass every health line; when one fails, it is almost always bacteria, which you cannot taste. Here is what to test for, what boiling does and does not fix, which wells are most at risk, and what to do if your test finds a problem.
For a home, two systems take nitrate out of well water: a whole-house anion exchange system with nitrate-selective resin, and a reverse osmosis unit at one faucet. Boiling, softeners, carbon filters and UV lights do not. Here is how the whole-house system works, the order the tanks go in on a well, what reverse osmosis really takes out, what to drink until the system is in, and who installs it.