Postgres Administration For Database Administrator

0

1

2

3

4

5

Posted on 16 Nov 11:17 | by mitsumi | 21 views

Published 11/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 828.05 MB | Duration: 1h 29m

Postgres 14 Database Administration

What you'll learn
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
Requirements
No requirements
Description
PostgreSQL Administration Course OverviewThis course is targeted towards beginners, 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 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 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 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 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.
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 Changing Database Owner
Lecture 11 Changing 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