OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Pluralsight logo

Enterprise Database Migration

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.

Enroll now

What's inside

Syllabus

Introduction
Migrating Enterprise Databases to the Cloud
Google Cloud Data Migration Solutions
Google Implementation Methodology
Read more
Migration Strategies
Networking for Secure Database Connectivity
Migrating SQL Server Databases to Google Cloud
Migrating Oracle Databases to Google Cloud
Testing and Monitoring SQL Server Databases in Google Cloud
Google Cloud Data Migration Services
Making the Business Case for Moving to Google Cloud
Course Resources

Good to know

Know what's good
, what to watch for
, 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

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

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.
View High Performance MySQL: Optimization, Backups,... on Amazon
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.
See salaries and explore the career path for Database Administrator
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.
See salaries and explore the career path for Systems Administrator
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.
See salaries and explore the career path for Solution Architect
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.
See salaries and explore the career path for Database Architect
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.
See salaries and explore the career path for Data Architect
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.
See salaries and explore the career path for Software Architect
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.
See salaries and explore the career path for 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.
See salaries and explore the career path for Cloud Architect
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.
See salaries and explore the career path for Network 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.
See salaries and explore the career path for Database Developer
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.
See salaries and explore the career path for 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.
See salaries and explore the career path for Information Security Analyst
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.
See salaries and explore the career path for 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.
See salaries and explore the career path for 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.
See salaries and explore the career path for 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.
Cover image
Expert Oracle Enterprise Manager 12c
Save
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.
Expert Oracle Enterprise Manager 12c
Paperback
$$$
Expert Oracle Enterprise Manager 12c
Kindle Edition
$$$
Cover image
Tourist Experiences
Save
Offers a classic text on database design principles and techniques. Provides a foundational understanding of data modeling, normalization, and query optimization.
Tourist Experiences: Insights from Psychology...
Paperback
$$
Tourist Experiences: Insights from Psychology...
Kindle Edition
$$
Cover image
Master Data Management
Save
Focuses on data migration best practices and techniques. Provides a broader perspective on data migration beyond database migration, offering valuable insights for practitioners.
Master Data Management (The MK/OMG Press)
Paperback
$$$
Master Data Management (The MK/OMG Press)
Kindle Edition
$$
Cover image
The Kimball Group Reader
Save
Is considered a classic in data warehouse design and architecture, but may not be directly relevant to the course content.
The Kimball Group Reader
Paperback
Check
The Kimball Group Reader
Kindle Edition
Check
Cover image
Cloud Computing
Save
Provides a foundational understanding of cloud computing concepts and architecture. Useful as background reading for those new to the field of cloud computing.
Cloud Computing: Concepts, Technology &...
Hardcover
$$
(中文) Cloud Computing: Concepts. Technology and...
Paperback
$$
Cloud Computing: Concepts, Technology &...
Kindle Edition
$$
Cover image
Database Systems: The Complete Book
Save
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.
Database Systems: The Complete Book
Kindle Edition
$$$
Database Systems The Complete Book
Paperback
$$
Database Systems: The Complete Book
Hardcover
$$$$
Goal Student Access Code Card for Database Systems:...
Printed Access Code
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to Enterprise Database Migration.
Enterprise Database Migration
Most relevant
AWS Database Specialty Certification
Most relevant
Exam Prep DP-300: Azure Database Administrator Associate
Most relevant
Introduction to the Azure Data Migration Service
Most relevant
Storage, Databases, and Migration for Associate AWS...
Most relevant
Migrating Databases with AWS Database Migration Service
Most relevant
Microsoft Azure Solutions Architect: Design Migrations
Most relevant
Migrating On-premises MySQL Using a Continuous Database...
Most relevant
Migrating to AWS: a high level introduction
Most relevant
Course image
Time
216 hours
Level
Introductory
Via
Pluralsight
Instructor
Google Cloud
Language
English
Good to know
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
Share and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
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