Introduction to PostgreSQL Databases with PgAdmin for Beginners

Video description

Create databases and write SQL queries using PostgreSQL and PgAdmin 4

About This Video

  • Learn to install PostgreSQL and PgAdmin 4
  • Discover how to use PostgreSQL databases with PgAdmin 4

In Detail

Although there are a variety of databases to choose from, PostgreSQL is constantly ranked as a top database for everything from data analytics to basic web development.

With this interactive course, you’ll learn how to set up and use PostgreSQL databases with the PgAdmin 4 interface. You’ll start by learning how to install PgAdmin and PostgreSQL, along with understanding all about a database. Next, the course will help you develop the skills you need to create table columns. You’ll then use a variety of SQL commands to easily add, sort, update, delete, and perform other data management tasks. Toward the end, the course will help you grasp the technique of relating data between tables with the help of inner join. In addition to this, you will be able to use the WHERE clause to filter results from statements such as INSERT, DELETE, UPDATE, and SELECT.

By the end of this book, you will have developed the skills you need to confidently manage data using PostgreSQL and PgAdmin.

Product information

  • Title: Introduction to PostgreSQL Databases with PgAdmin for Beginners
  • Author(s): John Elder
  • Release date: May 2019
  • Publisher(s): Packt Publishing
  • ISBN: 9781838983062