Looking to level up your skills in PostgreSQL dba?

We have a training requirement on skill "postgresql database administrator"

PFB Details of the Training:
Mode of Training: Online
Location: Chennai
Start Date: In April (2nd/3rd Week)
Number of Participants: 25
Participant background : Intermediate
Note: Looking for a trainer who is based out of Chennai only.

Kindly revert with your acknowledgement if you are interested in this training along with your updated profile and commercial/cost

CONTACT:

Mobile:
+918838953252
+918148383856
+918122550964

Email:
info@rayafeel.com
hrsupport@rayafeel.com

TOPICS:

Introduction of PostgreSQL
• Introduction
• History
• PostgreSQL Editions & Licensing
• Architecture
• Limits
Installing PostgreSQL Server and Client
• Comparison of installation methods
• Demonstration of installation
• Database Cluster & Initializing the Database Cluster
• Hands-on installation exercise
• Hands-on Cluster management
Configuring a PostgreSQL Cluster
• Review components of a PostgreSQL cluster
• Identify available configuration files
• Changing PostgreSQL Configuration
• Identifying whether a particular configuration change needs restart or not
• Configuration Best Practices
• Hands-on Exercise
Creating & Managing Databases
• Object Hierarchy
• Creating Database
• Creating Database Objects
• Creating Schemas
• Schema Search Path
• DDL & DML
• Data Types
• Hand-on Exercise
User Security
• Creating users
• Using and assigning user roles
• User authentication
• User Authorizations
• Hands-on Exercise
Cluster Security
• Enabling remote connections to cluster
• Host-based authentication (pg_hba.conf)
• Hands-on Exercise
Tablespace
• Built-in Table Space
• User Tablespaces
• Managing Tablespaces
Backup and Recovery Methods
• Selecting an effective backup approach
• Logical backup
• Physical backup
• PITR and WAL Archiving
• Hands-on Exercise
Table Partitioning
• Table partitioning
• Table partitioning in older versions
Routine Maintenance Task
• Optimizer Statistics
• Data Fragmentation
• VACUUM
• AutoVacuum
• Full Vacuum
• ReIndex
• Cluster
• Hands-on Exercise
Data Dictionary
• System Catalog Schema
• System Information Tables
• System Information Functions
• Hands-on Exercise
• System Information Views
• System Administration Functions
• Hands-on Exercise
Performance Tuning
• Hardware Configuration
• OS Configuration
• PG State statement
• SQL Tuning and EXPLAIN statement
• 6 step query tuning
• PostgreSQL Configuration
• Transactions
• Locks
• Hands-on Exercise
Transactions and Concurrency
• What is Transaction
• ACID properties

Loading and Moving Data
• pg_upgrade utility
PostgreSQL Migration
• Overview of Database Migration
• Available Free Migration Tools

Видео Looking to level up your skills in PostgreSQL dba? канала Remote DBA Support