PostgreSQL DBA Course

Become a Database Administrator for PostgreSQL by acquiring the required skills in this course

All Levels

Created by Yaw Boteng Last Updated 26/05/2023 18:04

$14,500.00 $15,000.00 3.33% off

What's Included

  • 3 Lectures
  • Access on tablet and phone
  • Certificate of completion

Preview

What you'll learn

  • Understand the PostgreSQL architecture
  • Installing PostgreSQL
  • Create databases
  • Get used to the command line interface: psql
  • Understand backup and restore procedures in PostgreSQL
  • Understand extensions in PostgreSQL
  • Create a hot standby database
  • Understand the optimizer, statistics and vacuum
  • Understand monitoring tools
  • Upgrades in PostgreSQL
  • Training Method
  • Recording of Presentation with numerous exercises, case studies, and live demos
  • Discussions forums and ask a question.
  • Hands on Lab assignments
  • Handouts for reference
  • Doubt clearing sessions by sharing screen one on one.

Course Curriculum

Expand all Collapse all

3 Lectures

00:00

Database and Storage Management 1 Lectures

Requirements

  • Recording of Presentation with numerous exercises, case studies, and live demos
  • Discussions forums and ask a question.
  • Hands on Lab assignments
  • Handouts for reference
  • Doubt clearing sessions by sharing screen one on one.

Description

Course Objectives

  • Understand the PostgreSQL architecture
  • Installing PostgreSQL
  • Create databases
  • Get used to the command line interface: psql
  • Understand backup and restore procedures in PostgreSQL
  • Understand extensions in PostgreSQL
  • Create a hot standby database
  • Understand the optimizer, statistics and vacuum
  • Understand monitoring tools
  • Upgrades in PostgreSQL

Training Method

  • Recording of Presentation with numerous exercises, case studies, and live demos
  • Discussions forums and ask a question.
  • Hands on Lab assignments
  • Handouts for reference
  • Doubt clearing sessions by sharing screen one on one.

Target Audience

  • Database administrators (DBA) as well as network, system and application administrators responsible for or supporting PostgreSQL databases

PostgreSQL Course Topics

Instructors

YB

8 Courses

0 Students

0 Reviews

Yaw Boteng