Store

0

PostgreSQL Database Administration Certified Associate V9 SC-PSQLDA9

$200.00
In stock
Product Details

PostgreSQL Database Administration Certified Associate V9 SC-PSQLDA9

The PostgreSQL 9 Database Administration Certified Associate certification validates a range of skills and competencies specific to the PostgreSQL 9 version. Based on the provided syllabus, the specific skills validated include:

  1. Basic Knowledge of PostgreSQL 9:
    • Understanding the fundamental features of PostgreSQL 9, including its robustness, security, ease of use, extensibility, performance, concurrency, and scalability.
    • Initial connection and configuration of the PostgreSQL 9 server.
    • Enabling access for network and remote users.
    • Using graphical administration tools and the psql query and scripting tool.
  2. Exploring and Monitoring the Database:
    • Identifying and locating server files and logs in PostgreSQL 9.
    • Evaluating the server version and uptime.
    • Enumerating and assessing databases and their extensions on the PostgreSQL 9 server.
    • Quickly estimating the number of rows in a table using functions specific to PostgreSQL 9.
    • Understanding object dependencies within the database.
  3. Installation and Configuration:
    • Installing modules from PGXN, manual packages, and source code specifically for PostgreSQL 9.
    • Using and managing installed extensions in PostgreSQL 9.
  4. Server Control:
    • Starting and stopping the PostgreSQL 9 server safely and quickly.
    • Reloading configuration files and restarting the server efficiently.
    • Controlling connections and user sessions, including preventing new connections and restricting users to one session each.
    • Designing and managing multitenancy schemas using PostgreSQL 9 features.
    • Running multiple servers on one system and setting up a connection pool.
  5. Database Administration:
    • Managing tablespaces, including adding and removing tablespaces, and optimizing tablespace-level tuning for PostgreSQL 9.
    • Moving objects between tablespaces and accessing objects in other PostgreSQL and foreign databases.
    • Creating and managing updatable views and materialized views specific to PostgreSQL 9.
  6. Backup and Recovery:
    • Planning and executing logical and physical backups for PostgreSQL 9.
    • Implementing recovery strategies, including point-in-time recovery and recovery of dropped or damaged tables and databases.
    • Improving the performance of backup and recovery operations.
    • Using advanced tools like Barman for hot physical backups and recovery in PostgreSQL 9.

These skills ensure that the certification holder has a solid and practical understanding of PostgreSQL 9 database administration, including installation, configuration, monitoring, control, optimization, backup, and recovery of databases specific to PostgreSQL version 9.



Share this product with your friends
PostgreSQL Database Administration Certified Associate V9 SC-PSQLDA9

Professional credibility

Sector recognition

Job opportunities

Career advancement

Share by: