|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mainframe-db2-developer-course-1/
课程评论：没有评论
**Mainframe DB2 开发者课程 1 摘要** 本课程是 Mainframe DB2 开发者系列课程的第一部分，旨在为学员打下坚实的基础。课程将从 DB2 的基本概念入手，深入介绍 DB2 的对象和组件，并详细讲解 DB2 环境中的各种数据类型。 学员将通过 QMF 和 SPUFI 两种界面，动手实践执行 SQL 命令。学习内容将涵盖 SQL 的核心操作，包括 **CREATE TABLE**（包括创建带主键、复合键和参照完整性的表）、**INSERT**、**UPDATE**、**DELETE** 和 **SELECT** 命令。此外，课程还将深入探讨 **JOIN**（内连接、左外连接、右外连接、全外连接）和 **子查询** 等高级 SQL 概念。 课程还将重点讲解一些常见的 SQL 错误码，如 -105, -206, -204, -180, -181, -540 等，帮助学员更好地理解和处理数据库操作中遇到的问题。 所有课程内容均在 Mainframe 服务器上进行实践操作，以确保学员能够获得更深入的理解和实际操作经验。本课程为后续的 COBOL 与 DB2 集成课程（课程 2）奠定基础。
In the comprehensive Mainframe DB2 developer curriculum, the initial segment focuses on fundamental concepts. This includes an introduction to DB2, exploration of DB2 objects and components, as well as an in-depth study of datatypes within the DB2 environment. Students will gain practical experience in executing SQL commands using both QMF and SPUFI interfaces, covering essential operations such as CREATE TABLE, INSERT, UPDATE, DELETE, SELECT commands, Join concepts, Sub queries. The subsequent course delves into the integration of DB2 functionalities within COBOL programs, providing learners with hands-on training in implementing DB2 features in COBOL applications.Topics covered:Introduction to DB2Understanding DB2 ObjectsExploring DB2 ComponentsStudying Datatypes in DB2Executing SQL Commands in QMFExecuting SQL Commands in SPUFILearning CREATE TABLE CommandMastering INSERT CommandUnderstanding UPDATE CommandImplementing DELETE CommandExecuting SELECT CommandCreate table with Primary keyCreate table with Composite keyCreate table with referential integrityDiscussed on few SQL commands like -105, -206,-204,-180,-181, -540 and etc.Joins in DB2Inner joinLeft outer joinRight outer joinFull outer joinSub-queriesThe topics outlined above are thoroughly explored on the Mainframe server to facilitate better comprehension and practical knowledge acquisition. Through both Course 1 and Course 2, students will engage in hands-on learning experiences that reinforce their understanding of DB2 concepts and their application within the Mainframe environment.
