Course Outline

Introduction

  • Overview of PostgreSQL features and architecture
  • Basics of database administration

Getting Started

  • Installing PostgreSQL
  • Configuring a pgAdmin 4 client
  • Creating a database user
  • Creating a database

Database Operations

  • SQL syntax, functions, and operators
  • Data definition and data types
  • User-defined data types
  • Table schemas
  • Creating and modifying tables
  • Manipulating data in tables
  • Querying and filtering data
  • Exploring constraints
  • Conversion functions
  • Joining multiple tables
  • Combining queries
  • Indexes and full-text search
  • Concurrency control
  • Regular expressions

Database Server Administration

  • Security and encryption
  • Access roles and permissions
  • Backup and restore
  • Upgrading PostgreSQL
  • High availability
  • Load balancing and replication
  • Statistics and monitoring

High Performance Tuning

  • Resource management
  • Monitoring query performance
  • Parameter tuning
  • Index optimization
  • Query optimization
  • Scalability and partitioning

External Tools for Monitoring and Observability

  • pgAdmin
  • pgBadger
  • pgbench
  • node-exporter Prometheus, Grafana
  • Zabbix

Troubleshooting

Summary and Next Steps

Requirements

  • Basic knowledge in database administration
  • Familiarity with SQL language

Audience

  • Database administrators
  • System administrators
  21 Hours
 

Testimonials (2)

Related Courses

Related Categories