Install and Run SQL Server on MacOs!
These are tools and services I personally use or have tested, and I highly recommend them for learning, productivity, and professional growth:
Datacamp - Learn data science and analytics skills: https://datacamp.pxf.io/Z6XZ1z
Coursera – Top university and industry courses online: https://imp.i384100.net/EEzJ7K
365 Data Science Online Program – Comprehensive data science training: https://365datascience.pxf.io/dORDny
Babbel – Learn a new language effectively: https://babbel.sjv.io/zxGy26
SentryPC – Employee & computer monitoring software: https://sentrypc.7eer.net/DyWoGa
Carson Dellosa Education – Educational resources & materials: https://carsondellosaeducation.sjv.io...
Skuad – Hire and manage remote teams globally: https://skuad.pxf.io/rarGLG
Affiliate Disclosure:
Some of the links above are affiliate links, meaning I may earn a small commission if you purchase through them, at no extra cost to you. This helps support my channel and allows me to continue creating valuable content. Thank you for your support! ❤️
*************************************************************************************
Want to run SQL Server on your Mac but don't know how? Look no further!
In this tutorial, we'll show you how to easily install and run SQL Server on your Mac using Docker. This method eliminates the need for a virtual machine or dual-booting, making it a convenient and efficient solution for developers and data professionals.
By the end of this video, you'll have a fully functional SQL Server instance running on your Mac, ready for you to start developing and testing your applications. Whether you're a seasoned developer or just starting out, this video will guide you through the process step-by-step, so you can get up and running with SQL Server on your Mac in no time.
We also show you how to connect popular SQL client tools like CLI (sql-cli), DBeaver and Azure Data studio to Microsoft SQL Server and run queries.
This video is helpful if you want to know:
how to install sql server on mac
how to install Microsoft sql server on mac M1, M2, M3
how to install microsoft sql server on mac using docker
how to install sql server using docker on mac M1,M2,M3
how to install and run sql server on mac
install microsoft sql server on mac
install sql server on mac m3
how to connect azure data studio to sql server on mac
azure data studio connect to sql server
dbeaver connect to ms sql server
how to connect dbeaver to ms sql server
Commands Used in the video:
#check docker version
docker --version
#pull image from docker registry
docker pull mcr.microsoft.com/mssql/server:2022-latest
#run docker image in background
docker run --platform linux/amd64 -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=mypassword \
-p 1433:1433 --name sqlserver \
-d mcr.microsoft.com/mssql/server:2022-latest
#install sql-cli to run sqlserver from cli
sudo npm install -g sql-cli
#login to database
mssql -u sa -p
#show databases
select name from sys.databases;
#create database
CREATE DATABASE TestDB;
#use database
USE TestDB;
#create database
CREATE TABLE Employees ( \
ID INT PRIMARY KEY, \
Name NVARCHAR(50), \
Position NVARCHAR(50) \
);
#insert to database
INSERT INTO Employees (ID, Name, Position)\
VALUES (1, 'John Doe', 'Developer');
#select
SELECT * FROM Employees;
Supporting Videos:
How to install docker on Mac - • Install Docker Desktop on Your MacOS (M1, ...
How to install DBeaver on Mac - • DOWNLOAD DBeaver for Mac!! EASY Step-by-s...
DBeaver Tutorials:
Connect DBeaver to MySQL - • How To Connect and Query MySQL Database Fr...
Connect DBeaver to Snowflake - • How To CONNECT DBeaver to Snowflake & RUN ...
Connect DBeaver to Redshift - • CONNECT DBeaver to Redshift & RUN Queries ...
Connect DBeaver to BigQuery - • How To Connect DBeaver to BigQuery in Minu...
Connect DBeaver to PostgreSQL - • CONNECT DBeaver to PostgreSQL & RUN Querie...
Download Links:
Docker - https://docs.docker.com/desktop/
NodeJS - https://nodejs.org/en/
#sqlserver #mssqlserver #mssql #docker #dockerdesktop #azuredatastudio #dbeaver