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).
day 1 => (1:12:28) day 2 => (1:52:08) day 3 => (2:25:58) day 4 => SKIPED day 5 => (2:49:15) day 6 => SKIPED day 7 => (3:16:41) day 8 => (3:40:53)
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.
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.
The best PostgresQL tutorial I've seen so far.
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!
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.
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.
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! ⭐⭐⭐⭐⭐
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.
1:53:33 Make sure the currency is set to none, otherwise it won't work if you use numeric for the type for the price
Hey everyone. For windows users on the mockaroo section: I encountered some problems importing the .sql file. Apparently psql doesn't accept the common backslashes \ that are used for paths on windows. So you need to use forward slashes / like on linux or mac. So for example, here's what I typed in psql: \i C:/Users/MyName/Desktop/person.sql
I was struggling to learn SQL, before this tutorial. I am commenting at 1:50:16 without watching the complete tutorial. This course is very helpful to me. Thank you! so much. I can't explain how grateful I am to you.
Great work man. Thank you from Barcelona. I like your voice, it's very clear to understand to non English-speaking like me.
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
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.
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
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.
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.
@AmanSinghYT