PAC | Introduction To PostgreSQL Databases With PgAdmin For Beginners (2019 EN)

Company: Packt Publishing
Author: John Elder
Full Title: Introduction To PostgreSQL Databases With PgAdmin For Beginners
Year: 2019
Language: English
Genre: Educational: Databases
Skill Level: -
Price: €183.99
-
Files: MP4
Time: 01:42:31
Video: AVC, 1920 x 1080 (1.778) at 30.000 fps, 400 kbps
Audio: AAC at 132 Kbps, 2 channels, 48.0 KHz



Create databases and write SQL queries using PostgreSQL and PgAdmin 4.

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.


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

Features:
✓ Learn to install PostgreSQL and PgAdmin 4
✓ Learn how to use PostgreSQL databases with PgAdmin 4


Lessons:
1. Introduction
01. Introduction
02. Installing pgAdmin and PostgreSQL
03. What Is A Database
04. pgAdmin Overview
05. Create Table Columns
06. Add Data To A Table
07. PostgreSQL Select Statements
08. PostgreSQL Where Clause
09. PostgreSQL Wildcards
10. PostgreSQL AND OR NOT
11. PostgreSQL Order By
12. PostgreSQL Insert Into
13. PostgreSQL Update
14. PostgreSQL Delete
15. PostgreSQL Limit
16. pgAdmin Menu Walkthru
17. PostgreSQL Foreign Keys
18. PostgreSQL Inner Join
19. PostgreSQL Join Where Hack
20. PostgreSQL Delete Table
21. PostgreSQL Import and Export Tables
22. PostgreSQL Backup and Restore Database
23. Bonus

Our members see more. Join us!
-------------
Our members see more. Join us!