Cursos de Data Storage

This course will expose the beginning z/OS DBAs (Database Administrators) to fundamentals of Database Administration for a Db2 13 for z/OS. This course will teach the students how to physically implement a logical database design using DDL, and teaches considerations of referentially related tables. This course discusses the use of basic utilities, program preparation, serialization, and basic database security. This course does not cover distributed data processing, nor does it cover data sharing.

This course provides an introduction to the SQL language. This course utilizes IBM Data Studio on a Windows 11 operating system, but the SQL queries are appropriate for Linux, UNIX, and Windows environments. This course introduces SQL, including syntax, retrieving data from a Db2 table, coding inner joins, arithmetic operations, and scalar and columnar functions. Learners will also explore the UNION function, inserting, updating, and deleting rows, and will use the create table and create view statements.Students will participate in hands-on exercises to practice what they have learned.

This is an online course. please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to enroll in this clas.Learn about Information Management System (IMS) data sharing capabilities. Examine how multiple IMS systems on different processors can access and update the same databases with complete integrity.

This course is designed to describe the features and functions of Fast Path both from a capability and an implementation perspective.

Learn about the Information Management System (IMS) High Availability Large Database (HALDB). Examine how databases may be migrated to HALDB and the advantages of using HALDB.

Learn implementation for Information Management System (IMS) using Resource Access Control Facility (RACF) as the external security manager, and the installation provided security exit routines. Apply classroom lectures with security paper lab exercises in which you setup the security definitions.

Learn how to tune Information Management System (IMS) databases for use in IMS/Batch, IMS/Data Communications (DC), CICS-Local-Data Language One (DL/I), and Data Base Control (DBCTL) environments.Explore the IMS database features that affect performance such as data set considerations and buffers for VSAM and OSAM. You will also practice a method for estimating performance before implementation. Plus, you will reinforce the skills you have learned with seven machine labs.IACET Continuing Education Units: 4.0

Learn how to design, implement, reorganize, and recover Information Management System (IMS) databases. Practice these skills in intensive machine labs.

Learn all aspects, including installation, implementation, and management of the Database Recovery Control (DBRC) feature of Information Management System (IMS). DBRC is an IMS facility that provides database recovery, and facilitates database sharing, between IMS systems in all IMS environments including DB/TM, Data Base Control (DBCTL), and Batch. Reinforce the concepts and skills you have learned with machine labs.