Login | Create new business account

Courses: RLPG201 - PostgreSQL Advanced DBA


Classroom3 daysFull-timeCoursesEnglish




This three-day course provides everything included in the standard DBA, with some more depth.

 

It also covers topics like replication, high availability clustering and tuning.

 

Course Format

This class is 90% theory and 10% informal labs. The course is held in local language or English. Documentation is only provided in English.

 

 

Agenda

 

Day 1: 

  • Introduction and Architecture
  • Installation of PostgreSQL
  • PgAdmin and psql
  • Data design and Data types
  • Using large objects
  • MVCC in PostgreSQL

 

Day 2:

  • Basic configurations
  • Security
  • Logging and Monitoring
  • Routine maintenance
  • Indexing and fulltext indexing

 

Day 3:

  • Partitioning 
  • Backup and recovery 
  • Performance and tuning 
  • Basic high availability
  • Warm standby and Slony
  • SQL Optimization


Prerequisites


SQL, basic knowledge about database administration in any RDBMS.



Target audience


DBAs who administer and maintain installations of PostgreSQL.


Instructors

Magnus Hagander

Senior database architect, developer and systems administrator with a broad experience through most of the stack, from hardware to application development. Part of the core developer team for the PostgreSQL open-source relational database. Experienced course instructor and public speaker.



Booking
RLPG201 - PostgreSQL Advanced DBA

Start here
100% secure form
Takes a minute to complete
Quick response

Campaign!
Fields marked with * are mandatory
Preferred currency *
Date and place *
Participants
How many? (Gift card)
Evt. kampanjekode (Gift card)
Kampanjekoden er korrekt og rabatt er lagt til.
Fant ingen kampanje. Skrev du kampanjekoden riktig?
Kampanjekode er korrekt, men kampanjen gir ikke bedre pris enn nåværende kampanje.
Delegate {{$index+1}}
{{item.is_required ? item.title + '*' : item.title}} {{item.tooltip}}
{{item.title}}
{{item.title}}
{{item.title}}
Filen ble lastet opp
Filen ble fjernet
Laster opp... {{item.upload_progress}}%
{{ file.file.name }} Fjern
{{ctrl.total_price-ctrl.total_with_discount | fprice}} kr {{ctrl.currency}}
{{ctrl.total_vat | fprice}} kr {{ctrl.currency}}
X

MVA per produkt:

{{arr[1]}}
Number: 1+2 *
Please correct the following and try again
{{errors_msg}}
Submitting ...
Wait until the file upload is complete


Payment will be made via Payex (VISA, MasterCard, Diners Club, Eurocard and others)





Powered by