I need an explanation of SQL database indexing and query optimization because my college database class was too theoretical and I need practical skills for backend development.