Setup Menus in Admin Panel

Course Description

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.

 

Prerequisite

  • Basic SQL & Linux OS

Curriculum

How to set up an Amazon RDS

  1. Amazon RDS Deployments
  2. Pre-configured Parameters
  3. Monitoring and Metrics
  4. DB Event Notifications
  5. Automatic Software Patching
  6. Create a new lesson

Performance

  1. General Purpose (SSD)
  2. Provisioned IOPS (SSD)
  3. Create a DB Instance
  4. Backup & Recovery
  5. DB Snapshots
  6. Automated Backups
  7. Point-in-time restores and backups
  8. Push-Button Scaling
  9. Storage and IOPS
  10. DB Instance Class
  11. Replication
  12. Read Replicas
  13. Multi-AZ Deployments
  14. Isolation and Security
  15. Using SSL to connect to a DB instance running PostgreSQL
  16. Amazon RDS for PostgreSQL and Compliance with many industry standards
  17. Compliance Industry Standards:
  18. Amazon RDS for PostgreSQL databases to build HIPAA-compliant applications
  19. Storing healthcare related information, including protected health information (PHI)
  20. Amazon RDS for PostgreSQL & FedRAMP
  21. PostgreSQL Features Supported by Amazon RDS
  22. PostgreSQL Features Supported
  23. PostGIS
  24. Language Extensions
  25. Full Text Search Dictionaries
  26. HStore, JSON Data Types
  27. pg_stat_statements
  28. Foreign data wrappers
  29. Core PostgreSQL engine features

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

0 STUDENTS ENROLLED
    All Rights Reserved 2020 postgresqlcert
    X