Lessons: 10Length: 1.8 hours
This course will get you up to speed on using PostgreSQL databases. We will cover the command line tools, the PGAdmin GUI tool, the unique hstore extension, and much more. By the conclusion of this course, hopefully, you’ll feel confident to kick-start your own Postgres-based projects!
1.PostgreSQL Essentials
1.1Intro01:54
1.1
Intro
01:54
1.2History of Postgres and Installation06:09
1.2
History of Postgres and Installation
06:09
1.3Tour of psql09:28
1.3
Tour of psql
09:28
1.4Creating and Manipulating Tables15:15
1.4
Creating and Manipulating Tables
15:15
1.5Data Types - Part 115:55
1.5
Data Types - Part 1
15:55
1.6Data Types - Part 217:37
1.6
Data Types - Part 2
17:37
1.7Querying Data - the Select Statement12:45
1.7
Querying Data - the Select Statement
12:45
1.8Organizing Queries15:44
1.8
Organizing Queries
15:44
1.9The hstore Extension13:50
1.9
The hstore Extension
13:50
1.10Conclusion01:55
1.10
Conclusion
01:55
