Mainframe COBOL DB2 Developer Course [Full Course]

سرفصل های دوره

DB2, DB2 on Z/OS

1. Introduction to DB2, DB2 Objects, DB2 Components,Intro to QMF,SPUFI, Datatypes

1. Introduction to DB2, Differences between Files and DB2

2. What is Object in DB2 and Different types of DB2 Objects

3. DB2 ArchitectureAddress spacescomponents SSAS, DBAS, IRLM,SPAS,DDF

4. Detailed discussion about DB2 Objects Storage, Database,TableSpace objects

5. Datatypes in DB2

6. Executing SQL commands in QMF

7. Executing SQL commands in SPUFI, Creation of TABLE,UNIQUE Index

8. INSER,SELECT,UPDATE,DELTETE commands execution in SPUFI

9. Primay key and Unique index in DB2

10. What is Composite key and Demo on Composite key

11. Demo on Referential Integrity

12. Differences between Rollback and Commit commands - Class2

13. Executing SQL commands thru QMF and SPUFI and System defined Objects - Class2

2. Different options in SELECT command, Other options, Joins and subqueries

1. Select Command and Different options in SELECT command - Part 1 video

2. Select Command and Different options in SELECT command - Part 2 video

3. Demo on Different types of joins

4. Subqueries in DB2

3. Application Program - COBOL,DB2,File Handling, Null handling, Varchar handling,

1.1 Day5 28 04 2024.txt

1. Demo on CREATE,UPDATE,SELECT,INSERT,DELETE commands and Primary key

2.1 Day6 29 04 2024.txt

2. Part1COBOL,DB2 and File handling combination program with Null & VARCHAR HANDLE

3.1 Day7 20 04 2024.txt

3. Part2COBOL,DB2 and File combination program with Null & VARCHAR HANDLE,DCLGEN

4.1 Day8 01 May 2024.txt

4. Part3COBOL,DB2 and File combination program -Precompilation Process

5.1 Day9 02 May 2024.txt

5. Part4COBOL,DB2 and File combination program -Execution -818 -805-INSERT command

6.1 Day10 03 May 2024.txt

6. Part5Updating the table data THRU COBOL program

7. Delete command and Select commands in COBOL, -305,-811, CURSOR concepts

8. Differences between Plan and Package-Theory

4. Advanced cursor topics

1. Differences between scrollable and non-scrollable cursor

2. Scrollable cursor

3. Absolute cursor

4. Select from 50th Row till 100th row using advanced cursor concept

5. How to select the last row from table

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy