Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Day 1: Introduction and Core Setup
Module 1: Introduction to AlloyDB
- What is AlloyDB?
- Key Features and Use Cases
- Comparison with Other Databases (e.g., PostgreSQL, Google Cloud SQL)
Module 2: Setting Up AlloyDB
- Prerequisites and Requirements
- Creating an AlloyDB Instance
- Configuration Options and Best Practices
- Connecting to AlloyDB from Various Environments
Module 3: Database Administration Essentials
- Instance Types and High Availability
- Backup and Restore Strategies
- Monitoring and Performance Management
Hands-on Lab: Initial Setup
- Provision a new AlloyDB instance
- Configure basic settings and connectivity
- Set up monitoring and alerts
Day 2: Data Management and Security
Module 4: Working with Data in AlloyDB
- Creating and Managing Databases and Tables
- Importing and Exporting Data
- Running Queries and Using Tools like pgAdmin
- Performance Tuning and Indexing Strategies
Module 5: Security and Compliance
- Security Best Practices in AlloyDB
- Managing Roles and Permissions
- Encryption and Data Protection
- Auditing and Compliance Features
Module 6: High Availability and Disaster Recovery
- Replication Setup and Management
- Failover and Read Replicas
- Designing for Disaster Recovery
- Testing High Availability Configurations
Hands-on Lab: Data Operations and Security
- Create and manage databases and tables
- Implement security measures and test permissions
- Configure replication and test failover scenarios
Day 3: Advanced Features, Integration, and Optimization
Module 7: Integrating AlloyDB with Applications
- Connecting AlloyDB with Google Cloud Services
- Integrating with Data Analytics Tools
- Using APIs and Automation
- ETL and Data Migration Best Practices
Module 8: Performance Optimization and Troubleshooting
- Analyzing Query Performance
- Identifying and Resolving Bottlenecks
- Using Performance Insights
- Common Troubleshooting Techniques
Hands-on Lab: Building a Real-World Scenario
- Design a high-availability setup
- Build a sample application integration
- Simulate performance issues and optimize queries
- Test disaster recovery scenarios
Wrap-Up and Q&A
- Key Takeaways and Best Practices
- Additional Resources and Next Steps
- Open Q&A Session
Requirements
- Basic knowledge of relational databases (preferably PostgreSQL)
- Familiarity with cloud concepts, particularly GCP
- Some experience with database administration or development
21 Hours
Testimonials (3)
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.
Jade Stappaerts - KULeuven
Course - Oracle SQL Language
the exercises
