This KM423G: IBM InfoSphere DataStage v11.x – Advanced Data Processing course is designed to introduce you to advanced parallel job data processing techniques in DataStage v11.5. In this course you will develop data techniques for processing different types of complex data resources including relational data, unstructured data (Excel spreadsheets), and XML data. In addition, you will learn advanced techniques for processing data, including techniques for masking data and techniques for validating data using data rules. Finally, you will learn techniques for updating data in a star schema data warehouse using the DataStage SCD (Slowly Changing Dimensions) stage. Even if you are not working with all of these specific types of data, you will benefit from this course by learning advanced DataStage job design techniques, techniques that go beyond those utilized in the DataStage Essentials course.
-
This KM413G: IBM InfoSphere Advanced QualityStage v11.5 course will step you through the Quality Stage data cleansing process. You will transform an unstructured data source into a format suitable for loading into an existing data target. You will cleanse the source data by building a customer rule set that you create and use that rule set to standardize the data. You will next build a reference match to relate the cleansed source data to the existing target data.
-
This course is designed to introduce advanced parallel job development techniques in DataStage v11.5. In this course you will develop a deeper understanding of the DataStage architecture, including a deeper understanding of the DataStage development and runtime environments. This will enable you to design parallel jobs that are robust, less subject to errors, reusable, and optimized for better performance.
-
This course teaches how to build QualityStage parallel jobs that investigate, standardize, match, and consolidate data records. Students will gain experience by building an application that combines customer data from three source systems into a single master customer record.
-
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 will teach about the InfoSphere Change Data Capture (CDC) component of the IBM InfoSphere Data Replication family of solutions. This course will examine the architecture, components and capabilities of CDC, and discuss various ways to setup and implement the software. This course will explore how to operate and troubleshoot CDC and discuss “Best Practices” in maintaining the Environment. Lastly, use cases will be provided to help student understand how replication is used using InfoSphere Change Data Capture to a Business Environment.
-
This offering teaches Cloudant developers how to build and query all of the different types of indexes supported by Cloudant.
Note: Guided eLearning is a self-paced offering which includes web-based content for self study and videos (including audio) that demonstrate hands-on activities.
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.
-
The K07001G: Using XML in DataStage course teaches experienced DataStage developers how to use the Hierarchical Data stage to parse, compose, and transform XML data.
Note: Guided eLearning is a self-paced offering which includes web-based content for self study and videos (including audio) that demonstrate the hands-on activity.
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 provides Administrators with guidance on installing and administering the IBM Planning Analytics – Local environment. The course outlines how the architecture can be customized to fit into various infrastructures. Students will learn how to install and configure IBM Planning Analytics – Local, monitor system performance, and secure applications.
Note: Guided eLearning is a self-paced offering which includes web-based content for self-study and videos (including audio) that demonstrate activities.
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 intended for Developers, Database Administrators, and System Programmers who require further insight into the SQL language.
Note: Guided eLearning is a self-paced offering which includes web-based content for self-study and videos (including audio) that demonstrate activities.
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 offering teaches cloud database support staff how to use the CLPPLUS and REST API command line tools to load data into a dashDB for Analytics or dashDB for Transactions database.
Note: Guided eLearning is a self-paced offering which includes web-based content for self study and videos (including audio) that demonstrate the hands-on activity.
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 offering teaches cloud database support staff how to manage access of users and privileges to a dashDB for Analytics or dashDB for Transactions database.
Note: Guided eLearning is a self-paced offering which includes web-based content for self study and videos (including audio) that demonstrate the hands-on activity.
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. http://www.ibm.com/training/terms
