PostgreSQL Database Administration On AlmaLinux

[BaDshaH]

Published 1/2024
Created by Shruchin Boreda
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 51 Lectures ( 4h 34m ) | Size: 1.85 GB

PostgreSQL Database Administration v13

[b]What you'll learn:[/b]
PostgreSQL Database Administration
Enhanced features
Performance Tuning
Database Upgrade

[b]Requirements:[/b]
No prerequisites

[b]Description:[/b]
Why PostgreSQL?PostgreSQL is an opensource RDBMS DB, which is widely used across globally with it unique features and huge community. The DB doesn't have any size limitations.The maximum size of a table is 32TB, you can assume how easily it stores the data. With the new generations servers available round the corner of the world and many great mindscontributing to the database, PostgreSQL stands tall.Timely releases with enhanced features, and being open source PostgreSQL stands far away from the competitors.This course starts from basic to advance levelBelow are the list of topics which will be discussed:Setting up the server with AlmaLinuxInstalling DB BinariesCreating Directories as our requirementInitializing the DB clusterPostgreSQL Architecture.Physical filesconfiguration fileshow to perform deploymentsUser ManagementSchema Managementhow to set search_pathLogical objectsDefault Tablespaces and User defined tablespaceBackup and Restore which include Logical, Physical, filesystem, compressed and split backups.Utilities used for backupsSetting in archivelog mode.performing wal switch manuallyMaintenance Tasks which include vacuum, vacuumfull and analyzekilling inactive session from the DBDatabase upgrade from v13 to v15 with pg_upgradeExtensions in postgresviews in postgreSQLpgbench and pgbouncer overviewEnhancements in postgreSQL

Who this course is for:
Database Administrators willing to learn PostgreSQL
Students
Database Developers
Willing to learn PostgreSQL

Homepage

[To see links please register or login]

[To see links please register or login]