Let us understand how to setup and use SQL Workbench.
Why SQL Workbench
Let us see the details of why we might have to use SQL Workbench.
Using Database CLIs such as psql for postgres, mysql etc can be cumbersome for those who are not comfortable with command-line interfaces.
Database IDEs such as SQL Workbench will provide required features to run queries against databases without worrying too much about underlying data dictionaries.
SQL Workbench provides required features to review databases and objects without writing queries or running database specific commands.
Also Database IDEs provide capabilities to preserve the scripts we develop.
In short Database IDEs such as SQL Workbench improves productivity.
There are several IDEs in the market.
Install SQL Workbench
Here are the instructions to setup SQL Workbench.
Once installed we need to perform below steps which will be covered in detail as part of next topic.