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.





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)
Enter promo code (Gift card)
The promo code is correct and discount awarded.
No campaign found. Sure you got the promo code right?
Promo code is correct but the campaign does not give better price than current campaign.
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}}
of which VAT {{ctrl.total_vat | fprice}} kr {{ctrl.currency}}
X

VAT per product:

{{arr[1]}}
Invoice information
{{ invoice_field.title }}*
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