Looking for an easy way to understand database indexing? I can help with that.

Hey everyone, I'm just starting to get into database design and optimization. I've read about indexes and how they can speed up queries, but I'm a bit lost on the practical side. When should I add an index? Are there any common pitfalls I should avoid when creating them, especially for a beginner? Looking for some straightforward advice on best practices here.