From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced
Unlock the full course today
Join today to access over 24,400 courses taught by industry experts.
Walkthrough: PostgreSQL - SQL Tutorial
From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced
Walkthrough: PostgreSQL
- [Instructor] In the previous movie, we have installed the PostgreSQL server, along with pgAdmin 4. That is the UI interface. Now let's just go to our pgAdmin 4, the UI interface, to have a quick walkthrough to understand what it contains. This is our window for pgAdmin 4. On the left-hand side, top corner, here you see Server. If you click on this server, it's asking you the password. Now here you can see that it is asking the password for the user postgres and to connect to the PostgreSQL 16. Remember, this password is the same password which you have given at the time of the installation. So I just type in the same password. If in case you don't want always to give this password and you want to save it, you can click on save password and the next time when you log in or when you come to the screen, it won't ask you. So click OK and you will be allowed to log in. Now, once you log in, you start seeing the information.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.