Course code: PostgreSQL5« Back

Comprehensive PostgreSQL Administration

Designed for database professionals who are responsible for administration and maintenance of PostgreSQL, who want to increase proficiency and learn best practices with 9.6. This special 1-week course teaches both foundational and advanced Postgres database administration topics. This immersive class offers hands-on experience with Postgres use cases based on years of field experience. It combines the core topics from Foundations of Postgres Administration and Advanced PostgreSQL Administration for version 9.6 into a one-week class, with significant savings over list price. This official EnterpriseDB (EDB) course includes one complimentary attempt at the PostgreSQL Associate Certification exam.

 DateDurationCourse priceHandbook priceCourse languageLocation 
2/17/2020 5 31 300 CZK included in course price Český jazyk GOPAS Praha
 
2/24/2020 5 1 380,00 EUR included in course price Slovenský jazyk GOPAS Bratislava
 
GTK 11/11/2019 5 1 380,00 EUR included in course price Slovenský jazyk GOPAS _Košice
 

AffiliateDurationCatalogue priceHandbook priceITB
Praha5 31 300 CZK included in course price 50
Brno5 31 300 CZK included in course price 50
Bratislava5 1 380,00 EUR included in course price 50

User intensity level

Who the course is for

  • Designed for database professionals who are responsible for administration and maintenance of PostgreSQL, who want to increase proficiency and learn best practices with 9.6

Required skills

  • Intermediate knowledge of RDBMS concepts
  • Basic understanding of SQL
  • No prior knowledge of PostgreSQL is required, but may be helpful for learning advanced topics

Teaching methods

Expert instruction with practical examples, computer practice

Literature

Electronic documantation

Certification

  • People considering taking the Associate Certification exam are strongly encouraged to complete the associated training course.
  • This course includes one complimentary attempt at the PostgreSQL Associate Certification exam

Course Outline

  • Postgres System Architecture
  • Getting Started – installation, setting env. variables, creating a cluster, connecting to the server
  • Configuration – connection, authentication, WAL, log, vacuum settings and more
  • Creating and Managing Databases – object hierarchy, databases, schemas, roles, users, groups and access control
  • Introduction to PSQL – basic conventions, commands and parameters
  • Using pgAdmin III
  • Security Basics – configuration, access control, ownership, etc.
  • SQL Primer – data types, basic queries, functions, constraints, views, sequences, indexes
  • Backup and Recovery – backup types and strategies
  • Point in Time Recovery
  • Routine Maintenance – query plan, table statistics, vacuuming, re-indexing, and more
  • Postgres Data Dictionary
  • Transactions and Concurrency
  • Performance Tuning
  • Table Partitioning
  • High Availability & Replication
  • Monitoring
  • Extension Modules

        Previous courses

        no preceding courses

        Next courses

        no following course
        Elektronická příručka kurzu PostgreSQL5

        Price:
        included in course price
        The prices are without VAT.


        Graph of course relations