PostgreSQL Administration Deep Dive

By Landon Fowler

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

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.

  • 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 14:33

    CentOS Installation

    9:11

    Ubuntu Installation

    5:22

    Installing PostgreSQL on CentOS

    0:00 Hands-On Lab
  • Chapter 5 5 Lessons Configuration 34:59

    Server Configuration

    15:54

    Authentication and Authorization

    6:39

    Assigning Permissions

    7:13

    Database Configuration

    5:13

    Configuring PostgreSQL on CentOS

    0:00 Hands-On Lab
  • Chapter 6 4 Lessons Routine Maintenance 16:35

    Vacuuming

    7:20

    Indexes

    3:10

    Backup and Recovery

    6:05

    Backing up and Recovering PostgreSQL on CentOS

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

    System Catalogs

    4:12

    Using pgAdmin

    3:45

    Using System Catalogs to Investigate a PostgreSQL Server

    0: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 14:17

    Stored Procedures

    4:20

    Triggers

    5:02

    Extending SQL

    4:55

    Working With Data in PostgreSQL

    0: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.

Practice alongside courses in Cloud Playground

What is Cloud Playground? Cloud Playground lets you build skills in real-world AWS, Google Cloud, and Azure environments. Spin up risk-free Sandboxes, Servers and Terminals and follow along with courses, test a new idea or prepare for exams.

Get Started
Who’s going to be learning?

How many seats do you need?

  • $499 USD per seat per year
  • Billed Annually
  • Renews in 12 months

Ready to accelerate learning?

For over 25 licenses, a member of our sales team will walk you through a custom tailored solution for your business.


$2,495.00

Checkout
Sign In
Welcome Back!

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