Just installed PostgreSQL and pgAdmin and wondering what to do next?
This video is the **setup for my free SQL in Practice course**. We’ll create our first PostgreSQL database, open the Query Tool in pgAdmin, run the sample SQL script, and get everything ready for the SQL lessons that follow.
We’ll be working with a simple **car rental database** containing users, cars, locations, and bookings — so throughout the course, we’ll learn SQL using realistic data instead of completely abstract examples.
In this setup video, you’ll learn how to:
• Create a database in PostgreSQL
• Use pgAdmin’s Query Tool
• Run a SQL setup script
• Create tables and relationships
• Insert sample data
• Check that your database is ready
• Prepare your environment for the SQL lessons
The complete SQL setup script is available in the description so you can build the same database and follow along.
After this, we’ll start working with SQL fundamentals such as:
SELECT
WHERE
ORDER BY
GROUP BY
HAVING
DISTINCT
JOINs
Subqueries
Window Functions
and much more.
Need help figuring out what to learn next?
I offer 1:1 career consultations for junior and mid-level engineers.
👉 Apply here: vladalipska.com
✅ SQL Script:
https://github.com/vladalipska/SQL-Time-with-Vlada/blob/main/SQL-BASICS-SAMPLE-DATA.txt
If you already have PostgreSQL, pgAdmin, and the database ready, **you can skip this video and go straight to the next SQL lesson.**
Welcome to **SQL in Practice** — let’s learn SQL by solving real problems.
#PostgreSQL #SQL #SQLTutorial #LearnSQL #pgAdmin #SQLForBeginners #PostgreSQLTutorial