How to run sql server in docker container | Run sql server in linux using docker within few minutes

Sql Server in docker:
In this video we are going to learn how to install docker and How to run sql sever in docker.
first we will pull the sql server docker image.After some configuration
we are good to use the sql server from docker container.

----------------------------------------------
Used commands:
-----------------------------
Docker installation steps
1. sudo apt-get update

2. sudo apt-get install \
apt-transport-https \
ca-certificates \
curl \
gnupg-agent \
software-properties-common

3. Add Docker’s official GPG key:
curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -
4. sudo apt-key fingerprint 0EBFCD88
5. sudo add-apt-repository \
"deb [arch=amd64] https://download.docker.com/linux/ubuntu \
$(lsb_release -cs) \
stable"
.........................................................................................................................
sudo apt-get update
sudo apt-get install docker-ce docker-ce-cli containerd.io
sudo apt install docker-ce
for testing: sudo docker run hello-world
------------------------------------------------------------------------
sql server container commands:

1.To pull the image: sudo docker pull mcr.microsoft.com/mssql/server:2019-CU5-ubuntu-18.04
2.sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=YourStrong@Passw0rd" \
-p 1434:1434 --name sql1 \
-d mcr.microsoft.com/mssql/server:2019-CU5-ubuntu-18.04

3. sudo docker ps -a
4.sudo docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd \
-S localhost -U SA -P "current password" \
-Q 'ALTER LOGIN SA WITH PASSWORD="new password'

connect to sql server
.................................................
1.sudo docker exec -it sql1 "bash"
2./opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "Sa@1234 #"
---------------------------------------------------------------------------------------------------
Previous videos:
1. Asp.Net Core MVC Web App CRUD with EF Core
https://www.youtube.com/watch?v=HOB4G-uskJU&t=1131s

2.How to deploy .net core website in linux
https://www.youtube.com/watch?v=mtXE1LMQZEY&t=198s

3. How to use SQL-Server with VS Code in Ubuntu.
https://www.youtube.com/watch?v=ulndc5Ac6VQ&t=73s

4. Asp.net core rest api tutorial in single video
https://www.youtube.com/watch?v=qT-YtifPqjM
-----------------------------------------------------------------------------
Like us on facebook -
https://www.facebook.com/Code-Arc-112783630467091/

Thanks