Go to https://www.microsoft.com/en-us/learning/browse-all-certifications.aspx
Under "Filter Role-based certifications by technology or job role", click the 'Technology" box and select 'SQL Server'.
The current certs will be shown.
MTA: Base certification, single test. This is optional.
MCSA: The Certified Solution Associate certifications. Pass one of these as a pre-requisite to earning an MCSE
MCSE: The Certified Solution Expert certification. If you click on the link for MCSE: Data Management and Analytics, you can drill into all of the different tests and certifications necessary.