|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-apex-19-sql-plsql-to-web-application-development/
课程评论：没有评论
课程名称：Oracle APEX：SQL、PL/SQL与网页应用开发 概述：本课程旨在提供开发网页应用所需的完整知识，使用Oracle APEX的云版本，无需安装。课程内容更新至Oracle APEX最新版本23，使得数据库表中的图片上传（BLOB数据类型）以及在报告中检索更加便捷。Oracle APEX是一种“即插即用”的应用开发工具，无需任何网页编程即可创建出色的表单和报告工具。然而，对于较复杂的应用，则需要通过页面设计器使用SQL语句或PL/SQL编程。 为了方便学习，课程还简要介绍了SQL和PL/SQL，使学习者无需寻找其他资料。课程深入讲解Oracle APEX的一些关键特性，以便构建所需的网页应用。同时，课程展示了如何在Oracle APEX中在页面处理、动态操作以及事件的电子邮件功能等方面使用SQL和PL/SQL。 课程内容包括： - RDBMS（关系数据库管理系统）和SQL的概述 - RDBMS的定义 - 实体关系图 - 实践环境搭建 - SQL概述 - DDL与DML - PL/SQL概述 - 代码块及其不同形式 - Oracle应用程序表达（Oracle Application Express） - 为什么选择Oracle APEX？ - 获取环境的访问权限 - 导航方法 - 使用电子表格和数据库构建应用 - 页面设计器 - APEX与外部世界的RESTful Web服务通信（如物联网设备） - 通过示例应用和演示学习 此外，课程设有内置的测验部分，以检验你对Oracle APEX的理解。祝您学习愉快，学有所成！
This course provides you will necessary details to develop web application using Oracle APEX. This course uses cloud version of Oracle APEX , hence no install required. This course is also updated with Oracle Apex latest release 23, which has inbuilt functionality for image upload (BLOB - datatype) into database table column and then retrieve in a report. Oracle APEX is 'plug and play' application development tool to create impressive application of forms and report based tool without use of any web programming. However, for a complex application, it would require to use SQL statement or PLSQL programming through Page designer. To make learning easier, this course also provides a brief overview about SQL and PLSQL too so that learner need not look at t other source towards learning SQL, PLSQL. This course provide in depth details about some of the critical features available with Oracle APEX to build desired web applicationThere are also demonstration as how sql, plsql can be used in application development in Oracle APEX in Page processing, dynamic action and even email feature of event. •Overview about RDBMS & SQL •What's RDBMS •Entity relationship diagrams •Environment for practice •An overview of SQLs •DDL, DMLs.•Overview about PL/SQL •Code block •Different forms of code blocks •Demonstration.•Oracle Application Express •Why Oracle Apex? •Getting access to environment •Navigation. •Building application using Spreadsheet and from Database. •Page Designer • RESTful webservices communication between APEX and external world - like IOT device. •Learning through Sample Application & demonstrationsAdditionally there are built in Quiz section to test your understanding of Oracle APEX.Good luck and happy learning
