PostgreSQL Tutorial for Beginners
January 27, 2025 2025-01-27 6:18
PostgreSQL Tutorial for Beginners
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
⭐️ 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
❤️ Support for this channel comes from our friends at Scrimba – the coding platform that’s reinvented interactive learning: https://scrimba.com/freecodecamp
source
Comments (48)
@programmingwithalex.585
If you'd like to show your support, you can also explore my course on Kotlin and Android development using a special discount code. Let's continue learning and growing together! https://www.udemy.com/course/kotlin-masterclass-learn-kotlin-from-zero-to-advanced/?couponCode=FREECODECAMP4AADC8F8
@avey_6607
I knew most of this queries but he explains each of it with its use cases which makes me understand where to use the query in application. This is very helpful. Thank you sir for this☺☺
@obrejaiulian6717
Recunosc accentul ala de roman oriunde în lume :)))) Mulțumim!
@dgjkbcchjhcfhh8124
For 2:38:15 you can also try this
SELECT payment_id, amount, DATE(payment_date) FROM payment
WHERE DATE(payment_date) = '2007-02-19';
@VK-pk8uz
Giasou Alexandru.
@neoTriny
COMPLETED !!! Nice one. Although the tutor was going a bit slow but that what makes it more natural and not robotic. Thanks and best wishes for the teacher 🔥
@jinkisaragi2673
damn… you use light background? you are abnormal dude
@alexandruscumpu3544
Felicitari! Foarte bun cursul!
@Onnashok
Best vedio bro
@CapDrew
it looks like you had the dvdrental file already in the downloads section in order to restore it. I didn't get that unless I missed it. I also am using mac and downloaded PostgeSQL/pgAdmin from homebrew so idk if that makes the difference.
@sakulluk
i am absolutely unable to understand all the positive comments. he only reads the slides, one whole chapter is duplicated, he could have mentioned more general stuff like how to make comments (you can do it with — and it is very useful to recycle your queries). the challenges are by far not challenging enough given what he is talking about in the theoretical parts. search for another tutorial if you are currently looking
@raidoung4100
I am already here 2:49:40 ;d gotta watch again the example with group by lol, dun understand much
i love that you use the grapical user interface :d That other dude whos got a 4h tutorial does everything in terminal. my "psql" command doesnt work, meaning cant be found and i dont wanna dwell in that:P
@subaru9773
to be honest for the first time you disappointed me with course… just waste of 5hours= 3hr video + 2 hr add
@praveenakhan4251
i've tried everything i couldn't restore the database someone please help me?
@chunchenglee174
There are two duplicate sections in counts topic
@thedonhub
The tutor is making the course boring if I'm being honest 😢.
@steveandro1810
This isn't what I expect from FreeCodeCamp. It feels more like an AI reading through slides rather than actual teaching. The content is very basic and could easily be learned in 30 minutes, yet it's stretched out over 3 hours.
@ShaqarudenGames
I would have PGAdmin open before starting each section of the video. No need to keep us waiting for ~25s each time.
@astralvolt6309
The start of the video ruined the installation. My pgadmin is not starting even
@pujasingha181
did not understand the second question's solution of group by challenge. Can anyone please help?
@mrlectus
I thought these videos was about Postgres and not SQL
@ZenTechnologist
30 minutes in, little about PostgreSQL really, more about SQL fundamentals.
@twig4237
strange course. not everyone can make courses
@debottamkar2364
avg video
@MohamedAlaa-vx5qn
What is the programing language use in this Crouse ❤
@codedusting
pgAdmin is installed in the first installer itself. No need to do it again.
@richardquadzie9124
Please any help on how to download the dvdrental.tar. Thank you
@liviugeorge9103
since it's clear a guy reading a text and since this is a tutorial, at least FIND A GUY THAT SPEAK OK!
@batuhanbatuhan6445
0:50 Whether I'm a Syrian database professional?
@malikayeshasiddiqa
how to deal wuth this error : C:/NEW/main.exe: error while loading shared libraries: LIBPQ.dll: cannot open shared object file: No such file or directory
@truongkham3845
where is the "Downloading Supplemental Resources" link?
@jeffsellers5468
After following this video instructions there are now two locations for pgAdmin4.
Start Menu->Programs->PostgreSQL
Start Menu->Programs->pgAdmin 4
I chose the 2nd one that we downloaded, which is the latest version.
the first one is included in the Postgres database download
@Caulene
this .tar situation is a nightmare
@mantravora6119
can someone tell me the timestamp of JOINS?
@arijitdn
Postgres tutorial without updating, inserting or deleting data?
@aviskafernando946
How can I download the dvdrental.tar file?
@ahmadhaidar7088
is there a part 2 with a final project in it?
@ahmadhaidar7088
is the count part repeated??
@SHADoff6939
Індуси…. ще трохи і моя психіка не витримає
@SonuDeVilliers149
Wow thank you for such a nice explanation ❤
@mickeyfounder
1:15:01 why COUNT given again? it already explained on 0:41:09
@bracket9731
and what language he spoke ?
@MerinaMotu
can you please upload the ppt slides as well?
@BrantK147
Welcome 🤖to the exciting 🤖 world 🤖 of relational databases. 🤖
@alext2664
As there is no link in the description for the exercise file needed to follow this tutorial, it's usefulness is extremely limited.
@EmreYavuzalp
Why you disabled auto subtitles for a video like this?
@anabildebnath2590
I got to realize that whether you write queries on MySql or Postgre, most of the syntaxes are xactly same!
@svkggl2778
Correct Title: "Learn SQL using Postgresql Database". Pls correct me if I am wrong?