Lessons:10Length:1.8 hours
1.4 Creating and Manipulating Tables
It all starts with a table, the primary means of organizing data within Postgres. In this lesson, we will learn about the lifecycle commands for handling tables, which are CREATE, INSERT, ALTER, UPDATE and DELETE.
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
