Course: 22 Videos
Length: 2 Hours
Price: $49
In this course I’ll teach you how to setup and use PostgreSQL databases with the PgAdmin 4 interface!
There’s a reason why Postgres is so popular, find out why in this course!
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!
In this course, you learn to:
– 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 Walkthru
– PostgreSQL Foreign Keys
– PostgreSQL Inner Join
– PostgreSQL Join Where Hack
– PostgreSQL Delete Table
– PostgreSQL Import and Export Tables
– PostgreSQL Backup and Restore Database
– And More!
This course is perfect for anyone just starting out, you don’t need any special skills or prior knowledge to take this course.
And as always, we offer a 100% money back guarantee if you aren’t completely happy with the course. No questions asked!
What are you waiting for, let’s learn some PostgreSQL database wizardry!
-John Elder
CEO Codemy.com
Course Content…
| Module 1 | Intro To PostgreSQL Databases With PgAdmin For Beginners |
| Unit 1 | Introduction | Video 1 |
| Unit 2 | Installing pgAdmin and PostgreSQL | Video 2 |
| Unit 3 | What Is A Database | Video 3 |
| Unit 4 | pgAdmin Overview | Video 4 |
| Unit 5 | Create Table Columns | Video 5 |
| Unit 6 | Add Data To A Table | Video 6 |
| Unit 7 | PostgreSQL Select Statements | Video 7 |
| Unit 8 | PostgreSQL Where Clause | Video 8 |
| Unit 9 | PostgreSQL Wildcards | Video 9 |
| Unit 10 | PostgreSQL AND OR NOT | Video 10 |
| Unit 11 | PostgreSQL Order By | Video 11 |
| Unit 12 | PostgreSQL Insert Into | Video 12 |
| Unit 13 | PostgreSQL Update | Video 13 |
| Unit 14 | PostgreSQL Delete | Video 14 |
| Unit 15 | PostgreSQL Limit | Video 15 |
| Unit 16 | pgAdmin Menu Walkthru | Video 16 |
| Unit 17 | PostgreSQL Foreign Keys | Video 17 |
| Unit 18 | PostgreSQL Inner Join | Video 18 |
| Unit 19 | PostgreSQL Join Where Hack | Video 19 |
| Unit 20 | PostgreSQL Delete Table | Video 20 |
| Unit 21 | PostgreSQL Import and Export Tables | Video 21 |
| Unit 22 | PostgreSQL Backup and Restore Database | Video 22 |