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).
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.
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! ⭐⭐⭐⭐⭐
Working as an oracle dba, even non IT employees could use this db. This is really help me to learn postgres, respect sir!!!
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.
The best PostgresQL tutorial I've seen so far.
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.
I am from Pakistan yesterday I downloaded this video and watched it offline. After watching then I open youtube and search your video just for saying thank you for such a clear , simple and educated tutorial. Now I subscribed to your channel and will explore this channel. Keep it up sir
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. <3
Great work man. Thank you from Barcelona. I like your voice, it's very clear to understand to non English-speaking like me.
Boi this is excellent, it's really hard to believe this is free
The volume difference at 1:43:20 was a wake up call. Great tutorial for someone who has never used postgres or wants to brush up.
My progress tracker : Day 1 => 1:16:00 Setting up PostgresSQL on windows , making databases & tables , dropping tables , Adding , renaming , dropping columns , Using 'Mockaroo' for creating dummy data and importing it via the '\i' command.
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!!!!!
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")
One update for 2:04:24 : SELECT 100!; gives an error. So alternatively, one can use SELECT FACTORIAL(4); to get the answer. Give a 👍 if this helped you.
I cant believe the quality of content and explanation in this video. Brilliant course explaining PostgreSQL. Very easy to follow - Highly recommend it!
I want to thank you sir for this beautiful and complete course now I'm heading to advanced postgres and spring boot as you said thanks
I'm at 35:00, using windows and bversion 12 of PostgresQL, and the commands seem completely different. first off I get a prompt that says "(database name)=#", rather than the ~ he gets, second, the --h commans isnt working. I'm typing in "help" to get commands, and it says \h for sql help, and \? for psql help. I typed in \? assuming it would show me the same PSQL help it shows on the video, but it shows a completely different set of commands, al starting with \ instead of with --. I haven't watched the rest of the video, but so far it seems like it's different for windows. I hope not. EDIT: I did manage to do the rest of the tutorial without problems, it works on windows aswell, I just skipped this step in particular. Wonderful tutorial. However I'm having trouble trying to add a NOT NULL constraint to an already created row. Is this possible? I'm using " ALTER TABLE person MODIFY name VARCHAR(30) NOT NULL; " and it says there's a syntax error around modify. Any help?
@AmanSinghYT