Stage 1 · Lesson 5 of 8
pgAdmin as your GUI
is the graphical tool for . Register your local server in it, then browse databases, (named folders of tables) and tables in the object tree. Open the Query Tool to write and run SQL, with history and autocomplete.
Its EXPLAIN button draws as diagrams, which will help in the performance stage. When you create a table through a dialog, open the SQL tab and read the statement it generates. That way the tool teaches you SQL instead of hiding it. DBeaver or the PostgreSQL extension for VS Code are good alternatives if you prefer them.
Common trapdoing everything through dialogs and never learning the statements, which leaves you stuck on a server that only has psql.
A question to check yourself, an AI practice session and 1 cheat sheet entry come with the full roadmap. Unlock
Resources for this stage
Start with· follow one of these
- CourseFreeCS50's Introduction to Databases with SQL
Harvard University · Beginner
Watch Lecture 0 (Querying) for the relational model; it uses SQLite, and the ideas carry straight across
- GuideFreePostgreSQL Tutorial
PostgreSQL Global Development Group · Beginner
The short official tutorial: Chapters 1 and 2 cover creating a database and your first tables