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.
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.
Course Information:
Course Number: -AWS100
Delivery Method: CertCamps,Virtual Live Instructor Led Training,Customer Onsite Training,Classroom Training,
Duration: 4 Days
Pre-Requisite:
Basic SQL & Linux OS
Target Audience:
Existing Oracle, MySQL or Microsoft DBA’s or new candidates interested in joining the DBA world!
PostgrSQLCert offers a basic 4-day virtual live instructor or classroom on Amazon RDS
Course Description:
- 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
◦ Create a DB Instance
◦ Backup & Recovery
▪ DB Snapshots
- ▪ Automated Backups
◦ Point-in-time restores and backups
◦ Push-Button Scaling
▪ Storage and IOPS
▪ DB Instance Class
◦ Replication
▪ Read Replicas
▪ Multi-AZ Deployments
◦ Isolation and Security
◦ Using SSL to connect to a DB instance running PostgreSQL
- ◦ Amazon RDS for PostgreSQL and Compliance with many industry standards
◦ Compliance Industry Standards:
▪ 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 by Amazon RDS
▪ PostgreSQL Features Supported
▪ PostGIS
▪ Language Extensions
▪ Full Text Search Dictionaries
▪ HStore, JSON Data Types
▪ pg_stat_statements
▪ Foreign data wrappers
▪ Core PostgreSQL engine features
Curriculum
How to set up an Amazon RDS
- Amazon RDS Deployments
- Pre-configured Parameters
- Monitoring and Metrics
- DB Event Notifications
- Automatic Software Patching
- Create a new lesson
Performance
- General Purpose (SSD)
- Provisioned IOPS (SSD)
- Create a DB Instance
- Backup & Recovery
- DB Snapshots
- Automated Backups
- Point-in-time restores and backups
- Push-Button Scaling
- Storage and IOPS
- DB Instance Class
- Replication
- Read Replicas
- Multi-AZ Deployments
- Isolation and Security
- Using SSL to connect to a DB instance running PostgreSQL
- Amazon RDS for PostgreSQL and Compliance with many industry standards
- Compliance Industry Standards:
- 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 by Amazon RDS
- PostgreSQL Features Supported
- PostGIS
- Language Extensions
- Full Text Search Dictionaries
- HStore, JSON Data Types
- pg_stat_statements
- Foreign data wrappers
- Core PostgreSQL engine features
Customized Group Training (Your site or ours)
- Experinced & certified trainers
- Hands-on training
- Exclusive lab access
Virtual Live
- Live Instructor-Led Training
- Webex Based
- Interavtice Classes
- Certified Trainers
Classroom Training
- Customise your training according to your needs
- Save as much as 50%
- 50+ CertCamp Loactions Worldwide
