PostgreSQL Database Administration on Windows/Linux- Part 1

PostgreSQL Database Administration on Windows/Linux- Part 1, available at $84.99, has an average rating of 4.59, with 85 lectures, based on 4366 reviews, and has 18616 subscribers.

You will learn about Understand PostgreSQL Process and Memory Architecture. Install PostgreSQL v12 on Windows and Linux. How to Setup Environment Variable on Windows and Linux. PostgreSQL Directory Structure. PostgreSQL Configuration Files. How to use PSQL command line interface to connect to PostgreSQL. How to Create Database/User/Schema from utility and Psql commands. Learn how to use pg system catalogs. CRUD operations on PostgreSQL. Table Inheritance in PostgreSQL. Partitioning in PostgreSQL using Table Inheritance. Copy table from/to PostgreSQL. How to Create/Move/Drop Tablespace. Logical (pg dump, pgdumpall), Physical backup (Offline, Online). Continuous Archiving and PITR. What is Explain plan and how to calculate cost of query. Maintenance (Updating planner statistics, Vacuum, Routine Reindex, Cluster). What is Transaction Id Wraparound Failure and Vacuum Freeze. How to use Pgadmin 4 Interface. Uninstall PostgreSQL on Windows and Linux. Bonus Module Course Extra Documents Journey into Postgresql v13 Postgresql v13 – New Features Let's Explore Postgresql v15 Postgresql v15- New Features Postgresql v16- New Features This course is ideal for individuals who are Database Administrators or Accidental DBA's or Developers or Architects and Analyst or Students or Anyone who is curious about PostgreSQL It is particularly useful for Database Administrators or Accidental DBA's or Developers or Architects and Analyst or Students or Anyone who is curious about PostgreSQL.

Enroll now: PostgreSQL Database Administration on Windows/Linux- Part 1

Summary

Title: PostgreSQL Database Administration on Windows/Linux- Part 1

Price: $84.99

Average Rating: 4.59

Number of Lectures: 85

Number of Published Lectures: 85

Number of Curriculum Items: 85

Number of Published Curriculum Objects: 85

Original Price: CA$34.99

Quality Status: approved

Status: Live

What You Will Learn

Understand PostgreSQL Process and Memory Architecture.
Install PostgreSQL v12 on Windows and Linux.
How to Setup Environment Variable on Windows and Linux.
PostgreSQL Directory Structure.
PostgreSQL Configuration Files.
How to use PSQL command line interface to connect to PostgreSQL.
How to Create Database/User/Schema from utility and Psql commands.
Learn how to use pg system catalogs.
CRUD operations on PostgreSQL.
Table Inheritance in PostgreSQL.
Partitioning in PostgreSQL using Table Inheritance.
Copy table from/to PostgreSQL.
How to Create/Move/Drop Tablespace.
Logical (pg dump, pgdumpall), Physical backup (Offline, Online).
Continuous Archiving and PITR.
What is Explain plan and how to calculate cost of query.
Maintenance (Updating planner statistics, Vacuum, Routine Reindex, Cluster).
What is Transaction Id Wraparound Failure and Vacuum Freeze.
How to use Pgadmin 4 Interface.
Uninstall PostgreSQL on Windows and Linux.
Bonus Module
Course Extra Documents
Journey into Postgresql v13
Postgresql v13 – New Features
Let's Explore Postgresql v15
Postgresql v15- New Features
Postgresql v16- New Features

Who Should Attend

Database Administrators
Accidental DBA's
Developers
Architects and Analyst
Students
Anyone who is curious about PostgreSQL

Target Audiences

Database Administrators
Accidental DBA's
Developers
Architects and Analyst
Students
Anyone who is curious about PostgreSQL

PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.

PostgreSQL possesses robust feature sets including Multi-Version Concurrency Control (MVCC), point in time recovery, granular access controls, tablespaces, asynchronous replication, nested transactions, online/hot backups, a refined query planner/optimizer, and write ahead logging. It supports international character sets, multi-byte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. PostgreSQL is highly scalable both in the quantity of data it can manage and in the number of concurrent users it can accommodate.

The course provides the learner with an extensive knowledge of PostgreSQL Database Administration with real time examples.

Topics covered are:

PostgreSQL Process and Memory Architecture
Installation of PostgreSQL v12 – Windows and Linux
Setup PostgreSQL v12 Environment Variables – Windows and Linux
PostgreSQL Page Layout
Database Directory Layout
PostgreSQL Configuration Files
Cluster in PostgreSQL (Initdb,Start/Stop,Reload/Restart Cluster)
Createdb/Dropdb, Createuser/Dropuser Utility
Create Schema and Schema Search Path
Psql Interface Commands
Pg System Catalogs
Working with PostgreSQL Objects
CRUD Operations
Table Inheritance
Table Partitioning
Tablespace in PostgreSQL
Backup, Continuous Archiving and PITR (Point-in-Time-Recovery)
Explain plan and Query Execution Cost
Maintenance (Updating Planner Statistics, Vacuum, Routine Reindex & Cluster)
Data Fragmentation
Transaction ID wraparound, Vacuum freeze, Auto_Vacuum Demon
Pgadmin 4
Uninstall PostgreSQL v12 on Windows and Linux
Bonus Module
Journey into Postgresql v13
Postgresql v13 – New Features
Let’s Explore Postgresql v15
Postgresql v15 – New Features
Tour of Postgresql v16
Postgresql v16 – New Features

Course Curriculum

Chapter 1: Introduction

Lecture 1: PostgreSQL Introduction

Lecture 2: PostgreSQL Page Setup

