Postgres Administration For Database Administrator

What you'll learn
Install and Configure Postgres
Perform backups and restores
Create Roles and Grant Permissions
How To Manage Tablespaces
How To Optimize Database Backups
How To Migrate Databases
Requirements
No requirements
Description
PostgreSQL Administration Course OverviewThis course is targeted towards beginners, DBAs with experience using another DBMS such as Microsoft SQL Server, MySQL or Oracle. Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.Course ObjectivesThis course aims to provide the delegate with the knowledge to be able to install, administer, maintain, backup, recover and tune a PostgreSQL database.Who will the Course Benefit?This PostgreSQL Administration course is designed for professional database administrators who need to gain an understanding of the features and functionality that can be used to manage PostgreSQL 10, 11, 12, 13, 14 and 15 databases. This course is also suitable for users of PostgreSQL 9 databases.Skills GainedThe delegate will learn and acquire skills as follows:Install PostgreSQLCreate a databaseManage roles and privilegesManage schemasTransaction handling and concurrencyExamine statistics and system tablesManage tablespacesUnderstand error reporting and loggingCarry out periodic maintenance with VACUUM autovacuumBackup and restore databasesCreate indexes to improve table accessConfigure settings for increased performancePostgreSQL is one of the most advanced open-source platforms available today. Multiple large-scale organizations such as Cisco and Apple use the tool for their web-based and mobile-based application development. It is managed by an open-source...

Read more

Continue reading...