Data Migration Engineer: MSSQL | Oracle | MySQL | MS Access

数据库迁移是使用数据库迁移服务将数据从一个或多个源数据库迁移到一个或多个目标数据库的过程。迁移完成后，源数据库中的数据集将完全驻留在目标数据库中，尽管可能会进行重组。

数据迁移是任何使用数据库的人都应该能够执行的重要功能。有多种工具可用于执行数据库和数据迁移。

数据库是结构化的数据集合。它可以是任何东西，从简单的购物清单到图片库或公司网络中的大量信息。要添加、访问和处理存储在计算机数据库中的数据，您需要一个数据库管理系统，例如 MySQL Server。由于计算机非常擅长处理大量数据，因此数据库管理系统在计算中发挥着核心作用，作为独立实用程序或作为其他应用程序的一部分。

MySQL 是开源的，这意味着任何人都可以使用和修改该软件。任何人都可以从 Internet 上下载 MySQL 软件并使用它，而无需支付任何费用。如果您愿意，您可以研究源代码并根据您的需要进行更改。

Microsoft SQL Server 是微软开发的关系型数据库管理系统。作为数据库服务器，它是一种软件产品，主要功能是根据其他软件应用程序的请求存储和检索数据——这些应用程序可以在同一台计算机上运行，​​也可以在网络（包括 Internet）上的另一台计算机上运行。Microsoft 销售至少十几个不同版本的 Microsoft SQL Server，针对不同的受众和工作负载，从小型单机应用程序到具有许多并发用户的大型面向 Internet 的应用程序。

Oracle 数据库是由 Oracle Corporation 生产和销售的多模型数据库管理系统。它是一种常用于运行在线事务处理、数据仓库和混合数据库工作负载的数据库。

Published 06/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 45 lectures (3h 51m) | Size: 1.22 GB

Migrate multiple database systems

What you’ll learn
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

Requirements
Basic knowledge of database concepts advised.

Description
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

Who this course is for
Beginners to data migration