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 
9/2/2019 5 31 300 CZK included in course price Český jazyk GOPAS Praha
 
2/17/2020 5 31 300 CZK included in course price Český jazyk GOPAS Praha
 
10/14/2019 5 1 380,00 EUR included in course price Slovenský jazyk GOPAS Bratislava
 

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