+91 88606 33966            edu_sales@siriam.in                   Job Opening : On-site Functional Trainer/Instructor | Supply Chain Management (SCM)

Siriam

Making Intellectuals Meet Excellence!

Postgresql Plus Advanced Server
PostgreSQL SQL

Postgresql Plus Advanced Server

0 (0)
Overview
Curriculum
Reviews

The Postgresql Plus Advanced Server certification verifies expertise in working with the Advanced Server database management system of Postgresql. This course affirms a professional’s understanding in implementing and managing the database system efficiently and effectively. Many industries use it to validate their IT professionals' proficiency in handling data management, backups, security and performance tuning in database operations.

Course Prerequisites
• Basic understanding of SQL database management
• Familiarity with Postgres implementation and usage
• Knowledge of database design and system performance optimization
• Prior experience in creating and managing databases
• Proficiency in backup strategies, partitioning, and security aspects
• Understanding of SQL, PL/pgSQL, triggers & stored procedures.

Curriculum

  • 1 Section
  • 20 Lessons
  • 40h Duration
Expand All
LESSONS
20 Lessons
  1. Introduction
  2. PostgreSQL System Architecture
  3. Installation
  4. Configuration
  5. Creating and Managing Database
  6. Postgres Data Dictionary
  7. Introduction To PSQL
  8. pgAdmin III
  9. Security Basics
  10. SQL
  11. Backup and Recovery & Point-in-Time Recovery
  12. Routine Maintenance
  13. PostgreSQL API Connectivity
  14. Transaction & Concurrency
  15. Performance Tuning
  16. Replication and Failover
  17. Table Partitioning
  18. Connection Pooling
  19. Database Monitoring
  20. EDB Tools
0 out of 5

0 user ratings

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Scroll to top