This video explains step by step how to Install MS SQL Server on Mac OS and create databases.

More Details: https://medium.com/p/39460da701b9

📌 Install Docker
Download the (free) Docker Community Edition for Mac (unless you’ve already got it installed on your system). This will enable you to run SQL Server from within a Docker container.

To download, visit the Docker CE for Mac download page and click Get Docker.

📌 Azure Data Studio
Now Download azure data studio from here,
https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15

📌 Latest Image:
https://hub.docker.com/_/microsoft-mssql-server