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.
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
In this tutorial" we will basically use the two tables:
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! 🙂
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?