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.
Facts!! He helped me get my head around programming when I was crazy enough to start a computer science degree 😂 good to see him still doing what he does. I am again here for seeking some help
@derekbanas is one of the GOATs when it comes to programming tutorials. He taught me PHP, MySQL, Yii platform and now POSTGRESS! respect man!! from Nigeria
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.
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.
Finally I can add SQL and PostgreSQL on my resume.😅 Thanks for making this course, it helped me to learn a lot of things about sql and postgreSQL. I'll also recomend my peers to watch this video.
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!
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 :)
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
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
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.
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
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.
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!
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.
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.
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!
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!
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.
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 RU-vid 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! :)
@@dirtysouth3291 I spotted that immediately. It worked because it is not mandatory for two ids to be in pk vs. fk relationship. If there is no matching key the result row is discarded. But the result table is wrong, just inspect prices in the `item` table.
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!
@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.
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.😘
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.
Thank you for the wonderful message. I greatly appreciate it! I'll see what I can do about Photoshop and Flutter. I normally design logos with Illustrator. Inkscape is a free alternative that is almost as good if you are interested in that. I'm doing my best to search for topics to cover that are not already covered well else where on RU-vid.
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
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.
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?
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
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.
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.
"" one of the best things about dude is that he never takes credit for himself when he achieves something . he always respect us, the audience, and his team, and he is always polite in all of his video. we congratulate ourselves on this achievement more to come and everything to come""❤💛🧡💙 Let's we all just appreciate the content this man and his crew makes it's just a masterpiece imagine what's he's gonna doing the future ❤ I hope this channel never ends and keeps spreading happiness.❤😊
@@AcidiFy574 Which guy is human? The guy I was complimenting? Or the generic verified account that paid for a spam comment bot service to try and get subs? If you think that bot is a human, idk what you think you're doing on a programming tutorial lol
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