PostgreSQLCert DBA on-demand
Description
PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 30 years of active development on the core platform.
Topics for this course
22 Lessons11h
PostgreSQL DBA (CPSDBA)
PostgreSQL DBA Course-Introduction00:37:16
Module 1 – PostgreSQL-Introduction00:11:56
Module 2 – System Architecture00:40:25
Module 3 – Installation00:32:20
Module 4 – Database Clusters00:35:02
Module 5 – Configuration00:37:57
Module 6 – PSQL Part 100:08:28
Module 6 – PSQL Part 200:22:41
Module 7 – Creating and Managing Databases Part 100:20:40
Module 7 – Creating and Managing Databases Part 200:30:26
Module 8 – Security00:22:50
Module 9 – Tablespaces00:23:52
Module 10 – Routine Maintenance Tasks00:43:37
Module 11 – Backup, Recovery, PITR00:29:39
Module 12 – Data Dictionary00:23:32
Module 13 – Performance Tuning Part 101:04:33
Module 13 – Performance Tuning Part 200:24:47
Module 14 – Table Partitioning00:32:45
Module 15 – PG_UPGRADE00:14:46
Module 16 – Export/Import00:06:47
Module 17 – Streaming Replication00:17:21
Module 19 – Migration from Oracle to PostgreSQL01:17:18
About the instructors
$995