How to test SQL injection manually

Question

I’m learning about SQL injection vulnerabilities and want to know how to test for them manually on a sample application. What types of payloads should I try, and what signs indicate a potential vulnerability? Also, what precautions should I take to avoid unintended effects while testing?

Any guidance on basic, safe SQL injection testing techniques would be appreciated.