O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

PostgreSQL

Video Description

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.

Table of Contents

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