Intro To PostgreSQL Databases With PgAdmin For Beginners (Udemy.com)

Intro To SQL and PostgreSQL for Creating Databases and Writing SQL Queries using PostgreSQL and PgAdmin 4

Created by: John Elder

Produced in 2021

icon
What you will learn

  • Understand how to use PostgreSQL Database with PgAdmin 4
  • Understand the basics of what a Database can do
  • How to Install PostgreSQL and PgAdmin 4
  • You'll Learn How To Create a Database and Table
  • How to put data in and take data out using PgAdmin
  • How to update and delete data from the database
  • How to explore what's in the database whenever you want
  • How to create basic reports with the data from your database
  • SQL Commands such as SELECT, WHERE, AND, OR, NOT, ORDER BY, and INSERT INTO
  • SQL Commands like UPDATE, DELETE, LIMIT, INNER JOIN, and more
  • All about Primary Keys
  • All About Foreign Keys
  • How To Backup and Restore Database
  • How To Backup and Restore Tables

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 86 / 100

icon
Course Description

In this course I'll teach you how to setup and use PostgreSQL databases with the PgAdmin 4 interface!

There's a reason why Postgres is so popular, find out why in this course!

You have many databases to choose from, and even many free databases to choose from. But Postgresql is constantly ranked a top database for everything from data analytics to basic web development - and everything in between.

Postgres is pretty easy to use! You'll be amazed at how quick and easy it is to dive in and get started!

In this course, you learn to:

  • Install pgAdmin and PostgreSQL

  • What Is A Database

  • pgAdmin Overview

  • Create Table Columns

  • Add Data To A Table

  • PostgreSQL Select Statements

  • PostgreSQL Where Clause

  • PostgreSQL Wildcards

  • PostgreSQL AND OR NOT

  • PostgreSQL Order By

  • PostgreSQL Insert Into

  • PostgreSQL Update

  • PostgreSQL Delete

  • PostgreSQL Limit

  • pgAdmin Menu Walkthru

  • PostgreSQL Foreign Keys

  • PostgreSQL Inner Join

  • PostgreSQL Join Where Hack

  • PostgreSQL Delete Table

  • PostgreSQL Import and Export Tables

  • PostgreSQL Backup and Restore Database

  • And More!


This course is perfect for anyone just starting out, you don't need any special skills or prior knowledge to take this course.

And as always, we offer a 100% money back guarantee if you aren't completely happy with the course. No questions asked!

My name is John Elder and I have nearly 40 courses here at udemy, with close to 45,000 students and over 105,000 enrollments. I've been writing code and developing neat things online for over 20 years and I'd love to teach you what I know!

What are you waiting for, let's learn some PostgreSQL database wizardry!

-John Elder
CEO Codemy. comWho this course is for:
  • Anyone who wants to use the PostgreSQL database with the PgAdmin 4 Interface

icon
Instructor Details

placeholder

John Elder is a pioneer in Web Development who created one of the first Internet advertising networks back in 1997. He sold it to a publicly traded company at the height of the dot com boom and then went on to create the best-selling Submission-Spider search engine submission software that's been used by over 3 million individuals and small businesses in over 45 countries.
Today he teaches Web Development courses at Codemy the online code school he founded.
John graduated with honors with a degree in economics from Washington University in St. Louis where he was an artsci scholar.

icon
More courses by John Elder

Python Django Web Development: To-Do App

$11.99

Learn SQL with Microsoft SQL Server

$11.99

Ruby On Rails For Web Development

$11.99

Build a Stock Market Web App With Python and Django

$11.99

Build a User Authentication Web App With Python and Django

$11.99

Using MySQL Databases With Python

$11.99

icon
More postgresql courses

Rock the JVM! Akka Persistence with Scala

$11.99

SQL and PostgreSQL: The Complete Developer's Guide

$11.99

Practical SQL Bootcamp for Data Analysts and Data Scientists

$11.99

Python 3 Complete Masterclass - Make Your Job Tasks Easier!

$11.99

REST APIs with Flask and Python

$11.99

Python Django Dev To Deployment

$11.99

icon
Reviews

4.3

200 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Nelson Bayma on 11/22/2020

Bom dia, o principal objetivo de fazer este curso foi pela necessidade de fazer uma atualizao nos banco de dados do sistema que desenvolvo. Venho utilizando a verso 9.4 do postgreSQL desde seu lanamento, antes usava o dBaseIII pois desenvolvia em Clipper, quando forosamente tive que mudar para Java, foi a linguagem que melhor me ambientei na poca e desde l venho desenvolvendo para meus clientes utilizando Java 8.1 e PostgreSQL 9.4 e desta semana em diante resolvi fazer uma atualizao de ambos para no ficar muito desatualizado como estou atualmente, parabns pela sua didtica. Abrao, Nelson Bayma.

By Sean Duong on 11/15/2020

John is great. I wish there was more to cover. But what more can I expect from a two hours course. Overall, I really enjoyed it. It was very informative. 2 thumbs UP!

By Wanangwa Ndhlovu on 11/8/2020

Yeah its what I am looking for.

By Michael Foster on 11/8/2020

You did not bother to show how to add a new connection with pgadmin4, I'm on linux and the default connection is not created with an install... creating a new connection is not trivial.

By shah Maulikbhai on 11/1/2020

nice presentation

By Miguel Malcolm on 10/27/2020

It was a great crash course if you have some prior sql knowledge. Maybe adding a bit more detail around the options that are being chosen when setting up a new table, foreign keys, etc. or add a slide with some additional resources to learn more would address the "why" with regard to the selections that were made. In all, a great, quick introduction. Thanks!

By Micca Guan on 10/27/2020

Really good experience! Useful hand-on instruction, easy to understand.Good pace, and he is very funny.

By Faisal Rizki on 10/15/2020

This course only teaches basic queries, and some errors are not explained.

By Gosimang Baisitse on 10/3/2020

The instructor is very good at explaining

By Akshay G Phadnis on 10/1/2020

It's really very basic.. At least types of select like complex queries, subqueries need to be included

By Venkatesh Ponraj on 9/25/2020

Instructor was not aware of basics. while using where clause you were selecting a specific line and trying to execute which returned the error.

By Shreyas Rajagopal on 9/21/2020

SImple and got me started on postgres