by Pavan Podila
Lessons:10Length:1.8 hours

For full access to all 10 lessons, including source files, subscribe with Elements.
- Overview
- Transcript
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 Essentials10 lessons, 1:50:32
10 lessons, 1:50:32
Free Lesson 1.1Intro01:54
Free Lesson
1.1
Intro
01:54
Free Lesson 1.2History of Postgres and Installation06:09
Free Lesson
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
Continue watching with Elements
Continue watching with Elements