IBM

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 course is designed to introduce the student to the capabilities of IBM Big SQL. IBM Big SQL allows you to access your HDFS data by providing a logical view to it. You can use the same SQL that was developed for your data warehouse data on your HDFS data. This course provides context on why you would use Big SQL followed by how to use Big SQL to access your data. It also covers what Big SQL is, how it is used, and the Big SQL architecture. The course also covers how to connect to Big SQL, create tables with a variety of data types, load data in, and run queries against the data. The course also shows how to use Big SQL with other components of the Hadoop ecosystem.

The IBM InfoSphere Big Match on Hadoop course will introduce students to the Probabilistic Matching Engine (PME) and how it can be used to resolve and discover entities across multiple data sets in Hadoop.  Students will learn the basics of a PME algorithm including data model configuration, standardization, comparison and bucketing functions, weight generation, and threshold. During the exercises, the student will work on a large use case, where they will apply their knowledge of Big Match to discover relationships be two data sets that can be used to understand the full view of the member data.

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 course provides the fundamentals of using IBM SPSS Modeler and introduces the participant to data science. The principles and practice of data science are illustrated using the CRISP-DM methodology. The course provides training in the basics of how to import, explore, and prepare data with IBM SPSS Modeler v18.1.1, and introduces the student to modeling.

The course is updated for DB2 10 for z/OS. This course is the classroom delivered version of the Instructor led Online course DB2 10 for z/OS System Administration - ILO (3V851). 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: Relate the z/OS IPL process to a DB2 subsystem Explain effects of stopping and starting DB2 Explain how DB2 sets and use Integrated Catalog Facility (ICF) catalog names The use of DSN command processor running in batch and foreground Use views to minimize your ability to see into the DB2 catalog See how the catalog (through grant activity) controls access to data Search the catalog for problem situations Use the catalog and DB2 utilities to determine data recovery requirements Describe Internal Resource Lock Manager (IRLM) in a DB2 environment Implement DB2 and Resource Access Control Facility (RACF) security Describe DB2 program flow for all environments Display normal and problem threads and database status See how the SQL Processor Using File Input (SPUFI) AUTOCOMMIT option defers the COMMIT/ROLLBACK decision Interpret lock displays Identify and cancel particular threads Describe available DB2 utilities to manage system and user page sets

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.

In this course, you will customize IBM Case Manager Client without using much code. In an IBM Case Manager system, you will create pages with custom layout and implement new actions by configuring buttons and menu items. You will use the Calendar widget to track case events and a Script Adapter widget to transform the data. You will learn how to wire two widgets together to establish communication, customize views for case properties including business objects, specify viewers for documents, and implement External Data Services to create dependent choice lists.

The IBM Optim Data Privacy Option course is designed to enable you to successfully develop and execute a data privacy strategy to de-identify sensitive data. This course provides a conceptual understanding of the data privacy issue, as well as the Optim Solutions capabilities for de-identifying data and supporting compliance initiatives for critical business applications. This course serves as a foundation for the Optim Solutions features, and functionality.  This course focuses on the technical aspects of the Optim Solution and is intended for technical audiences. You will learn the basics of how the technology works through hands-on exercises illustrating how the technology applies to business scenarios. This course does not include information on how to install and configure the technology.  This course prepares technical users with the Optim knowledge and skills necessary to participate in an Optim privacy implementation project and confidently perform Optim tasks ongoing.

Your company wants to automate records declaration for your IBM Enterprise Records system. In this course, you learn to configure automatic record declaration using two different methods: event subscriptions and workflow. You work with a fully functioning IBM Enterprise Records system to practice the skills required for automating record declaration.

In this course, you will learn the core features and functionality of Watson Explorer Foundational Components. This core functionality is found in all editions of Watson Explorer (Enterprise and Advanced edition). This course is designed to introduce the technical student to using the enterprise search functionality in creating applications using the Search Engine and Application Builder capabilities. In this course will look at configuring search collection and engine components for ingesting, converting, indexing, and querying. This course will also introduce you to the design process of creating an Application Builder 360-degree application. This course offers hands-on labs giving students exposure to the various aspects of configuring components that will be used in solutions that will involve Watson Explorer Foundational Components functionality.

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 course is for anyone who is responsible for day-to-day operations of a production IBM Case Foundation workflow application.

This 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.

In this course, students will learn the basic concepts of data management with Informix 12.10. They will learn how to create, manage, and maintain tables and indexes; how the Informix Optimizer works; and how to use the SET EXPLAIN feature to determine query effectiveness.

This course is designed to teach the students how to prevent SQL performance problems and how to improve the performance of existing SQL.

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

This course is designed to introduce you to the capabilities of BigSheets. BigSheets is a component of IBM BigInsights through the Analyst and the Data Scientist module. It provides the analyst the ability to be able to visualize and analyze data stored on the HDFS using a spreadsheet type interface without any programming.