We may earn an affiliate commission when you visit our partners.
Course image
Google Cloud Training

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.

Enroll now

What's inside

Syllabus

Introduction
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.
Read more
Migrating Enterprise Databases to the Cloud
In this module, you learn some theories and motivations behind the course.
Google Cloud Data Migration Solutions
In this module, you learn about the various solutions Google provides for running your databases.
Google Implementation Methodology
In this module, you learn about Google's recommended approach for migrating enterprise applications and databases to the cloud.
Migration Strategies
In this module, you learn about different strategies you can take when moving your applications and databases to the cloud.
Networking for Secure Database Connectivity
In this module, you learn how to build a secure network for database connectivity.
Migrating SQL Server Databases to Google Cloud
In this module, you learn about the options available for migrating a SQL Server database to Google Cloud.
Migrating Oracle Databases to Google Cloud
In this module, you learn about how to migrate Oracle databases to Google Cloud.
Testing and Monitoring SQL Server Databases in Google Cloud
In this module, you learn about testing and monitoring options for SQL Server databases deployed on Google Cloud.
Google Cloud Data Migration Services
In this module, you learn about options and tools available to assist your data migration activties to Google Cloud.
Making the Business Case for Moving to Google Cloud
In this module, you learn how to write a business case for a Google Cloud database migration project.

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Develops knowledge and skills that are transferable to other data migration projects
Taught by Google Cloud Training, who are recognized for their expertise in data migration
Teaches project skills that are highly relevant in industry
Develops knowledge and skills that provide a strong foundation for beginners in data migration
Develops knowledge and skills that strengthen an existing foundation for intermediate learners in data migration
Teaches real-world project methods that prepare learners for a career in data migration

Save this course

Save Enterprise Database Migration to your list so you can find it easily later:
Save

Reviews summary

In-depth database migration

Learners say that this course on Enterprise Database Migration is in-depth, worthwhile, and one of the most comprehensive courses available on database migration. It offers great hand-on labs, goes into detail on various migration strategies, and provides valuable strategic advice. However, there is one specific lab that learners largely disliked.
This course has many helpful labs.
"Excellent course with great hand-on labs."
"Definitely worthwhile to take this course."
The content of this course is comprehensive.
"One of the most comprehensive course on Database migration to Cloud."
"Goes into great detail on various strategies to adopt while migrating databases and lot of strategic advise is embedded as well."
Learners dislike Lab 6.
"Week 6 Lab should be abolished!"
"Everything is okay until they ask you for creating a new file in the Google Cloud Shell Editor and it doesn't create it."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Enterprise Database Migration with these activities:
Explore SQL Server Migration Tools
Gain practical experience in using tools to facilitate migration, making the process smoother and efficient.
Show steps
  • Follow tutorials on using SQL Server Migration Assistant
  • Explore the features and functionalities of third-party migration tools
Test Data Modeling
Develop deeper understanding of data structure and querying, essential for enterprise database migration
Show steps
  • Create a data model for a sample enterprise application
  • Practice writing SQL queries to retrieve data from the model
Attend Database Migration Meetup
Connect with industry professionals and learn from their experiences and insights in database migration.
Show steps
  • Identify relevant database migration meetups in your area
  • Attend the meetup and actively participate
Five other activities
Expand to see all activities and additional details
Show all eight activities
Curate Database Migration Resources
Build a comprehensive knowledge base of resources to support understanding of database migration.
Show steps
  • Collect relevant articles, tutorials, and documentation on database migration
  • Organize and categorize the resources for easy access
Document Database Migration Plan
Reinforce migration strategies, best practices, and key considerations.
Browse courses on Migration Planning
Show steps
  • Outline the steps and phases of the migration process
  • Identify potential challenges and mitigation strategies
  • Document the migration timeline and budget
Participate in Hands-on Database Migration Workshop
Gain practical experience in migrating databases and apply best practices.
Show steps
  • Identify relevant hands-on database migration workshops
  • Register and attend the workshop
Assist with Open Source Database Migration Projects
Contribute to real-world database migration projects and gain valuable hands-on experience.
Show steps
  • Identify open source database migration projects on platforms like GitHub
  • Select a project and contribute your skills
Provide Guidance to Database Migration Beginners
Reinforce your understanding of database migration by sharing your knowledge and supporting others.
Show steps
  • Identify opportunities to mentor aspiring database migration professionals
  • Share your expertise and provide guidance

Career center

