Development

Certfirst PostgreSQL Amazon RDS

Descriptions

Amazon RDS for PostgreSQL gives you access to the capabilities of the familiar PostgreSQL database engine. This means that the code, applications, and tools you already use today with your existing databases can be used with Amazon RDS. Amazon RDS supports PostgreSQL major version 11, which includes a number of enhancements to performance, robustness, transaction management, query parallelism, and more.

PostgreSQL.org released the new version of PostgreSQL 12 on October 3, 2019, the world’s most advanced open-source database. PostgreSQL 12.X is now available with many impressive, beneficial,   and critical improvements to query performance (particularly over larger data sets and overall space utilization) among other important features.
In this one-day hands-on training program, we’ll take a look at some of these new features and show you how to get and install this new PostgreSQL 12 version and as well as explore best practices and considerations to take into account when upgrading.

Prerequisites:

  • Basic SQL & Linux OS.

How to set up an Amazon RDS

  • Amazon RDS Deployments
    • Pre-configured Parameters
    • Monitoring and Metrics
    • DB Event Notifications
    • Automatic Software Patching
  • Performance
    • General Purpose (SSD)
    • Provisioned IOPS (SSD)
  • DB Snapshots
  • Automated Backups
  • Storage and IOPS
  • DB Instance Class
  • Read Replicas
  • Multi-AZ Deployments
  • Amazon RDS for PostgreSQL databases to build HIPAA-compliant applications
  • Storing healthcare related information, including protected health information (PHI)
  • Amazon RDS for PostgreSQL & FedRAMP
  • PostgreSQL Features Supported
  • PostGIS
  • Language Extensions
  • Full Text Search Dictionaries
  • HStore, JSON Data Types
  • pg_stat_statements
  • Foreign data wrappers
  • Core PostgreSQL engine features

All candidates interested in becoming Certified PostgreSQL DBA are encouraged to attend hands-on instructor-led training at CertFirst or through one of its affiliated partners.

Number Of Questions:60 Questions

Time Allocated:90 Minutes

Minimum Pass Requirement: 70%

Certification Renewal is required every two years.

Target Audience:
share it :

Start your learning journey today! Enroll now in our course.