How to install MS SQL Server on Mac and create databases – step by step

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

The step is as follows:
00:00 – Presentation
00:45 – Download and install Docker
02:20 – Upload MS SQL Server image to Docker
03:32 – Run container
05:16 – Install MS SQL CLI
06:11 – Test the installation by logging in
06:43 – Download and install the GUI app – Azure Data Studio
08:55 – Download the BikeStores sample database
10:15 – Run the SQL query to create the database objects
11:40 – Run SQL query to load data

Download Docker from here – https://www.docker.com/products/docker-desktop

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

Get the BikeStores sample database here
https://www.sqlservertutorial.net/wp-content/uploads/SQL-Server-Sample-Database.zip

Command to pull MSSQL Docker image
sudo docker pull mcr.microsoft.com/mssql/server:2019-latest

Command to run container
docker run -d –name sql_server_demo -e 'ACCEPT_EULAY' -e 'SA_PASSWORDreallyStrongPwd123' -p 1433:1433 mcr.microsoft.com/mssql/server:2019-latest

Order for M1 chip, please try this
docker run -e /"ACCEPT_EULA1/" -e /"MSSQL_SA_PASSWORDreallyStrongPwd123/" -e /"MSSQL_PIDDeveloper/" -e /"MSSQL_USERSA/" -p 1433:1433 -d –namesql mcr.microsoft.com/azure-sql- edge

My SQL Tutorials – www.kindsonthegenius.com/mssql

Visit www.kindsonthegenius.com
My technology channel https://www.youtube.com/c/KindsonTheTechPro

My websites
http://www.kindsonthegenius.com
http://www.munonye.com
http://www.datarmatics.com

Learn programming by joining International Computer Programmers here:
https://www.facebook.com/groups/internationalcomputerprogrammers

Feel free to connect with me
️ Facebook: https://www.facebook.com/kindsonm/
️ Instagram: https://www.instagram.com/kindsonthegius
️ LinkedIn: https://www.linkedin.com/in/kindson/
️ Twitter: https://twitter.com/KindsonM
️ Pinest: https://www.pinterest.com/kindsonm/
️ Tumblr: https://www.tumblr.com/blog/kindsonthegenius

Your support can help me improve my content:
Buy me a coffee: https://www.buymeacoffee.com/PWsXo7h13
Support me on Patreon: https://www.patreon.com/kindsonthegenius

You can find many MS SQL tutorials on the website