PostgreSQL Tutorial for Beginners

Overview

Learn PostgreSQL, one of the world's most advanced and robust open-source relational database systems. Whether you're a beginner looking to set up your first database, or a seasoned developer aiming to scale and optimize complex data structures, this course has something valuable for you.

✏️ Alexandru Cristian created this course.

Watch his Complete Android & Kotlin Development Course: https://www.udemy.com/course/kotlin-masterclass-learn-kotlin-from-zero-to-advanced/?couponCode=FREECODECAMP4AADC8F8

❤️ Try interactive Databases courses we love, right in your browser: https://scrimba.com/freeCodeCamp-Databases (Made possible by a grant from our friends at Scrimba)

⭐️ Contents ⭐️

(0:00:00) PostgreSQL Introduction

(0:02:03) Windows Installation - PostgreSQL and PgAdmin with Database Setup

(0:17:12) SELECT statement

(0:27:25) SELECT Challenge

(0:31:17) SELECT DISTINCT

(0:39:13) SELECT DISTINCT Challenge

(0:41:09) COUNT

(0:54:03) SELECT WHERE

(1:02:13) SELECT WHERE Example

(1:11:19) SELECT WHERE Challenge

(1:15:01) COUNT

(1:27:56) ORDER BY

(1:35:21) LIMIT

(1:42:05) BETWEEN Statement

(1:48:48) IN Statement

(1:54:18) LIKE and ILIKE

(2:11:00) General Challenge

(2:14:28) Aggregate Functions

(2:20:02) GROUP BY

(2:26:08) GROUP BY example

(2:37:17) GROUP BY Challenge

(2:38:22) HAVING command

(2:48:05) AS Statement

🎉 Thanks to our Champion and Sponsor supporters:

👾 davthecoder

👾 jedi-or-sith

👾 南宮千影

👾 Agustín Kussrow

👾 Nattira Maneerat

👾 Heather Wcislo

👾 Serhiy Kalinets

👾 Justin Hual

👾 Otis Morgan

👾 Oscar Rahnama

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://freecodecamp.org/news

Chapters 23

0:00:00PostgreSQL Introduction
0:02:03Windows Installation - PostgreSQL and PgAdmin with Database Setup
0:17:12SELECT statement
0:27:25SELECT Challenge
0:31:17SELECT DISTINCT
0:39:13SELECT DISTINCT Challenge
0:41:09COUNT
0:54:03SELECT WHERE
1:02:13SELECT WHERE Example
1:11:19SELECT WHERE Challenge
1:15:01COUNT
1:27:56ORDER BY
1:35:21LIMIT
1:42:05BETWEEN Statement
1:48:48IN Statement
1:54:18LIKE and ILIKE
2:11:00General Challenge
2:14:28Aggregate Functions
2:20:02GROUP BY
2:26:08GROUP BY example
2:37:17GROUP BY Challenge
2:38:22HAVING command
2:48:05AS Statement

Advantages and disadvantages

Advantages

Completely free, with no ads inside the lessons.
Project-based: you build real apps as you learn.
freeCodeCamp's own certifications are free and well known among developers.
Free, one long video that covers a topic end to end.
Use the chapters to jump to what you need.
576,260 views, so help and notes are easy to find.
Completely free.
Self-paced: start any time.

Disadvantages

YouTube videos are long single recordings; you pace yourself.
Less theory than a university course.
No exercises or certificate: code along to make it stick.
No certificate.
No graded assignments or feedback.

Some points apply to every course of this kind; see how we rank.

Free

Free: Watch on YouTube, no account needed.
Certificate: None. Code or take notes along to make it stick.

freeCodeCamp is in Tier 3: good universities, respected companies, nonprofits and well-known teachers of our institution ranking (78/100). Free full courses and certifications; practical, but not university-level depth.