Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Hands-On Introduction to SQL with PostgreSQL
Rating: 4.5 out of 5(49 ratings)
4,191 students
Created byLukasz Kallas
Last updated 8/2025
English

What you'll learn

  • Understand how SQL and relational databases work
  • Install and run PostgreSQL on your machine
  • Create and manage database tables
  • Use data types like TEXT, INT, NUMERIC, and SERIAL
  • Write queries using SELECT, WHERE, and JOIN
  • Structure data using one-to-many relationships
  • Analyze data with GROUP BY and aggregation functions

Course content

3 sections • 19 lectures • 1h 59m total length

  • Welcome!2:28
  • Join Our Community0:04
  • What is SQL and Why PostgreSQL2:47
  • Installing PostgreSQL and pgAdmin12:32

    Install and configure PostgreSQL locally across Windows, macOS, and Ubuntu, install pgAdmin, set the PostgreSQL password, and connect to the database via pgAdmin to manage schemas and queries.

Requirements

  • No prior SQL or database experience needed
  • A computer (Windows, Mac, or Linux)
  • Willingness to learn by doing

Description

Welcome to Hands-On Introduction to SQL with PostgreSQL. I'm Lucas, a tech lead working in an international team with a passion for helping beginners start their tech journey in a simple and practical way.

In this course, we’ll take the mystery out of SQL — the language of data — using one of the most powerful and widely-used relational databases out there: PostgreSQL. Whether you're looking to become a developer, work with data, or just understand how modern applications store and access information, this course is your perfect starting point.

We'll begin with the absolute basics: what SQL is, how relational databases work, and why PostgreSQL is such a great tool for both beginners and professionals.

From there, we’ll build a mini bookstore project and get hands-on with essential SQL concepts:

  • How to install and set up PostgreSQL on any operating system

  • How to create tables and define your own schema

  • How to insert, update, and delete data

  • How to run powerful SELECT queries with filtering, sorting, and limits

  • How to connect tables with relationships and foreign keys

  • How to use joins to combine data across tables

  • How to analyze data with GROUP BY, COUNT, SUM, and other aggregate functions

By the end of this course, you won’t just understand SQL—you’ll feel confident creating and querying your own databases, ready to expand into projects, applications, or deeper data analysis.

So no matter if you're learning to code, working with data, or switching careers—you’re in the right place.

Let’s make SQL simple, practical, and rewarding!

Who this course is for:

  • Developers or DevOps engineers starting with databases
  • Bootcamp graduates or self-learners
  • Anyone curious about how data is stored and queried
  • People who prefer learning by doing, not slides

Report abuse