Learn PostgreSQL Tutorial - Full Course for Beginners

Подписаться 10 млн

Просмотров 2,5 млн

50% 1

Learn how to use PostgreSQL in this full course. PostgreSQL is a general purpose and object-relational database management system. It is the most advanced open source database system widely used to build back-end systems.
⭐️ Contents ⭐️
⌨️ (0:03:16) What is a Database
⌨️ (0:05:17) What is SQL And Relational Database
⌨️ (0:09:10) What is PostreSQL AKA Postrgres
⌨️ (0:10:53) PostgreSQL Installation (Mac OS)
⌨️ (0:14:21) PostgreSQL Installation (Windows)
⌨️ (0:17:38) GUI Clients vs Terminal/CMD Clients
⌨️ (0:21:39) Setup PSQL (MAC OS)
⌨️ (0:25:22) Setup PSQL (Windows)
⌨️ (0:30:15) How to Create Database
⌨️ (0:33:35) How to Connect to Databases
⌨️ (0:38:12) A Very Dangerous Command
⌨️ (0:41:37) How To Create Tables
⌨️ (0:45:46) Creating Tables Without Constraints
⌨️ (0:49:12) Creating Tables with Constraints
⌨️ (0:55:55) Insert Into
⌨️ (0:59:14) Insert Into Example
⌨️ (1:02:36) Generate 1000 Rows with Mockaroo
⌨️ (1:12:28) Select From
⌨️ (1:15:18) Order By
⌨️ (1:19:53) Distinct
⌨️ (1:21:59) Where Clause and AND
⌨️ (1:25:29) Comparison Operators
⌨️ (1:29:35) Limit, Offset & Fetch
⌨️ (1:32:43) IN
⌨️ (1:35:43) Between
⌨️ (1:37:45) Like And iLike
⌨️ (1:43:10) Group By
⌨️ (1:46:41) Group By Having
⌨️ (1:52:08) Adding New Table And Data Using Mockaroo
⌨️ (1:55:40) Calculating Min, Max & Average
⌨️ (1:59:48) Sum
⌨️ (2:01:55) Basics of Arithmetic Operators
⌨️ (2:05:59) Arithmetic Operators (ROUND)
⌨️ (2:09:43) Alias
⌨️ (2:12:32) Coalesce
⌨️ (2:16:15) NULLIF
⌨️ (2:20:21) Timestamps And Dates Course
⌨️ (2:23:21) Adding And Subtracting With Dates
⌨️ (2:25:58) Extracting Fields From Timestamp
⌨️ (2:27:28) Age Function
⌨️ (2:29:24) What Are Primary Keys
⌨️ (2:31:23) Understanding Primary Keys
⌨️ (2:36:26) Adding Primary Key
⌨️ (2:40:55) Unique Constraints
⌨️ (2:49:15) Check Constraints
⌨️ (2:54:45) How to Delete Records
⌨️ (3:01:36) How to Update Records
⌨️ (3:05:55) On Conflict Do Nothing
⌨️ (3:11:09) Upsert
⌨️ (3:16:41) What Is A Relationship/Foreign Keys
⌨️ (3:19:48) Adding Relationship Between Tables
⌨️ (3:25:04) Updating Foreign Keys Columns
⌨️ (3:29:30) Inner Joins
⌨️ (3:35:17) Left Joins
⌨️ (3:40:53) Deleting Records With Foreign Keys
⌨️ (3:47:27) Exporting Query Results to CSV
⌨️ (3:50:42) Serial & Sequences
⌨️ (3:57:18) Extensions
⌨️ (3:59:39) Understanding UUID Data Type
⌨️ (4:05:54) UUID As Primary Keys
⌨️ (4:16:30) Conclusion
✏️ Course from Amigoscode.
🔗 Subscribe to Amigoscode RU-vid channel | bit.ly/2HpF5V8
🔗 Visit Amigoscode.com for more courses | bit.ly/2JgGW0w
🔗 Full Playlist Available Here | bit.ly/2ClGPdY
🔗 Follow Amigoscode on Instagram | bit.ly/2TSkA9w
🔗 Join Amigoscode Closed Facebook Group | bit.ly/2FbuIkx
--
Learn to code for free and get a developer job: www.freecodecamp.org
Read hundreds of articles on programming: medium.freecodecamp.org
And subscribe for new videos on technology: ru-vid.com_cent...

Опубликовано:

