|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-migration-engineer-mssql-oracle-mysql-ms-access/
课程评论：没有评论
课程名称：数据迁移工程师：MSSQL Oracle MySQL MS Access 课程概述：数据库迁移是指将数据从一个或多个源数据库迁移到一个或多个目标数据库的过程，通常通过数据库迁移服务来完成。迁移完成后，源数据库中的数据集会完整地保留在目标数据库中，虽然可能会进行一定程度的重组。数据迁移是任何数据库工作者必须掌握的重要功能。目前有多种工具可以执行数据库和数据迁移。 数据库是结构化的数据集合，可以是简单的购物清单、图片库，或是企业网络中庞大的信息量。为了添加、访问和处理存储在计算机数据库中的数据，需要使用如MySQL Server等数据库管理系统。由于计算机在处理大量数据方面非常出色，数据库管理系统在计算中起着核心作用，既可以作为独立的工具，也可以作为其他应用程序的一部分。 MySQL是开源的，这意味着任何人都可以使用和修改该软件。用户可以从互联网下载MySQL软件，无需支付任何费用，并且可以学习源代码并根据自己的需求进行更改。微软SQL Server是由微软开发的关系数据库管理系统，作为数据库服务器，其主要功能是根据其他软件应用程序的请求存储和检索数据，这些应用程序可以在同一台计算机上运行，也可以通过网络（包括互联网）在另一台计算机上运行。微软为不同的受众和工作负载，推出了多个不同版本的SQL Server，从小型单机应用到大型面向互联网的应用都有覆盖。 Oracle数据库是由甲骨文公司生产和销售的多模型数据库管理系统，通常用于在线事务处理、数据仓库和混合数据库工作负载。微软Access是微软推出的一种数据库管理系统，将关系型Access数据库引擎与图形用户界面和软件开发工具结合在一起，是Microsoft 365应用套件的一部分，包含在专业版及更高版本中，也可单独出售。
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
