Udemy – PostgreSQL Database Administration on Windows/Linux- Part 1 2024-3

PostgreSQL Database Administration on Windows/Linux- Part 1 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. The training content of this course will introduce you to topics such as PostgreSQL process and memory architecture, installing PostgreSQL v12 – Windows and Linux, setting PostgreSQL v12 environment variables, PostgreSQL page layout, database directory layout, PostgreSQL configuration files, Psql interface commands, working with You will learn about PostgreSQL objects, CRUD operations, table partitioning, Tablespace in PostgreSQL, maintenance and more. This course is recommended for database administrators, developers, architects and analysts, and anyone interested in PostgreSQL. After completing this course, you will have comprehensive knowledge about the PostgreSQL database management system and learn how to manage it.

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

• Database directory layout
• PostgreSQL configuration files
• Working with PostgreSQL objects
• Table partitioning
• Repair and maintenance
• And …

Course specifications

Publisher: Udemy
Instructors: Sadiq Basha
Language: English
Level: Introductory to Advanced
Number of Lessons: 85
Duration: 13 hours and 15 minutes

Course topics

PostgreSQL Database Administration on Windows/Linux- Part 1 Prerequisites

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

Pictures

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

Installation guide

After Extract, watch with your favorite Player.

English subtitle

Quality: 720p

The 2024/3 version has increased by 7 lessons and 48 minutes in duration compared to 2023/5. The course quality has also been reduced from 1080p to 720p.

Download link

Download Part 1 – 1 GB

Download Part 2 – 1 GB

Download Part 3 – 302 MB

Size

2.3 GB