|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-r12-technical-course-bundle-sqlplsqld2ktechnical/
课程评论：没有评论
**课程概览：Oracle Apps R12 技术培训捆绑包 (技术，D2K...)** 本套餐课程旨在为学员提供Oracle Apps R12相关的全面技术培训，涵盖 SQL & PL/SQL、D2K (Forms & Reports 10g) 以及Oracle Apps R12技术核心内容。 **SQL & PL/SQL 课程详情：** * **RDBMS 入门：** 学习关系型数据库管理系统的基本概念。 * **SQL 基础：** 掌握 SQL 语言，包括数据类型、SQL 分类、DDL 和 DML 命令、完整性约束、SQL 函数（字符、数字、日期、组函数）、连接（Joins）、子查询和子句。 * **数据库对象：** 了解并操作数据库对象，学习 DCL 和 TCL 命令。 * **PL/SQL 核心：** 深入学习 PL/SQL 编程，包括 PL/SQL 块、数据类型、循环结构、条件语句、游标 (Cursors)、异常处理 (Exceptions)、过程 (Procedures)、函数 (Functions) 和程序包 (Packages)。 **D2K (Forms and Reports 10g) 课程详情：** * **Forms 10g 基础：** 理解 Forms 10g 的作用及其在 Oracle Apps 中的应用。 * **D2K 基础：** 学习 D2K 的基础知识。 * **Forms 开发：** * 通过向导和手动方式创建数据块 (Data Blocks)。 * 创建不同类型的画布 (Canvases) 并进行操作。 * 掌握窗口 (Windows) 的类型、操作及属性修改。 * 深入学习各种触发器 (Triggers)，并在不同控件上应用。 * 创建警告 (Alerts)，调用警告，并动态修改属性以及实现警告的重用。 * 创建编辑器 (Editors)，了解编辑器的类型，并通过代码调用编辑器。 * 创建和使用对象组 (Object Groups)。 * 创建和使用对象库 (Object Libraries)。 * 通过向导和手动方式创建 LOV (List of Values)。 * 掌握 LOV 的属性。 * 基于查询创建记录组 (Record Groups)，并使用静态值。 * 创建主从数据块 (Master-Detail Data Blocks)。 * 学习参数 (Parameters)。 * 创建菜单 (Menus) 并将菜单附加到 Forms。 * 在 Forms 中使用过程、函数和程序包。 * 了解 PL/SQL 库 (Libraries) 在 Forms 中的使用和附加。 * **Reports 10g 基础：** * 介绍 Reports 10g，掌握其基础概念、优点、特性及其在 D2K 中的作用。 * 创建不同类型的报表，包括带用户参数和系统参数的报表。 * 学习使用公式列 (Formula Columns)、汇总列 (Summary Columns) 和占位符列 (Placeholder Columns)。 * 掌握数据链接 (Data Links)。 * 学习手动开发报表。 * 了解报表中的触发器。 * 创建报表的布局 (Layout)，以及实现钻取式报表 (Drill Down Reports)。 * 学习从 Forms 调用报表，以及从报表调用报表。 **Oracle Apps R12 技术课程详情：** * **ERP 概述：** 学习 Oracle Apps R12 作为企业资源规划 (ERP) 包的原理，以及其基于通用会计原则 (GAAP) 的设计。 * **技术模块核心：** 深入理解 Oracle Apps 的技术模块，包括数据集成、架构、表关系、以及使用 Oracle Apps 进行报表和表单设计。 * **关键概念：** * 角色类型。 * 应用程序对象库 (Application Object Library)。 * 应用程序开发。 * 自定义对象注册。 * 接口与转换 (Interfaces and Conversions)。 * Flexfields。 * Profiles。 * Value Sets。 * 多组织概念 (Multi-org Concepts)。 * 功能模块概述。 * Oracle Applications 中的报表和表单开发。 * XML 报表开发。 **目标学员：** * PL/SQL 开发者 * Forms 开发者 * Application 开发者 * Report 开发者 * 系统分析师 * 技术顾问 * 商业智能开发者 * 有 Java 和非 Java 背景的资深架构师和开发者 * 资深 IT 软件专业人士 * 初学者 * 对 Oracle 相关职位和行业机会感兴趣的候选人 * 高级架构和开发人员（Java 和非 Java 背景） * 高级 IT 软件专业人士 * 应届毕业生 **课程收益：** 本课程将帮助学员掌握 Oracle Apps R12 的核心技术，提升在 Oracle Apps 技术领域的专业能力，从而获得有竞争力的职业发展和高薪机会。
Oracle Apps R12 Technical Training Course Bundle includes SQL & PL/SQL, D2K (Forms & Reports 10g), Oracle Apps R12 Technical Course SQL & PL/SQL Course DetailsThis course covers Introduction to RDBMS, Introduction to SQL, Oracle data types, classification of sql, DDL and DML Commands, Integrity Constraints, SQL Functions, Character Functions, Number Functions, Date Functions, Group Functions, Joins, Sub Queries and Clauses, Database Objects, DCL and TCL Commands, Introduction to PL/SQL, Data Types and PLSQL Blocks, Looping Structures, Conditional Statements, Cursors, Exceptions, Exceptions continued, Procedures, Functions, Packages. Oracle D2K (Forms and Reports 10g) Course DetailsFrom this course you will get a clear idea of Forms 10g and Role in Oracle Apps, Fundamentals of D2K, Creation of Data blocks Through wizard and Manually, Creation of Different Types of Canvases and Working with Canvases, Types of windows and working with windows and changing windows properties, Different types of Triggers, Working with Triggers and Applying to Different Controls, Creation of alerts and Calling of Alerts Changing Properties at runtime and Re-using Alerts, Creation of Editors, Types of Editors and Calling editors through Code, Creating and Using Object Groups. Creating and Using Object Libraries, Creation of Lov through wizard and Manually, Working with Lov Properties, Creation of Record Groups Based On Query and Using Static Values, Creation of Master-Detail Data Blocks, Parameters, Creation of Menus and attaching menus to Forms, Working with Procedures, Functions and Packages in Forms, Usage of PL/SQL Libraries in Forms and Attached Libraries, Reports 10g, Introduction to Reports. Fundamentals of Reports. Advantages, Features and role of Reports in D2K, Creation of Different types of Reports. Creation of Reports with different Parameters. User Parameters. System Parameters, Working with Formula Columns. Working with Summary Columns. Working with Place Holder Columns, Working with Data links, Developing Reports Manually, Reports in Triggers, Creation of Layout in Reports. Drill Down Reports. Calling Reports from Forms. Calling Reports from Reports.Who should take this oracle D2K CoursePL/SQL Developer Forms Developer Application Developer Report Developer System Analyst Technical Consultant Business Intelligence DeveloperOracle Apps R12 Technical Course DetailsOracle Apps Technical is the Enterprise Resource Package (ERP) package. It has designed on the base of Generally Acceptable Accounting Principles (GAAP). This Oracle Application has the business software or else application software of the Oracle Corporation.Oracle Apps Technical Course is a collection of complete end-to-end solutions that serve businesses with their own functionality. The course provides an in-depth explanation on the technical module of data integration. This module makes you understand the architecture, table relations, designing reports and forms using Oracle Apps.From this course, you get a clear idea ofTypes of Roles, Application Object Library, Application Development, Registration of Custom Objects, Interfaces and Conversions, Flex fields, Profiles, Value Sets, Multi-org Concepts, Functional Modules Overview, Reports and Forms in Oracle Applications and development of XML Reports.There are incredible job opportunities for the desired aspirants with highest paid salary range. It will be a great career advantage by taking Oracle Apps Technical Course.Who should take this oracle Apps technical courseThe following software or industry professionals were deserved to take this Oracle Apps technical training.senior architecture and developers java and non java background. senior IT Software professionals FreshersThe following job roles will get benefited from this course:Functional Consultants Technical Consultants Business Analysts Finance Functional Implementers End Users Candidates interested in taking up a career under Oracle Related Jobs and Positions in the Industry
