VTC - PostgreSQL Tutorials (2012)

Introduction
About the Course (02:32)
About PostgreSQL (03:31)
Resources (05:17)
Installation
Installing Locally (05:11)
Regarding Installation on a Server (03:37)
Stop and Start the Service Locally (02:22)
Create / Drop / Connect to a Database pt. 1 (05:12)
Create / Drop / Connect to a Database pt. 2 (02:51)
Psql Help (06:04)
Keywords and Identifiers (02:42)
Comments (03:03)
Data Types
Numeric Types (05:39)
Character Types (03:26)
Date / Time Types pt. 1 (06:22)
Date / Time Types pt. 2 (04:53)
Boolean Types (03:24)
Enumerated Types (03:08)
Geometric Types (05:24)
Arrays (04:05)
Defining Tables
Create / Drop a Table Using Command Line (04:10)
Primary Key Constraint (05:40)
Foreign Key Constraint pt. 1 (04:33)
Foreign Key Constraint pt. 2 (03:39)
Foreign Key Constraint pt. 3 (06:13)
Check Constraints pt. 1 (05:46)
Check Constraints pt. 2 (03:56)
Not Null Constraint (03:42)
Unique Constraint (03:34)
Create a Table Using pgAdmin (03:50)
Creating Constraints Using pgAdmin pt. 1 (06:35)
Creating Constraints Using pgAdmin pt. 2 (04:34)
Default Values (04:54)
Drop Table Cascade (03:26)
Working with Tables
Insert pt. 1 (04:31)
Insert pt. 2 (05:28)
Update (04:59)
Delete (04:22)
Cascade Option (07:22)
Truncate (03:05)
Working with Tables Using pgAdmin pt. 1 (07:09)
Working with Tables Using pgAdmin pt. 2 (05:05)
Queries
Simple Query (03:01)
Retrieving a Portion of the Rows (03:23)
Sorting Queries (04:57)
Table and Column Aliases (04:30)
Limit and Offset Options (04:09)
Combining Queries (05:31)
Aggregate Functions (04:54)
Group By and Having pt. 1 (05:51)
Group By and Having pt. 2 (03:31)
Inner Joins Between Tables pt. 1 (06:04)
Inner Joins Between Tables pt. 2 (05:49)
Outer Joins Between Tables (05:11)
Cross and Self Joins (04:25)
Subquery Expressions pt. 1 (03:57)
Subquery Expressions pt. 2 (06:51)
Accessing Data Using pgadmin pt. 1 (04:27)
Accessing Data Using pgadmin pt. 2 (04:02)
Creating Views Using Command Line (04:03)
Creating Views Using pgAdmin (03:33)
Transactions
Starting and Ending a Transaction (05:35)
Savepoints (05:26)
DeadLocks (05:18)
System Columns (05:24)
Modifying Tables
Changing a Column Data Type and Default Value (05:21)
Adding / Removing a Column (04:39)
Adding / Removing a Constraint (06:21)
Renaming a Column / Table (03:03)
Modifying Tables Using pgAdmin (04:53)
Main Operators and Functions
Logical Operators (05:10)
Comparison Operators (06:08)
Mathematical Operators (03:12)
Mathematical Functions (06:32)
String Functions pt. 1 (06:49)
String Functions pt. 2 (03:09)
String Functions pt. 3 (06:03)
Pattern Matching pt. 1 (07:26)
Pattern Matching pt. 2 (06:39)
Date and Time Operators (05:08)
Date and Time Functions (06:52)
Sequences (06:56)
Conditional Expressions (06:46)
Schemas / Privileges
Create / Drop Schemas (06:25)
Grant / Revoke Privileges on Tables (06:03)
Grant / Revoke Privileges on Columns (06:24)
Grant / Revoke Privileges Using pgAdmin (04:02)
Indexes
Index Usage and Benefits (03:02)
Index Types (02:52)
Create and Drop an Index (05:23)
Multi-Column Index (04:10)
Indexes on Expressions (05:09)
Unique Index and Partial Index (02:52)
Create and Drop Index Using pgAdmin (03:52)
Conclusion
Course Wrap Up (04:30)
Credits
About the Author (01:59)

General
Complete name : 0001 About the Course.mov
Format : MPEG-4
Format profile : QuickTime
Codec ID : qt
File size : 3.47 MiB
Duration : 2mn 31s
Overall bit rate : 192 Kbps
Encoded date : UTC 2012-02-03 02:13:19
Tagged date : UTC 2012-02-03 02:13:20
Writing library : Apple QuickTime

Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings, CABAC : No
Format settings, ReFrames : 2 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 2mn 31s
Bit rate : 127 Kbps
Width : 800 pixels
Height : 600 pixels
Display aspect ratio : 4:3
Frame rate mode : Constant
Frame rate : 15.000 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.018
Stream size : 2.30 MiB (66%)
Language : English
Encoded date : UTC 2012-02-03 02:13:19
Tagged date : UTC 2012-02-03 02:13:20
Color primaries : BT.601-6 525, BT.1358 525, BT.1700 NTSC, SMPTE 170M
Transfer characteristics : BT.709-5, BT.1361
Matrix coefficients : BT.601-6 525, BT.1358 525, BT.1700 NTSC, SMPTE 170M

Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 2mn 31s
Bit rate mode : Constant
Bit rate : 64.0 Kbps
Channel(s) : 1 channel
Channel positions : Front: C
Sampling rate : 44.1 KHz
Compression mode : Lossy
Stream size : 1.12 MiB (32%)
Language : English
Encoded date : UTC 2012-02-03 02:13:19
Tagged date : UTC 2012-02-03 02:13:20