Practitioner Level
5 Hands-on labs

PostgreSQL Administration Deep Dive

By Landon Fowler

Learn how to install, configure, use, and troubleshoot PostgreSQL — the world's most advanced open-source database.

See Pricing
5 hours
  • 39 Lessons
  • 5 Hands-On Labs

About the course

PostgreSQL is the world’s most advanced open-source database. With a focus on being open source, standards compliant, and extensible, it has become a popular choice across a wide variety of use cases.

In this course, we cover how to install, configure, use, and troubleshoot PostgreSQL. Whether you’ve worked with other databases before or are wanting to use PostgreSQL as your first, this course has something for everyone.

Lab Highlights

Working With Data in PostgreSQL Using System Catalogs to Investigate a PostgreSQL Server Backing up and Recovering PostgreSQL on CentOS Installing PostgreSQL on CentOS Configuring PostgreSQL on CentOS
Contact SalesSee Pricing
  • Chapter 1 3 Lessons Getting Started 6:14

    An Important Note About A Cloud Guru and Linux Academy Courses

    1:19

    Course Introduction

    4:18

    About the Training Architect

    0:37
  • Chapter 2 2 Lessons Concepts Overview 10:15

    Database and RDBMS Introduction

    6:17

    PostgreSQL History

    3:58
  • Chapter 3 4 Lessons Technical Overview 36:57

    PostgreSQL Architecture

    10:06

    Clustering Discussion

    9:43

    Clients

    4:06

    Psql

    13:02
  • Chapter 4 3 Lessons Installation 29:33

    CentOS Installation

    9:11

    Ubuntu Installation

    5:22

    Installing PostgreSQL on CentOS

    15:00 Hands-On Lab
  • Chapter 5 5 Lessons Configuration 1:04:59

    Server Configuration

    15:54

    Authentication and Authorization

    6:39

    Assigning Permissions

    7:13

    Database Configuration

    5:13

    Configuring PostgreSQL on CentOS

    30:00 Hands-On Lab
  • Chapter 6 4 Lessons Routine Maintenance 46:35

    Vacuuming

    7:20

    Indexes

    3:10

    Backup and Recovery

    6:05

    Backing up and Recovering PostgreSQL on CentOS

    30:00 Hands-On Lab
  • Chapter 7 3 Lessons Troubleshooting 22:57

    System Catalogs

    4:12

    Using pgAdmin

    3:45

    Using System Catalogs to Investigate a PostgreSQL Server

    15:00 Hands-On Lab
  • Chapter 8 5 Lessons Creating Objects 20:22

    Database

    3:34

    Schema

    2:29

    Table

    4:37

    View

    4:25

    Index

    5:17
  • Chapter 9 3 Lessons Changing Data 10:34

    Insert

    5:59

    Update

    2:28

    Delete

    2:07
  • Chapter 10 2 Lessons Selecting Data 18:07

    Select

    11:45

    Joins

    6:22
  • Chapter 11 4 Lessons Programming 44:17

    Stored Procedures

    4:20

    Triggers

    5:02

    Extending SQL

    4:55

    Working With Data in PostgreSQL

    30:00 Hands-On Lab
  • Chapter 12 1 Lesson Final Steps 3:00

    What's Next

    3:00

What you will need

  • A familiarity with Linux, command line, and database concepts is suggested.

What are Hands-on Labs

What's the difference between theoretical knowledge and real skills? Practical real-world experience. That's where Hands-on Labs come in! Hands-on Labs are guided, interactive experiences that help you learn and practice real-world scenarios in real cloud environments. Hands-on Labs are seamlessly integrated in courses, so you can learn by doing.

Get Started
Who’s going to be learning?
MyselfMy Organization
Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Don't have an account?