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
- Understanding AlloyDB
- Core Features and Use Cases
- Comparison with Alternatives (e.g., PostgreSQL, Google Cloud SQL)
Module 2: Setting Up AlloyDB
- Prerequisites and System Requirements
- Creating an AlloyDB Instance
- Configuration Options and Best Practices
- Establishing Connectivity from Various Environments
Module 3: Database Administration Essentials
- Instance Types and High Availability Configurations
- Backup and Restore Strategies
- Monitoring and Performance Management
Hands-on Lab: Initial Setup
- Provisioning a new AlloyDB instance
- Configuring basic settings and connectivity
- Setting up monitoring and alert systems
Day 2: Data Management and Security
Module 4: Working with Data in AlloyDB
- Creating and Managing Databases and Tables
- Importing and Exporting Data
- Executing Queries and Utilizing 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
- Setting Up and Managing Replication
- Failover Mechanisms and Read Replicas
- Designing for Disaster Recovery
- Testing High Availability Configurations
Hands-on Lab: Data Operations and Security
- Creating and managing databases and tables
- Implementing security measures and testing permissions
- Configuring replication and testing 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
- Leveraging APIs and Automation
- ETL and Data Migration Best Practices
Module 8: Performance Optimization and Troubleshooting
- Analyzing Query Performance
- Identifying and Resolving Bottlenecks
- Utilizing Performance Insights
- Common Troubleshooting Techniques
Hands-on Lab: Building a Real-World Scenario
- Designing a high-availability setup
- Developing a sample application integration
- Simulating performance issues and optimizing queries
- Testing disaster recovery scenarios
Wrap-Up and Q&A
- Key Takeaways and Best Practices
- Additional Resources and Next Steps
- Open Q&A Session
Requirements
- Foundational understanding of relational databases (PostgreSQL is preferred)
- Familiarity with cloud computing concepts, specifically GCP
- Prior experience in database administration or development
21 Hours
Testimonials (3)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
- UNIFI
Course - NoSQL Database with Microsoft Azure Cosmos DB
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.
