Overview

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 ArchitectureInstallation of PostgreSQL on Windows and Linux Setup PostgreSQL Environment Variables - Windows and LinuxPostgreSQL Storage InternalsDatabase Directory LayoutPostgreSQL Configuration FilesCluster in PostgreSQL (Initdb,Start/Stop,Reload/Restart Cluster)Createdb/Dropdb, Createuser/Dropuser UtilityBest Practices for User Management.Create Schema and Schema Search PathPgpass FilePsqlrc.confPsql Interface CommandsPg System CatalogsWorking with PostgreSQL ObjectsCRUD OperationsMERGE AND MERGE RETURNINGTable Inheritance Table PartitioningTable Partitioning with InheritanceTablespace in PostgreSQLBackup's, Continuous Archiving and PITR (Point-in-Time-Recovery)Incremental Backups using Pg_basebackup.Wal Summarizer ProcessExplain plan and Query Execution CostMaintenance (Updating Planner Statistics, Vacuum, Routine Reindex & Log File Maintenance)Best Practices for Routine Reindexing.Data FragmentationVacuum, Vacuum Full, Auto Vacuum DameonBest Practices for Vacuum Commands.Automating Backup's and Maintenance Task.Pgadmin 4 Upgrade PostgreSQL (Pg_Dumpall & Pg_Upgrade Utility)Uninstall PostgreSQL on Windows and LinuxJourney into Postgresql v13Postgresql v13 - New FeaturesLet's Explore Postgresql v15Postgresql v15 - New FeaturesTour of Postgresql v16Postgresql v16 - New Features

Skills

Reviews