Share this post and Earn Free Points!

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".

SQL Environment Setup - Complete Online Training

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".

SQL Environment Setup - Complete Online Training

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! 🙂

How useful was this post?

Click on a star to rate it!

Average rating 4.9 / 5. Vote count: 11

No votes so far! Be the first to rate this post.

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

Leave a Reply