SHA-256 is part of the SHA-2 family, which fixed the problems with MD5. It's much more secure and is the standard for modern security applications.
The output is longer - 64 hex characters instead of 32 - but that's because there's actual cryptographic security behind it.
Where It's Used
Password hashing, SSL certificates, blockchain - SHA-256 is everywhere. Understanding it helps you understand modern security!