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 by: John Elder
Founder of Codemy

What Will I 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

Target audience

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