Learners who complete Enterprise Database Migration will develop knowledge and skills that may be useful to these careers:
Data Engineer
Data Engineers design, build, and maintain data pipelines. This course provides a comprehensive understanding of database migration, enabling Data Engineers to develop and implement migration strategies that meet the specific needs of their organizations. It also covers data quality and governance, ensuring that migrated data is accurate and reliable.
Enterprise Architect
Enterprise Architects design and manage enterprise-wide IT architectures. This course provides a comprehensive understanding of database migration, enabling Enterprise Architects to develop and implement migration strategies that align with overall business objectives. It also covers vendor-specific migrations, ensuring that organizations can migrate their databases to the cloud with minimal disruption.
Database Administrator
Database Administrators maintain and optimize enterprise databases. This course provides in-depth knowledge of database migration strategies and techniques. It will help Database Administrators plan and execute successful migrations, ensuring minimal disruption to business operations.
Data Warehouse Architect
Data Warehouse Architects design and develop data warehouses. This course provides a solid foundation in database migration, enabling Data Warehouse Architects to integrate data from multiple sources into a centralized data warehouse. It also covers data modeling and optimization, ensuring that data warehouses are efficient and scalable.
Software Architect
Software Architects design and develop software systems. This course provides a comprehensive overview of database migration, enabling Software Architects to make informed decisions about migration strategies. It also covers the Google Implementation Methodology, ensuring that migrations are aligned with best practices.
Cloud Engineer
Cloud Engineers support cloud computing platforms and applications. This course teaches how to design and develop secure and reliable cloud-based solutions, with a focus on database migration. It will help Cloud Engineers better support their customers' database migration initiatives.
Database Engineer
Database Engineers are responsible for the implementation and maintenance of enterprise databases. This course covers the fundamentals of enterprise database migration and how to lead teams in such endeavors. It will help Database Engineers stay current with the latest cloud technologies and trends.
Systems Engineer
Systems Engineers design, implement, and maintain complex systems. This course provides a solid foundation in database migration, enabling Systems Engineers to integrate database systems into larger IT architectures. It also covers networking and security, ensuring that migrations are secure and reliable.
Project Manager
Project Managers plan and execute projects, ensuring their successful completion. This course teaches the methodologies and best practices for managing enterprise database migration projects. It will help Project Managers lead their teams effectively and deliver successful outcomes.
Software Developer
Software Developers design, develop, and maintain software applications. This course provides a practical understanding of database migration, enabling Software Developers to migrate databases as part of application development projects. It also covers testing and deployment, ensuring that migrations are successful and do not disrupt application functionality.
Data Scientist
Data Scientists use data to solve complex business problems. This course provides a foundation in database migration, enabling Data Scientists to access and leverage data from multiple sources. It also covers testing and monitoring, ensuring the reliability and accuracy of migrated data.
Data Analyst
Data Analysts transform raw data into valuable business insights. This course provides a foundation in database migration, enabling Data Analysts to effectively leverage cloud-based data platforms and tools for their analyses. It also covers testing and monitoring, ensuring the reliability and accuracy of migrated data.
Data Architect
Data Architects design and manage enterprise data in accordance with business objectives and technological constraints. This course teaches how to understand complex enterprise databases, as well as skills to migrate them to the Google Cloud - a service used by many modern businesses and organizations.
Business Analyst
Business Analysts help organizations understand their business needs and develop solutions. This course provides Business Analysts with the knowledge and skills necessary to evaluate and recommend cloud-based database migration solutions. It also covers making a business case, ensuring that organizations can justify the cost and benefits of a migration.
IT Manager
IT Managers oversee the IT operations of an organization. This course provides a high-level overview of database migration, enabling IT Managers to make informed decisions about migration projects. It also covers budgeting and resource planning, ensuring that migrations are completed within budget and on time.

Reading list

We've selected six books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Enterprise Database Migration.
Is specifically focused on Oracle database migration to Google Cloud, providing technical details and best practices.
Offers an in-depth look at designing scalable and high-performance data-intensive applications. Covers data modeling, indexing, and distributed systems.
Offers a structured approach to migrating data from legacy systems to modern platforms. Provides guidance on planning, assessment, and implementation.
Provides a comprehensive overview of data management on Google Cloud Platform. It covers all aspects of data management, from storage and processing to analytics and machine learning. It valuable resource for anyone using Google Cloud Platform for data management.

Share

Help others find this course page by sharing it with your friends and followers:
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser