PostgreSQL v12 Database Administration on Windows and Linux
PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.
PostgreSQL possesses robust feature sets including Multi-Version Concurrency Control (MVCC), point in time recovery, granular access controls, tablespaces, asynchronous replication, nested transactions, online/hot backups, a refined query planner/optimizer, and write ahead logging. It supports international character sets, multi-byte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. PostgreSQL is highly scalable both in the quantity of data it can manage and in the number of concurrent users it can accommodate.
The course provides the learner with an extensive knowledge of PostgreSQL Database Administration with real time examples.
Topics covered are:
PostgreSQL Process and Memory Architecture
Installation of PostgreSQL v12 - Windows and Linux
Setup PostgreSQL v12 Environment Variables - Windows and Linux
PostgreSQL Page Layout
Database Directory Layout
PostgreSQL Configuration Files
Cluster in PostgreSQL (Initdb,Start/Stop,Reload/Restart Cluster)
Createdb/Dropdb, Createuser/Dropuser Utility
Create Schema and Schema Search Path
Psql Interface Commands
Pg System Catalogs
Working with PostgreSQL Objects
CRUD Operations
Table Inheritance
Table Partitioning
Tablespace in PostgreSQL
Backup, Continuous Archiving and PITR (Point-in-Time-Recovery)
Explain plan and Query Execution Cost
Maintenance (Updating Planner Statistics, Vacuum, Routine Reindex & Cluster)
Data Fragmentation
Transaction ID wraparound, Vacuum freeze, Auto_Vacuum Demon
Pgadmin 4
Uninstall PostgreSQL v12 on Windows and Linux
Bonus Module
Get a Reminder
Get a Reminder
Similar Courses
What people are saying
active passive cluster servers
I would like to see more on replication and active passive cluster servers.
coming from oracle dba
Coming from oracle dba, wanted to have a quick crash course on postgreSQL.
believe it came purely
The teacher gives simple real time examples to explain concepts and i believe it came purely because he has worked extensively on it.
gives simple real time
useful if instructor adds
The course would be more useful if Instructor adds the advance topics in this course.
advanced query optimization with
Among other things, I would have liked to learn more about the following subjects: * advanced query optimization with the "explain" command * how to configure backups on a production like server * I still wonder what is the purpose of the "vacuum freeze" * etc Moreover, there is no exercice nor quiz that would have helped me to be sure that my understanding of the subjet is good or not.
covers postgresql version 12
The course covers PostgreSQL Version 12.
among other things
it contains all
It contains all the important parts of PostgreSQL Administration with the necessary needed information.
postgres but lacks
This course is not bad for an overview of Postgres but lacks a bit of depth.
exercice nor quiz
manage those instances
Going through the course, i feel confident that should be able to manage those instances.
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Database Editor 2 $70k
PostgreSQL Database Administrator $73k
PostgreSQL Database Administrator $73k
PostGreSQL Developer $74k
PostGreSQL Developer $74k
Database Administrator 1 2 3 $80k
Manufacturing Database $84k
Database Executive $107k
Database Administrator/Database Developer $127k
Database Programmer 3 $134k
Senior Database Developer/Database Administrator $144k
Senior Database Developer/Database Administrator $144k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course