Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.Course ObjectivesThis 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 BenefitThis 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 GainedThe delegate will learn and acquire skills as follows:Install PostgreSQLCreate a databaseManage roles and privilegesManage schemasTransaction handling and concurrencyExamine statistics and system tablesManage tablespacesUnderstand error reporting and loggingCarry out periodic maintenance with VACUUM autovacuumBackup and restore databasesCreate indexes to improve table accessConfigure settings for increased performancePostgreSQL 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 . 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.

Overview
Section 1: Introduction

Lecture 1 Introduction

Lecture 2 What is postgres

Section 2: Install & Configure Postgres

Lecture 3 Install PortgreSQL on Linux

Lecture 4 Install PortgreSQL on Windows

Lecture 5 Understanding PostgreSQL Configuration files

Lecture 6 Connecting to PostgreSQL Database

Section 3: Managing Databases

Lecture 7 Creating your first database

Lecture 8 Altering PostgreSQL database

Lecture 9 Renaming PostgreSQL Database

Lecture 10 Chag Database Owner

Lecture 11 Chag The Tablespace of Database

Lecture 12 Demo: Altering Databases

Section 4: Managing Tablespaces

Lecture 13 Understanding tablespaces in PostgreSQL

Lecture 14 Creating a Tablespace in Postgres

Lecture 15 Altering Tablespaces in Postgres

Lecture 16 Dropping Tablespaces in Postgres

Section 5: Securing Your Server

Lecture 17 Creating users in Postgres

Lecture 18 Granting privileges in Postgres

Lecture 19 Revoking Privileges in Postgres

Lecture 20 Altering Roles in Postgres

Lecture 21 Dropping Roles in Postgres

Section 6: Backup & Restore Databases

Lecture 22 Backing up a Single Database

Lecture 23 Backing up all Databases

Lecture 24 Compressing Postgres Backups

Lecture 25 Splitting Backups into Multiple Files

Lecture 26 Backing up Remote Databases

Lecture 27 Optimizing Postgres Backups

Lecture 28 Restoring all Backup Types Database

Database administrators,DBAs

HomePage:

Https://anonymz.com/https://www.udemy.com/course/postgres-administration-for-database-administrator/

DOWNLOAD
1dl.net


[/b]

[b]uploadgig.com


rapidgator.net