3 апр 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 2 тыс.

@AmanSinghYT 4 года назад

⭐️ Contents ⭐️ ⌨️ (0:03:16) What is a Database ⌨️ (0:05:17) What is SQL And Relational Database ⌨️ (0:09:10) What is PostreSQL AKA Postrgres ⌨️ (0:10:53) PostgreSQL Installation (Mac OS) ⌨️ (0:14:21) PostgreSQL Installation (Windows) ⌨️ (0:17:38) GUI Clients vs Terminal/CMD Clients ⌨️ (0:21:39) Setup PSQL (MAC OS) ⌨️ (0:25:22) Setup PSQL (Windows) ⌨️ (0:30:15) How to Create Database ⌨️ (0:33:35) How to Connect to Databases ⌨️ (0:38:12) A Very Dangerous Command ⌨️ (0:41:37) How To Create Tables ⌨️ (0:45:46) Creating Tables Without Constraints ⌨️ (0:49:12) Creating Tables with Constraints ⌨️ (0:55:55) Insert Into ⌨️ (0:59:14) Insert Into Example ⌨️ (1:02:36) Generate 1000 Rows with Mockaroo ⌨️ (1:12:28) Select From ⌨️ (1:15:18) Order By ⌨️ (1:19:53) Distinct ⌨️ (1:21:59) Where Clause and AND ⌨️ (1:25:29) Comparison Operators ⌨️ (1:29:35) Limit, Offset & Fetch ⌨️ (1:32:43) IN ⌨️ (1:35:43) Between ⌨️ (1:37:45) Like And iLike ⌨️ (1:43:10) Group By ⌨️ (1:46:41) Group By Having ⌨️ (1:52:08) Adding New Table And Data Using Mockaroo ⌨️ (1:55:40) Calculating Min, Max & Average ⌨️ (1:59:48) Sum ⌨️ (2:01:55) Basics of Arithmetic Operators ⌨️ (2:05:59) Arithmetic Operators (ROUND) ⌨️ (2:09:43) Alias ⌨️ (2:12:32) Coalesce ⌨️ (2:16:15) NULLIF ⌨️ (2:20:21) Timestamps And Dates Course ⌨️ (2:23:21) Adding And Subtracting With Dates ⌨️ (2:25:58) Extracting Fields From Timestamp ⌨️ (2:27:28) Age Function ⌨️ (2:29:24) What Are Primary Keys ⌨️ (2:31:23) Understanding Primary Keys ⌨️ (2:36:26) Adding Primary Key ⌨️ (2:40:55) Unique Constraints ⌨️ (2:49:15) Check Constraints ⌨️ (2:54:45) How to Delete Records ⌨️ (3:01:36) How to Update Records ⌨️ (3:05:55) On Conflict Do Nothing ⌨️ (3:11:09) Upsert ⌨️ (3:16:41) What Is A Relationship/Foreign Keys ⌨️ (3:19:48) Adding Relationship Between Tables ⌨️ (3:25:04) Updating Foreign Keys Columns ⌨️ (3:29:30) Inner Joins ⌨️ (3:35:17) Left Joins ⌨️ (3:40:53) Deleting Records With Foreign Keys ⌨️ (3:47:27) Exporting Query Results to CSV ⌨️ (3:50:42) Serial & Sequences ⌨️ (3:57:18) Extensions ⌨️ (3:59:39) Understanding UUID Data Type ⌨️ (4:05:54) UUID As Primary Keys ⌨️ (4:16:30) Conclusion

@hejsjsi2449 2 года назад

THANKS

@mendylanda125 2 года назад

Thanks!

@sattasundertalukder1972 2 года назад

awesome man...Thanks a bunch.....

@abbiemorancie547 2 года назад

GREAT! THANKS MEHN

@venusbahrami2875 2 года назад

Thanks, can you send the link that he talks about it at 1:54?

@andrerangel7654 5 лет назад

Somebody give that man a medal!!

@zbigniewbrzezinski8869 4 года назад

I will !

@smile-tk7yt 3 года назад

@@zbigniewbrzezinski8869 😅😂😅😂

@allanmachado2011 3 года назад

big agree

@zes3813 3 года назад

wrr

@ouichoulhicham5726 3 года назад

i only have a cookie

@calvinbarajas5144 3 года назад

This lecture is amazing because (a) Nelson knows the exact technical terminology, (b) he is very patient and methodical, (c) covers the basics very well, (d) gives professional insight into how to use PostgreSQL.

@elco7956 Год назад

**proceeds to call an asterisk a star**

@user-xw4mu6nz4t Год назад

@@elco7956 I've been a web developer for 7 years and I still do that.

@IceEnglish-ii7jv Год назад

@@elco7956 asterisk AS star 😮

@electrolyteorb Год назад

@@elco7956 @IceEN Holy mother of GOD!!!!

@dzzygaming 2 месяца назад

@@elco7956 imagine being overly critical because someone didnt say asterisk XD

@mercantilism954 Год назад

Note for beginners: 34:50 Here, he is using a command prompt, not postgres shell. If " psql - -help" does not work on your terminal, you need to add an environment variable. This video explains how to add one. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0EBkVzIBnoc.html 35:44 If your password does not work, use 'postgres' for the username. Your code should look like this " psql -h localhost -p 5432 -U postgres test" This is simply because you have not created a user account called 'user'

@omar-bb3dv Год назад

thank you so much

@chantelboiro3899 Год назад

Thank you! I was wondering what I was missing

@JadeObidosXP Год назад

I was wondering why that part doesn't work on my end. Thank you so much for this!

@leishmaniaful Год назад

Thanks, man. How can they miss this from the video? freecodecamp tutorials used to be proficient...

@windows99 Год назад

Oh my god. I was so confused why it doesn't work on my part. Thank you so much.

@user-ro2do2uh5y 4 года назад

Thank You for using easy English. I understand a lot of. Respect from Russia with 41 peoples.

@nyteskun 4 года назад

41+1

@sergeyvechkitov221 4 года назад

@WeirdAlSuperFan 4 года назад

just fyi this guy's English is terrible, but hey at least it's simple

@user-mh7kx3oo7t 4 года назад

@nabil libre just racist up there

@diegodelsol1309 4 года назад

@@WeirdAlSuperFan How so? He is speaking slowly and clearly and obviously has a good grasp of the concepts.

@sewind6613 2 года назад

That someone would take their time to make such a complete set of tutorials, and to make them available for free, is amazing. Words are not enough to express my gratitude, and my respect for you.

@Friend_2162 6 месяцев назад

I believe they were not free in the beginning. We can just appreciate they are free eventually after just 4 years :)

@alexnavarro2628 2 года назад

Seriously a 10/10 course! I sat down and watched this whole thing in a single session. I seriously appreciate your teaching style, and how well you explained everything. Thank you!

@kieranbarker1902 3 года назад

This video is excellent. I'm only as far as creating tables (around the 41-minute mark) but it's already better than the courses I could find on Udemy! Thank you! 🙏

@madhanmurali4877 4 года назад

Completed till WHERE Clause and you're getting straight to the point without wasting time. It is really helpful for a complete newbie like me. Thank you!

@gwagner3446 5 лет назад

Dude, this course was VERY GOOD! Basically binged through the whole 4 hours and felt like no time! Very didactic and well explained. THANK YOU SO MUCH FOR THIS AMAZING CONTENT!!

@stalinengoma7680 3 года назад

Very comprehensive video. I didn’t know about any database before and this man just plugged everything I needed to know how databases work. Thank you man

@gunk4196 Год назад

The fact that this is free is insane! A very good course on Postgres. I finished this in less than 24 hours and before starting I didn't even know what 'SQL' was but now I feel like I have a solid understanding of Postgres.

@richumathew7352 2 месяца назад

Also train and make project before you forget

@LordBenjamin1998 5 лет назад

One of the best tutorials out here for PostgreSQL, the explanation is clear and the pace of it is great for beginners. Props to you.

@arvi8843 3 года назад

Thank you so much for congratulating me by the end of this video for finishing this course. I learned a lot! 💯 💯 💯

@banisan2035 2 года назад

Thank you so much for this tutorial! It always fills me with joy when so much effort is put into something that simply benefits everyone without expecting anything in return. So much wholesome altruism in the IT community.

@richard1991ish 21 день назад

also just going to take a moment to appreciate how excellent this tutorial is. Clear, concise, straight to the point with real-world examples. Worked through the whole thing, and learned a TON. TYSM! ⭐⭐⭐⭐⭐

@chriswilson8584 5 лет назад

The best PostgresQL tutorial I've seen so far.

@m.alisetiapratama6932 5 лет назад

What a timing! Just in time when I want to learn it. Appreciate it a lot guys!

@kasperkat2004 2 года назад

Nelson, you outdid yourself with this! I am using Windows and psql and it works. There are no problems with it. But I have been using command lines/terminals for years. Thanks again Lad.

@nasxmo 2 года назад

Really great course with great pace! Finished more than 3 hours in one sitting. Thanks !

@TheAremoh 5 лет назад

From being scared to run sql command from command line to liking it. Thanks for this awesome video

@brian1801 3 года назад

Nelson -- quite simply -- YOU ROCK!!! Seriously outstanding content, videos and presentation skills. Thank you for taking the time to create this awesome course. Wishing you nothing but the greatest success!

@itsReshad 2 года назад

I cant believe the quality of content and explanation in this video. Brilliant course explaining PostgreSQL. Very easy to follow - Highly recommend it!

@dalvandi 2 года назад

Tutorial really gets down to the basics and is a really good starting point for beginners like myself with no previous experience with databases! Especially cool that you covered the installation for both MacOS and Windows!

@xilllllix 2 года назад

indeed! what a great teacher and lecture! i feel like i can do whatever i want now with Postgres...

@TubeSwarn 4 года назад

The teacher's pace is just awesome!! He is the best teacher in the world.

@TonnySanjiao 5 лет назад

Great work man. Thank you from Barcelona. I like your voice, it's very clear to understand to non English-speaking like me.

@yunjiehong4649 4 года назад

Really clear accent! Easy to understand. Thank u, bro.

@mgultas 3 года назад

This video is one of the best SQL and PostgreSQL intro videos that I have come across. Thanks.

@rbartig 3 года назад

Dude, be proud, this is an awesome video for getting started with Postgres.

@mythic414 2 года назад

Thank you for this video! You're a great teacher and the material was clear and straight to the point. Definitely one of the best online courses i've come across

@harlanreece2348 2 года назад

I am reaching out to you because your post appears to be the most recent. I have a basic question that you may be able to answer. No luck reaching Nelson.

@random-0 10 месяцев назад

@@harlanreece2348 you should have asked the doubt directly in the comment

@Terzaghi12 3 года назад

For Windows users, the command 'psql' only will work if you edit the environment variables and add 'C:\Program Files\PostgreSQL\13\bin' to your path, the 13 it's the version of Postgres i've installed. After that, the command you have to enter on the cmd or powershell is: psql -U postgres then it will ask for the password you set on the installation

@karljasoncangas8525 Год назад

thanks Capt.

@anwinkon242 Год назад

thanks this really worked for me

@manisha_nair 11 месяцев назад

Thanks a lot man!

@nikethvelala5424 10 месяцев назад

Thank you 🫡

@sirhuman560 5 месяцев назад

Thank you brotherrr :))

@edzams Год назад

Thanks so much for this course and all the other wonderful courses you've put up. Please keep up the good work. I really appreciate you guys.

@chrisgousset8673 2 года назад

One of the best tutorials I have ever sat through, thank you so much!

@adamrolczyk7217 2 года назад

It was my long long dream to learn Postgres. I watched the entire video almost in one sitting, making notes in vscode and using commands in terminal. Thank you so much for sharing this knowledge. Can't wait to use it to build something cool.

@sadramohh 2 года назад

Can we maybe have the notes? pretty please?

@phen2841 2 года назад

For anyone who needs the resource link for 3:19:48 (Adding Relationship Between Tables): drive.google.com/drive/folders/1v0I19Ed2his8otHRLm5i6W7feD9sIMc6

@AnujKumar-to7mt Год назад

thanks a lot bro

@ThanhTran-ki1lz Год назад

You saved my ass. Thank you.

@subinkv6849 Год назад

Thank you bro

@alexandredejoncairenarten1906 2 месяца назад

Cheers

@P0P0_xyz288 22 дня назад

Thanks a lot dawg

@Pakmerchant 3 года назад

It's hard to believe this course is free! Thanks man you were a great help

@YounisJad 3 года назад

thanks man, this is the best crash course into SQL, and postures, I have really enjoyed it!

@scienceofart9121 4 года назад

I'm only in the 20th minute but I liked this tutorial soo much, Thanks man !

@khateebanwer7466 2 года назад

For someone who is following this tutorial currently : 1) at around 01:06:00 when you go through the SQL file in VSCode , do change the value of varchar of gender greater than 20 because Mockaroo includes more than 2 genders in randomly generated database which will throw an error during its execution through cli when not changed. 2)When using terminal (for windows users ) , you might get errors during execution of sql file through cli due to path format which can easily be dealt with --> before even opening your postgres ,navigate through the command line where the actual file is located and then open postgres and use \i filename.extension to execute your file. 3)When installing postgres , always provide passwords without any alphanumeric characters like "$" otherwise it will throw an error during the installation phase ( I don't know what is that error as it was really vague but this worked for me).

@TheBenTonks 2 года назад

just so you know you can also change the data Mockaroo gives, you can set it to only be male and female

@khateebanwer7466 2 года назад

@@TheBenTonks Thanks for the information , brother.

@MrMadmaggot 2 года назад

In ubuntu when I try to import the person.sql it denies me the permission.

@Technomic-o Год назад

Thanks man , can you please elaborate more on pointe 2 ? following the way mention on the video Im getting missing requirement error . i even went through the command line where the actual file is located and used \i filename.extension but still not able to execute it

@facundoarrascaeta3143 Год назад

@@Technomic-o I used i\ 'C:/Users/:myuser/Downloads/person.sql' on windows and it worked, you have to put the path in quotes

@danielnadar75 2 года назад

This is one of the best SQL course out there for FREE!!! I can't praise enough of this course and the instructor, I always feared SQL until I took this course and I can now call myself a SQL pro! Thanks Nelson for this amazing course.

@vladimiraleksic4066 5 месяцев назад

Great job. I am enrolled in the Code Institute online boot camp and the tutorials there cannot be compared with this material in terms of quality. Thank you a lot.

@O_o___o_0 2 года назад

First thank you so much for this amazing course, easy to follow and straight to the point For those like me that will be learning on PostgreSQL 14, at 33:50 he uses the command psql --help for the option help and on Windows and PSQL 14 it's actually the \? options command that will give you the same result.

@SamareshMaity231 2 года назад

thanks Johan

@olamideadigun9206 2 года назад

So many things have changed with mockaroo too. My Gender column has 8 inputs so you don't have to add Hello to practice CHECK CONSTRAINT.

@SHrehman12 2 года назад

OMG, Thank you

@kalamansihans 2 года назад

thanks! I didn't notice this helpful comment. Anyway another work around I found for this is to go to the directory of the bin folder and enter psql --help. It works the same.

@ady4230 2 года назад

Thanks man

@antonkorshunov4979 5 лет назад

My applause to the speaker! Enough deep and straightforward material at the same time!

@datchuravi159 3 года назад

Excellent course you deserve a medal for making it this easy!

@melanieprevot4926 Год назад

Definitely the best psql tutorial for beginners i have ever seen ! Thank you sir.

@michaelvigato3228 5 лет назад

Boi this is excellent, it's really hard to believe this is free

@kjane3390 3 года назад

I am only 8.42 minutes through and I already felt the urge to thank you for such an incredible video. I have a terrible attention span and I am genuinely excited for what the next 4 hours will bring. Thank you thank you thank you!!!!!

@user-xw4mu6nz4t Год назад

Legend has it Mr. Terrible-Attention-Span still hasn't finished the video,

@shashanksingh4968 Год назад

This is an awesome go to guide for learning Postgres SQL DB for an absolute beginner, you can get your SQL refreshed also along the way. I learnt a lot along the way, though the course is bit outdated for November 2022, have some execution errors for the queries shown in videos, but thanks to people in comment section who become savior and help the fellows out along the way. Happy Learning team. Let's code something! ❤❤

@kokoyoke2775 3 года назад

Working as an oracle dba, even non IT employees could use this db. This is really help me to learn postgres, respect sir!!!

@krzysztoflechowski81 5 лет назад

you are great, I wish your tutorial was there when I started my SQL journey 15 years ago.

@kirollosmagdy275 5 лет назад

does it mean that after 15 years of experience , you're still looking for tutorials ? , omg what scary future do we juniors have 😅

@krzysztoflechowski81 5 лет назад

@@kirollosmagdy275 you'll allways be learning as there's more to know, not that scary these days. I haven't worked on PG as much as on other databases. I knew it was great, but haven't had a chance in my projects. The more I appreciate how effective the author made it here.

@user-io4jl9ev3z Год назад

Thank you so much! Such a great job you've did. Wish you all the best and inspiration to learning people. Thank you again!

@alexandrspiridonov9569 2 года назад

It is not the first PostgreSQL tutorial I watch, but this one is the best. Thank you)))))

