Login | Create new business account

Courses: RLPG101 - PostgreSQL DBA


Classroom2 daysFull-timeCoursesEnglish




This two-day course provides students with the knowledge and concepts on how to administer, maintain and troubleshoot PostgreSQL. Topics covered include installation, configuration, basic tuning, monitoring and backup/recovery. Some basic database design work is also included.

 

Course Format

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

 

 

Agenda

  

  • Introduction and Architecture
  • Installations
  • Using PgAdmin and psql
  • MVCC in PostgreSQL
  • VACUUM
  • Cache Management
  • Basic configuration 
  • Security and Logging
  • Monitoring and statistics
  • Routing maintenance
  • Backup and recovery


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.



Sjekk om du er registrert fra før

Før vi går videre ønsker vi å ta en rask sjekk for å se om du allerede er registrert i systemet. Hvis du ikke finnes fra før vil alt du taster inn føres videre til skjemaet.
{{ ctrl.registration_message }}
Det kan se ut til at du allerede har en konto. Har du glemt passordet trykk her for å sette et nytt passord.

Booking
RLPG101 - PostgreSQL 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.title}}
{{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.voucher_payable | fprice}} kr {{ctrl.currency}}
Derav MVA {{ctrl.total_vat | fprice}} kr {{ctrl.currency}}
X

MVA per produkt:

{{arr[1]}}
Number: 1+2 *
Please correct the following and try again
{{ctrl.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