Learn PostgreSQL Tutorial - Full Course for Beginners
video description
Date: 2022-03-14
Related videos
Comments and reviews: 8
Khateeb
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).
reply
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).
reply
VanderGaming
There is a problem with the new Mockaroo options. You have to have a currency infront of the NUMERIC value, which creates a problem when importing the file into a terminal (at least in windows). you'd have to use Studio Code, Edit > Repalce > Find $ (whatever currency) and leave the replace with what as blank. Hold down enter until it replaced every line. Save and import.
reply
There is a problem with the new Mockaroo options. You have to have a currency infront of the NUMERIC value, which creates a problem when importing the file into a terminal (at least in windows). you'd have to use Studio Code, Edit > Repalce > Find $ (whatever currency) and leave the replace with what as blank. Hold down enter until it replaced every line. Save and import.
reply
Yugal
I'm on the paql version 14.1 and whenever I enter \l, it does show me the list of databases currently availabe but after that it says -(END)- and is highlighted and I can only enter certain keys in there like q and when I enter q the database disappears. I doesn't show -amigoscode=#- or whatever the name of mine is like it does in yours. Can anyone help please??
reply
I'm on the paql version 14.1 and whenever I enter \l, it does show me the list of databases currently availabe but after that it says -(END)- and is highlighted and I can only enter certain keys in there like q and when I enter q the database disappears. I doesn't show -amigoscode=#- or whatever the name of mine is like it does in yours. Can anyone help please??
reply
PROMI
In Mockaroo for the car data when I am trying to take the price as money it is creating a $ sign before the price like '$630000'. But in the tutorial 1:53:17 it is none instead of $ sign. In Mockaroo there is no option to replace the $ sign. Did anyone face the same problem? It's a great tutorial though
reply
In Mockaroo for the car data when I am trying to take the price as money it is creating a $ sign before the price like '$630000'. But in the tutorial 1:53:17 it is none instead of $ sign. In Mockaroo there is no option to replace the $ sign. Did anyone face the same problem? It's a great tutorial though
reply
Adam
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.
reply
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.
reply
Kevin
So I learned mySQL and Oracle in faculty, but I didn't remembered one thing and this course really gave me the courage to apply to a job. Thanks
reply
So I learned mySQL and Oracle in faculty, but I didn't remembered one thing and this course really gave me the courage to apply to a job. Thanks
reply
NikolaTom
Thank you for this course! Feedback from my side is to bring a separate lecture for Windows users, as it is very difficult to follow.
reply
Thank you for this course! Feedback from my side is to bring a separate lecture for Windows users, as it is very difficult to follow.
reply
caleb
hi can anyone help, i want to link this to vscode, so that when I code on terminal I can see the tables created to the databas
reply
hi can anyone help, i want to link this to vscode, so that when I code on terminal I can see the tables created to the databas
reply
Add a review, comment
Other channel videos