@earthmother4599 2 года назад

Just finished; took a few days (I like to let info settle in) but worth every minute! Thank you!

@user-mv8nk8tl9r 5 лет назад

Thanks from Russia. Great tutorial!

@EuanFR 2 года назад

Really good, for beginners or as a refresher to prepare interviews. Just a small improvement that could be made: I was especting a chapter to explain (summarize) the differents types of alter table queries (ie ADD, DROP, MODIFY, CHANGE). It would be an honor to help you providing a french version of these courses.

@ihorrud5088 9 месяцев назад

The best tutorial I've ever seen for PostgreSQL!

@steeven094 3 года назад

Thank you for making this video. It really helped me. In fact, it has helped me several times, and not only on the PostgreSQL database.

@tejasparekh6808 4 года назад

Amazing explanation man!!! you just made my lockdown fruitful....thanks a lot.

@gouravgoel2974 4 года назад

great

@OladipupoPopoola 5 лет назад

Wow! I just finished this course and I must confess you took me from a noob to an intermediate pro. Thank you so much. but I can't fid your other courses.....please share link in reply. I really appreciate. God bless you bro.

@ciscogopro8481 Год назад

Thank you Nelson, I went through the whole video and for the first time after so many tutorial finally I understood and learn about database and Postgres. Thank you do much for make easy for newbies.

@laurscode5778 3 года назад

So I usually don't like tutorials but this one was really cool and the author really know what he is teaching about. Explained in a really easy way so everybody will understand that)

@John-fd9fe 2 года назад

I love the fact that we have timestamps. I already knew a lot of SQL, I just needed to learn PostgreSQL and I could skip a lot of the lessons. Thank you very much.

@fahansheikh Год назад

for user using ubuntu/linux(check if postgres is preinstalled in your system) following the installation steps may cause installation of two versions of postgres simultaneously which can cause unnecessary trouble for beginners.

@naveenkalhan95 3 года назад

my first freecodecamp video that I watched until the end ... cheers man, thanks a lot

@smcatapan 3 года назад

Thank you very much! You helped me a lot on gaining knowledge with SQL and POSTGRES in general.

@vs4vijay 5 лет назад

Very Informative!!! Watched the whole video in 1.25x speed. I would suggest to walk us through on TRIGGERS, VIEWS, INDEXING, TRANSACTIONS and JSON data handling.

@smyasir0 5 лет назад

good suggestion Soni ! you know any tutorials regarding these ?

@franciscojavierramirezhern8588 5 лет назад

I had a lot of extra work trying to follow some parts of this awesome course, the difference between MacOS and Windows are tinny, but important, when you try to import file using \i you must have to use '/' not '\' and other differences that I had to search on google and stack, but finally.... Thanks for sharing this course, I appreciate this. I heard something that bad MySql settings are so dangerous and complicate to fix and protect from SQL injection, so, he said PostgreSQL is more secure and flexible, but I just looking for answers. Anyway, nice work! greetings!

@yepyepyep3 4 года назад

thanks! needed help with that exact part

@Nephros 2 года назад

Thanks a lot

@tunmbi_okediran 6 месяцев назад

Yeah, thanks a bunch

@davidmurinda4658 3 года назад

Brilliant. You made it simple enough for anyone to grasp.

@lucasfrnnsr1348 3 года назад

Thank you for the course, you speak so clearly and that's quite helpful man.

@Ou8y2k2 5 лет назад

1:21:60 should be 1:21:59 in the description. Thanks for the course.

@sarathradhakrishnan2135 3 года назад

I must admit, this is way more better than some Udemy courses.

@reynaldlamury4772 2 года назад

there is also good course about postgreSQL there in udemy from Jose Portilla if iam not mistaken

@abdikhaliqmohamoud3373 2 года назад

The best and complete PostgreSQL Course out there.

@farahanib4960 Год назад

All i can say is wow.. just from the very beginning, i added more learnings prior to what i have. Thanks a lot🙏and more power...👌

@fernandopineda2414 4 года назад

I recommend you guys to put a couple of advertisements, I'd watch both entirely. I'm very grateful with you all for your extraordinary job.

@niyazi95 3 года назад

33:39 guys if you cant run "psql" command in the command line, you must add it to system environments, find the postgresql folder in C:\ and add its "bin" folder to "Path" variable in the env.

