Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Intro To PostgreSQL Databases With PgAdmin For Beginners
Rating: 4.5 out of 5(7,644 ratings)
27,926 students

Intro To PostgreSQL Databases With PgAdmin For Beginners

Intro To SQL and PostgreSQL for Creating Databases and Writing SQL Queries using PostgreSQL and PgAdmin 4
Created byJohn Elder
Last updated 11/2023
English
German [Auto],English [Auto],

What you'll 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

Course content

1 section • 24 lectures • 2h 2m total length

  • Introduction2:04
  • First Things First: How To Get Support Fast!0:09

    Check out my student Facebook Group...

    It's a great place to get fast support for this course from me, to interact with other students, to post your projects and code, and to access course announcements and extras...

    Join Now!

    https://www.facebook.com/groups/codemycom/

  • Installing pgAdmin and PostgreSQL7:34

    Download and install Postgres and Pgadmin by following the official sites, choose the latest version, and configure the Postgres superuser with a password, default port 5433, and data directory.

  • What Is A Database5:39
  • pgAdmin Overview5:19

    Launch pgAdmin, connect to the Postgres server with the postgres user, and create a database named my DB while exploring SQL basics.

  • Create Table Columns6:44
  • Add Data To A Table8:17

    Add data to a PostgreSQL table using import, manual entry, or SQL insert in PgAdmin, with automatic ID assignment and save data changes.

  • PostgreSQL Select Statements2:54

    Learn how to use the PostgreSQL select statement to return all columns or specific fields from the public.customers table, and alias columns for clear reports.

  • PostgreSQL Where Clause3:49
  • PostgreSQL Wildcards3:37
  • PostgreSQL AND OR NOT4:14
  • PostgreSQL Order By3:36

    Learn how to use order by in PostgreSQL with PgAdmin to sort query results by any column, choosing ascending or descending (ASC or DSC), and default to ascending when omitted.

  • PostgreSQL Insert Into3:17

    Learn to insert data into a PostgreSQL table using insert into, targeting public.customers with first_name and last_name values. Use single quotes and understand auto-incremented IDs and basic error handling.

  • PostgreSQL Update3:27
  • PostgreSQL Delete4:16
  • PostgreSQL Limit3:25
  • pgAdmin Menu Walkthru8:43
  • PostgreSQL Foreign Keys9:06
  • PostgreSQL Inner Join6:31

    Learn how to use inner join to connect the customers and customer ages tables, select first name, last name, and age, and join on foreign key equals primary key.

  • PostgreSQL Join Where Hack4:15
  • PostgreSQL Delete Table3:18

    Learn how to drop a table in PostgreSQL using both the graphical PgAdmin menu and the drop table command. Understand when to use delete cascade for related foreign keys.

  • PostgreSQL Import and Export Tables5:39
  • PostgreSQL Backup and Restore Database5:57

    Back up and restore PostgreSQL tables and databases using pgadmin. Save backups, restore data, and manage active sessions to complete changes smoothly.

  • Bonus Lecture10:10

Requirements

  • You don't need any special tools, we'll download everything we need for free. You just need a Windows, Mac, or Linux computer
  • You don't need any prior database experience, I'll walk you through everything

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. com

Who this course is for:

  • Anyone who wants to use the PostgreSQL database with the PgAdmin 4 Interface

Report abuse