Complete Practical and Real-time Training on PostgreSQL. PostgreSQL Training will enable you to gain in-depth knowledge on all the core fundamentals of PostgreSQL. You will gain hands-on skills and expertise to administer and performance tune PostgreSQL databases through hands-on projects, and this will enable you to become a certified PostgreSQL developer.
PLAN A | PLAN B | |
---|---|---|
PostgreSQL Dev, DBA |
PostgreSQL with Azure |
|
Course Curriculum | Chapters 1 to 21 | Chapters 1 to 30 |
Course Duration | 5 Weeks | 7 Weeks |
PostgreSQL: Archtiecture, Configurations | ✔ | ✔ |
PostgreSQL: SQL Queries and Sub Queries | ✔ | ✔ |
PostgreSQL: Constraints, Keys, Joins & Views | ✔ | ✔ |
PostgreSQL: Stored Procedures and Functions | ✔ | ✔ |
PostgreSQL DBA: Lock Management, Tuning | ✔ | ✔ |
PostgreSQL DBA: Backups and Restores | ✔ | ✔ |
PostgreSQL DBA: HA DR with Replication | ✔ | ✔ |
PostgreSQL DBA: HA DR with Log Shipping | ✔ | ✔ |
PostgreSQL DBA: Security Management | ✔ | ✔ |
PostgreSQL DBA: Service Packs, Maintenance | ✔ | ✔ |
PostgreSQL DBA: Common Issues, Solutions | ✔ | ✔ |
PostgreSQL in Azure: Configurations, Migrations | ❌ | ✔ |
PostgreSQL in Azure: Server Modes | ❌ | ✔ |
PostgreSQL in Azure:Hybrid Cloud | ❌ | ✔ |
PostgreSQL in Azure: Maintenance and Tuning | ❌ | ✔ |
PostgreSQL in Azure: Server Failover | ❌ | ✔ |
PostgreSQL in Azure: Server Maintenance | ❌ | ✔ |
PostgreSQL in Azure: Security Management | ❌ | ✔ |
Total Course Fee * | INR 18000/- USD 244 |
INR 24000/- USD 325 |
PostgreSQL Training Schedules | ||||
S No | Timings (IST) | Start Date | ||
---|---|---|---|---|
Regular Schedules [Mon - Fri] | ||||
1 | 10 AM - 11 AM | Jan 19th | Register | |
2 | 10 PM - 11 PM | Jan 4th | Register | |
Weekend Schedules [Sat & Sun] | ||||
2 | 6 PM - 8 PM | Jan 30th | Register |
If above schedules does not work, opt for PostgreSQL Video Training
All Trainings are completely Practical, Real-Time. Register Today
PostgreSQL - TRAINING HIGHLIGHTS :
✔ In-depth Tuning | ✔ Migration Issues | ✔ In-Memory Data |
✔ Schema Migrations | ✔ Stretch Database | ✔ DB Documenation |
✔ Memory Tables | ✔ Temporal Tables | ✔ App Connections |
✔ CTEs and TVPs | ✔ Excel Imports | ✔ Excel Pivots |
✔ BLOB Storage | ✔ Power Shell | ✔ Azure CLI |
Module I |
Module II |
Module III |
Chapter 1: Introduction & Installation
|
Ch 8: Installation from Source Code
|
Ch 15: Tuning - 2: Full Text Search
|
Chapter 2: PostgreSQL Archtiecture, SQL
|
Ch 9: Managing Databases
|
Ch 16: High Availability & Load Balancing - 1
|
Chapter 3: SQL Concepts, Data Types
|
Ch 10: Client Authentication
|
Ch 17: High Availability & Load Balancing - 2
|
Chapter 4: Constraints and Keys
|
Ch 11: Security Management
|
Ch 18: Lock Management
|
Chapter 5: Joins, Group By Queries
|
Ch 12: Backup
|
Ch 19: Database Monitoring
|
Chapter 6: CTE, Views, Transactions
|
Ch 13: Restores
|
Ch 20: Common Errors and Solutions
|
Chapter 7: Stored Procedures & Triggers
|
Ch 14: Tuning - 1: Indexes
|
Ch 21: Real-time Project
|
Ch 22: Azure Database For PostgreSQL
|
Ch 25: PostgreSQL DB Migrations
|
Ch 28: Security Management
|
Ch 23: Azure Fundamentals
|
Ch 26: DB Backups and Restores
|
Ch 29: HA & DR Concepts
|
Ch 24: PostgreSQL Server, DB in Azure
|
Ch 27: Monitoring and Tuning
|
Ch 30: Planned Maintenance
|