@divakarsiva623 3 года назад

@Niyazi Yildirim can u explain in detail....since many of us have the same problem

@mergenberdiyev8438 3 года назад

@@divakarsiva623 Maybe it's already late, but here is a video how to do that ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0EBkVzIBnoc.html&ab_channel=jinujawadm

@arpansingh4284 2 года назад

@@mergenberdiyev8438 Nope , its never late . Thanks !

@billyssk666 2 года назад

@@mergenberdiyev8438 This tutorial doesn't work with version 14. There is no "bin" folder with the psql.exe file. Anyone have another fix?

@yatskovych 2 года назад

@@billyssk666 worked just fine for me (version 14.1). Maybe you didn't see bin folder of psql.exe file

@semujjuderickscofield3029 Год назад

this was my first postgresql tutorial, it's very simple and straight forward, Thank you very much bro

@sandeepgande 3 года назад

Great tutorial, easily understandable even for beginners... Hats off for your work...

@Ian69885 5 лет назад

I can not thank you enough. you explain the subject way better than my lecturer

@diegopiscoya4318 5 лет назад

Lmao that seems to be a really recurrent event in cs matters

@shahman1 5 лет назад

@@diegopiscoya4318 its true, surprisingly or unsurprisingly

@henrikflindt3086 5 лет назад

These 4 hours was better than 15 + lecturers

@eduardotrujillo9316 3 года назад

Very well explained and with very accessible English. You did an amazing job. Thanks!

@mykhailshavkunov7345 Год назад

Just finished it! thank you a lot! no water in course, only useful information!

@maaxmith 3 года назад

To anyone getting an error when using the psql command in Windows Terminal: You need to add "psql" to your system path variables: - In the search bar, type "env" and click on "Edit the system environment variables" - Click on "Environment Variables" - Then, in the "System Variables" table, click on the column with the Variable name "Path" and then click on "Edit" - Click on "New" and paste the path to the "bin" folder of your psql installation. E.g. in my case, its "C:\Program Files\PostgreSQL\13\bin", but it could be different based on where you installed PostgreSQL or what version you have. Now restart the Console, and the command should work.

@BexruzXolmuminov 3 года назад

thank you man.

@afunnykorean 3 года назад

Im getting this prompt after I have typed "psql" Password for user "****": (Note "****" is my folder path, that looks like this when i open command prompt-> C:\Users\"****">) When i enter my postgressql database password, it says psql: error: FATAL: password authentication failed for user "****" My postgressql username is set to default, and not "****". Any idea what is causing this?

@afunnykorean 3 года назад

I figured it out, you have to type: psql -U 'userName'

@maaxmith 3 года назад

@@afunnykorean or "psql -U postgres". I actually don't know the cause of that bug, but its at least easy to fix :)

@elBanananas Год назад

this should be top comment.

@prometheus8457 2 года назад

To those on Windows, to clear the screen, run "\! clear" or "\! cls". Hope this helps.

@az-ni7hc 2 года назад

Awesome. Thanks a lot

@swarupsarangi734 2 года назад

Great Tutorial. Loved it. Brushed up my SQL and learned new things. Recommended. PSQL Command Line is awesome. Didnt know about that.

@cesarvalenzuela5280 Год назад

De lujo, me gusta el detalle con el que explican los procesos. Excelente video, llevo unos minutos viéndolo y he entendido bastante.

@ianawilsonn Год назад

Halfway through, and it's a great course so far. Some of the material is a little dated, as Postgresql has made some changes as they are at version 15+. For example: Postgresql uses "SELECT factorial(5);" now instead of "SELECT 5!;" to get the factorial of 5. Might be time for an updated course.

@leondaz7380 4 года назад

If you're having trouble in AVG, use this "SELECT AVG(price::money::numeric) from car;" and this basically casts the VARCHAR money to Money (adds commas every 3 numbers) and casts the result to a number (decimal) as numeric is an alias for decimal in postgreSQL.

@TheLucidWay 2 года назад

Nice. Thank you!

@caioantonio0001 8 месяцев назад

What a class! Thanks a lot. I am so grateful to learn more about sql and postgres :)

@Lampalot 2 года назад

MashAllah brother such an amazing course, May Allah give you jannah !

@ugljesavojvodic3384 4 года назад

