Introduction to PostgreSQL Databases with PgAdmin For Beginners
Introduction to PostgreSQL Databases with PgAdmin For Beginners
.MP4, AVC, 1920x1080, 30 fps | English, AAC, 2 Ch | 1h 42m | 386 MB
Instructor: John Elder
.MP4, AVC, 1920x1080, 30 fps | English, AAC, 2 Ch | 1h 42m | 386 MB
Instructor: John Elder
Create databases and write SQL queries using PostgreSQL and PgAdmin 4
Learn
- Understand how to use PostgreSQL databases 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 a database
- How to explore what's in a 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 such as 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
About
In this course, I'll teach you how to set up and use PostgreSQL databases with the PgAdmin 4 interface!
There's a reason why Postgre is so popular; find out why in this course!
You have many databases to choose from, many of them even free. But PostgreSQL is constantly ranked as a top database for everything from data analytics to basic web development—and everything in between.
Postgre is pretty easy to use! You'll be amazed at how quick and easy it is to dive in and get started!
Style and Approach
A complete course packed with step-by-step instructions, working examples, and helpful advice.
Features
- Learn to install PostgreSQL and PgAdmin 4
- Learn how to use PostgreSQL databases with PgAdmin 4
Introduction to PostgreSQL Databases with PgAdmin For Beginners
