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.
IBM Information Management Courses
Click Here to Request It.
- Self-Paced Virtual Classroom
KM020G – IBM InfoSphere Data Replication – InfoSphere Change Data Capture Essentials
In this course students will learn 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. The 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.
- Instructor Led Online
KM204G – IBM InfoSphere DataStage Essentials
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.
KM213G – IBM InfoSphere QualityStage Essentials
This course teaches students 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.
KM404G – IBM InfoSphere Advanced DataStage: Parallel Framework
This course is designed to introduce advanced parallel job development techniques in DataStage v11.5. In this course students 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.
KM413G – IBM InfoSphere Advanced QualityStage
This course introduces students to the QualityStage data cleansing process. Students will transform an unstructured data source into a format suitable for loading into an existing data target. Students will cleanse the source data by building a customer rule set that they create and use that rule set to standardize the data. Students will next build a reference match to relate the cleansed source data to the existing target data.
KM423G – IBM InfoSphere DataStage – Advanced Data Processing
This course is designed to introduce students to advanced parallel job data processing techniques in InfoSphere DataStage v11.5. In this course students will develop data techniques for processing different types of complex data resources including relational data, unstructured data (Excel spreadsheets), and XML data. In addition, students will learn advanced techniques for processing data, including techniques for masking data and techniques for validating data using data rules. Finally, students will learn techniques for updating data in a star schema data warehouse using the DataStage SCD (Slowly Changing Dimensions) stage. Even if students are not working with all of these specific types of data, they will benefit from this course by learning advanced DataStage job design techniques, techniques that go beyond those utilized in the DataStage Essentials course.
KM510G – IBM InfoSphere Information Server Administrative Tasks
This course gets those charged with administering InfoSphere Information Server v11.5 and its suite of many products and components started with the basic administrative tasks necessary to support Information Server users and developers.
The course begins with a functional overview of Information Server and the products and components that support these functions. Then it focuses on the basic administrative tasks an Information Server administrator will need to perform including user management, session management, and reporting management tasks. The course covers both the use of Information Server administrative clients such as the Administration Console and Metadata Asset Manager and the use of command line tools such as istool and encrypt.
KM520G – IBM InfoSphere DataStage engine Administration for Information Server V11.5
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.