For Windows users it's even easier, even though it seems to be confusing, just enter database name when it ask for it. This how it looks in the shell: - Server [localhost]: Database [postgres]: test Port [5433]: Username [postgres]: Password for user postgres:your_pw - Please note when you connect for the first time you are actually connect to default one and that's why you don't enter any name, it will have name"postgres", and the owner is also default one, guess the name - "postgres". - When you login with all empty parameters you noted line in terminal like "postgres=#", well the part before "=#" is actually name of database, so in this default case "postgres". - You noted he has owner "amigoscode" (when he list all databases) , it's actually added role, check postgres documentation how to add role and change owner of table. - Also, when you are in "postgres=#" database you can easily switch to another (that is already created, it won't create it by itself) database using command: \c another_database_name (example: "postgres=# \c test" result: "test=#")

@pranayreddy7303 3 года назад

thank u its really helpful could u please tell me how to clear the terminal

@ugljesavojvodic3384 3 года назад

@@pranayreddy7303 Actually I never clear terminal, no matter of what I am working on :) Try with \! clear Usually I just hit enter few times... :D Be aware of using ; at the end of sequence... It's mentioned in this tutorial. But during login to database, I'm not sure how can it be cleared...

@yatskovych 2 года назад

thanks so much! I was confused about switching to another DB, so I went to the comments. You rock

@ugljesavojvodic3384 2 года назад

@@yatskovych I'm glad to se it is helpful 👍 Thank for feedback.

@O_o___o_0 2 года назад

@@ugljesavojvodic3384 Man, thank you soooooo much! I ended up stuck with that yesterday and you made my day this morning 🤘🙏

@mauroavellaneda9019 3 года назад

Minute 24:57: To be able to write in bash profile or like in this case, zshrc, after you open the text editor, you need to type "i" to start typing. Another way of saving it is, when you finish what you need to type, press scape and then Shift + z + z. (two times "z")

@arrow1197 Год назад

Very impressive! you have explained all these concepts really well. it gives a good overview of postgresQL. I also liked the way you broke down each topic made it easy to understand where you were going with it, thankyou for sharing.

@hariprasadm6970 2 года назад

Thank you so much for the course. The instructor was clear and precise.

@gideonrichards1862 3 года назад

Thanks you this was a really helpful course, even as we are now on 13.2. A couple of comments to aid the user of the tutorial, if I may: 1) Please can you explain at the beginning how to get back to the =# prompt - I struggled on the Mac because the ctrl is ctrl button and not cmd button; 2) Please can you explain how you clear the screen at the beginning of the tutorial; 3) Please can yous tree at the beginning how important accurate typing is for the student; 4) Please can you ensure when you are using a comma and not a dot (e.g. NUMERIC(19, 2)) that that is clear. I did miss that. Apart from that this has really helped me and I would recommend it to anyone doing PostgreSQL as a beginner. I will look up the longer more advance course! Kind Regards Gideon

@notsoaverageraj7917 3 года назад

2:16:57 : "I have 10 apples and I want to divide it with 0 people" That totally makes sense as it sounds like my sibling.

@johnwick-m4m 3 года назад

LOL

@gustavoadolfogrisalesmonto1910 2 года назад

@@johnwick-m4m at least you (one person)

@Lisa-jt4ww 2 года назад

Fantastic - you've helped me so much on my software engineering course

@archibaldsimango7998 3 года назад

Thank you so much, I really appreciate the good work..... Simple and Straight forward.

@rohitdalal954 3 года назад

If you are on Windows, to insert the data using Mockaroo: \i 'C:\\INSERT\\YOUR\\PATH\\HERE'; What a great tutorial this is. A simple and clear explanation. Thank you so much ;)

@BearRockin47 3 года назад

G.O.A.T.

@pranayreddy7303 3 года назад

atill i cant open the .sql file in terminal

@Dineshsharma-ec6ys 3 года назад

I got permission denied error help me out

@rohitdalal954 3 года назад

@@Dineshsharma-ec6ys Try to use single quote 'path' for the file path.

@adeyemiblessing 2 года назад

Thanks a lot for this. Just saved me from fraustration

@aleksekokorev 4 года назад

Hello! Great quality course, but i'd watch about that with a python together. Then it would be really useful practically. Thanks.

@anuranroy4617 2 года назад

Dude, you can just use a PosgreSQL client and learn of the basic mappings from PostgreSQL to Python. I don't think that's even remotely hard. I think doing a course for Python exclusively with PostgreSQL will be like repeating a lot of material from this video. Just an opinion though.