PostgreSQL: Getting Started
In this course we will go over basics of PostgreSQL, often called the world's most advanced open source database.
What you'll learn
PostgreSQL is commonly known as Postgres and is is often referred to as a the world's most advanced open source database. In this course, we will go over the basics of the PostgreSQL. We will cover topics ranging from installations, to writing basic queries and retrieving data from tables. We will also explore the logic of join, and a few best practices.
Table of contents
- Getting Started 1m
- Scenario 1 Task 1: Retrieve Data From Table 4m
- Scenario 1 Task 2: Order Data by Columnnames 3m
- Scenario 2 Task 1: Count Distinct Values 5m
- Scenario 2 Task 2: Using Having Clause 3m
- Scenario 3 Task 1: Update Table With New Data 4m
- Scenario 3 Task 2: Insert Data Into Table 4m
- Scenario 3: Generate Script With pgAdmin III 2m
- Scenario 4: Delete Rows From Table 3m
- Summary 1m
- Getting Started 1m
- Scenario Setup 2m
- Scenario 1: Inner Join 2m
- Demo 1: Scenario Setup 2m
- Demo 1: Inner Join 4m
- Scenario 2: Left Outer Join 2m
- Demo 2: Left Outer Join 4m
- Scenario 3: Right Outer Join 2m
- Demo 3: Right Outer Join 3m
- Scenario 4: Cross Join 2m
- Demo 4: Cross Join 2m
- Scenario 5: Full Outer Join 2m
- Demo 5: Full Outer Join 2m
- Summary 1m
About the author
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 81 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.