[{"id":"75418","title":"Introduction","description":"

In this module, you learn the about the structure and flow of the course. The overall goal of this course is to teach you how to migrate enterprise databases from on-premises to Google Cloud.

","steps":[{"id":"522250","prompt":null,"isOptional":true,"activities":[{"id":"515080","href":"/course_templates/145/video/515080","isLocked":false,"duration":232000,"title":"Course Introduction","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"75419","title":"Migrating Enterprise Databases to the Cloud","description":"

In this module, you learn some theories and motivations behind the course.

","steps":[{"id":"522251","prompt":null,"isOptional":true,"activities":[{"id":"515081","href":"/course_templates/145/video/515081","isLocked":false,"duration":50000,"title":"Module Overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522252","prompt":null,"isOptional":true,"activities":[{"id":"515082","href":"/course_templates/145/video/515082","isLocked":false,"duration":402000,"title":"Solution Overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522253","prompt":null,"isOptional":true,"activities":[{"id":"515083","href":"/course_templates/145/video/515083","isLocked":false,"duration":276000,"title":"Traditional Database Architectures","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522254","prompt":null,"isOptional":true,"activities":[{"id":"515084","href":"/course_templates/145/video/515084","isLocked":false,"duration":248000,"title":"Optimizing Databases for the Cloud","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522255","prompt":null,"isOptional":true,"activities":[{"id":"515085","href":"/course_templates/145/video/515085","isLocked":false,"duration":201000,"title":"Architecting Scalable and Highly Available Database","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522256","prompt":null,"isOptional":false,"activities":[{"id":"515086","href":"/course_templates/145/quizzes/515086","isLocked":false,"duration":900000,"title":"Module 1 Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522257","prompt":null,"isOptional":true,"activities":[{"id":"515087","href":"/course_templates/145/video/515087","isLocked":false,"duration":24000,"title":"Module Review","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"75420","title":"Google Cloud Data Migration Solutions","description":"

In this module, you learn about the various solutions Google provides for running your databases.

","steps":[{"id":"522258","prompt":null,"isOptional":true,"activities":[{"id":"515088","href":"/course_templates/145/video/515088","isLocked":false,"duration":107000,"title":"Module Overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522259","prompt":null,"isOptional":true,"activities":[{"id":"515089","href":"/course_templates/145/video/515089","isLocked":false,"duration":231000,"title":"Leveraging Google Cloud Infrastructure as a Service","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522260","prompt":null,"isOptional":true,"activities":[{"id":"515090","href":"/course_templates/145/video/515090","isLocked":false,"duration":17000,"title":"Lab intro: Creating Databases on Compute Engine","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522261","prompt":null,"isOptional":false,"activities":[{"id":"515091","href":"/course_templates/145/labs/515091","isLocked":false,"duration":4500000,"title":"Creating Databases in Compute Engine","description":"In this lab, you will create database servers running on Google Cloud Compute Engine. You will create both Linux and Windows servers and will use the CLI to automate the creation of a server.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522262","prompt":null,"isOptional":true,"activities":[{"id":"515092","href":"/course_templates/145/video/515092","isLocked":false,"duration":47000,"title":"Lab review: Creating Databases on Compute Engine","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522263","prompt":null,"isOptional":true,"activities":[{"id":"515093","href":"/course_templates/145/video/515093","isLocked":false,"duration":704000,"title":"Running Databases in a Kubernetes Cluster","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522264","prompt":null,"isOptional":true,"activities":[{"id":"515094","href":"/course_templates/145/video/515094","isLocked":false,"duration":21000,"title":"Lab intro: Running Databases in GKE","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522265","prompt":null,"isOptional":false,"activities":[{"id":"515095","href":"/course_templates/145/labs/515095","isLocked":false,"duration":3600000,"title":"Running Databases in GKE","description":"In this lab, you will create a Kubernetes cluster and then deploy databases into it. You will see two ways to deploy the databases. First using your own configuration code and then using a Kubernetes package manager called Helm.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522266","prompt":null,"isOptional":true,"activities":[{"id":"515096","href":"/course_templates/145/video/515096","isLocked":false,"duration":39000,"title":"Lab review: Running Databases in GKE","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522267","prompt":null,"isOptional":true,"activities":[{"id":"515097","href":"/course_templates/145/video/515097","isLocked":false,"duration":453000,"title":"Managed Relational Databases","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522268","prompt":null,"isOptional":true,"activities":[{"id":"515098","href":"/course_templates/145/video/515098","isLocked":false,"duration":14000,"title":"Lab intro: Creating a Cloud SQL Database","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522269","prompt":null,"isOptional":false,"activities":[{"id":"515099","href":"/course_templates/145/labs/515099","isLocked":false,"duration":3600000,"title":"Creating Cloud SQL Databases","description":"In this lab, you will use Google Cloud SQL to create databases that are managed by Google. You will create both PostgreSQL and MySQL databases and you will connect to those databases using the Google Cloud CLI and from a virtual machine.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522270","prompt":null,"isOptional":true,"activities":[{"id":"515100","href":"/course_templates/145/video/515100","isLocked":false,"duration":42000,"title":"Lab review: Creating a Cloud SQL Database","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522271","prompt":null,"isOptional":true,"activities":[{"id":"515101","href":"/course_templates/145/video/515101","isLocked":false,"duration":310000,"title":"Bare Metal Solution","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522272","prompt":null,"isOptional":true,"activities":[{"id":"515102","href":"/course_templates/145/video/515102","isLocked":false,"duration":183000,"title":"Estimating Costs","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522273","prompt":null,"isOptional":true,"activities":[{"id":"515103","href":"/course_templates/145/documents/515103","isLocked":false,"duration":1800000,"title":"Enterprise Database Migration Case Study","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522274","prompt":null,"isOptional":false,"activities":[{"id":"515104","href":"/course_templates/145/quizzes/515104","isLocked":false,"duration":900000,"title":"Module 2 Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522275","prompt":null,"isOptional":true,"activities":[{"id":"515105","href":"/course_templates/145/video/515105","isLocked":false,"duration":31000,"title":"Module Review","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"75421","title":"Google Implementation Methodology","description":"

In this module, you learn about Google's recommended approach for migrating enterprise applications and databases to the cloud.

","steps":[{"id":"522276","prompt":null,"isOptional":true,"activities":[{"id":"515106","href":"/course_templates/145/video/515106","isLocked":false,"duration":54000,"title":"Module Overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522277","prompt":null,"isOptional":true,"activities":[{"id":"515107","href":"/course_templates/145/video/515107","isLocked":false,"duration":854000,"title":"Google Migration Methodology","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522278","prompt":null,"isOptional":true,"activities":[{"id":"515108","href":"/course_templates/145/video/515108","isLocked":false,"duration":328000,"title":"Database Migration Activities","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522279","prompt":null,"isOptional":true,"activities":[{"id":"515109","href":"/course_templates/145/video/515109","isLocked":false,"duration":270000,"title":"Database Migration Approaches","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522280","prompt":null,"isOptional":true,"activities":[{"id":"515110","href":"/course_templates/145/documents/515110","isLocked":false,"duration":1800000,"title":"Enterprise Database Migration Case Study","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522281","prompt":null,"isOptional":true,"activities":[{"id":"515111","href":"/course_templates/145/video/515111","isLocked":false,"duration":56000,"title":"Activity review: Planning a database migration project","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522282","prompt":null,"isOptional":false,"activities":[{"id":"515112","href":"/course_templates/145/quizzes/515112","isLocked":false,"duration":900000,"title":"Module 3 Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522283","prompt":null,"isOptional":true,"activities":[{"id":"515113","href":"/course_templates/145/video/515113","isLocked":false,"duration":48000,"title":"Module Review","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"75422","title":"Migration Strategies","description":"

In this module, you learn about different strategies you can take when moving your applications and databases to the cloud.

","steps":[{"id":"522284","prompt":null,"isOptional":true,"activities":[{"id":"515114","href":"/course_templates/145/video/515114","isLocked":false,"duration":43000,"title":"Module Overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522285","prompt":null,"isOptional":true,"activities":[{"id":"515115","href":"/course_templates/145/video/515115","isLocked":false,"duration":277000,"title":"Lift and Shift","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522286","prompt":null,"isOptional":true,"activities":[{"id":"515116","href":"/course_templates/145/video/515116","isLocked":false,"duration":81000,"title":"Backup and Restore","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522287","prompt":null,"isOptional":true,"activities":[{"id":"515117","href":"/course_templates/145/video/515117","isLocked":false,"duration":104000,"title":"Live Database Migration","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522288","prompt":null,"isOptional":true,"activities":[{"id":"515118","href":"/course_templates/145/video/515118","isLocked":false,"duration":252000,"title":"Optimize Databases for the Cloud","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522289","prompt":null,"isOptional":false,"activities":[{"id":"515119","href":"/course_templates/145/quizzes/515119","isLocked":false,"duration":900000,"title":"Module 4 Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522290","prompt":null,"isOptional":true,"activities":[{"id":"515120","href":"/course_templates/145/video/515120","isLocked":false,"duration":33000,"title":"Module Review","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"75423","title":"Networking for Secure Database Connectivity","description":"

In this module, you learn how to build a secure network for database connectivity.

","steps":[{"id":"522291","prompt":null,"isOptional":true,"activities":[{"id":"515121","href":"/course_templates/145/video/515121","isLocked":false,"duration":44000,"title":"Module Overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522292","prompt":null,"isOptional":true,"activities":[{"id":"515122","href":"/course_templates/145/video/515122","isLocked":false,"duration":608000,"title":"Building Secure Networks","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522293","prompt":null,"isOptional":true,"activities":[{"id":"515123","href":"/course_templates/145/video/515123","isLocked":false,"duration":13000,"title":"Lab intro: Using Terraform to Create Networks and Firewalls","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522294","prompt":null,"isOptional":false,"activities":[{"id":"515124","href":"/course_templates/145/labs/515124","isLocked":false,"duration":3600000,"title":"Using Terraform to Create Networks and Firewalls","description":"In this lab, you will create a secure network infrastructure for you database migration projects. You will create both public and private VPCs with appropriate firewall rules in each. You will add virtual machines to each network and test the commnication between them. You will do all of this using Terraform to demonstrate a more real-world workflow that you can use in your migration projects.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522295","prompt":null,"isOptional":true,"activities":[{"id":"515125","href":"/course_templates/145/video/515125","isLocked":false,"duration":27000,"title":"Lab review: Using Terraform to Create Networks and Firewalls","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522296","prompt":null,"isOptional":true,"activities":[{"id":"515126","href":"/course_templates/145/video/515126","isLocked":false,"duration":544000,"title":"Connecting Networks","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522297","prompt":null,"isOptional":true,"activities":[{"id":"515127","href":"/course_templates/145/video/515127","isLocked":false,"duration":30000,"title":"Lab intro: Use Terraform to Create a Network Peering","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522298","prompt":null,"isOptional":false,"activities":[{"id":"515128","href":"/course_templates/145/labs/515128","isLocked":false,"duration":3600000,"title":"Use Terraform to Create a Network Peering","description":"In this lab, you will peer two networks. This will allow communication between machines in those networks using internal IP addresses. This means databases can be deployed on a private network without external IP addresses, and those database will only be reachable from from the peered network.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522299","prompt":null,"isOptional":true,"activities":[{"id":"515129","href":"/course_templates/145/video/515129","isLocked":false,"duration":19000,"title":"Lab review: Use Terraform to Create a Network Peering","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522300","prompt":null,"isOptional":true,"activities":[{"id":"515130","href":"/course_templates/145/video/515130","isLocked":false,"duration":142000,"title":"Enabling Communication Across Networks","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522301","prompt":null,"isOptional":true,"activities":[{"id":"515131","href":"/course_templates/145/video/515131","isLocked":false,"duration":11000,"title":"Lab intro: Using Terraform to Create Clients and Servers","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522302","prompt":null,"isOptional":false,"activities":[{"id":"515132","href":"/course_templates/145/labs/515132","isLocked":false,"duration":3600000,"title":"Using Terraform to Create Clients and Servers","description":"In this lab, you will provision a Linux virtual machine in a private network to act as a database server. You will also create a virtual machine that you can use as a bastion host to connect to the database server as an administrator. You will configure the database server for remote connections and add a user account. You will then install the MySQL client software to connect to the database server from a client machine.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522303","prompt":null,"isOptional":true,"activities":[{"id":"515133","href":"/course_templates/145/video/515133","isLocked":false,"duration":19000,"title":"Lab review: Using Terraform to Create Clients and Servers","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522304","prompt":null,"isOptional":true,"activities":[{"id":"515134","href":"/course_templates/145/video/515134","isLocked":false,"duration":89000,"title":"Network Considerations for Managed Databases","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522305","prompt":null,"isOptional":false,"activities":[{"id":"515135","href":"/course_templates/145/quizzes/515135","isLocked":false,"duration":900000,"title":"Module 5 Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522306","prompt":null,"isOptional":true,"activities":[{"id":"515136","href":"/course_templates/145/video/515136","isLocked":false,"duration":20000,"title":"Module Review","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"75424","title":"Migrating SQL Server Databases to Google Cloud","description":"

In this module, you learn about the options available for migrating a SQL Server database to Google Cloud.

","steps":[{"id":"522307","prompt":null,"isOptional":true,"activities":[{"id":"515137","href":"/course_templates/145/video/515137","isLocked":false,"duration":99000,"title":"Module Overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522308","prompt":null,"isOptional":true,"activities":[{"id":"515138","href":"/course_templates/145/video/515138","isLocked":false,"duration":417000,"title":"SQL Server on Compute Engine","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522309","prompt":null,"isOptional":true,"activities":[{"id":"515139","href":"/course_templates/145/video/515139","isLocked":false,"duration":11000,"title":"Lab intro: Creating SQL Server Databases on Compute Engine","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522310","prompt":null,"isOptional":false,"activities":[{"id":"515140","href":"/course_templates/145/labs/515140","isLocked":false,"duration":3600000,"title":"Creating SQL Server Databases on Compute Engine","description":"In this lab, you will provision a SQL Server machine in a private network. Then, you will create a Windows machine in a public network that you can use to adminstrate the database server. You will also create a Linux client in the public network that can be used to connect to the database. Lastly, you will setup a firewall rule that allows access to the SQL Server database only from the private network.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522311","prompt":null,"isOptional":true,"activities":[{"id":"515141","href":"/course_templates/145/video/515141","isLocked":false,"duration":24000,"title":"Lab review: Creating SQL Server Databases on Compute Engine","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522312","prompt":null,"isOptional":true,"activities":[{"id":"515142","href":"/course_templates/145/video/515142","isLocked":false,"duration":324000,"title":"SQL Server on Cloud SQL","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522313","prompt":null,"isOptional":true,"activities":[{"id":"515143","href":"/course_templates/145/video/515143","isLocked":false,"duration":26000,"title":"Lab intro: Administering a Highly Available Cloud SQL for SQL Server Database","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522314","prompt":null,"isOptional":false,"activities":[{"id":"515144","href":"/course_templates/145/labs/515144","isLocked":false,"duration":2700000,"title":"Administering a Highly Available Cloud SQL for SQL Server Database","description":"In this lab, you will create a SQL Server database using Google Cloud SQL. You will enable high availability and deploy it securely with only a private IP address. You will then load a sample database into it and connect to the database using a client machine. You will also perform backup and restore operations and test high availability by triggering a failover.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522315","prompt":null,"isOptional":true,"activities":[{"id":"515145","href":"/course_templates/145/video/515145","isLocked":false,"duration":26000,"title":"Lab review: Administering a Highly Available Cloud SQL for SQL Server Database","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522316","prompt":null,"isOptional":true,"activities":[{"id":"515146","href":"/course_templates/145/video/515146","isLocked":false,"duration":215000,"title":"SQL Server on GKE","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522317","prompt":null,"isOptional":true,"activities":[{"id":"515147","href":"/course_templates/145/video/515147","isLocked":false,"duration":30000,"title":"Lab intro: Running SQL Server on Google Kubernetes Engine","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522318","prompt":null,"isOptional":false,"activities":[{"id":"515148","href":"/course_templates/145/labs/515148","isLocked":false,"duration":2700000,"title":"Running SQL Server on Google Kubernetes Engine","description":"In this lab, you will create a Kubernetes cluster in Google Kubernetes Engine (GKE). You will configure and deploy a Microsoft SQL Server database into the cluster and connect to it from a client machine. Then, you will simplify the deployment using Helm.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522319","prompt":null,"isOptional":true,"activities":[{"id":"515149","href":"/course_templates/145/video/515149","isLocked":false,"duration":24000,"title":"Lab review: Running SQL Server on Google Kubernetes Engine","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522320","prompt":null,"isOptional":false,"activities":[{"id":"515150","href":"/course_templates/145/quizzes/515150","isLocked":false,"duration":600000,"title":"Module 6 Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522321","prompt":null,"isOptional":true,"activities":[{"id":"515151","href":"/course_templates/145/video/515151","isLocked":false,"duration":22000,"title":"Module Review","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"75425","title":"Migrating Oracle Databases to Google Cloud","description":"

In this module, you learn about how to migrate Oracle databases to Google Cloud.

","steps":[{"id":"522322","prompt":null,"isOptional":true,"activities":[{"id":"515152","href":"/course_templates/145/video/515152","isLocked":false,"duration":24000,"title":"Module Overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522323","prompt":null,"isOptional":true,"activities":[{"id":"515153","href":"/course_templates/145/video/515153","isLocked":false,"duration":268000,"title":"Why Oracle on Google Cloud","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522324","prompt":null,"isOptional":true,"activities":[{"id":"515154","href":"/course_templates/145/video/515154","isLocked":false,"duration":359000,"title":"Technical Specs","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522325","prompt":null,"isOptional":true,"activities":[{"id":"515155","href":"/course_templates/145/video/515155","isLocked":false,"duration":232000,"title":"Use Cases","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522326","prompt":null,"isOptional":true,"activities":[{"id":"515156","href":"/course_templates/145/video/515156","isLocked":false,"duration":35000,"title":"Lab intro: Oracle on Bare Metal Solution","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522327","prompt":null,"isOptional":false,"activities":[{"id":"515157","href":"/course_templates/145/labs/515157","isLocked":false,"duration":7200000,"title":"Deploying the Oracle on Bare Metal Solution","description":"In this lab, you will enable and test connectivity between Google Cloud and an Oracle Database 19c instance on a Bare Metal Server.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522328","prompt":null,"isOptional":true,"activities":[{"id":"515158","href":"/course_templates/145/video/515158","isLocked":false,"duration":23000,"title":"Lab review: Oracle on Bare Metal Solution","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522329","prompt":null,"isOptional":false,"activities":[{"id":"515159","href":"/course_templates/145/quizzes/515159","isLocked":false,"duration":900000,"title":"Module 7 Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522330","prompt":null,"isOptional":true,"activities":[{"id":"515160","href":"/course_templates/145/video/515160","isLocked":false,"duration":18000,"title":"Module Review","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"75426","title":"Testing and Monitoring SQL Server Databases in Google Cloud","description":"

In this module, you learn about testing and monitoring options for SQL Server databases deployed on Google Cloud.

","steps":[{"id":"522331","prompt":null,"isOptional":true,"activities":[{"id":"515161","href":"/course_templates/145/video/515161","isLocked":false,"duration":37000,"title":"Module Overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522332","prompt":null,"isOptional":true,"activities":[{"id":"515162","href":"/course_templates/145/video/515162","isLocked":false,"duration":155000,"title":"Testing","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522333","prompt":null,"isOptional":true,"activities":[{"id":"515163","href":"/course_templates/145/video/515163","isLocked":false,"duration":198000,"title":"Monitoring","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522334","prompt":null,"isOptional":false,"activities":[{"id":"515164","href":"/course_templates/145/quizzes/515164","isLocked":false,"duration":600000,"title":"Module 8 Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522335","prompt":null,"isOptional":true,"activities":[{"id":"515165","href":"/course_templates/145/video/515165","isLocked":false,"duration":13000,"title":"Module Review","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"75427","title":"Google Cloud Data Migration Services","description":"

In this module, you learn about options and tools available to assist your data migration activties to Google Cloud.

","steps":[{"id":"522336","prompt":null,"isOptional":true,"activities":[{"id":"515166","href":"/course_templates/145/video/515166","isLocked":false,"duration":68000,"title":"Module Overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522337","prompt":null,"isOptional":true,"activities":[{"id":"515167","href":"/course_templates/145/video/515167","isLocked":false,"duration":493000,"title":"Google Cloud Data Migration Services","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522338","prompt":null,"isOptional":true,"activities":[{"id":"515168","href":"/course_templates/145/video/515168","isLocked":false,"duration":282000,"title":"Programming Data Processing Pipelines with Data Fusion","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522339","prompt":null,"isOptional":true,"activities":[{"id":"515169","href":"/course_templates/145/video/515169","isLocked":false,"duration":183000,"title":"Creating Workflows with Composer","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522340","prompt":null,"isOptional":true,"activities":[{"id":"515170","href":"/course_templates/145/video/515170","isLocked":false,"duration":161000,"title":"Third-Party Tools","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522341","prompt":null,"isOptional":true,"activities":[{"id":"515171","href":"/course_templates/145/video/515171","isLocked":false,"duration":37000,"title":"Lab intro: Online Data Migration to Cloud Spanner using Striim","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522342","prompt":null,"isOptional":false,"activities":[{"id":"515172","href":"/course_templates/145/labs/515172","isLocked":false,"duration":7200000,"title":"Performing an Online Database Migration","description":"This lab demonstrates how to perform an online migration of a SQL Server database to Cloud Spanner using Google Cloud's Data Migration Partner, Striim.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522343","prompt":null,"isOptional":true,"activities":[{"id":"515173","href":"/course_templates/145/video/515173","isLocked":false,"duration":33000,"title":"Lab review: Online Data Migration to Cloud Spanner using Striim","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522344","prompt":null,"isOptional":false,"activities":[{"id":"515174","href":"/course_templates/145/quizzes/515174","isLocked":false,"duration":600000,"title":"Module 9 Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522345","prompt":null,"isOptional":true,"activities":[{"id":"515175","href":"/course_templates/145/video/515175","isLocked":false,"duration":25000,"title":"Module Review","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"75428","title":"Making the Business Case for Moving to Google Cloud","description":"

In this module, you learn how to write a business case for a Google Cloud database migration project.

","steps":[{"id":"522346","prompt":null,"isOptional":true,"activities":[{"id":"515176","href":"/course_templates/145/video/515176","isLocked":false,"duration":34000,"title":"Module Overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522347","prompt":null,"isOptional":true,"activities":[{"id":"515177","href":"/course_templates/145/video/515177","isLocked":false,"duration":750000,"title":"Writing a Business Case","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522348","prompt":null,"isOptional":true,"activities":[{"id":"515178","href":"/course_templates/145/documents/515178","isLocked":false,"duration":1800000,"title":"Enterprise Database Migration Case Study","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522349","prompt":null,"isOptional":true,"activities":[{"id":"515179","href":"/course_templates/145/video/515179","isLocked":false,"duration":32000,"title":"Activity review Writing a Business Case","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522350","prompt":null,"isOptional":false,"activities":[{"id":"515180","href":"/course_templates/145/quizzes/515180","isLocked":false,"duration":600000,"title":"Module 10 Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522351","prompt":null,"isOptional":true,"activities":[{"id":"515181","href":"/course_templates/145/video/515181","isLocked":false,"duration":18000,"title":"Module Review","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522352","prompt":null,"isOptional":true,"activities":[{"id":"515182","href":"/course_templates/145/video/515182","isLocked":false,"duration":64000,"title":"Course Review","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"75429","title":"Course Resources","description":"

PDF links to all modules

","steps":[{"id":"522353","prompt":null,"isOptional":true,"activities":[{"id":"515183","href":"/course_templates/145/documents/515183","isLocked":false,"duration":1800000,"title":"Course Resources","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"next-steps","title":"Your Next Steps","description":null,"steps":[{"id":"badge-step","prompt":null,"isOptional":true,"activities":[{"id":"badge","href":null,"isLocked":true,"duration":null,"title":"Course Badge","description":null,"type":"badge","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":true}]

Google Cloud Skills Boost

Enterprise Database Migration