Share This Post, Help Others, And Earn My Heartfelt Appreciation! :)
4.9
(11)

In this page we will focus on the 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.

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.

BigData-ETL: image 2

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.

BigData-ETL: image 1

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.

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments