This guy is one of the OG programming tutorial guy on YT. Seriously, he helped me out so much way back in 2016-17 when I was starting out with Java, and he's still pumping out videos. Legend.

Hey derek. Just wanted to let you know that from my very first engineering class ten years ago to today where i am a full fledged software engineer you have really helped out. Thank you for your contributions to society.

Sometimes I feel like Derek must be following me around or something. Every time I start working with a new technology it seems I get a notification that Derek has made a new video about it lol. Thank you Derek. As always, your content is awesome.

Thanks Derek! It a miracle for you to explain so many things in such a short video! You explain FUNCTION, PROCEDURE in great details, which are not always available in other resources. Many thanks again.

Hi uncle derek, just wanna say i started learning with your videos back when i was 14-15. Now im doing my bachelor degree in software engineering, and already a full stack dev with experience shipping few production app. Yet i still had one month more to finish my degree, and im already shipping app. Partially of that is a big thanks to you and your tutorial in one video.

i love PostgreSQL since it is a powerful, open-source Object-relational database system. It provides good performance with low maintenance efforts because of its high stability.PostgreSQL was the first DBMS that implemented the multi-version concurrency control (MVCC) feature. Some of the highlights of PostgreSQL are: Support for the vast amount of languages. It provides advanced security features. It has geo-tagging support.

@Derek Banas - I Started watching your code tutorials back in 2016 with the python series you made, hoping to get a job/career in programming and away from security. Haven't got a spot yet, but haven't stopped watching your stuff yet. Thank you for making these videos, it helps me feel smarter every time I watch them as so little else keeps my brain preoccupied.

Wow I have a coding test for a grad scheme in a few days where I have to use postgres and you posted this, what a legend!

Thanks Derek for your fantastic video on PostgreSQL. Very helpful and much appreciated.

This guy is GIGACHAD, he's a good person who likes to teach people, he's so smart, he explains so good. Thank you for your tutorials.

ABSOLUTELY BRILLIANT! Excellent speed flow, excellent lesson flow, excellent explanation and excellent "PASSION" which can be felt in the humour/attitude and presentation tones! REALLY GRATEFUL Derek! As this is my first official introduction to SQL in general, I still have ways to go before I can be as comfortable with it as I am with other languages but you definitely set me up to follow a methodical route to finding points of reference as the need may arise. Looking forward to other lessons! PS: for what its worth, it took me a solid 18 hours to complete your 3.5hr lesson with notes and practices. And your request to leave comment "came this far" was noted but I waited until the video was complete :)

Long tutorial with many things covered. I referred the documentation once in awhile but your content covers quite a lot, especially the useful stuff. Keep it up!

This is an excellent tutorial, I'll deduct 2points for not explaining the different JOIN types better, and for suddenly just using NATURAL JOIN out of the blue. But over all it was a 98 out of 100 score from me - tank you sir!

Another nice, thorough tutorial... A lot of material is covered over a short period of time. The pacing was good. Quick and to the point, using plausible scenarios to emphasize the concept. The thing I appreciate most is having a good explanation of Postgres broad capabilities, which are impressive. I will certainly use this video as a reference. I feel I have a good conceptual understanding of Postgres now. Well done. Thanks.

Great tutorial, voice pleasant to the ear, can't recommend enough. Thank you sir.

There is a mistake at 1:06:25. It should not be: item id = sales_item id. It should be: item id = sales_item item_id.

Wow!.... this is very comprehensive lecture... Thank you Sir, am beginning to understand the basics of SQL... More power to you....

hi, excellent tutorial! honestly i never seen an in depth tutorial on sql or postgres but this one is exactly that. Good job keep doing more advance videos on postgres! Thank you, regards!

I made it. Excellent video my guy. keep it up.

Thanks !!! This is a great video... It's the SQL tutorial that I needed !!!

Incredibly educational and useful. Thank you very much for all of your efforts and sharing it ! Highly appreciated! Wish you a happy year :)

I made it to 2:49:28. Thanks for your help. I first used PostgreSQL when it was just Postgres and needed a refresher since I've been doing nothing in management for a long time. lol

and once again after 2 years I'm back on legendary tutor's tutorial

in the functions part, following the example in current versions will give an error if you just run the query on the whole thing and it requires more steps to get the result, but if you add a semi-colon at the end of the block for declaring and defining the function (LANGUAGE SQL ;) it will still work with a single click

His Video helped me with C++ years back when I was in college, Now I hope this video will help me change my career but this man is absolute legend for putting so much videos for free to help people all over the world for free.

