Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

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

    PostgreSQL

    Subscriber Reviews • Browse Similar Topics

    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