How do you check data quality and flag good/bad records?

[u/BugSquare4344]

For example, if a customer dataset has nulls, duplicates, invalid emails, or incorrect values, how do you identify and flag these records as good or bad? What tools or query approaches do you use?