Back

Certfirst PostgreSQL Amazon RDS

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.

Course Contents:

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

Exam Details:

  • Course Number: -AWS100

Prerequisites:

  • Basic SQL & Linux OS

Virtual live Training

Training Expired