Tutorialspoint

PostgreSQL Database Administration

Postgres Database 14 For Database Administrators

Description

PostgreSQL Administration Course Overview

This course is targeted towards beginners, and DBAs with experience using another DBMS such as Microsoft SQL Server, MySQL, or Oracle. 

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Course Objectives

This course aims to provide the delegate with the knowledge to be able to install, administer, maintain, backup, recover and tune a PostgreSQL database.

Who will the Course Benefit?

This PostgreSQL Administration course is designed for professional database administrators who need to gain an understanding of the features and functionality that can be used to manage PostgreSQL 10, 11, 12, 13, 14, and 15 databases. This course is also suitable for users of PostgreSQL 9 databases.

Skills Gained

The delegate will learn and acquire skills as follows:

  • Install PostgreSQL

  • Create a database

  • Manage roles and privileges

  • Manage schemas

  • Examine statistics and system tables

  • Manage tablespaces

  • Understand error reporting and logging

  • Carry out periodic maintenance with VACUUM auto vacuum

  • Backup and restore databases

  • Create indexes to improve table access

  • Configure settings for increased performance

PostgreSQL is one of the most advanced open-source platforms available today. Multiple large-scale organizations such as Cisco and Apple use the tool for their web-based and mobile-based application development. It is managed by an open-source community that is dedicated to improving the platform to keep it relevant to today's time. Another focus for the community of developers is security; they keep evolving PostgreSQL and updating their security measures to keep up with the threats of today.

Goals

  • Install and Configure Postgres

  • Perform backups and restores

  • Create Roles and Grant Permissions

  • How To Manage Tablespaces

  • How To Optimize Database Backups

  • How To Migrate Databases

Prerequisites

  • No requirements

Show More

Curriculum

Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Feedbacks
  • No Feedbacks Posted Yet..!
PostgreSQL Database Administration
This Course Includes
  • 1 hours
  • 30 Lectures
  • Completion Certificate
  • Lifetime Access
  • 30-Days Money Back Guarantee

Sample Certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registgered users and counting who have advanced their careers with us.

X

Sample Certificate