Chapter 2: Installing PostgreSQL v12 on Windows and Linux

Lecture 1: PostgreSQL System Requirement

Lecture 2: Installing PostgreSQL v12 on Windows

Lecture 3: Setup PostgreSQL Environment Variable on Windows

Lecture 4: Installing PostgreSQL v12 on Linux

Lecture 5: Setup PostgreSQL Environment Variable on Linux

Chapter 3: PostgreSQL Architecture

Lecture 1: Process and Memory Architecture

Lecture 2: Postmaster Process

Lecture 3: Utility Processes

Lecture 4: Memory Segments

Lecture 5: Physical Files in PostgreSQL

Chapter 4: Database Cluster

Lecture 1: PostgreSQL Cluster (Initdb, Start/Stop/Restart/Reload)

Lecture 2: PostgreSQL Cluster Demo on Windows

Lecture 3: PostgreSQL Cluster Demo on Linux

Chapter 5: PostgreSQL Directory Layout

Lecture 1: Database Directory Layout

Lecture 2: Base Directory

Chapter 6: Configuration Files

Lecture 1: PostgreSQL.conf

Lecture 2: PostgreSQL.Auto.conf

Lecture 3: Pg_Ident.conf

Lecture 4: Pg_Hba.conf

Chapter 7: Create Objects(Database/User/Schema) and Privileges

Lecture 1: Create/Drop Database

Lecture 2: Create/Drop User

Lecture 3: Create/Drop Schema and Search Schema Path

Lecture 4: Grant/Revoke Privileges on Database Objects

Chapter 8: Using Psql Command Line Interface

Lecture 1: Psql Commands

Chapter 9: Working with Pg System Catalog

Lecture 1: Pg_Catalog & Time zones in PostgreSQL

Chapter 10: CRUD Operations in PostgreSQL

Lecture 1: CRUD Introduction

Lecture 2: Create Table, Data Types, Constraints, Functions and Operators

Lecture 3: Retrieve Data in PostgreSQL

Lecture 4: Update Records in a Table

Lecture 5: Delete Records in a Table

Chapter 11: Table Inheritance, Table Partitioning and Copy Table in PostgreSQL

Lecture 1: Table Inheritance

Lecture 2: Table Partitioning using Inheritance

Lecture 3: Copy Table

Chapter 12: Working with Tablespace

Lecture 1: Tablespace Introduction

Lecture 2: Create Tablespace on Windows and Linux

Lecture 3: Move Objects from Tablespace and Drop a Tablespace

Lecture 4: Temporary Tablespace in PostgreSQL

Chapter 13: Backup and Restore

Lecture 1: Introduction to PostgreSQL Backups

Lecture 2: Logical Backups on Windows and Linux

Lecture 3: How to Compress and Split Dump Files

Lecture 4: Restore Database using Logical Backups through Psql Interface

Lecture 5: Restore Database using Logical Backups through Pg_Restore Utility

Lecture 6: Offline Backups

Lecture 7: Introduction to Online Backups

Lecture 8: Setup Continuous Archiving In Windows

Lecture 9: Setup Continuous Archiving In Linux

Lecture 10: Online Low Level API Backup

Lecture 11: Pg_Basebackup Utility

Lecture 12: Point-In-Time-Recovery(PITR)

Lecture 13: Point-In-Time-Recovery(PITR) – Demo

Chapter 14: Maintenance in PostgreSQL

Lecture 1: Introduction to Maintenance

Lecture 2: How to Calculate Query Cost and Explain Plan

Lecture 3: Updating Planner StatisticsAnalyze

Lecture 4: Vacuum Freeze

Lecture 5: Data Fragmentation

Lecture 6: Introduction to Vacuum and Vacuum Full

Lecture 7: Transaction ID Wrap Around Failure

Lecture 8: How to Vacuum a Database and Remove Data Fragmentation

Lecture 9: Routine Re-Indexing

Lecture 10: How to Cluster a Table

Lecture 11: Auto-Vacuum in PostgreSQL

Chapter 15: Introduction to Pgadmin 4 Interface

Lecture 1: Pgadmin 4 – Demo

Chapter 16: Uninstall PostgreSQL v12 From Windows and Linux

Lecture 1: Uninstall PostgreSQL v12 From Windows – Demo

Lecture 2: Uninstall PostgreSQL v12 From Linux – Demo

Chapter 17: Bonus Module

Lecture 1: Introduction to PostgreSQL Upgrade

Lecture 2: PostgreSQL Upgrade using PG_Dumpall Utility.

Lecture 3: Introduction to PG_Upgrade Utility

Lecture 4: PostgreSQL Upgrade using PG_Upgrade Utility

Chapter 18: Journey into Postgresql- v13

Lecture 1: Introduction to Postgresql v13

Lecture 2: Postgresql v13 – New Features Part 1

Lecture 3: Postgresql v13 – New Features Part 2

Lecture 4: Postgresql v13 – New Features Part 3

Chapter 19: Let's Explore Postgresql -v15

Lecture 1: Introduction to Postgresql v15

Lecture 2: Postgresql v15 – New Features 1

Lecture 3: Postgresql v15 – New Features 2

Lecture 4: Postgresql v15 – New Features 3

Chapter 20: Tour of Postgresql -v16

Lecture 1: Introduction to Postgresql v16

Lecture 2: Postgresql v16 – New Features 1

Instructors

Sadiq Basha
Senior Production Database Administrator

Rating Distribution

1 stars: 32 votes
2 stars: 57 votes
3 stars: 438 votes
4 stars: 1755 votes
5 stars: 2084 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu