Database Modernization
1h 28mBeginner2021-08-18
Authors

David Yahalom
Certified Database Expert and Cloud Solutions Architect
Course details
There are many drivers for database modernization, such as technology stack updates, cost savings, and new data centers or event cloud migrations. Database migrations are complex, and preparation and execution are key. In this course, get a high-level look at how to prepare for and successfully execute a database modernization project. Instructor David Yahalom details the key steps and challenges you may face when modernizing your current database technologies. He explains how to run a database migration assessment, which can give you insights into both your current state and how to plan your target state. David also reviews the conceptual ideas behind schema-to-schema conversion and data migrations, as well as tools that can help you with these steps. Whether you're a hands-on engineer or a curious executive, you'll come away from this course with the basic information you need to approach your own database modernization project.
Skills covered
Data Resource ManagementDatabase AdministrationDatabase DevelopmentDatabase ManagementSoftware DevelopmentDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Modernizing databases
1. Fundamentals of Database Modernization
- 02 - Drivers for database modernization
- 03 - The benefits of database modernization
- 04 - The database modernization process
- 05 - Option 1 - Rehosting databases
- 06 - Option 2 - Replatforming databases
- 07 - Option 3 - Refactoring databases
- 08 - Rehost, replatform, or refactor
2. Steps to Modernize Your Database
- 09 - Step 1 - Database assessment
- 10 - Step 2 - Schema conversion
- 11 - Step 3 - Data migration
3. Planning Your Modernization Project
- 12 - Database assessments
- 13 - Assessment steps
- 14 - Assessment tools
- 15 - Plan your migration
4. Schema Conversion
- 16 - Database schema conversion
- 17 - Automatic schema conversion
- 18 - Examples of schema conversion tools
- 19 - Application data access layer
5. Data Migration
- 20 - Heterogenous data migration concepts
- 21 - Requirements for logical data replication
- 22 - Tools for data migration
Conclusion
- 23 - Additional resources
Related courses
Related learn paths
- Prepare for the Google Cloud Digital Leader Certification
- Advance Your Skills in SQL
- Master Python for Data Science
- Explore App Development with the MERN Stack
- Develop Your NoSQL Skills
- Explore a Career in Database Development
- Advance Your Database Administration Skills
- Prepare for the VMware Certified Professional: Data Center Virtualization 2022 (VCP-DCV) Certification Exam