Making Intellectuals Meet Excellence!
PostgreSQL Database Administration
Intermediate
PostgreSQL Database Administration
PostgreSQL is one of the most advanced open-source platforms available today. Multiple large-scale organizations such as Cisco and Apple use the tool for their web-based and mobile-based application development. It is managed by an open-source community that is dedicated to improving the platform to keep it relevant to today's time. Another focus for the community of developers is security; they keep evolving PostgreSQL and updating their security measures to keep up with the threats of today.
Learning Objectives of PostgreSQL Database Administration training
Those who complete the training course will gain knowledge and insight on the following topics under PostgreSQL:
- What the PostgreSQL platform is and how it functions
- PostgreSQL's system architecture
- How to create and manage different databases using PostgreSQL
- How to install and configure servers on PostgreSQL
- The fundamentals of security with PostgreSQL
- How to perform backups of databases
- How to perform recovery of databases
- Details about the point in time recovery
- How to conduct routine maintenance checks
Curriculum
- 18 Sections
- 46 Lessons
- 0 Quizzes
- 40h Duration
Introduction
2 Lessons0 Quizzes
- Introduction to PostgreSQL Server and Advance Features
- Postgres Client Server Architecture
Getting Started
4 Lessons0 Quizzes
- Installing the PostgreSQL Server
- Setting Environment Variables
- Creating a Cluster
- Running a Server
Configuring of PostgreSQL Server
7 Lessons0 Quizzes
- Connection Settings
- Security and Authentication
- Resource Settings
- WAL
- Error Reporting and Logging
- Autovacuum
- Runtime Statistics, etc.
Server Control
1 Lesson0 Quizzes
- Postgres hosed based access configuration
Client and Tools
1 Lesson0 Quizzes
- Introduction To PSQL
Creating and Managing Database
0 Lessons0 Quizzes
Obtaining Metadata
0 Lessons0 Quizzes
Transaction & Concurrency Control
0 Lessons0 Quizzes
Database Administration
2 Lessons0 Quizzes
- Moving objects between tablespaces
- Using materialized views
Table Partitioning
0 Lessons0 Quizzes
Extensions
2 Lessons0 Quizzes
- Accessing objects in other PostgreSQL databases (postgres_fdw, dblink)
- File_fdw, hstore, pgcrypto,etc
Security
5 Lessons0 Quizzes
- User Management
- Preventing Connections
- Checking Secured Passwords
- Auditing Changes
- Encrypting Sensitive data
Monitoring and Diagnosis
9 Lessons0 Quizzes
- Real-time viewing using pgAdmin
- Checking whether a user is connected
- Checking which queries are running
- Checking which queries are active or blocked
- Knowing who is blocking a query
- Killing a specific session
- Knowing when a table was last used
- Usage of disk space by temporary data
- Understanding why queries slow down
Performamce and Concurrency
3 Lessons0 Quizzes
- Find and Tune Slow Running Queries
- Collecting regular statistics from pg_stat* views
- Speeding up queries without rewriting them
Regular Maintenance
3 Lessons0 Quizzes
- Controlling automatic database maintenance
- Monitoring and tuning vacuum
- Updating Table Statistics & Vacuuming
Backup and Recovery
2 Lessons0 Quizzes
- Planning Backups
- Backup Types & Restore
Moving Data
1 Lesson0 Quizzes
- Exporting/Importing Data To/From A Flat File
Replication and Upgrades
4 Lessons0 Quizzes
- Replication
- Handling Switchover and Failover
- Upgrading Best Practices
- Migration from Oracle to Postgres using Ora2PG