MP4 | Video: AVC 1920x1080 | Audio: AAC 48KHz 2ch | Duration: 1h 42m
Genre: eLearning | Language: English | Size: 386 MB

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
[/i]Homepage

[i]Screenshots