AWS Aurora is a relational database engine from Amazon Web Services. It helps to overcome traditional database scalability, performance, and availability limitations in a cost-effective way. Aurora uses a high-performance storage subsystem that automates and standardises database clustering and replication.
This AWS Aurora training course is designed to provide a thorough understanding of how to work with Aurora. Delegates will learn how to manage security, configure the Aurora DB cluster and migrate data to a cluster. The course also looks at how to work with Aurora MySQL and Aurora PostgreSQL.
Course Objectives:
After completing this course attendees should be able to:
- Fundamentals of PostgreSQL
- Aurora Architecture deep dive & cluster setup
- Monitoring features and tools (CloudWatch, Enhanced Monitoring, Performance Insights ..)
- Designing highly available, and scalable clusters
- Cluster configuration management
- Query performance tuning
- Aurora Postgres Security
- Effectively using Aurora features such as Global Database, Serverless, Cache management
- Aurora Disaster Recovery
- Backup Recovery
- Cluster management tasks such as vacuuming, analyse & explain etc.
Course content
PostgreSQL Fundamentals
- Storage, Processes & Query processing
- WAL, Checkpointing, Archiver & Background processes
- High availability, Standby servers & Replication
- Scaling, Read vs Write scaling
- Tools, Config, Logs & Catalog
Amazon RDS & Aurora
- AWS PostgreSQL options
- RDS Vs Aurora PostgreSQL
- Aurora specific features
- Aurora – PostgreSQL version & releases
- Deciding between RDS & Aurora PostgreSQL
Introduction to Aurora
- DB Clusters
- Connection Management
- Storage and Reliability
- Security
- High Availability and Global Databases for Aurora
- Replication with Aurora
Setting Environment
- Getting Started with Aurora
- Configuring Aurora DB Cluster
- Choose DB Instance Class
- Choose Regions and Availability Zones
- DB Instance Billing for Aurora
- Creating DB Cluster
- Aurora Serverless
- Connecting to DB Cluster
- Migrate Data to DB Cluster
Amazon RDS Aurora Architecture
- Aurora Storage Architecture
- Database Instance Classes & I/O performance
- Database Instance Right Sizing
- Primary instance, Replicas & Endpoints
- Aurora Reads & Writes
- AZ +1 Fault Tolerance Model
- Aurora Standby Replication
- Lab : Read Replica
- Lab : Replication Lag
Aurora Metrics, Logging & Events
- Baseline, KPI & Metric Monitoring
- Introduction to Pgbench tool
- RDS CloudWatch Metrics & Dimensions
- RDS Aurora Metrics
- RDS Enhanced Metrics
- RDS Database Logs
- PostgreSQL Log files & configuration
- RDS Events
- Lab : Aurora CloudWatch Metrics
- Lab : Enhanced Metrics
- Lab : Checkout PostgreSQL Logs
- Lab : RDS Event retention to CloudWatch
Aurora Scaling and High Availability
- Aurora Storage Scaling
- Aurora Compute Scaling
- Aurora Failover
- Aurora Cluster Cache Management
- Lab : Vertical Scaling
- Lab : Auto Scaling
- Lab : Aurora failover
Configuring Security
- Managing and Monitoring Aurora DB Cluster
- Working with Aurora MySQL
- Introduction to Aurora MySQL
- Aurora MySQL Security
- Migrating Data to Aurora MySQL
- Managing Aurora MySQL
- Parallel Query for Aurora MySQL
- Advanced Auditing and Replication with Aurora MySQL
- Integrating Aurora MySQL with AWS Services
Query Performance Analysis
- PostgreSQL Stats Subsystem
- PostgreSQL Stats Functions
- PostgreSQL Wait events and Locks
- pg_stat_statements extension
- Lab : Wait & Lock events
- Lab : pg_stat_statements extension
PostgreSQL Commands – Vacuum, Analyse & Explain
- PostgreSQL Query Processing, Plan, Paths, Optimizer
- Explain command
- PostgreSQL Analyze command
- Multi Version Concurrency Control (MVCC)
- Vacuuming – Addressing table bloat
- Vacuum – Addressing the wraparound
- Vacuum command
- Auto vacuuming
- Lab : Explain command
- Lab : vacuum command
Query Performance Tuning for waits
- Performance Insights Overview
- Performance Insights Counters
- DB Load & Active Sessions
- IO Wait Events
- Buffer Cache Tuning
- Aurora IO XactSync Event
- IO Events : DataFileRead, BufFileRead, BufFileWrite
- Lightweight Lock Waits
- Heavyweight Lock Waits
- Client & Timeout wait events
- Lab : Performance Insights
- Lab : IO XactSync Event
- Lab : BufFileRead & BufFileWrite IO Events
- Lab : Lock transactionid
- Lab : Performance Insights dashboard
- Lab : Timeout wait event
RDS Aurora Security
- Data Encryption Support
- Database Network Security
- RDS Aurora Access & Authorization Control
- Password Authentication
- Aurora IAM Authentication
- Introduction to Kerberos and AWS Managed AD
- RDS Aurora Kerberos Authentication
- PostgreSQL Pgaudit Extension
- Lab : Force TLS/SSL connection
- Lab : Password Authentication
- Lab : IAM Authentication
- Lab : Setup AWS Managed AD
- Lab : Setup Aurora PostgreSQL for Kerberos
- Lab : pgAudit extension
Aurora Global Database
- Aurora Global Database
- Managing the Aurora global DB
- Aurora global DB monitoring
- Disaster Recovery (DR) & Managed RPO
- DR & Aurora Endpoint management
- Lab : Setup Aurora global DB cluster
- Lab : Planned global DB failover
- Lab : Endpoint management
- Lab : Aurora global DB clean-up
Aurora Backup and Recovery
- PostgreSQL backup and restore
- Aurora Automatic & Manual backups
- Backup Encryption, Copying and Sharing
- Backup Costs and Monitoring
- AWS Backup Service
- Lab : PostgreSQL pg_dump
- Lab : PostgreSQL pg_restore
- Lab : Restoring from a snapshot
- Lab : Point in time recovery (PITR)
- Lab : Snapshot export to S3
Aurora Cloning
- Aurora Cloning & Copy on write protocol
- Cross account cloning
- Lab : Create an Aurora Clone
Aurora Serverless v2
- Aurora Serverless v2 DB Instance
- High availability considerations
- Serverless v2 DB instance capacity scaling
- Monitoring considerations
- Lab : Build a Aurora cluster with Serverless v2
Cluster Maintenance
- RDS and PostgreSQL versioning
- Aurora PostgreSQL upgrade
- Minor version upgrade
- Major version upgrade
- Aurora PostgreSQL releases & deprecation
- Lab : PostgreSQL native replication
Working with Aurora PostgreSQL
- Aurora PostgreSQL Security
- Managing Aurora PostgreSQL
- Replication with Aurora PostgreSQL
- Query Plan Management
- Best Practices with Aurora
- Basics of Limits and Troubleshooting
To see the full course content Download now
Course Prerequisites
- No prerequisites are required for this course. However, basic knowledge of relational databases and query language would be beneficial.
- Hands on with AWS
- Experience with any RDBMS
- Basic Unix shell scripting
Who can attend
- Database Administrators
- Software Architects
- Software and IT Engineers
- AWS Cloud Architects
- Application Architects & Developers
- DBA's intending to develop AWS/RDS skills
- Cloud Architects, & Engineers looking to leverage Aurora PostgreSQL
- Database Administrators interested in diving deep into Aurora Postgres
- Cloud Developers looking to leverage Aurora Postgres for building cloud native applications
- Anyone interested in learning how Aurora Postgres is different from community version of Postgres
Number of Hours: 40hrs
Certification
Key features
- One to One Training
- Online Training
- Fastrack & Normal Track
- Resume Modification
- Mock Interviews
- Video Tutorials
- Materials
- Real Time Projects
- Virtual Live Experience
- Preparing for Certification
FAQs
DASVM Technologies offers 300+ IT training courses with 10+ years of Experienced Expert level Trainers.
- One to One Training
- Online Training
- Fastrack & Normal Track
- Resume Modification
- Mock Interviews
- Video Tutorials
- Materials
- Real Time Projects
- Materials
- Preparing for Certification
Call now: +91-99003 49889 and know the exciting offers available for you!
We working and coordinating with the companies exclusively to get placed. We have a placement cell focussing on training and placements in Bangalore. Our placement cell help more than 600+ students per year.
Learn from experts active in their field, not out-of-touch trainers. Leading practitioners who bring current best practices and case studies to sessions that fit into your work schedule. We have a pool of experts and trainers are composed with highly skilled and experienced in supporting you in specific tasks and provide professional support. 24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts. Our trainers has contributed in the growth of our clients as well as professionals.
All of our highly qualified trainers are industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo before they are certified to train for us. We also ensure that only those trainers with a high alumni rating continue to train for us.
No worries. DASVM technologies assure that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.
DASVM Technologies provides many suitable modes of training to the students like:
- Classroom training
- One to One training
- Fast track training
- Live Instructor LED Online training
- Customized training
Yes, the access to the course material will be available for lifetime once you have enrolled into the course.
You will receive DASVM Technologies recognized course completion certification & we will help you to crack global certification with our training.
Yes, DASVM Technologies provides corporate trainings with Course Customization, Learning Analytics, Cloud Labs, Certifications, Real time Projects with 24x7 Support.
Yes, DASVM Technologies provides group discounts for its training programs. Depending on the group size, we offer discounts as per the terms and conditions.
We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Wallets, Net Banking, Cheques and etc.
DASVM Technologies has a no refund policy. Fees once paid will not be refunded. If the candidate is not able to attend a training batch, he/she is to reschedule for a future batch. Due Date for Balance should be cleared as per date given. If in case trainer got cancelled or unavailable to provide training DASVM will arrange training sessions with other backup trainer.
Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.
Please Contact our course advisor +91-99003 49889. Or you can share your queries through info@dasvmtechnologies.com