In this page we will focus on the topic: SQL" Environment Setup. The easiest way to do this will be to use Docker" image. If you’re not familiar with Docker, don’t worry. I will show you step by step how to install the docker client.
SQL Environment Setup
The setup is a part of our SQL" Online Training.
Installation
Please find the link how to install docker on Mac, Windows and Linux(e.g.: Ubuntu). After that we can go to the next step.
Run Postgres Database
Now you can run docker container with Postgres" which already has all necessary tables and data included. In the following command you especially should take a look on the -e (environment variables" like password/user) which will allow you to connect to this database". Finally let’s copy and run this command.
docker run -d --rm -p 5432:5432 -e POSTGRES_PASSWORD=postgres -e POSTGRES_USER=postgres --name bigdataetl-postgres-sql-course bigdataetl/postgres-sql-course:latest
If everything goes right you should be able to establish connection to this database using you favourite SQL" tool. In my case it’s DBeaver".
Data Model
In this tutorial" we will basically use the two tables:
- sales_report
- country_code
The diagram below shows what the tables look like, what are the columns and types. In the next stages of this tutorial" we will learn various SQL" syntaxes based on this model. Thanks to this, you will save time and you will not have to prepare data on your own. Moreover you get a ready model and you can focus only on learning the ins and outs of SQL".
Above all steps are required to have good start position which allow you went smoothly through this course. To summarize: be ready for the next part! 🙂