This course is intended to give architects, engineers, and developers the skills required to help enterprise customers architect, plan, execute, and test database migration projects. Through a combination of presentations, demos, and hands-on labs participants move databases to Google Cloud while taking advantage of various services. This course covers how to move on-premises, enterprise databases like SQL Server to Google Cloud (Compute Engine and Cloud SQL) and Oracle to Google Cloud bare metal.
Overview
Syllabus
- Introduction
- Course Introduction
- Migrating Enterprise Databases to the Cloud
- Module Overview
- Solution Overview
- Traditional Database Architectures
- Optimizing Databases for the Cloud
- Architecting Scalable and Highly Available Database
- Quiz: Module 1 - Migrating Enterprise Databases to the Cloud
- Module Review
- Google Cloud Data Migration Solutions
- Module Overview
- Leveraging Google Cloud Infrastructure as a Service
- Lab intro: Creating Databases on Compute Engine
- Creating Databases in Compute Engine
- Lab review: Creating Databases on Compute Engine
- Running Databases in a Kubernetes Cluster
- Lab intro: Running Databases in GKE
- Running Databases in GKE
- Lab review: Running Databases in GKE
- Managed Relational Databases
- Lab intro: Creating a Cloud SQL Database
- Creating Cloud SQL Databases
- Lab review: Creating a Cloud SQL Database
- Bare Metal Solution
- Estimating Costs
- Enterprise Database Migration Case Study
- Quiz: Module 2 - Google Cloud Data Migration Solutions
- Module Review
- Google Implementation Methodology
- Module Overview
- Google Migration Methodology
- Database Migration Activities
- Database Migration Approaches
- Enterprise Database Migration Case Study
- Activity review: Planning a database migration project
- Quiz: Module 3 - Google Implementation Methodology
- Module Review
- Migration Strategies
- Module Overview
- Lift and Shift
- Backup and Restore
- Live Database Migration
- Optimize Databases for the Cloud
- Quiz: Module 4 - Migration Strategies
- Module Review
- Networking for Secure Database Connectivity
- Module Overview
- Building Secure Networks
- Lab intro: Using Terraform to Create Networks and Firewalls
- Using Terraform to Create Networks and Firewalls
- Lab review: Using Terraform to Create Networks and Firewalls
- Connecting Networks
- Lab intro: Use Terraform to Create a Network Peering
- Use Terraform to Create a Network Peering
- Lab review: Use Terraform to Create a Network Peering
- Enabling Communication Across Networks
- Lab intro: Using Terraform to Create Clients and Servers
- Using Terraform to Create Clients and Servers
- Lab review: Using Terraform to Create Clients and Servers
- Network Considerations for Managed Databases
- Quiz: Module 5 - Networking for Secure Database Connectivity
- Module Review
- Migrating SQL Server Databases to Google Cloud
- Module Overview
- SQL Server on Compute Engine
- Lab intro: Creating SQL Server Databases on Compute Engine
- Creating SQL Server Databases on Compute Engine
- Lab review: Creating SQL Server Databases on Compute Engine
- SQL Server on Cloud SQL
- Lab intro: Administering a Highly Available Cloud SQL for SQL Server Database
- Administering a Highly Available Cloud SQL for SQL Server Database
- Lab review: Administering a Highly Available Cloud SQL for SQL Server Database
- SQL Server on GKE
- Lab intro: Running SQL Server on Google Kubernetes Engine
- Running SQL Server on Google Kubernetes Engine
- Lab review: Running SQL Server on Google Kubernetes Engine
- Quiz: Module 6 - Migrating SQL Server Databases to Google Cloud
- Module Review
- Migrating Oracle Databases to Google Cloud
- Module Overview
- Why Oracle on Google Cloud
- Technical Specs
- Use Cases
- Lab intro: Oracle on Bare Metal Solution
- Deploying the Oracle on Bare Metal Solution
- Lab review: Oracle on Bare Metal Solution
- Quiz: Module 7 - Migrating Oracle Databases to Google Cloud
- Module Review
- Testing and Monitoring SQL Server Databases in Google Cloud
- Module Overview
- Testing
- Monitoring
- Quiz: Module 8 - Testing and Monitoring SQL Server Databases in Google Cloud
- Module Review
- Google Cloud Data Migration Services
- Module Overview
- Google Cloud Data Migration Services
- Programming Data Processing Pipelines with Data Fusion
- Creating Workflows with Composer
- Third-Party Tools
- Lab intro: Online Data Migration to Cloud Spanner using Striim
- Performing an Online Database Migration
- Lab review: Online Data Migration to Cloud Spanner using Striim
- Quiz: Module 9 - Google Cloud Data Migration Services
- Module Review
- Making the Business Case for Moving to Google Cloud
- Module Overview
- Writing a Business Case
- Enterprise Database Migration Case Study
- Activity review Writing a Business Case
- Quiz: Module 10 - Making the Business Case for Moving to Google Cloud
- Module Review
- Course Review
- Course Resources
- Course Resources
- Your Next Steps
- Course Badge
