PostgreSQL DBA Training with Real-time Project

WHAT WE DO AS A POSTGRESQL DBA IN REAL-WORLD?
ROUTINE DBA ACTIVITIES
1 How do you Auditing Login Failures? Solutions ?
2 How to Monitor & Resolve Connectivity Issues ?
3 How to Audit Long Running Queries ?
4 How to Audit Memory Issues ? Solutions ?
5 How to Identify, Troubleshoot DB Connections ?
6 How do you Monitor Databases ?
7 How do you monitor HA & DR Mechanisms ?
8 How do you Audit Backups?
9 How do you refresh a Database? Precautions ?
10 How do you perform Object / Schema Refresh ?
11 Where do you Audit Physical, Logical Backups ?
12 How do you identify & Resolve Idle Sessions ?
13 How do your monitor Index Fragmentation ?
14 How you monitor SQL Server Health ?
15 How do you monitor Backups & Clusters?
16 How do you monitor Database Health Checks ?
17 How do you monitor Log Space Issues ?
18 How do you monitor Memory Space Issues ?
19 How do you monitor Table Cluster Issues ?
20 How do you monitor Replication Issues?
21 How do you Generate Audit Log Files?
22 How do monitor PG Clusters ?
23 How do you Sync LINUX Users and PG Users?
24 How do you Monitor, Manage HBA Config File?
25 How do you monitor POSTGRES Config File?

EMERGENCY & MAINTENANCE DBA ACTIVITIES
26 What you do as a DBA if PG Cluster is Down ?
27 What you do as a DBA if a Database is Down ?
28 How do you resolve Table, Schema Missing Issues ?
29 How do you resolve Data Synchronization Issues ?
30 How do you resolve Query Performance Issues ?
31 How do you resolve Slow Database Issues ?
32 How do you resolve Replication / WAL Issues ?
33 What precautions you consider For Resources?
34 Where do you Check, Resolve Corrupted Pages ?
35 How do you decide between Partitions & Indexes?
36 What parameters you consider to decide a HA, DR ?
37 What are DBA actions if Statistics are out of date ?
38 How to configure Table Clusters for Performance?
39 How to configure Table Partitions (Online)?
40 How to resolve PEER and MD5 Connection Issues?
41 How do you Resolve Lock Problems ?
42 How you ensure Synchronized Replication?
43 How do you resolve VACUUM Errors and Statistics?
44 How do you resolve automated WAL Archive Errors ?
45 How do you Migrate LIVE SQL Server Database ?
46 How do you resolve HA DR / Replication Errors ?
47 How do you trace PG Cluster Logs?
48 If Database is not responsive, what are next steps ?
49 Have you used any 3rd Party Migration Tools?
50 How Any Third Party / Native Tools you have Used ?

This PostgreSQL DBA course includes :
1. Day wise Notes
2. Study Material
3. Certification Material
4. Concept wise FAQs
5. Real-time Project
6. Project FAQs
7. Resume Support
8. Certification Guidance

Or call on : [phone] between 3 PM to 5 PM and between 10 PM to 12 AM IST: any day.

Above Introduction Notes:

[esaval]

can I have details on the course content, duration & price ? Thank you

[satishv]

What is the fee and when u r going to start