THIS SECTION IS UNDER CONSTRUCTION!!!

sql-learning-kit

It's hard enough to setup proper learning environment for learning SQL basics, so i decide to make one not so complicated. Welcome to one of mine "1-3 hours project", and feel free to contribute or fork.

Requirements

1. Some kind of terminal with administrative permissions;
2. git is installed;
   • To check, run git -v
   • To install, please follow the instructions
3. Docker is installed;
   • To check, run docker -v in the terminal
   • To install, please follow the instructions
4. Some browser is installed (optional);
   • You can choose any, or if you prefer GUI software, you can go to 4.
5. DBeaver or some other DB software, compatible with postgresql is installed (optional);
   • If you don't want to install any DB software, you should at least have some browser installed.
   • To install DBeaver, please follow the instructions
6. ports 4444, 5555, 5432 is free.

!!!IMPORTANT INFORMATION

Don't forget to always switch off your environment after working. At least, change all default passwords to your's. You can shutdown the environment by different ways. First off all, if you not familiar with Docker, just remember to always follow the instructions from running section

Running the environment

This isn't proper production environment! Don't use it on any kind of server, or cloud! You should use it only on your desktop or laptop, from you are learn SQL and only for learning purposes.

To get the environment

• Windows:

  1. Press win+r.
  2. Type powershell (or cmd).
  3. Clone this repository: git clone https://github.com/FeorPrime/sql-learning-kit.git.

• Linux:

  1. Open your terminal (i hope, as a linux yser, you already know how to).
  2. Clone this repository: git clone https://github.com/FeorPrime/sql-learning-kit.git.

• MacOs:

  1. press command + space.
  2. type terminal (or whatever terminal you use).
  3. Clone this repository: git clone https://github.com/FeorPrime/sql-learning-kit.git.

To run the environment

Open