e-Learning
Learn at your own pace with anytime, anywhere training.
Classroom Schedule
There are no classes currently scheduled
* Prices Inclusive of taxes
Virtual Schedule
| Location | Delivered By | Language | Date | Price | Action |
|---|---|---|---|---|---|
| No schedule date's available now. | |||||
* Prices Inclusive of taxes
Private / Corporate Training
Tell us a little about yourself:
Course Description
-
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.
Objectives
-
Please refer to course overview
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
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 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