Course Content
Pre Introduction
0/9
How does a computer work?
00:00
Teams involved in IT project
Database Administration environment types
Types of Databases a DBA has to support
Further team classification in DBA team
Responsibilities of a DBA
Service level agreement
00:00
Common database related problems
What a Relational Database Is
Introduction
0/1
Brief history of PostgreSQL database
PostgreSQL Features
0/9
Object Relational Database Management System
00:00
PostgreSQL is open source
00:00
No License and a Large Community
Extensibility
DBaaS and JSON support
Scalability High-Availability Redundancy
PostgreSQL Forks and Data handling
What am I going to learn from here on
General Database Limits
PostgreSQL Architecture
0/8
How a connection is established in PostgreSQL
PostgreSQL Architecture Introduction
PostgreSQL Process Architecture
PostgreSQL Checkpointer process
Logger, Stats Collector and Autovacuum Process
Background Writer and WALWriter
PostgreSQL Memory Architecture
00:00
PostgreSQL Local Memory Architecture
ACID Properties and Query Processing
0/2
ACID Properties
The Path of a Query
PostgreSQL Installation
0/5
PostgreSQL Source code installation
PostgreSQL Yum Installation
PostgreSQL RPM Installation
Starting and Stopping the Server
PostgreSQL Database design
Physical Database Layout
0/4
PostgreSQL Page Layout
PostgreSQL WAL log files
PostgreSQL Control file
PostgreSQL Configuration and Authentication File
Logical Database Layout
0/5
PostgreSQL Tablespaces
00:00
PostgreSQL Databases
PostgreSQL Schemas
PostgreSQL Users and Roles
PostgreSQL Roles and Privileges
PostgreSQL Backup Methods
0/3
PostgreSQL Physical Backups
Pg Basebackup
PostgreSQL Logical Backups
PostgreSQL Replication
0/1
PostgreSQL Physical Replication
SQL Tuning
0/2
What is Explain plan
PostgreSQL Optimizer Stats
PostgreSQL Upgrade
0/1
PostgreSQL Upgrade
PostgreSQL Tutorial for Absolute Beginners [Administration]
About Lesson

The PostgreSQL Global Development Group remains committed to making PostgreSQL available as free and open-source software in perpetuity.PostgreSQL has a wide variety of community and commercial support options available for users, including:

  1. Community support
  2. Commercial support is also available from one of the many companies providing professional services.

Some of the commercial support vendors are.

  1. Severalnines
  2. 2ndQuadrant
  3. EDB

Further reading here

Previous
Next