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

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.

Read more

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.

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.

This course is no longer available. Find something similar by browsing:
Database Migration Google Cloud SQL Server Oracle Cloud SQL Compute Engine

What's inside

Syllabus

Introduction
Migrating Enterprise Databases to the Cloud
Google Cloud Data Migration Solutions
Google Implementation Methodology
Read more

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Taught by Google Cloud, who are recognized for their work in database management
Explores database migration strategies relevant to enterprise contexts
Covers practical implementation methodologies for database migrations
Develops skills in migrating popular enterprise databases like SQL Server and Oracle to Google Cloud
Provides hands-on labs to reinforce learning and demonstrate real-world applications
Examines the business value and impact of database migration

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Enterprise database migration guide

According to students, this course offers a largely positive and practical guide for professionals undertaking enterprise database migrations to Google Cloud. Learners found the hands-on labs and demonstrations particularly effective for gaining applicable skills. While it provides a solid foundation for understanding strategies for SQL Server and Oracle migrations, some experienced learners desired a deeper dive into more advanced or niche topics. The course content generally appears up-to-date, reflecting ongoing efforts to keep pace with evolving cloud services.
Material is generally current, with ongoing improvements.
"The course material felt largely up-to-date with current Google Cloud offerings, which is crucial for cloud tech."
"I noticed recent updates to the labs and course content, which indicates the instructors are keeping it fresh."
"It's challenging for any cloud course to stay 100% current, but this one makes a commendable effort to do so."
Provides a strong foundational understanding of cloud migration.
"This course gave me a solid understanding of the core principles behind migrating databases to the cloud."
"For someone relatively new to Google Cloud database services and migration, this was an excellent starting point."
"I now have a clear roadmap and a better grasp of different migration strategies and their implications."
Highly relevant for IT professionals in database migration.
"As a database architect, I found this course directly applicable to the complex migration challenges I face daily at my company."
"It's perfect for anyone involved in planning or executing enterprise-level database moves to Google Cloud."
"The content covered specific concerns for large-scale migrations, which was very helpful for our internal projects."
Offers valuable hands-on experience with migration tools.
"The hands-on labs were incredibly useful for understanding the migration process end-to-end and truly solidified concepts."
"I really appreciated the practical exercises; they helped me apply what I learned and prepare for real-world scenarios."
"Applying the concepts in the labs made me feel confident about tackling actual database migration challenges in my work."
Some wish for more advanced topics or deeper dives into specifics.
"While good, I felt some topics could have been explored in greater depth, especially advanced tuning or edge cases."
"It's a good overview, but I found myself needing to do additional research for more complex migration challenges."
"For experienced users, some parts might feel a bit basic; however, beginners will find it quite thorough."

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:
Review Networking Concepts
Refresh your memory on the fundamental networking concepts and terminologies that will be used throughout the course.
Show steps
  • Review the OSI model
  • Review IP addressing
  • Review DNS
Read High-Performance MySQL
Delve deeper into the fundamentals of MySQL performance and gain practical insights from this comprehensive reference book.
Show steps
  • Read Chapter 1: Understanding MySQL Performance
  • Read Chapter 2: Monitoring MySQL Performance
  • Read Chapter 3: Tuning MySQL Configuration
Practice SQL Server Query Optimization
Sharpen your SQL Server query optimization skills through hands-on practice and improve the performance of your database queries.
Browse courses on Query Optimization
Show steps
  • Use EXPLAIN PLAN to analyze query execution plans
  • Optimize queries using indexes
  • Refactor queries to improve performance
Four other activities
Expand to see all activities and additional details
Show all seven activities
Attend a Cloud SQL Workshop
Gain hands-on experience with Cloud SQL and its migration tools by attending a workshop.
Browse courses on Cloud SQL
Show steps
  • Register for a workshop
  • Attend the workshop
Design a Database Migration Plan
Put your understanding of database migration strategies into action by creating a comprehensive plan for migrating a database to Google Cloud.
Browse courses on Database Migration
Show steps
  • Identify the source and target databases
  • Assess the data and schema compatibility
  • Choose a migration strategy
  • Develop a migration timeline
Answer Questions in the Course Discussion Forum
Contribute to the learning community by actively answering questions and sharing your knowledge in the course discussion forum.
Show steps
  • Log in to the discussion forum
  • Read through the posted questions
  • Identify questions that you can provide insightful answers to
Contribute to an Open-Source Database Project
Deepen your understanding of database technologies by contributing to the development of an open-source database project.
Browse courses on Database
Show steps
  • Identify an open-source database project to contribute to
  • Join the project's community
  • Find an issue or feature to work on

Career center

Learners who complete Enterprise Database Migration will develop knowledge and skills that may be useful to these careers:
Database Administrator
Database Administrators work to make sure the systems that store critical business data are up and running. These systems may run on on-premises hardware or in the cloud. Training in on-premises and cloud database administration, such as this course provides, will help you step into the field of Database Administration.
Systems Administrator
Systems Administrators work to make sure that business processes and IT work together smoothly, which can include ensuring that the organization's databases are up and running securely and efficiently. The networking, security, database migration, and implementation methodology that you will learn about in this course will all play a role in the daily life of a Systems Administrator.
Database Architect
Database Architects work to design the databases that support a business's IT infrastructure. Receiving training in both on-premises and cloud database technologies will help a future Database Architect make more informed choices about database implementation. This course covers many of the implementation decisions a Database Architect should know how to make.
Solution Architect
Solution Architects work to design the technology infrastructure that supports a client or business. Database migration is a common part of a Solution Architect's role. The hands-on training in migration that this course provides will help a future Solution Architect become comfortable proposing and executing these sorts of changes.
Data Architect
Data Architects design and implement data storage solutions to meet the needs of a business. In this role, it would be important to be aware of design and implementation tradeoffs between migrating data on-premises and in the cloud. This course covers many of the considerations that a Data Architect must keep in mind, including networking, security, and implementation strategy.
Software Architect
Software Architects design and implement technology solutions to meet the needs of a business. In this role, it would be important to understand the implications of migrating an organization's database from on-premises hardware to the cloud. This course covers database migration at a comprehensive level, from design to implementation.
Cloud Engineer
Cloud Engineers work to make sure that an organization is using cloud resources effectively and efficiently. Efficient database migration is a key component of cloud engineering. The hands-on training that this course provides will help you prepare for a career as a Cloud Engineer.
Cloud Architect
Cloud Architects work to design and implement cloud solutions for organizations. The ability to migrate on-premises databases to the cloud is a key component of a Cloud Architect's role. This course covers the end-to-end process of database migration, providing you with the tools for success as a Cloud Architect.
Database Developer
Database Developers design and implement the code required to interact with an organization's databases. The training offered in this course in both on-premises and cloud-based databases will be valuable to an aspiring Database Developer.
Network Architect
Network Architects design and implement network solutions for organizations. The training in network design and implementation that this course provides will prepare you for a role as a Network Architect.
IT Manager
IT Managers are responsible for the IT operations of an organization. Training in database migration, data security, and data networking, like this course provides, will help you prepare for a career as an IT Manager.
Information Security Analyst
Information Security Analysts work to protect an organization's data and systems from cyberattacks. The training that this course provides in data security and data networking may be of great value to Information Security Analysts.
Business Analyst
Business Analysts work to understand the business needs of an organization and translate them into technical requirements. The training in database migration and data security that this course provides may be of some value to a Business Analyst.
Data Scientist
Data Scientists work to gather and analyze data in order to help businesses make better decisions. The training in data migration that this course provides may be of some help to a Data Scientist.
Software Developer
Software Developers work to design, implement, and test software applications. The training in data migration that this course provides may be of some value to a Software Developer.

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.
A practical guide to migrating Oracle Database 12c to Google Cloud. Provides step-by-step instructions, troubleshooting tips, and best practices specific to this migration scenario.
Offers a classic text on database design principles and techniques. Provides a foundational understanding of data modeling, normalization, and query optimization.
Focuses on data migration best practices and techniques. Provides a broader perspective on data migration beyond database migration, offering valuable insights for practitioners.
Is considered a classic in data warehouse design and architecture, but may not be directly relevant to the course content.
Provides a foundational understanding of cloud computing concepts and architecture. Useful as background reading for those new to the field of cloud computing.
A comprehensive textbook on database systems. Provides a solid foundation in database concepts and technologies, which is beneficial for understanding the fundamentals of database migration.

Share

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

Similar courses

Similar courses are unavailable at this time. Please try again later.
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 - 2025 OpenCourser