This video explains step by step how to Install MS SQL Server on Mac OS and create databases.
The step are as follows:
00:00 – Introduction
00:45 – Download and Install Docker
02:20 – Download the MS SQL Server Image to Docker
03:32 – Run the Container
05:16 – Install the MS SQL CLI
06:11 – Test the Installation by Login In
06:43 – Download and install the GUI application – Azure Data Studio
08:55 – Download the BikeStores sample database
10:15 – Run the SQL Query to Create the Database objects
11:40 – Run the SQL Query to Load Data
👉 Downlaod Docker from here – https://www.docker.com/products/docker-desktop
👉 Downlaod Azure Data Studio from here
https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15
👉 Get the BikeStores Sample Datatabase 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 the container
docker run -d –name sql_server_demo -e ‘ACCEPT_EULA=Y’ -e ‘SA_PASSWORD=reallyStrongPwd123’ -p 1433:1433 mcr.microsoft.com/mssql/server:2019-latest
🔥 Command for M1 Chip, please try this
docker run -e “ACCEPT_EULA=1” -e “MSSQL_SA_PASSWORD=reallyStrongPwd123” -e “MSSQL_PID=Developer” -e “MSSQL_USER=SA” -p 1433:1433 -d –name=sql mcr.microsoft.com/azure-sql-edge
My SQL Tutorials – www.kindsonthegenius.com/mssql
Visit www.kindsonthegenius.com
My Tech 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
❤️ Pinerest: 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 lots of MS SQL tutorials on website