How to install Microsoft SQL Server as Docker Container on Ubuntu OS | Part 10 | DM | DataMaking

Hello friends welcome to my channel data making in this video I'm going to explain you how to install uh Microsoft SQL Server as a Docker container on OB to operating system uh let's get started uh Microsoft SQL Server is a rdbms uh database management system so that we are going to use it uh let me give you the uh detail instruction how to install it so the prequest is you need to have a Docker engine installed so if you don't know how to install Docker uh engine um or the docker software please follow my previous video where I given the detail instruction of how to install the docker on open to operating system so the first step is to pull the docker image of SQL Server so I'm going to install the SQL server or SQL Server it's called Microsoft SQL Server 2022 um so you can uh run this command to pull the container so sudo docker pull and space mc. microsoft.com / mssql server colon uh 20122 iph latest so this is going to pull the docker image so I'm going to run this in terminal Window Control all T is a shortcut uh let me run this it is going to ask me the password the S password uh so so it's already uh image is downloaded um so if you are running for first time so it will take some time to download this image okay so to just check whether uh uh the images are downloaded you can run a command sudo uh Docker images so you see there is a uh Microsoft SQL Server 2022 uh image is uh downloaded Okay so now what I'm going to do is I'm going to uh make use of uh uh Docker run command to create a Docker container for your SQL Server database so for that what you need to do is sud sudo Docker run and you have to pass this uh license agreement uh as property and then the important thing is you need to set the password for uh the admin user called sea okay so uh so you need to set the password so you need to follow the uh the password policy as well default Poli password policy it should contain uh at least 8 digit characters long and contains characters of uh from three of the following so L it should contain upper case lower case and digital uh based on digit digits sorry and symbols so I'm going to keep it very simple uh welcome1 123 uh so and then um so the default boort number is 143 uh and then you can give the container name for it I'm just giving SQL uh um one okay or I can just change this to um um um data making SQL one I'm making SQL Server one that's my uh name I'm giving container name the host name also I'll give the same thing okay so don't need to give us um underscore data making SQL Server one instance I'm giving it that's a name so I will be using the same thing for logging in as well so I just change this I'll tell you that shortly okay so I'm going to run this command and then so it is going to run it in a demon as a background process database so the image we need to provide from which image the the container has to create so this is the image so let's run this command okay okay the container is created there is a long uh uh um Alpha numic number is given so basically it's a container ID so to check whether a container is created for your resq server you can run this command sudo Docker PS um I so you see there I created few other containers as well so you see there is a container created for SQL Server so it status it says up for 15 minutes so that means success y running okay so if it's any failure you could go and check the docker locks using the sudo Docker locks and now we need to we can connect to this uh cql server first you need to connect to this uh Docker instance so for that sudo Docker exe it means interactive mode the your container name is uh data making SQL Server one so we will run on bash you can just give this as Bash so so so we open it so it will open a terminal okay so so it is so I'm in inside the container data making SQL Server one container so from here we can using the SQL command uh we can connect to the SQL so what I did is basically I connected to the container inside container we have SQL Server installed right so to connect to the SQL Server we are using a SQL client called SQL command and you need to pass the Local H is a server name and sa is a username password is this one so if you pass this entire thing so it launch this SQL command CLA which is a command line so let's create a database called uh create database test DB and say go so database is created and I'm going to run this command to check whether the database is created in CIS dat uh CIS do databases you should see the uh database name so so I see the default databases Master tempdb model msdb uh addition to that my database testdb is created so this is successful um then once you done with this I can quit from this CLI so so we successfully installed the uh SQL Server Microsoft SQL Server as a Docker container on operating system I hope this video is helpful uh please uh uh uh put the comment section or uh uh um if you have any queries and if you have feedback please provide in comment section of this video I'm happy to help you thank you so much friends