Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

This VTC course is an introduction to the popular open source and free database management system PostgreSQL. Author Dima Kassab covers the basics needed to create databases and database objects. The course assumes no prior knowledge of database concepts. It sets the groundwork for more advanced topics such as database administration and development. Topics covered include: installations, data types, main database operators/functions, and creating/modifying database objects such as tables, views, indexes, and sequences. To begin learning today, simply click on the movie links.

Subscriber Reviews

Average Rating: 3.5 out of 5 rating Based on 2 Ratings

"Great introductory survey of the core features" - by Pat Wellington on 18-MAR-2013
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
This video series is an excellent primer for new Postgres users.  Although the pace is geared for beginners, the videos contain a lot of Postgres details that will help an experienced RDBMS user get up speed on Postgres quickly.  (I did jump ahead at points.)
Report as Inappropriate

Table of Contents

Chapter/Selection

Time

Introduction

About the Course

Play Video

00:02:31

About PostgreSQL

Play Video

00:03:31

Resources

Play Video

00:05:17

Installation

Installing Locally

Play Video

00:05:11

Regarding Installation on a Server

Play Video

00:03:36

Stop and Start the Service Locally

Play Video

00:02:21

Create / Drop / Connect to a Database pt. 1

Play Video

00:05:11

Create / Drop / Connect to a Database pt. 2

Play Video

00:02:50

Psql Help

Play Video

00:06:03

Keywords and Identifiers

Play Video

00:02:42

Comments

Play Video

00:03:03

Data Types

Numeric Types

Play Video

00:05:39

Character Types

Play Video

00:03:25

Date / Time Types pt. 1

Play Video

00:06:21

Date / Time Types pt. 2

Play Video

00:04:52

Boolean Types

Play Video

00:03:24

Enumerated Types

Play Video

00:03:08

Geometric Types

Play Video

00:05:23

Arrays

Play Video

00:04:05

Defining Tables

Create / Drop a Table Using Command Line

Preview

00:04:10

Primary Key Constraint

Preview

00:05:39

Foreign Key Constraint pt. 1

Preview

00:04:33

Foreign Key Constraint pt. 2

Preview

00:03:39

Foreign Key Constraint pt. 3

Preview

00:06:12

Check Constraints pt. 1

Preview

00:05:45

Check Constraints pt. 2

Preview

00:03:55

Not Null Constraint

Preview

00:03:41

Unique Constraint

Preview

00:03:34

Create a Table Using pgAdmin

Preview

00:03:49

Creating Constraints Using pgAdmin pt. 1

Preview

00:06:34

Creating Constraints Using pgAdmin pt. 2

Preview

00:04:33

Default Values

Preview

00:04:54

Drop Table Cascade

Preview

00:03:26

Working with Tables

Insert pt. 1

Preview

00:04:30

Insert pt. 2

Preview

00:05:28

Update

Preview

00:04:59

Delete

Preview

00:04:22

Cascade Option

Preview

00:07:22

Truncate

Preview

00:03:04

Working with Tables Using pgAdmin pt. 1

Preview

00:07:08

Working with Tables Using pgAdmin pt. 2

Preview

00:05:04

Queries

Simple Query

Preview

00:03:01

Retrieving a Portion of the Rows

Preview

00:03:23

Sorting Queries

Preview

00:04:56

Table and Column Aliases

Preview

00:04:29

Limit and Offset Options

Preview

00:04:09

Combining Queries

Preview

00:05:30

Aggregate Functions

Preview

00:04:53

Group By and Having pt. 1

Preview

00:05:51

Group By and Having pt. 2

Preview

00:03:30

Inner Joins Between Tables pt. 1

Preview

00:06:04

Inner Joins Between Tables pt. 2

Preview

00:05:48

Outer Joins Between Tables

Preview

00:05:11

Cross and Self Joins

Preview

00:04:24

Subquery Expressions pt. 1

Preview

00:03:57

Subquery Expressions pt. 2

Preview

00:06:50

Accessing Data Using pgAdmin pt. 1

Preview

00:04:27

Accessing Data Using pgAdmin pt. 2

Preview

00:04:01

Creating Views Using Command Line

Preview

00:04:03

Creating Views Using pgAdmin

Preview

00:03:33

Transactions

Starting and Ending a Transaction

Preview

00:05:35

Savepoints

Preview

00:05:26

DeadLocks

Preview

00:05:18

System Columns

Preview

00:05:23

Modifying Tables

Changing a Column Data Type and Default Value

Preview

00:05:21

Adding / Removing a Column

Preview

00:04:38

Adding / Removing a Constraint

Preview

00:06:21

Renaming a Column / Table

Preview

00:03:02

Modifying Tables Using pgAdmin

Preview

00:04:53

Main Operators and Functions

Logical Operators

Preview

00:05:09

Comparison Operators

Preview

00:06:08

Mathematical Operators

Preview

00:03:12

Mathematical Functions

Preview

00:06:31

String Functions pt. 1

Preview

00:06:49

String Functions pt. 2

Preview

00:03:09

String Functions pt. 3

Preview

00:06:03

Pattern Matching pt. 1

Preview

00:07:25

Pattern Matching pt. 2

Preview

00:06:38

Date and Time Operators

Preview

00:05:08

Date and Time Functions

Preview

00:06:52

Sequences

Preview

00:06:56

Conditional Expressions

Preview

00:06:46

Schemas / Privileges

Create / Drop Schemas

Preview

00:06:24

Grant / Revoke Privileges on Tables

Preview

00:06:02

Grant / Revoke Privileges on Columns

Preview

00:06:23

Grant / Revoke Privileges Using pgAdmin

Preview

00:04:02

Indexes

Index Usage and Benefits

Preview

00:03:02

Index Types

Preview

00:02:51

Create and Drop an Index

Preview

00:05:23

Multi-Column Index

Preview

00:04:09

Indexes on Expressions

Preview

00:05:08

Unique Index and Partial Index

Preview

00:02:51

Create and Drop Index Using pgAdmin

Preview

00:03:51

Conclusion

Course Wrap Up

Preview

00:04:30

Credits

About the Author

Preview

00:01:59

Extras

The publisher has provided additional content related to this title.


Description
Content

These files have been provided by the publisher.

  • postgresql.zip