{"course":{"productid":8132,"modality":6,"active":true,"language":"en","title":"Introduction to DB2 for z\/OS for Systems and Operations Personnel","productcode":"CV021G","vendorcode":"IB","vendorname":"IBM","fullproductcode":"IB-CV021G","courseware":{"has_ekit":true,"has_printkit":false,"language":"en"},"url":"https:\/\/portal.flane.ch\/course\/ibm-cv021g","essentials":"<p>You should have a working knowledge of<\/p>\n<ul>\n\n\t<li>z\/OS, TSO, ISPF, and SDSF<\/li><li>sequential, partitioned, and VSAM data sets<\/li><li>and basic JCL<\/li><\/ul>","audience":"<p>This course is for beginning DB2 for z\/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z\/OS environment.<\/p>","contents":"<p>DB2 11 for z\/OS beginning DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of:<\/p>\n<ul>\n\n\t<li>DB2 Objects<\/li><li>Structured Query Language<\/li><li>DB2 Commands<\/li><li>DB2 Utilities<\/li><li>DB2 Logging<\/li><li>DB2 Program Preparation<\/li><\/ul><p>The course materials cover DB2 11 for z\/OS.<\/p>","outline":"<p>CONTENTS:<\/p>\n<p>z\/OS Prequisite Review<\/p>\n<p>DB2 Relational Database Concepts<\/p>\n<p>Structured Query Language (SQL) and SPUFI<\/p>\n<p>DB2 Objects<\/p>\n<p>The DB2 System<\/p>\n<p>DB2 Commands and Program Preparation<\/p>\n<p>DB2 Utilities<\/p>\n<p>DB2 Shutdown, Startup, and Recovery<\/p>\n<p>Course Summary<\/p>\n<p>AGENDA:<\/p>\n<p>Day 1<\/p>\n<ul>\n<li>(00:15) Welcome<\/li><li>(00:30) Unit 1: z\/OS Prerequisite Review<\/li><li>(00:10) Exercise 1: Connecting to z\/OS and Creating Data Sets<\/li><li>(00:05) Exercise 1 Review<\/li><li>(01:15) Unit 2: DB2 Relational Database Concepts<\/li><li>(01:15) Unit 3: Structured Query Language (SQL) and SPUFI<\/li><li>(00:45) Exercise 2: SQL and SPUFI<\/li><li>(00:15) Exercise 2 Review<\/li><li>(01:30) Unit 4: DB2 Objects (Databases and Table Spaces)<\/li><li>(00:45) Exercise 3: Databases and Table Spaces<\/li><li>(00:15) Exercise 3 Review<\/li><li>(01:30) Unit 4: DB2 Objects (Tables, Indexes, and Views)<\/li><\/ul><p>Day 2<\/p>\n<ul>\n<li>(00:45) Exercise 4: Tables, Indexes, and Views<\/li><li>(00:15) Exercise 4 Review<\/li><li>(01:00) Unit 4: DB2 Objects (Qualified Names, Implicit Object Creation, and SQL Statements)<\/li><li>(00:30) Exercise 5: Qualified Names, Implicit Object Creation, and SQL Statements<\/li><li>(00:15) Exercise 5 Review<\/li><li>(01:30) Unit 5: The DB2 System<\/li><li>(00:45) Exercise 6: The DB2 System<\/li><li>(00:15) Exercise 6 Review<\/li><li>(02:00) Unit 6: DB2 Commands and Program Preparation<\/li><\/ul><p>Day 3<\/p>\n<ul>\n<li>(00:45) Exercise 7: DB2 Commands<\/li><li>(00:15) Exercise 7 Review<\/li><li>(02:00) Unit 7: DB2 Utilities<\/li><li>(01:00) Exercise 8: DB2 Utilities<\/li><li>(00:15) Exercise 8 Review<\/li><li>(01:15) Unit 8: DB2 Shutdown, Startup, and Recovery<\/li><li>(00:45) Exercise 9: DB2 Recovery<\/li><li>(00:15) Exercise 9 Review<\/li><li>(00:30) Unit 9: Course Summary<\/li><\/ul>","essentials_plain":"You should have a working knowledge of\n\n\n\n\t- z\/OS, TSO, ISPF, and SDSF\n- sequential, partitioned, and VSAM data sets\n- and basic JCL","audience_plain":"This course is for beginning DB2 for z\/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z\/OS environment.","contents_plain":"DB2 11 for z\/OS beginning DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of:\n\n\n\n\t- DB2 Objects\n- Structured Query Language\n- DB2 Commands\n- DB2 Utilities\n- DB2 Logging\n- DB2 Program Preparation\nThe course materials cover DB2 11 for z\/OS.","outline_plain":"CONTENTS:\n\nz\/OS Prequisite Review\n\nDB2 Relational Database Concepts\n\nStructured Query Language (SQL) and SPUFI\n\nDB2 Objects\n\nThe DB2 System\n\nDB2 Commands and Program Preparation\n\nDB2 Utilities\n\nDB2 Shutdown, Startup, and Recovery\n\nCourse Summary\n\nAGENDA:\n\nDay 1\n\n\n- (00:15) Welcome\n- (00:30) Unit 1: z\/OS Prerequisite Review\n- (00:10) Exercise 1: Connecting to z\/OS and Creating Data Sets\n- (00:05) Exercise 1 Review\n- (01:15) Unit 2: DB2 Relational Database Concepts\n- (01:15) Unit 3: Structured Query Language (SQL) and SPUFI\n- (00:45) Exercise 2: SQL and SPUFI\n- (00:15) Exercise 2 Review\n- (01:30) Unit 4: DB2 Objects (Databases and Table Spaces)\n- (00:45) Exercise 3: Databases and Table Spaces\n- (00:15) Exercise 3 Review\n- (01:30) Unit 4: DB2 Objects (Tables, Indexes, and Views)\nDay 2\n\n\n- (00:45) Exercise 4: Tables, Indexes, and Views\n- (00:15) Exercise 4 Review\n- (01:00) Unit 4: DB2 Objects (Qualified Names, Implicit Object Creation, and SQL Statements)\n- (00:30) Exercise 5: Qualified Names, Implicit Object Creation, and SQL Statements\n- (00:15) Exercise 5 Review\n- (01:30) Unit 5: The DB2 System\n- (00:45) Exercise 6: The DB2 System\n- (00:15) Exercise 6 Review\n- (02:00) Unit 6: DB2 Commands and Program Preparation\nDay 3\n\n\n- (00:45) Exercise 7: DB2 Commands\n- (00:15) Exercise 7 Review\n- (02:00) Unit 7: DB2 Utilities\n- (01:00) Exercise 8: DB2 Utilities\n- (00:15) Exercise 8 Review\n- (01:15) Unit 8: DB2 Shutdown, Startup, and Recovery\n- (00:45) Exercise 9: DB2 Recovery\n- (00:15) Exercise 9 Review\n- (00:30) Unit 9: Course Summary","skill_level":"Beginner","version":"1","duration":{"unit":"d","value":3,"formatted":"3 days"},"pricelist":{"List Price":{"SE":{"country":"SE","currency":"SEK","taxrate":25,"price":19500},"PL":{"country":"PL","currency":"EUR","taxrate":23,"price":2290},"FR":{"country":"FR","currency":"EUR","taxrate":19.6,"price":2325},"SI":{"country":"SI","currency":"EUR","taxrate":20,"price":2190},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":2600}}},"lastchanged":"2025-07-29T12:17:35+02:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/en\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course-schedule\/8132","source_lang":"en","source":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course\/ibm-cv021g"}}