I made it to 2:49:36 and will watch it all, I've watched many videos from you and have tried many of the SQL videos, I'm still learning but it helps a lot to understand how PostgreSQL works in a very compact and easy to understand way, I think I can do a lot of work with it as a data and reporting analyst which I have been working as for the last 7 years but haven't taken proper training in SQL until now, I'm also learning R and its data.table package and I have worked with regex in Javascript and google sheets and plan to use it in R and SQL.

There is a logical mistake at 2:59:15. By writing "FROM table1, table2" you get a cross join of these tables, which was not the intent. This is why the sum is so large.

completed it in 4 days!. Thankyou so much

"Hey I made it!" Thanks for such a great walkthrough

Derek I have no words this is gold i am student from India this video give me a precious knowledge thank you Derek. This video should have million views. Thank you

Hey, I made it, it wook me a while but I really appreciate the video!

Derek, thank you so much for all your videos. People are immensely benefited from your videos.

WOW THIS COURSE IS MAGNIFICENT, thank you very much appreciated

Incredible course that has to many information that you can search afterwards or during the course! Thanks Darek for making this video to all of us!!! Wish you all the best Edit my comment after one month: - This course is just so complete and with huge amount of work. You can spend at least 10 hours by yourself in order to understand each topic and search more information. Question: Do you know how we can produce sample data automatically in order to work more with SQL and try different examples ? Thank you!

Hi sir, I made it until the point you mentioned in the tutorial. And I am going to finish the whole video today. I take note of everything you said because I find them all very important. Thank you for producing an amazing video.

I think there is a logical mistake at 3:01:15 where the price sum is the sum of all item price instead of Nike’s specifically. I changed the code a bit and it worked out. I am thankful for the opportunity for me to actually think through the problem haha. Great video really helped! Thank you!

Aww so unexpected and good news to see you cover PostgreSQL. Good job!

if you have trouble with ids matching what I ended up doing was downloading the data from github and then copy pasting it in. The first time the ids still wouldn't behave but the 3rd try after typing manually the first run and then trying to copy paste 2nd, the third time was indeed the charm. I probably added something to a column by accident which really messed up the whole process. On a different note, I did learn there is a way to reset the IDs from a comment below, which may come in handy later in life. Thank you very much for the quality material and especially the downloadable data files.

This has been super helpful! I watch on 1.5 speed and try to follow along. Thanks so much.

Perfect Videoto get up and running with plenty of examples to use as reference ... thanks!

Thanks foor this. Likely the longest viedo on YoutTube I have watched. Time to implement and learn further!

One of the best tutorials I have come across. I have learnt a lot in 5 min. Thank you very much

Perfect voice and pace for an instructor. Thank you for sharing your knowledge in these great videos.

Hi Derek, I'm back! After some quite long time, because now I need to learn something BLASTING new, i.e. PostgreSQL for this time because one of my job interviews requires it and it is always something new for me and my CV!! ^^ :P Please don't hesitate to upload your materials because your tutorials quality is best on KZfaq and generally anywhere! ;] Udemy is just a joke sometimes .. I just love to be back on your channel and I really missed that! ^^ Hopefully you will still find some time for us and you're going to provide more really useful materials about more newest and most important technologies! :) Keep us up to date and keep up the good work Derek! I really appreciate your tutorials, great job! :)

A#1 your tutorials have saved me so much time!!!!

Well I pretty much LOVE your tutorials, and have kept watching for years. But actually as to postgresql, I feel that if you could paste pictures of some full tables you've been selecting from, it might make some commands more clear and explicit.😘

Just perfect ! Thank's a lot for this comprehensive and detailed tuto !

I just love your tutorials, and this is an awesome one as well, and as you requested: "Hey I made it!"

Always creating unparalleled content. Keep the Good Work, Derek Bhau ( Brother )

Thanks!

Made it to the 2:49:25 mark! Thanks for this tutorial, I will definitely be returning for tips and reminders in the future

OMG! This is incredible Derek 🔥 Thank you so much

Made it Sir !.. Wish you come up with more useful videos for us...like C++ in future💯

Hey I made it! You're changing lives. Thank you.

Hi, I greatly appreciate the quality content, truly amazing stuff. thank you :)

@derekbanas you are joining two primary keys @1:07:00. That is not correct. But i noticed you spoke the right thing after you wrote the wrong query. I hope that I'm not the only one noticed that. So, as you said, we join a fk from one table with the pk in the other table. One more mention - I don't know if you covered that later, to use transactions or to defer serial pk autoincrement on insert errors where serial keys are messed up for other related tables that depend on them. Good content so far, thanks.

