+91 88606 33966            edu_sales@siriam.in                   Job Opening : On-site Functional Trainer/Instructor | Supply Chain Management (SCM)

Siriam

Making Intellectuals Meet Excellence!

PostgreSQL Database Administration
Intermediate
Placeholder
PostgreSQL

PostgreSQL Database Administration

Mausomi Paul Mausomi Paul
Overview
Curriculum
  • 18 Sections
  • 46 Lessons
  • 40h Duration
Collapse All
Introduction
2 Lessons
  1. Introduction to PostgreSQL Server and Advance Features
  2. Postgres Client Server Architecture
Getting Started
4 Lessons
  1. Installing the PostgreSQL Server
  2. Setting Environment Variables
  3. Creating a Cluster
  4. Running a Server
Configuring of PostgreSQL Server
7 Lessons
  1. Connection Settings
  2. Security and Authentication
  3. Resource Settings
  4. WAL
  5. Error Reporting and Logging
  6. Autovacuum
  7. Runtime Statistics, etc.
Server Control
1 Lesson
  1. Postgres hosed based access configuration
Client and Tools
1 Lesson
  1. Introduction To PSQL
Creating and Managing Database
Obtaining Metadata
Transaction & Concurrency Control
Database Administration
2 Lessons
  1. Moving objects between tablespaces
  2. Using materialized views
Table Partitioning
Extensions
2 Lessons
  1. Accessing objects in other PostgreSQL databases (postgres_fdw, dblink)
  2. File_fdw, hstore, pgcrypto,etc
Security
5 Lessons
  1. User Management
  2. Preventing Connections
  3. Checking Secured Passwords
  4. Auditing Changes
  5. Encrypting Sensitive data
Monitoring and Diagnosis
9 Lessons
  1. Real-time viewing using pgAdmin
  2. Checking whether a user is connected
  3. Checking which queries are running
  4. Checking which queries are active or blocked
  5. Knowing who is blocking a query
  6. Killing a specific session
  7. Knowing when a table was last used
  8. Usage of disk space by temporary data
  9. Understanding why queries slow down
Performamce and Concurrency
3 Lessons
  1. Find and Tune Slow Running Queries
  2. Collecting regular statistics from pg_stat* views
  3. Speeding up queries without rewriting them
Regular Maintenance
3 Lessons
  1. Controlling automatic database maintenance
  2. Monitoring and tuning vacuum
  3. Updating Table Statistics & Vacuuming
Backup and Recovery
2 Lessons
  1. Planning Backups
  2. Backup Types & Restore
Moving Data
1 Lesson
  1. Exporting/Importing Data To/From A Flat File
Replication and Upgrades
4 Lessons
  1. Replication
  2. Handling Switchover and Failover
  3. Upgrading Best Practices
  4. Migration from Oracle to Postgres using Ora2PG

PostgreSQL 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 community that is dedicated to improving the platform to keep it relevant to today's time. Another focus for the community of developers is security; they keep evolving PostgreSQL and updating their security measures to keep up with the threats of today.

Learning Objectives of PostgreSQL Database Administration training

Those who complete the training course will gain knowledge and insight on the following topics under PostgreSQL:
  • What the PostgreSQL platform is and how it functions
  • PostgreSQL's system architecture
  • How to create and manage different databases using PostgreSQL
  • How to install and configure servers on PostgreSQL
  • The fundamentals of security with PostgreSQL
  • How to perform backups of databases
  • How to perform recovery of databases
  • Details about the point in time recovery
  • How to conduct routine maintenance checks

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Scroll to top