PostgreSQL
by Dima Kassab
Start the free chapterThis 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.
Course content
Introduction3 lessons
Installation8 lessons
- Installing Locally5:111 credit or ad
- Regarding Installation on a Server3:371 credit or ad
- Stop and Start the Service Locally2:221 credit or ad
- Create / Drop / Connect to a Database pt. 15:121 credit or ad
- Create / Drop / Connect to a Database pt. 22:511 credit or ad
- Psql Help6:041 credit or ad
- Keywords and Identifiers2:421 credit or ad
- Comments3:031 credit or ad
Data Types8 lessons
Defining Tables14 lessons
- Create / Drop a Table Using Command Line4:101 credit or ad
- Primary Key Constraint5:401 credit or ad
- Foreign Key Constraint pt. 14:331 credit or ad
- Foreign Key Constraint pt. 23:391 credit or ad
- Foreign Key Constraint pt. 36:131 credit or ad
- Check Constraints pt. 15:461 credit or ad
- Check Constraints pt. 23:561 credit or ad
- Not Null Constraint3:421 credit or ad
- Unique Constraint3:341 credit or ad
- Create a Table Using pgAdmin3:501 credit or ad
- Creating Constraints Using pgAdmin pt. 16:351 credit or ad
- Creating Constraints Using pgAdmin pt. 24:341 credit or ad
- Default Values4:541 credit or ad
- Drop Table Cascade3:261 credit or ad
Working with Tables8 lessons
Queries19 lessons
- Simple Query3:011 credit or ad
- Retrieving a Portion of the Rows3:231 credit or ad
- Sorting Queries4:571 credit or ad
- Table and Column Aliases4:301 credit or ad
- Limit and Offset Options4:091 credit or ad
- Combining Queries5:311 credit or ad
- Aggregate Functions4:541 credit or ad
- Group By and Having pt. 15:511 credit or ad
- Group By and Having pt. 23:311 credit or ad
- Inner Joins Between Tables pt. 16:041 credit or ad
- Inner Joins Between Tables pt. 25:491 credit or ad
- Outer Joins Between Tables5:111 credit or ad
- Cross and Self Joins4:251 credit or ad
- Subquery Expressions pt. 13:571 credit or ad
- Subquery Expressions pt. 26:511 credit or ad
- Accessing Data Using pgadmin pt. 14:271 credit or ad
- Accessing Data Using pgadmin pt. 24:021 credit or ad
- Creating Views Using Command Line4:031 credit or ad
- Creating Views Using pgAdmin3:331 credit or ad
Transactions4 lessons
Modifying Tables5 lessons
Main Operators and Functions13 lessons
- Logical Operators5:101 credit or ad
- Comparison Operators6:081 credit or ad
- Mathematical Operators3:121 credit or ad
- Mathematical Functions6:321 credit or ad
- String Functions pt. 16:491 credit or ad
- String Functions pt. 23:091 credit or ad
- String Functions pt. 36:031 credit or ad
- Pattern Matching pt. 17:261 credit or ad
- Pattern Matching pt. 26:391 credit or ad
- Date and Time Operators5:081 credit or ad
- Date and Time Functions6:521 credit or ad
- Sequences6:561 credit or ad
- Conditional Expressions6:461 credit or ad