Create a Postgres Table
Learn how to create a table using the most widely-used data types (serial, varchar, integer, float, boolean, and date), and the most necessary constraints (NOT NULL and primary key).
For anyone wondering more about setting up dev environment:
You can use pgAdmin if you are on Windows
Thanks for helping people out Kartikey :)
Can someone suggest a tutorial for getting set up with a database and hooking it up with the Postgres client? I downloaded the software but I don't know what to do next. In other words I'm looking for what I need to do to get ready for the first video in the series.
You can read the README on Github
Awesome thx
What is the program name that you use for postgresql in this lecture? I don't know what it is, so i can't start your lecture.
What is the program name that you use for postgresql in this lecture? I don't know what it is, so i can't start your lecture.
Sorry I checked the reply above.
Seems that someone felt offended by my previous comment and was deleted. So I'm re asking it: Is there any particular reason why all the videos are so fast paced? If so, what's the purpose on that? Feels that the author has taken for granted a lot of knowledge that audience is supposed to have (if that's the case there's absolutely no point in taking this course as you probably know most of it). On the other side if you're just new to a relational engine you will be absolutely confused (too many concepts terribly exposed and explained) as it does not have a clear goal in any section, it feels like a bad SQL medley. I'm not new to SQL and took this course just to remind a few things but completely failed that purpose.
A little typo in the transcript. I think it should be "release_date" not "releas_date". Thanks.
You can use pgAdmin if you are on Windows Or linux (ubuntu etc)
Also dbeaver community edition is looking very good. https://dbeaver.io/