Udemy – PostgreSQL Database Administration on Windows/Linux- Part 2 2024-8

PostgreSQL Database Administration on Windows/Linux – Part 2 is a PostgreSQL database administration training course published by Udemy Online Academy. PostgreSQL is a powerful open source relational database management system (RDBMS) known for its extensibility, reliability, and completeness of features. Database administration in PostgreSQL includes tasks such as installation, configuration, security management, performance tuning, backup and recovery, and general maintenance. In this training course, you will get acquainted with PostgreSQL database management and you will understand its basic and advanced concepts and principles. PostgreSQL is highly scalable both in terms of the amount of data it can handle and the number of concurrent users it can accommodate.

This course provides you with extensive knowledge of PostgreSQL database management with real-world examples. In this training course, you will learn topics such as an introduction to replication and its terms, master and slave configuration, types, modes and models of replication, log-based shipping standby in Windows and Linux, setting up and monitoring stream replication, stream replication At the same time, you will learn about automatic failover using Repmgr, the witness server, publishing and sharing, setting PostgreSQL Server parameters, and more. This training course is suitable for database administrators
Developers and people interested in PostgreSQL. After completing this course, you will have a high level of knowledge about PostgreSQL database management.

What you will learn in PostgreSQL Database Administration on Windows/Linux- Part 2:

• Log-based Shipping Standby on Windows and Linux
• Setting up and monitoring stream replication
• Automatic failover using Repmgr
• Setting PostgreSQL Server parameters
• Node Rejoin
• And …

Course specifications

Publisher: Udemy
Instructors: Sadiq Basha
Language: English
Level: Introductory to Advanced
Number of Lessons: 50
Duration: 7 hours and 35 minutes

Course topics

PostgreSQL Database Administration on Windows/Linux- Part 2 Prerequisites

Basic Knowledge of Database Concepts
PostgreSQL v12 Foundation
Internet access is required to download PostgreSQL Server
Working Knowledge on Windows and Linux

Pictures

PostgreSQL Database Administration on Windows/Linux- Part 2 introduction video

Installation guide

After Extract, watch with your favorite Player.

English subtitle

Quality: 720p

The 2024/8 version has increased the number of lessons by 10 and the duration by 55 minutes compared to 2023/3. The course quality has also been reduced from 1080p to 720p.

Download link

Download Part 1 – 1 GB

Download Part 2 – 538 MB

Size

1.5 GB