Hi Derek, am Mike from Nigeria, am one of your biggest fan ever, and you are one of my biggest inspiration, I have a request(humbly), this days I have been enjoying your Adobe premiere and after effect(so in depth) playlist, I checked for Photoshop playlist, you have Only one video, which I will also like to know about from photo editing to photo manipulation(using light and shadow) ,to making logo and flyers e.t.c with Photoshop, lastly u thought us Dart language, but did not build any flutter app you said you will build afterward. If things fall in place for me ,Will like to see you face to face one day sir, you help us who would never have thought we could be programmers and also inspire us that it's all achievable, please reply me it would mean a lot , have a nice day sir.

you are kidding me, this is exaaactly what I have been wanting to find recently

I've made it - great tutorial as always, Derek

As requested, I've made it to 2:49 so far :-) This is very well done,.

Great Tutorial Derek! Congrats!

You made a small mistake in drop trigger as it generated an error at 3:29 it should be “drop trigger tr_block_weekend_changes ON distributor”. Brilliance video by the way too.

Not confusing but fast tutorial. Ty for your efforts.

Thank you very much for all your hard work. You really helped a lot.

Just opened the video to hear you say "Well hello internet!". Will learn Postgres later :)

awesome content! finished till the end..

really wonderful and practical tutorial! helps a lot!

PostGreSql and the TimeScale add-on (free) make this one of the best for financial time series and IoT time-ordered data. Just smoking fast because of the automatic partitioning.

Thank you for this tutorial. Am I the only one that does not like dark theme? Otherwise, a very very good tutorial.

I've made it, great stuff !!

Video Request: Can you please make a PostgreSQL part2 showing us how to turn a small schema into a physical DB implementation on Azure Database for PostgreSQL and do API requests to/front it? Even if it's a simple temperature data app where you can fetch the daily temperature via a API query it would be super helpful.

Thank you very much for taking the time and effort to create these videos. I am starting with Postgresql and will certainly learn a lot from your course. One thing I noticed at the start is that you say "you will use varchar a lot" - which I did indeed until recently. Then someone pointed me to the "Don't do this" page on the official Postgresql wiki which says we should not use varchar(n) but text instead. I found it a bit counterintuitive but apparently, the database will handle text at least as efficiently as varchar. The same goes for or char(n). Do you have an opinion on that?

Made it! Very well done video

3rd time watching. it gets better and better. thank you

Great stuff, sir!

;) query : How your data types got highlighted ?? btw Great Lecture

Thanks Derek, this is awesome. Saving this for later.

Love the video, learning a lot. Thanks

made it to 3h, great tutorial. Hopefully I will come back to finish the remaining 40 min

Just a small note: in 21:50 when creating sales_person not only date_hired is different, but there isn't column for company too, which will mess up inserting values in the future if you created the table by the invoice like me

Good tutorial. Thanks for video!

These tutorials you're making are the BEST, but that ain't 2.1 million shoes 😂

nice... can you give tutor for pgsql maps too

zip column needs bigger type size than smallint, because smallint type can store data of two bytes and the biggest number to be stored in smallint column is 32767 while some zip codes are above that number

The best course ever

GOOD WORK 👍

How can I even find any servers? When I open servers section it's empty....

You truly are amazing, man. Respect

heyy can you create video on how to implement clean architecture and tdd? today i was checking my old projects and tried to do some changes but it broke 😢. I felt my old projects are just useless now because i couldn't make any changes. it would help if you could make a video on that. Your postgres video is amazing! It helped me in exams.. thank you so much for amazing content!

Amazing, I wanted to see course about this database.

Great job Thanks very helpfull

Incredible tutorial!

Thx for this, I needed a refresher on Postgres (and normalization for that matter). Question on the product table around the 28:00 min mark: Wouldn't the supplier normally be its own table? Just double checking my thought process. You might address this later (in which case I'll find out) and/or have omitted it for brevity/reduced complexity; or I might I just be wrong. Thanks, great stuff.

made it 2:49:25 and thanks for the amazing course

This is an incredible tutorial

Thanks again for a great course

Thank you for making this.

Still here broth, at 02:51:00. Gonna have to restart the video after I'm done with it in order for everything to make sense and for everything to stick. lol

You my friend is a living legend

Hello, I made it! Are there any projects tutorials anyone would recommend to pair with this that used Postrgres? Maybe PERN Stack Course - Postrgres, Express, React, and Node?