Index - SQL - What is it? Uses? Types?

Index - SQL - What is it? Uses? Types?

I am learning SQL. Recently came across Indexes in SQL. Was not able to
understand fully. Can anyone explain what is an Index, uses and different
types in simple language.
Thanks in advance, Varu.