|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-plsql-and-d2k-course-bundle/
课程评论：没有评论
课程名称：SQL、PL/SQL 和 D2K 在线培训课程套餐 课程概述：SQL、PL/SQL 和 D2K 培训课程套餐包含 SQL 和 PL/SQL 及 D2K（Oracle Forms 和 Reports 10g）。该课程详细介绍了关系数据库管理系统（RDBMS）基础、SQL 语言的基本概念、Oracle 数据类型、SQL 分类、数据定义语言（DDL）和数据操作语言（DML）命令、完整性约束、SQL 函数（字符函数、数字函数、日期函数、分组函数）、联接、子查询和子句、数据库对象、数据控制语言（DCL）和事务控制语言（TCL）命令。此外，还包括 PL/SQL 的基础知识、数据类型和 PL/SQL 块、循环结构、条件语句、游标、异常处理、过程、函数和包等内容。 关于 Oracle D2K（表单和报告 10g）的课程内容，让学员全面了解表单 10g 在 Oracle 应用中的角色，D2K 的基本概念，通过向导和手动创建数据块，创建不同类型的画布并进行操作，窗口类型及其属性的更改，不同类型触发器的应用，警报的创建与调用、在运行时更改属性、编辑器的创建与代码调用、对象组和对象库的使用，以及基于查询的记录组的创建。此外，课程还讲解了主从数据块的创建、菜单的创建与附加、表单中的过程、函数和包的使用，以及 PL/SQL 库和附加库的操作。对于报告部分，课程涵盖了报告的基本概念、优点、特性以及在 D2K 中的作用，如何创建不同类型的报告，使用用户参数和系统参数、公式列、汇总列及占位符列的操作，手动开发报告，以及从表单调用报告的技巧等。 适合对象：本课程适合 PL/SQL 开发者、表单开发者、应用开发者、报告开发者、系统分析师、技术顾问和商业智能开发者等。
SQL, PL/SQL and D2K Training Course bundle Includes SQL & PL/SQL and D2K (Oracle Forms & Reports 10g) 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 Developer
