This CV832G: DB2 11 for z/OS Database Administration Workshop Part 1 course provides you with instruction on how to physically implement a logical database design in DB2. The course includes instruction on DB2 data management, DB2 catalog tables, the bind process, database utilities such as LOAD and REORG, and security considerations.
Note: This course material is at the DB2 11 for z/OS level.
Learn how to tune for optimum performance the IBM DB2 10 for Linux, UNIX, and Windows relational database management system and associated applications written for this environment. Learn about DB2 10 for Linux, UNIX, and Windows in a single partition database environment. Explore performance issues affecting the design of the database and applications using the database, the major database performance parameters, and the different tools that assist in performance monitoring and tuning.
Use tools in class that are common across the Linux, UNIX, and Windows environments. During labs running on DB2 10.1, develop your ability to use monitoring tools. Explain tools and DB2 utilities like RUNSTATS, REORG and db2batch to tune a database running on your local LINUX workstation.
This course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution.
This CV853G: Db2 12 for z/OS Introduction to System Administration course provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z/OS system.
This Application Performance and Tuning course is designed to teach the students how to prevent application performance problems and to improve the performance of existing applications. Students will learn about indexes, table design, locking, and other issues relevant to application performance. This course includes paper exercises and machine exercises designed to reinforce the lecture content.
This offering provides participants with introductory to advanced knowledge of metadata modeling concepts, and how to model metadata for predictable reporting and analysis results using Framework Manager. Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing of metadata to the web, enabling end users to easily author reports and analyze data.
This P8361G: IBM Planning Analytics: Design and Develop Models in Architect v2.0 course is designed to teach modelers how to build a complete model in IBM Planning Analytics using the Architect tool. Through a series of lectures and hands-on exercises, students will learn how to set up and verify dimensions, cubes, and views, manually enter data into these structures, and define the data that users can see.
Students will also learn how to transfer data into the IBM Planning Analytics model, including the use of TurboIntegrator scripts to perform data transfer. In addition, the course outlines how to customize drill paths, convert currencies, model for different fiscal requirements, and deploy IBM Planning Analytics applications to the web.
This course is designed to teach you how to:
This course is designed as the starting point for any technical specialist working with the InfoSphere MDM Virtual module. This course walks you through the major components of the InfoSphere MDM Virtual module, the data model, the matching engine and how customization can be implementated. You will learn how to invoke the InfoSphere MDM interactions and the various configuration and extension points of a service. The course is also used as an intro to various compoments that make up the MDM Architecture and prepares you to identify how the MDM will fit into their organization and what pieces may be customize to fit their business requirements.
This course has a heavy emphasis on the exercises, where you will deploy a new MDM configuration, invoke interactions, walk through the default matching algorithm, and create a custom handler and composite view.
At the end of this course, it is expected that you will feel comfortable implementating a new Virtual configuration data model, invoking interactions and creating customization to the Virtual MDM.
This offering covers the fundamental concepts of installing and configuring IBM Cognos Analytics, and administering servers and content, in a distributed environment.
In the course, participants will identify requirements for the installation and configuration of a distributed IBM Cognos Analytics software environment, implement security in the environment, and manage the server components. Students will also monitor and schedule tasks, create data sources, and manage and deploy content in the portal and IBM Cognos Administration.
This offering introduces business and professional authors to the basics of creating reports using relational data models. Techniques to improve, personalize and manage professional relationships will be explored. During this training, activities will illustrate and reinforce the concepts.
This offering provides participants with introductory to advanced knowledge of metadata modeling concepts, and how to model metadata for predictable reporting and analysis results using Framework Manager. Participants will learn the full scope of the metadata modeling process, from initial project creation to publishing of metadata to the web, enabling end-users to easily author reports and analyze data.
This course provides participants with an understanding of Active Report content and functionality within IBM Cognos Analytics – Reporting. Through lecture, demonstrations, and exercises, participants increase their IBM Cognos Analytics experience by building highly interactive reports using Active Report controls, which can then be distributed to and consumed by users in a disconnected environment, including on mobile devices.
Learn about the new features and enhancements of DB2 11 for z/OS, including the technical detail of the functional enhancements of this significant new version of DB2 for z/OS.
Note: This course shall be made available a unit at a time. If you wish to receive training on this new version of DB2 11 for z/OS, contact your training provider to request a class containing the latest content.
The course is updated for DB2 10 for z/OS. This course is the classroom delivered version of the Instructor led Online course
Administrators of DB2 10 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 10 for z/OS subsystem. Engage in lectures and hands-on labs to gain experience to:
This course enables the project administrators and ETL developers to acquire the skills necessary to develop parallel jobs in DataStage. The emphasis is on developers. Only administrative functions that are relevant to DataStage developers are fully discussed. Students will learn to create parallel jobs that access sequential and relational data and combine and transform the data using functions and other job components.
This B6158G: IBM Cognos Analytics: Author Reports Fundamentals v11.0.x offering provides Business and Professional Authors with an introduction to report building techniques using relational data models. Techniques to enhance, customize, and manage professional reports will be explored. Activities will illustrate and reinforce key concepts during this learning opportunity.
This course teaches Information Server and/or DataStage administrators to configure, manage, and monitor the DataStage Engine which plays a crucial role in Information Server. It not only runs high performance parallel ETL jobs designed and built in DataStage. It also supports other Information Server products including Information Analyzer, QualityStage, and Data Click. After introducing DataStage parallel jobs and the Engine that runs them, the course describes DataStage project configuration, the Engine’s development and runtime environments, and the Engine’s data source connectivity. In addition the course explains how to import and export DataStage objects, how to run and monitor DataStage jobs through the command line and GUI, and how to use some important Engine utilities.
This course enables students to acquire the skills necessary to use the Information Governance Catalog to analyze metadata stored within the Information Server Repository. The emphasis is on how metadata gets captured within the repository and how to explore and analyze the metadata it contains.
This 0A108G: Introduction to IBM SPSS Modeler Text Analytics v18.1.1 course (formerly: Introduction to IBM SPSS Text Analytics for IBM SPSS Modeler (v18)) teaches you how to analyze text data using IBM SPSS Modeler Text Analytics. You will be introduced to the complete set of steps involved in working with text data, from reading the text data to creating the final categories for additional analysis. After the final model has been created, there is an example of how to apply the model to perform churn analysis in telecommunications.
Topics in this official IBM analytics course include how to automatically and manually create and modify categories, how to edit synonym, type, and exclude dictionaries, and how to perform Text Link Analysis and Cluster Analysis with text data. Also included are examples of how to create resource tempates and Text Analysis packages to share with other projects and other users.
This CV964G: Db2 12 for z/OS SQL Performance and Tuning course is designed to teach the students how to prevent SQL performance problems and how to improve the performance of existing SQL.
This CL487G: Db2 11.1 Quickstart for Experienced Relational DBAs course teaches you to perform, basic and advanced, database administrative tasks using Db2 11.1. These tasks include creating and populating databases and implementing a logical design to support recovery requirements.
The access strategies selected by the Db2 Optimizer will be examined using the Db2 Explain tools. Various diagnostic methods will be presented, including using various db2pd command options. Students will learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. The REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces, will be discussed.
We will also cover using the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. The selection of indexes to improve application performance and the use of SQL statements to track database performance and health will be covered. This course provides a quick start to Db2 database administration skills for experienced relational Database Administrators (DBA).
The lab demonstrations are performed using DB2 LUW 11.1 for Linux. For some lab tasks, students will have the option to complete the task using a DB2 command line processor, or using the graphical interface provided by IBM Data Server Manager.
This 0A039G: Advanced Machine Learning Models Using IBM SPSS Modeler (V18.2) course presents advanced models available in IBM SPSS Modeler. The participant is first introduced to a technique named PCA/Factor, to reduce the number of fields to a number of core factors, referred to as components or factors. The next topics focus on supervised models, including Support Vector Machines, Random Trees, and XGBoost. Methods are reviewed on how to analyze text data, combine individual models into a single model, and how to enhance the power of IBM SPSS Modeler by adding external models, developed in Python or R, to the Modeling palette.
This ZZ930G: InfoSphere MDM Physical Domains course is designed for anyone who wants to get an understanding of the Data Domains for the InfoSphere Master Data Management Physical Module. This course takes a comprehensive look at the three core data domains of InfoSphere MDM: Party, Account, and Product. For each of the domains spanned by InfoSphere MDM, participants will be exposed to the data model, services, and rules associated with the main entities of that domain. Heavy emphasis is put on exercises and activities so that the participants can apply the knowledge that they learn after course conclusion.
In a world that never stands still, we help you move forward.
With over 30 years of experience, Trainocate has been empowering individuals and businesses to build the essential skills that drive growth and success. Whether it’s professionals advancing in their careers or organizations transforming their workforce, our training programmes deliver results.
Specializing in cloud computing, data & AI, cybersecurity, and digital leadership, our training is powered by industry-leading technology partners like AWS, Alibaba Cloud, Cisco, EC-Council, Fortinet, Google Cloud, IBM, ISACA, ISC2, Microsoft, NetApp, Nutanix, Oracle, Palo Alto, Splunk, Red Hat, Rocheston, Trend Micro, and VMware.
Trainocate Group operates in 24 countries blending global expertise with localized insights to train the next generation of tech professionals and business leaders.
Trainocate Malaysia, based in KL Eco City, is proud to be an HRD Corp Registered Training Provider and a Yayasan Peneraju ALTI, driving workforce development across Malaysia.
