trainocate-ibm-training-b
Home > Vendors > IBM > k04007g

K04007G - Loading dashDB Tables Using CLPPLUS and REST API

Overview

Duration: 0.5 days

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. http://www.ibm.com/training/terms

Objectives

Please refer to course overview

Content

  • Selecting tools for loading data into dashDB tables
  • Add a dashDB database connection for CLPPlus
  • Creating dashDB database objects using CLPPlus
  • Table organization for dashDB tables
  • Table compression for dashDB tables
  • Using the IMPORT command to load data in dashDB
  • Using the LOAD command to load data in dashDB
  • Using dashDB REST API to execute load processing for local data files
  • LOAD recoverability and restar
  • LOAD processing for row compressed tables
  • Table statistics for newly loaded dashDB tables
  • Loading a dashDB table directly from a query result
  • Using database recovery history to review load processing
  • Audience

    Data Analysts or Data Administrators 

    Prerequisites

    • Knowledge of relational database fundamentals is required. Some experience creating relational database objects and load tables is recommended

    Certification

    Schedule

    Show Schedule for: