Database Modernization

Database Modernization

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 1h 28m | 230 MB

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.

Table of Contents

Introduction
1 Modernizing databases

1. Fundamentals of Database Modernization
2 Drivers for database modernization
3 The benefits of database modernization
4 The database modernization process
5 Option 1 Rehosting databases
6 Option 2 Replatforming databases
7 Option 3 Refactoring databases
8 Rehost, replatform, or refactor

2. Steps to Modernize Your Database
9 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

Homepage