Viale Premuda 14, 20129 Milano - academy@digiacademy.it - 0250030724

Loading dashDB Tables Using CLPPLUS and REST API - eLearning 

Codice corso: K04007G-WBT
Durata corso: 4hr

Overview

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

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

Objective

Please refer to course overview

 

Course Outline

• 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 restart
• 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

P.IVA 06249920965
C.C.I.A.A. REA: MI - 1880014
Cap. Soc. € 12.000,00

Contatti

Viale Premuda n. 14 ,20129 Milano
Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo.
Tel.: +39 02 50030 724
Fax.: +39 02 50030 725

© Copyright DI.GI. Academy
Privacy Policy | Cookie Policy