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.

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

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!

Who is the target audience?

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