xxxxxxxxxx
# Here is an example of how to install SQL Server on Linux using the Command Line Interface (CLI):
# Step 1: Import the Microsoft repository GPG keys
wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
# Step 2: Register the Microsoft SQL Server Ubuntu repository
sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-2019.list)"
# Step 3: Install SQL Server
sudo apt-get update
sudo apt-get install -y mssql-server
# Step 4: Run the SQL Server setup
sudo /opt/mssql/bin/mssql-conf setup
# After completing the setup, you can start and stop the SQL Server service using the following commands:
sudo systemctl start mssql-server
sudo systemctl stop mssql-server
# You can also enable SQL Server to automatically start at system boot:
sudo systemctl enable mssql-server
xxxxxxxxxx
SQL means "Structured Query Language", and is used to *search* through
existing relational database management systems (RDBMS).
In 2020, the most used RDBMS options[1] are (most-lowest):
1. Oracle DB
2. MySQL
3. Microsoft SQL Server
4. PostgreSQL
5. SQLite
Google trends (2020) ranked the same systems in the order:
1. MySQL
2. Microsoft SQL Server
3. PostgreSQL
4. Oracle DB
5. SQLite
MySQL, PostgreSQL and SQLite are Open Source and 'Free'.
- MySQL's shell handles JavaScript, Python and formerly Perl.
You can find drivers for the mysql connectors in most languages.
- PostgreSQL's interface layer is open to most languages. The
psql shell interpets PL/pgSQL, a custom language for the DBMS.
- SQLite has a single custom shell language, but supports bindings
in most well known programming languages. SQLite is installed
automatically on some Unix/Linux distributions.
References:
[1] https://db-engines.com/en/ranking