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