SQL Tutorial for Beginners 1: Installing PostgreSQL and Creating Your First Database

SQL’s value for beginners comes down to practicality: most software systems rely on databases, and SQL offers a relatively small set of core commands for common tasks like filtering and retrieving data. That makes it a strong on-ramp for computer science and programming careers, especially compared with learning a full programming language’s syntax and logic. With that motivation, the setup process focuses on getting a working PostgreSQL environment so SQL queries can be run immediately.

The tutorial walks through installing PostgreSQL on a Mac using the “Postgres.app,” a native macOS app that runs in the menu bar and avoids a traditional installer. After downloading and moving the app into the Applications folder, the PostgreSQL server starts and shows an elephant icon indicating it’s running on port 5432. The app also offers an option to open a command-line interface for issuing database commands.

To create a first database, the tutorial uses the command-line tool with a simple SQL statement: `create database sample_db;` (ending the command with a semicolon). It then verifies the new database by listing databases with `\\l`, confirming that `sample_db` now exists alongside the default databases created during installation. Exiting the command line is done with `\\q`.

Because command-line output can be harder to visualize, the tutorial adds a graphical interface: “pgAdmin” is not used here; instead it installs “PSequel,” chosen for a clean layout and the ability to enlarge fonts—useful for recording and readability. After installing and launching PSequel, a macOS security prompt may appear (“developer cannot be confirmed”); the workaround is to right-click and choose “Open” to proceed.

With PSequel running, the connection settings largely follow defaults, including port 5432, which must match the PostgreSQL server’s port. The key change is selecting the database name created earlier: `sample_db`. Once connected, the database initially appears empty because no tables exist yet.

From there, the tutorial demonstrates the next step conceptually: creating a table (named `test_table`) and adding at least one column (column `a`). After running the table-creation SQL and refreshing the table list in the interface, the new table appears with the expected column structure. The takeaway is a complete starter workflow—install PostgreSQL, create a database, connect through a GUI, and run SQL to create tables—setting up the next tutorial to focus on adding tables and writing more detailed SQL commands.