[Azure Data Studio] provides a GUI to administer MSSQL and Postgres databases.
Docker command to show port numbers to add database connections in Azure Data Studio.
docker port NAME_OF_CONTAINER
Azure Data Studio has an extension [PostgreSQL extension for Azure Data Studio] to add support for PostgresSQL. In Azure Data Studio, click the gears on the bottom left, click Extensions, and search for PostgresSQL.
Command to show currently running docker containers.
docker ps
The ps argument displays a table with headers: IMAGE, COMMAND, CREATED, STATUS, PORTS, and NAMES.
Command to show all docker containers running or not.
docker ps -a
Command to stop a docker container.
docker stop NAME_OF_CONTAINER
Command to start a docker container.
docker start NAME_OF_CONTAINER
Command to remove a docker container.
docker rm NAME_OF_CONTAINER
Command to install MSSQL in a docker container. (Windows)
docker run --name sqlserver2019 -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Adam123456" -p 1401:1433 -d mcr.microsoft.com/mssql/server:2019-latest
Command to install PostgresSQL in a docker container.
docker run --name postgresql -p 5401:5432 -e POSTGRES_PASSWORD=Adam123456 -d postgres:latest
Command to open an interactive terminal (bash shell) in a docker container.
docker exec -it NAME_OF_CONTAINER bash
Bash shell command to show OS details.
cat /etc/os-release
Bash shell command to log into the SQL command-line tool.
/opt/mssql-tools/bin/sqlcmd -U sa -P Adam123456
SQL command to query the database version.
SELECT @@Version;
GO
More Docker commands, bash commands, and SQL commands are available in Chapter 2 of [Database Foundations: Intro to Databases].
Ex_Files_Database_Foundations_Intro\Chapter 2