IBM KM204G - IBM INFOSPHERE DATASTAGE .IBM KM204G - IBM INFOSPHERE DATASTAGE ESSENTIALS (V11.5) Dauer:

  • View
    246

  • Download
    2

Embed Size (px)

Text of IBM KM204G - IBM INFOSPHERE DATASTAGE .IBM KM204G - IBM INFOSPHERE DATASTAGE ESSENTIALS (V11.5)...

  • IBM KM204G - IBM INFOSPHERE DATASTAGE ESSENTIALS (V11.5)

    Dauer: 4 Tage

    Durchfhrungsart: Prsenztraining

    Zielgruppe: Project administrators and ETL developers responsiblefor data extraction and transformation using DataStage.

    Voraussetzungen: - Basic knowledge of Windows operating system- Familiarity with database access techniques

    Nr.: 37417Preis: 2.790,00 (netto) / 3.320,10 inkl. 19% MwSt.

    Schulungsmethode: presentation, discussion, hands-on exercises,demonstrations on the system.

    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. Studentswill learn to create parallel jobs that access sequential and relational data and combine and transform the data using functions andother job components.

    Objectives:

    - Describe the uses of DataStage and the DataStage workflow

    - Describe the Information Server architecture and how DataStage fits within it

    - Describe the Information Server and DataStage deployment options

    - Use the Information Server Web Console and the DataStage Administrator client to create DataStage users and to configure theDataStage environment

    - Import and export DataStage objects to a file

    - Import table definitions for sequential files and relational tables

    - Design, compile, run, and monitor DataStage parallel jobs

    - Design jobs that read and write to sequential files

    - Describe the DataStage parallel processing architecture

    - Design jobs that combine data using joins and lookups

    - Design jobs that sort and aggregate data

    - Implement complex business logic using the DataStage Transformer stage

    - Debug DataStage jobs using the DataStage PX Debugger

    Programm

    Key topics:

    Introduction to DataStageDeploymentDataStage AdministrationWork with MetadataCreate Parallel JobsAccess Sequential Data

  • Partitioning and Collecting AlgorithmsCombine DataGroup Processing and Transformer StagesRepository FunctionsWork with Relational DataControl Jobs

    Hinweis

    Class language is German, student notebooks in English, examination is English.

  • Online Anmeldung:Kundenservice | Tel. 0711 62010 100 | Fax: 0711 62010 267 | seminaranmeldung@integrata.deURL: https://www.integrata.de/37417

    Termine und Orte: 06 September 2018 Nr.: 37417

    Dsseldorf

    05 Mrz - 08 Mrz 2019

    Mnchen

    09 Sep - 12 Sep 2019

  • IBM DW664G - IBM BIG SQL FOR ADMINISTRATORS (V5.0)

    Dauer: 1 Tag

    Durchfhrungsart: Prsenztraining

    Zielgruppe: Administrators, Developers.

    Voraussetzungen: Basic Linux knowledgeBasic SQL knowledgeWorking knowledge with big data and Hadoop Technologies

    Nr.: 37500Preis: 790,00 (netto) / 940,10 inkl. 19% MwSt.

    Schulungsmethode: presentation, discussion, hands-on exercises,demonstrations on the system.

    This course is designed to introduce the student to some of the additional capabilities and the administration of IBM Big SQL. IBM BigSQL 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 datawarehouse data on your HDFS data. This course covers Big SQL security using row and column access controls, impersonation, anddata federation. The course also covers some of the best practices, performance tuning, and monitoring techniques, YARN integrationand also includes an optional unit to explore a Big SQL installation.

    Programm

    Key topics:

    1: Managing the Big SQL Server

    Configure the Big SQL ServerConfigure the Big SQL SchedulerList the registries for compiler and runtime performance improvementBackup and restore Big SQL

    2: Configuring Big SQL security

    Configure authentication for Big SQLManage security with Apache RangerEnable SSL encryptionConfigure authorization of Big SQL objectsConfigure impersonation with Big SQL

    3: Data federation with Big SQL

    Configure wrappers, servers, user mappings and nicknames for data federation

    4: Using statistical data to improve Big SQL performance

    Understand the Big SQL data access planUse Big SQL statistics to improve query performance

  • 5: Monitoring Big SQL

    Use the Big SQL query interfaceMonitor the performance of read and write access

    6: Big SQL and YARN integration

    Configure Big SQL and YARN integration through Apache Slider

    7: Troubleshooting Big SQL

    Troubleshoot common problems and understand the known resolutions

    Exploring Big SQL installation (Optional)

    Explore Big SQL installation

    Objectives:

    Please refer to course overview.

  • Online Anmeldung:Kundenservice | Tel. 0711 62010 100 | Fax: 0711 62010 267 | seminaranmeldung@integrata.deURL: https://www.integrata.de/37500

    Termine und Orte: 06 September 2018 Nr.: 37500

    Frankfurt

    30 Nov - 30 Nov 2018

    Stuttgart

    08 Apr - 08 Apr 2019

    Hamburg

    11 Nov - 11 Nov 2019

  • IBM 0G525G - DATA MANAGEMENT AND MANIPULATION USING IBM SPSSSTATISTICS (V24)

    Dauer: 2 Tage

    Durchfhrungsart: Prsenztraining

    Zielgruppe: Anyone who has worked with IBM SPSS Statistics andwants to explore additional data management and manipulationfeatures of IBM SPSS Statistics and generally increase theirefficiency with IBM SPSS Statistics. Anyone who has learned the basic operations of IBM SPSSStatistics on their own.

    Voraussetzungen: General computer literacy Completion of the Introduction to IBM SPSS Statistics course orexperience with IBM SPSS Statistics (Version 18 or later) includingfamiliarity with defining data, basic uses of Recode and Computetransformations, the Frequencies, Descriptives, and Crosstabsprocedures, and creating and editing tables and charts. Nostatistical background is necessary.

    Nr.: 37525Preis: 1.490,00 (netto) / 1.773,10 inkl. 19% MwSt.

    Schulungsmethode: presentation, discussion, hands-on exercises,demonstrations on the system.

    Data Management and Manipulation Using IBM SPSS Statistics is a course on the use of a wide range of transformation techniques,ways to automate data preparation work, manipulate data files and analytical results. Students will gain an understanding of thevarious options for controlling the IBM SPSS Statistics operating environment and how to perform data transformations efficiently. Thiscourse uses the IBM SPSS Statistics Base features.

    Programm

    Key topics

    1. Helpful data management features

    Read from a database using the Database Wizard

    Customize variable attributes

    Compare datasets

    Use Variable Sets

    Rename datasets

    2. Use functions to cleanse and enrich data

    Identify the need to cleanse and enrich data

    Identify the general form of a function

    Use statistical functions

    Use logical functions

    Use missing value functions

    Use conversion functions

  • Use system variables

    3. Additional transformations for data preparation

    Use Automatic Recode to recode string variables into numeric variables

    Use Count Values within Cases to count values across variables

    4. Set the unit of analysis

    Remove duplicate cases

    Create aggregated datasets

    Restructure datasets

    5. Merge data files

    Add cases from one dataset to another

    Add variables from one dataset to another

    Enrich a dataset with aggregated information

    6. Analyze multiple response questions

    Describe the two ways to encode a multiple response set

    Define multiple response sets

    Use the Multiple Response Frequencies and Crosstabs procedures

    7. Customize tables and charts

    Use the features of the Pivot Table Editor

    Create and apply customized TableLooks

    Use the features of the Chart Editor

    Create and apply customized Chart Templates

    8. Introduction to the Output Management System

    Explain Output Types

    Specify an OMS request to suppress output

    Specify an OMS request to export output

    9. Automate analyses

    Describe and use the features of the Syntax Editor

    Make simple changes to syntax

    Describe and use the features of the Production Facility dialog box

    Run a simple production job

    Describe the use of external programming languages with IBM SPSS Statistics

    10. Control the IBM SPSS Statistics environment

    Describe the features of the Options dialog box

    Set the display of variables

  • Set the default working data folders

    Change transformation options for variables

  • Online Anmeldung:Kundenservice | Tel. 0711 62010 100 | Fax: 0711 62010 267 | seminaranmeldung@integrata.deURL: https://www.integrata.de/37525

    Termine und Orte: 06 September 2018 Nr.: 37525

    Mnchen

    15 Okt - 16 Okt 2018 09 Sep - 10 Sep 2019

    Hamburg

    07 Mrz - 08 Mrz 2019

  • IBM 0G505G - INTRODUCTION TO IBM SPSS STATISTICS (V24)

    Dauer: 2 Tage

    Durchfhrungsart: Prsenztraining

    Zielgruppe: Anyone with little or no experience in using IBM SPSSStatisticsAnyone who is new to using a statistical package for dataanalysisAnyone who is considering purchasing IBM SPSS Statistics

    Voraussetzungen: Experience using applications, such as wordprocessors or spreadsheets, in the Microsoft Windows, Macintoshor Linux environmentExperience with IBM SPSS Statistics is not necessary, though abasic understanding of purpose and functions of the software ishelpful

    Nr.: 37505Preis: 1.390,00 (netto) / 1.654,10 inkl. 19% MwSt.

    Schulungsmethode: presentation, discussion, hands-on ex