Autoplay
Autocomplete
Previous Lesson
Complete and Continue
ORDBMS With PostgreSQL Essential Administration Training
Introduction
Introduction (12:23)
Becoming an online instructor (9:05)
Overview (0:35)
System Architecture And Installation
Architecture, Buffering And Connection Response (24:45)
Database Directory Layout (14:03)
Installation (17:17)
Database Clusters
Creating And Managing Database Clusters (9:00)
Configuration And Log Management
Server Configuration And Settings (26:28)
Log Management (15:43)
Activity - Lab Exercise And Solution (7:11)
PSQL
PSQL Commands And Features (14:16)
Creating And Managing Database
Creating And Managing Database (24:15)
Activity - Lab Exercise And Solution (6:07)
Security
Authentication, Authorisation and Implementation of Host based Security (26:39)
Working With PSQL
Working With PSQL (22:05)
Routine Maintenance Tasks
Database Maintenance (24:29)
Vacuming Commands (8:31)
Auto Vacuming (19:08)
Backup And Recovery
SQL Dump (15:20)
Continuous Archiving - I (11:05)
Continuous Archiving - II (10:55)
System Administration
Loading And Unloading Data (6:01)
PG_Upgrade (10:18)
Data Dictionary (9:25)
Conclusion
Thanks! (Bonus Lecture) (3:52)
SQL Dump
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock