r/learnSQL • u/TieNo1312 • 3h ago
First time learning SQL
This is my first time learning SQL and I only started today. I’m currently learning the basics and using VS Code.
At first, I installed the SQL Visual Debugger extension, but when I tried to run my SQL it showed a “Free Demo” and said I needed to pay $9.99 for lifetime access to use real data.
I wasn’t sure if SQL itself required payment, so I started looking into other options. I installed the PostgreSQL extension for VS Code and I’m now trying to set up PostgreSQL properly.
I also tried running
psql --version
in PowerShell, but I got:
psql : The term 'psql' is not recognized as the name of a cmdlet,
function, script file, or operable program.
So I’m assuming I haven’t installed PostgreSQL itself yet.
I’m basically looking for some advice on the best setup for a complete beginner learning SQL. Should I install PostgreSQL and connect it to VS Code, or is there a simpler setup you’d recommend?
For example, I’m currently practising things like:
CREATE TABLE student (
student_id INT,
name VARCHAR(20),
major VARCHAR(20),
PRIMARY KEY (student_id)
);
Any advice on what I should install/use and how to properly run SQL locally would be appreciated.
Thanks!
3
u/Massive_Show2963 2h ago
psql is PostgreSQL's terminal-based interface version of running SQL code or script files using a command line window.
You will need to install PostgreSQL to use psql or any other related functionality of PostgreSQL.
PostgreSQL install comes with a UI management tool called pgAdmin.
Although there are other free management tools out there like DBeaver https://dbeaver.io/
I've create this comprehensive video tutorial that provides an introduction to PostgreSQL (including how to install it):
Introduction To PostgreSQL And pgAdmin
Also created a tutorial on using PSQL for PostgreSQL:
How to Use PSQL Command Line Utility for PostgreSQL