Structured Query Language or SQL is a standard Database language that is used to create, maintain and retrieve data from relational databases like MySQL, Oracle, SQL Server, Postgres, etc. As the name suggests, it is used when we have structured data (in tables). All databases that are not relational (or do not use fixed structure tables to store data) and therefore do not use SQL are called NoSQL databases. Examples of NoSQL are MongoDB, DynamoDB, Cassandra, etc. To learn more about SQL go to SQL Tutorial. To learn SQL You must have knowledge of Docker. What is Docker?
Docker is a set of platforms as a service (PaaS) products that use the Operating system level visualization to deliver software in packages called containers. Containers are isolated from one another and bundle their own software, libraries, and configuration files; they can communicate with each other through well-defined channels. All containers are run by a single operating system kernel and therefore use fewer resources than a virtual machine.
Features of SQL
- It contains commands which define the data for example create, drop, alter, rename, etc.
- Data Manipulation Language contains commands used to manipulate the data. The commands are inserted, delete, update, etc.
- We have commands in SQL that control how a client application can access the database over a network.
Downloading and Installation
We require to download docker first, following steps are to be followed in order to download docker:
Downloading Docker
Step 1: Go to the link https://docs.docker.com/desktop/install/mac-install/
Step 2: Select Mac with intel chip or Mac with apple silicon according to your MacBook processor. The download will begin.
Step 3: After the download is completed run the downloaded setup (Docker.dmg file in your system downloads).
Step 4: After installation is completed a window will appear. Drag and drop Docker to Applications.
Step 5: Now open Docker in your applications. A Docker window will appear.
Downloading and Configuring SQL Server
Step 1: Open the terminal on your mac.
Step 2: Type the below command in the terminal and press enter.
docker pull mcr.microsoft.com/mssql/server:2019-latest
Step 3: Type the below command to set up your SQL server.
docker run –NAME_OF_YOUR_SERVER -e ‘ACCEPT_EULA=Y’ -e ‘SA_PASSWORD=PASSWORD_OF_YOUR_SERVER e’ -e ‘MSSQL_PID=Express’ -p 1433:1433 -d mcr.microsoft.com/mssql/server:2019-latest
SQL server is installed now.