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 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 Azure Data Studio from here

👉 Get the BikeStores Sample Datatabase here

🔥 Command to pull MSSQL Docker Image

🔥 Command to run the container

🔥 Command for M1 Chip, please try this

My websites

Learn Programming by joining International Computer Programmers here:

Feel free to connect with me

Your support can help me improve my content:

You can find lots of MS SQL tutorials on website

[KindsonTheTechPro]

‼️‼️ Hey everyone, please use a strong password like this one "reallyStrongPwd123". I just updated the command. If you use a weak one like "pass", then you cannot connect! ‼️‼️

[akeylahwaite]

Great video!! for anyone with trouble at the npm sql cli part download homebrew then input these functions
brew install npm
npm install sql-cli
and than npm install -g sql-cli

[xvrpvn]

This is one the rare tuto that propose a solution for MAC and M1 Chip. You rock Kindson

[simplyibby]

By far, this has been the easiest explanation on how to set up ms sql on back. This video is very self explanatory provided you have all the needed tools pre installed on your Mac.

Also, the comment section is very helpful with knowing what’s needed for pre installation. Thank you for sharing your knowledge.

[jav-]

I had been struggling with this for the past year and finally someone provides a simple, accurate explanation on how to do this. Thank you!!

[lizsilva]

I cannot thank you enough. I found some roadblocks along the way but at the end I was able to install it, Thank you so

[ramanakodamalla]

omgg thank you so much, I was dying with anxiety bc my class was going to start soon and the installation tutorial video my uni provided was for windows only and the MAC installation process is so much more complicated. This helped me so much, thank you so much 🥰

[_ritamghosh]

Very very useful video Kindson. I tried a ton of videos before this, none worked as smotthly as this. Very excited to get started now

[wendyzhai]

Bruh I encountered like 2 million errors doing this but I was able to pull through!!! Thank you so much for making this video
I didn't have npm so I had to download it through homebrew but then I also don't have homebrew lmao, so I had to download that too. Such a long ride but it was worth it!

[JamiewithData]

I have been waiting for a while to install, no luck but finally i got it .Appreciate your help for sharing.

[mmayenejiasa]

Took me two hours but I'm grateful i went through this and was able to install it on my Laptop

[mahmudsurvey]

Hey, Great job! I am a cloud engineer and now I am using mac for my personal work, so this is a great help, I had a little bit trouble on connecting to server (localhost) thru command, however, I figured it out. Thank you!

[daviddamian]

Damn man. Thanks for this awesome video, so glad i came across it. Was watching some other guy's video where he's showing me to pay for the Azure before i can use it and some other stuffs which were usually frustrating. But i'm glad i followed your idea. Thanks. :)

[AbrahamLouw]

Wow, you really saved the day with this video, I have an M1 Macbook and the docker run cmd string worked perfectly, thanks!

[wangtony]

I am so glad that you explains it into simple words! many tutorial makes it too complex.

[arshinadange]

Thank You so much....every step was explained slowly and nicely please bring up more videos like this....Great Job!!!! and please recommend everyone to use some strong password I was getting some errors due to weak password

[LewiUberg]

Thanks man! I'm transitioning from pure python to c# and I am the only Mac user at work 😅

[Nchewiii]

AWESOME Tutorial video! The comments are great too. Thank you!

[liviaredua]

Hello !
i had a couple of problems during the installation, but in the end it worked ! thank you so much for the video !!

[christiejackson]

I am so glad I came across this tutorial. This was very easy to follow and understand. Thank you!