Let’s Learn Databases!
All the joy of a database environment without the pain of setup and configuration.
This repository contains docker configurations and base scripts necessary to provide a complete database management system with sample data and web-based tooling.
Use this software to accompany the Applied Database Management textbook, the Introduction to Database Management Systems course, or to just explore databases on your own!
- Microsoft SQL Server 2017 database management system.
- Database Provisioner Application for creating sample databases and populating data.
- SQL Pad a web-based query tool.
- Adminer a web-based database admin tool.
A computer with one of these Operating Systems:
- At least 8GB RAM.
- At least 8 GB free disk space.
- Docker is used to manage the containers. Installation instructions are here:
You must allocate at least 1CPU and 4GB of RAM to docker.
Linux/ChromeOS: No Configuration Necessary, but you will need to install docker-compose separately.
- Azure Data Studio. This is the client tool used to connect to the Microsoft SQL Server and compliments the web equivalents of SQL Pad and Adminer.
Installing Learn Databases
To install Learn Databases, clone or download this repository to your computer.
If you have
git installed on your computer and wish to clone the repository:
- Open a terminal window. Make sure you are in a folder where you wish to store the code repository.
git clone https://github.com/mafudge/learn-databases.git
The code will download from github to your computer.
If you do not have
git installed or you do not wish to clone the repository:
- Click https://github.com/mafudge/learn-databases/archive/master.zip to download this repository.
- After it downloads, unzip the file to a folder where you wish to store the code repository.
Here’s a video of the walkthrough:
Running the containers
- Open a terminal window inside the
learn-databases folder. This is where you cloned or unzipped the code repository.
- Type :
docker-compose up -d to start everything. This might take some time as images are downloaded and/or built.
- Type :
docker-compose ps to see the
adminer containers in a running Up state.
Creating the Sample Databases
The Database Provisioner webapp can be used to create the sample databases. It will also display the database login information.
- To launch the *Database Provisioner application, open a web browser and connect to:
Database Connection information appears in the upper right, and a list of databases you can provision appears in the application window.
- Click the icon in the Info section to learn about each database.
- Click the Create button to generate the database schema and initial data for a database.
- If the database is updatable, Click the Update button to bring the data current.
- You can click Drop at any time to remove the database, or Recreate to place the database back in its initial state.
Note: These commands can take time depending on the size or complexity of the database. Please be patient!
Connecting with Azure Data Studio
Azure Data Studio
Add New Connection
- Fill in the connection information based on the information displayed in the Database Provisioner application.
- Here’s a quick tutorial you can follow to learn Azure Data Studio.
Connecting with SQL Pad
SQL Pad is a browser-based query tool. You can connect to the SQL Server database and execute any query in the SQL language.
- Open a web browser and connect to:
http://localhost:5001 to launch the SQL Pad web application.
- Click on Connections
- Click Add Connection
- Enter a connection name and choose
SQL Server for the driver. Enter the connection information from the Database Provisioner application.
Connecting with Adminer
Adminer is a browser-based database admin tool. You can create database objects and edit data without using the SQL language.
- Open a web browser and connect to:
http://localhost:5002 to launch the Adminer web application.
- From the login screen, choose
MS SQL as the system and then enter the connection information from the Database Provisioner application.
Stopping the containers
When you are finished using the database, you might want to stop the docker containers to save the CPU and Memory resources on your host computer. The containers will remain up, even between reboots, until you tell docker to stop them.
To stop all containers, type:
If you want to just stop one of the containers you can use the
stop option. For example to stop the Adminer service container, type:
docker-compose stop adminer
To start an individual service, you can use the
docker-compose start sqlpad
Or to start all containers, you can use:
docker-compose up -d