11  Server installations

11.1 Sqlite

Sqlite has no server, sqlite is embedded file based database; therefore, only client tools are needed. Most, GUI tools, such as dbeaver, also include necessary files to run sqlite. Also every major programming language has necessary bindings, java, c#, python etc.

If you only use sqlite from programming language or GUI tool, you may not have to download sqlite. But I suggest to download and use command line for learning purposes.

sqlite downloads

Demo

1. Download sqlite
2. open command line
3. download chinook db.
4. show contents in the command line.

11.2 Docker

• docker download

We will use docker for our server installations due to ease of use. Normally, at least in my opinion, database production servers should not be docker containers.

11.3 Oracle

Dockerfile for oracle and scripts are provided in the course github repository.

• Oracle docker course files

Oracle also provides virtual box developer images.

• Oracle virtual box

11.4 SQL Server

Dockerfile for Sql server and scripts are provided in the course github repository.

• Sqlserver docker course files

11.4.1 SQL Server server installation

SQL Server downloads

• Different Versions of SQL Server

  • Express
  • Developer
  • Standard
  • Enterprise

• SQL Server Express Installation

• Server Configuration

  • Configure Stop - Start
  • Mixed Authentication
  • Documentation

• Service accounts