avaxgfx Posted May 9 Report Share Posted May 9 [img]https://i123.fastpic.org/big/2024/0509/bd/9ccadd8f56a9ef7e3f9a9c4503fe39bd.jpg[/img] Published 5/2024 Created by Venkateswarlu A MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Genre: eLearning | Language: English | Duration: 30 Lectures ( 16h 0m ) | Size: 9.2 GB [i]DB2, DB2 on Z/OS[/i] [b][i]What you'll learn:[/i][/b] Introduction to DB2 DB2 Objects DB2 Components: SSAS,DBAS,DDF,SPAS,IRLM Data types in DB2 Executing SQL commands thru QMF tool Executing SQL commands thru SPUFI tool Create table command,Primary key, Unique Index INSERT,SELECT,UPDATE and Delete commands SELECT Command: Where, Group By,Order By and Having,Like,Where , * Joins in DB2 Subqueries in DB2 Writing COBOL,DB2 programs Processing files in COBOL,DB2 programs Null and Varchar handling in Application program SQL error handling in application program Explained about Precompilation process(Compile, Linkedit) Explained about BIND plan and Differences between plan and package Executing the application program Cursor Handling and advanced cursor topics SQLCA,SQLCODE and SQLERRD(3) [b][i]Requirements:[/i][/b] Mainframe knowledge JCL, VSAM, COBOL modules knowledge and bit hands-on experience [b][i]Description:[/i][/b] 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 -104, -206,-204,-180,-181, -540,-601,-805,-818,-811,-305 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. [b][i]Who this course is for:[/i][/b] Beginners who are learning DB2 first time Mainframe developers Homepage [b]Buy Premium From My Links To Get Resumable Support and Max Speed [/b] https://fikper.com/LiCm8NUc2Y/Mainframe_DB2_Developer_Course_1.part01.rar.html https://fikper.com/ol9pqsPznM/Mainframe_DB2_Developer_Course_1.part02.rar.html https://fikper.com/6HwIWvIZ0J/Mainframe_DB2_Developer_Course_1.part03.rar.html https://fikper.com/CXg0wHQ16O/Mainframe_DB2_Developer_Course_1.part04.rar.html https://fikper.com/FHXbwdQNSh/Mainframe_DB2_Developer_Course_1.part05.rar.html https://fikper.com/RlomdV3uRg/Mainframe_DB2_Developer_Course_1.part06.rar.html https://fikper.com/X27djnD6z6/Mainframe_DB2_Developer_Course_1.part07.rar.html https://fikper.com/zByVtIYzhh/Mainframe_DB2_Developer_Course_1.part08.rar.html https://fikper.com/zOoSTyluYk/Mainframe_DB2_Developer_Course_1.part09.rar.html https://fikper.com/g9OOst7hCq/Mainframe_DB2_Developer_Course_1.part10.rar.html [code] https://rapidgator.net/file/367c0348d54d50f81f48ad7623fed99f/Mainframe_DB2_Developer_Course_1.part01.rar.html https://rapidgator.net/file/06721e6eb7af73f34542c7fad55ef36c/Mainframe_DB2_Developer_Course_1.part02.rar.html https://rapidgator.net/file/b3f51daa7c04f22405c204d434523088/Mainframe_DB2_Developer_Course_1.part03.rar.html https://rapidgator.net/file/217fca8b1418478fbd3937635639b322/Mainframe_DB2_Developer_Course_1.part04.rar.html https://rapidgator.net/file/a302b3040fc8f2516426cde58111d73f/Mainframe_DB2_Developer_Course_1.part05.rar.html https://rapidgator.net/file/9c5751c0d2ad3d0dc42967b81439425f/Mainframe_DB2_Developer_Course_1.part06.rar.html https://rapidgator.net/file/f372b09066d249fa14773f8081f5767a/Mainframe_DB2_Developer_Course_1.part07.rar.html https://rapidgator.net/file/b5de226d375a05a8377c3bc469e1b3bd/Mainframe_DB2_Developer_Course_1.part08.rar.html https://rapidgator.net/file/782334630d70d0d3b2ccc28e0a1abd14/Mainframe_DB2_Developer_Course_1.part09.rar.html https://rapidgator.net/file/71560f8e8e09619d18ac72aed204068a/Mainframe_DB2_Developer_Course_1.part10.rar.html[/code] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now