|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-engineerdeveloper-plsql-apex-data-migration/
课程评论：没有评论
课程名称：Oracle工程师/开发者 - (PL/SQL, APEX, 数据迁移) 课程概述： 本课程将带领学员深入了解Oracle数据库的使用与管理。Oracle数据库是一种数据的集合，主要用于存储和检索相关信息。数据库服务器是解决信息管理问题的关键，能够在多用户环境中高效地管理大量数据，支持多用户同时访问数据，并提供高性能和安全性，包括防止未授权访问和有效的故障恢复解决方案。 此外，Oracle应用程序开发环境（APEX）是一个低代码应用平台，适用于Oracle数据库。利用APEX，用户可以快速构建和部署现代数据驱动应用，企业用户和公民开发者能够在不需学习复杂网页技术的情况下，20倍迅速创建企业应用，且编写的代码量减少100倍。学员将掌握如何使用APEX快速开发引人入胜的应用，以解决实际问题。 课程还包含数据迁移部分，讲解如何将数据从一个位置迁移到另一个位置，从一种格式迁移到另一种格式，或从一个应用程序迁移到另一个应用程序。本课程将实践将SQL Server数据库迁移至Oracle数据库服务器环境。 PL/SQL是SQL与编程语言的过程特性结合而成的语言，由甲骨文公司在90年代初开发，旨在增强SQL的能力。PL/SQL是嵌入在Oracle数据库中的三种主要编程语言之一，课程将帮助学员深入理解PL/SQL，以便顺利进行Oracle数据库及其他高级关系数据库管理系统的概念学习。 通过本课程，学员将获得Oracle数据库的实用技能，并能够应对现代数据管理中遇到的挑战。
An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.Oracle Application Express (APEX) is a low-code application platform for Oracle Database. APEX Application Development, Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) are fully managed services, pre-integrated and pre-configured with APEX, for rapidly building and deploying modern data-driven applications in Oracle Cloud. Business users, citizen and application developers can create enterprise apps 20X faster with 100X less code-without having to learn complex web technologies with just a browser. Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. You won't need to be an expert in a vast array of technologies to deliver sophisticated solutions. Focus on solving the problem and let APEX take care of the rest.Data migration is the process of moving data from one location to another, one format to another, or one application to another. We will migrate a SQL Server database into an Oracle database server environment.PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL. PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java. This tutorial will give you great understanding on PL/SQL to proceed with Oracle database and other advanced RDBMS concepts.
