This course is designed for those interested to learn the basics of PostgreSQL databases and how to use PostgreSQL databases with pgAdmin 4.Read more.
John Elder is a the founder and CEO of Codemy.com where he has taught over 50,000 people to code, as well as an Amazon #1 Best-Selling Author.
Only want this course? Buy this course for
$199 $29 and keep lifetime access.
About This Course
Who this course is for:
- Anyone who wants to use the PostgreSQL database with the pgAdmin 4 Interface
What you’ll learn:
- 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 Walkthrough
- PostgreSQL Foreign Keys
- PostgreSQL Inner Join
- PostgreSQL Join Where Hack
- PostgreSQL Delete Table
- PostgreSQL Import and Export Tables
- PostgreSQL Backup and Restore Database
- No prior knowledge is required to take this course
There’s a reason why Postgres is so popular. 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!
Our Promise to You
By the end of this course, you will have learned how to create databases with PostgreSQL.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about PostgreSQL databases.
|Section 1 - Course Introduction|
|Installing PgAdmin And PostgreSQL||00:00:00|
|What Is A Database||00:00:00|
|Create Table Columns||00:00:00|
|Add Data To A Table||00:00:00|
|PostgreSQL Select Statements||00:00:00|
|PostgreSQL Where Clause||00:00:00|
|PostgreSQL AND Or NOT||00:00:00|
|PostgreSQL Order By||00:00:00|
|PostgreSQL Insert Into||00:00:00|
|PgAdmin Menu Walkthrough||00:00:00|
|PostgreSQL Foreign Keys||00:00:00|
|PostgreSQL Inner Join||00:00:00|
|PostgreSQL Join Where Hack||00:00:00|
|PostgreSQL Delete Table||00:00:00|
|PostgreSQL Import And Export Tables||00:00:00|
|PostgreSQL Backup And Restore Database||00:00:00|