PostgreSQL Database Administration

This class covers the tasks that a database administrator faces daily, starting from basic operations to some intermediate techniques. Course notes use pgAdmin as the graphical administration tool.

Prerequisites Topics Acquired skills

SQL basics

Basics of databases

• Introduction to PostgreSQL

• Server Configuration

• Database Administration

• User Administration

• Understanding Database Object Types

• Permissions & Security

• Running SQL

• Monitoring

• VACUUM, Freezing & Avoiding Wraparound

• Maintenance

• Basics of PostgreSQL database administration

• PostgreSQL basics

Tag: Software development, Systems Administration

Length: 2.00 days

Upcoming related events

Tieniti in contatto con noi.

Iscriviti alla nostra newsletter trimestrale: riceverai le ultime notizie su 2ndQuadrant e aggiornamenti sulle tecnologie da noi supportate

La tua privacy è tutelata in base alla normativa vigente (art. 13 D. Lgs. 30.06.2003, n. 196).