Mô tả

Database migration is the process of migrating data from one or more source databases to one or more target databases by using a database migration service. When a migration is finished, the datasets in the source databases resides fully, though possibly restructured, in the target databases.

Data Migration is an important function anyone working with a database should be able to carry out.  There are several tools available to perform database and data migration.

A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer database, you need a database management system such as MySQL Server. Since computers are very good at handling large amounts of data, database management systems play a central role in computing, as standalone utilities, or as parts of other applications.


MySQL is Open source which means that it is possible for anyone to use and modify the software. Anybody can download the MySQL software from the Internet and use it without paying anything. If you wish, you may study the source code and change it to suit your needs.

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet). Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing, data warehousing and mixed database workloads.


Microsoft Access is a database management system from Microsoft that combines the relational Access Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately


Bạn sẽ học được gì

Migrate data from SQL Server to Oracle

Migrate data from MS Access to SQL Server

Migrate data from MySQL to SQL Server

Create migration repository

Create migration user

Backup database before migration

Perform pre-migration assessment

Perform post-migration checks

Validate data mappings

Migrate schema and data

Yêu cầu

  • Basic knowledge of database concepts advised.

Nội dung khoá học

9 sections

Introduction to Data Migration Engineering

3 lectures
Overview of Data Migration Engineering
02:28
Role and Responsibilities of a Data Migration Engineer
02:11
Understanding the Importance of Data Migration in Software Projects
02:17

Overview of Relational Databases

3 lectures
Introduction to Relational Databases
02:28
Key Concepts of Relational Databases
02:09
Comparison of MSSQL, Oracle, MySQL, and MS Access Databases
01:19

Microsoft SQL Server Setup

10 lectures
Introduction
00:20
What is SQL Server
02:57
SQL Server Editions
04:45
Installation Requirements
04:21
Download SQL Server
04:31
Install SQL Server
09:43
SQL Server Configuration Manager
08:10
Install SQL Server Management Studio -SSMS
05:48
Connect SSMS to SQL Server
07:46
Install Sample Database
06:28

Access Database Setup

2 lectures
What is Microsoft Access
00:11
Installing Northwind Database
04:22

Database Migration: MS Access To MSSQL Server

8 lectures
Backup Access Database
02:40
Install SQL Server Migration Assistance for Access
02:24
Create a new SSMA Project
03:54
Create a pre-migration assessment report
03:36
Create a new database
01:14
Convert access schema
06:39
Migrate Access Database To SQL Server
04:08
Post Migration Checks
06:45

MySQL Database Server Setup

4 lectures
MySQL Download Link
00:14
Install MySQL on Windows
14:55
Install MySQL on Macs
06:58
MySQL Workbench
06:04

Data Migration: MySQL To SQL Server

8 lectures
Install SSMA
06:45
Prerequistes
00:57
SQL Server Agent
04:11
Pre-migration assessment
06:12
Validating type mappings
01:56
Converting schema
05:16
Migrating data
05:16
Post Migration data validation
03:26

Oracle Database Setup

4 lectures
Install Oracle Database Server
08:11
Unlock sample schema
05:04
Install Oracle developer
08:55
Connecting to Oracle database
06:05

Data Migration: SQL Server To Oracle

9 lectures
Create a database migration user
03:53
Create a migration repository
02:35
Configure 3rd party connection: part 1
06:28
Configure 3rd party connection: part 2
07:25
Capturing data source
07:36
Convert captured models to Oracle
01:57
Translate 3rd party T-SQL Objects to Oracle
10:11
Generate scripts to create database
02:21
Migrate data from SQL Server into Oracle
07:55

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.