Data Migration Masterclass: Database, Cloud & Enterprise Data
The complete data migration lifecycle, from planning and assessment through execution and validation to post-migration support. Covers profiling and cleansing, SQL Server, MySQL and Oracle, mapping and ETL design, scripted automation, testing, and security and compliance.
Instructor
Meta Brains
Duration
8.5 hours
The certificate
What it covered — 10 modules
- 01
Introduction to Data Migration
What is Data Migration · Types of Data Migration · Importance in Modern IT Systems
5/5 lectures - 02
Business Requirements and Data Analysis
Understanding Business Needs · Identifying Data Sources and Targets · Stakeholder Requirement Gathering
6/6 lectures - 03
Data Assessment and Preparation
Data Profiling Techniques · Identifying Data Quality Issues · Data Cleansing Strategies
5/5 lectures - 04
Database Platforms for Migration
Introduction to Databases in Migration · Working with Microsoft SQL Server · Working with MySQL
7/7 lectures - 05
Designing Data Migration Solutions
Migration Strategy Design · ETL (Extract, Transform, Load) Concepts · Data Mapping Techniques
6/6 lectures - 06
Scripting and Automation
Introduction to Scripting in Migration · Using Python for Data Migration · Using JavaScript for Automation
6/6 lectures - 07
Migration Execution and Workflow Management
Planning Migration Execution · Running Migration Jobs · Monitoring Migration Progress
5/5 lectures - 08
Testing and Validation
Importance of Testing in Migration · Unit Testing Migration Scripts · Comparing Source and Target Data
5/5 lectures - 09
Security and Compliance in Data Migration
Data Security Principles · Encryption During Migration · Access Control and Authentication
7/7 lectures - 10
Future Learnings and Conclusion
Key takeaways from the course · Best Practices for Data Migration · Resources for learnings
5/5 lectures
Toolkit from this course
More certificates
- 01The Complete Python Bootcamp: From Zero to Hero in Python 22 hoursCompleted
- 02Python for Machine Learning & Data Science 44 hoursCompleted
- 03A deep understanding of Deep Learning & Neural Networks with Python 57.5 hoursLearning
- 04A deep understanding of AI large language model mechanisms 91 hoursLearning
- 06Modern React with Redux [2024 Update] 76 hoursCompleted
- 07Fundamentals of Backend Engineering 19 hoursCompleted