Overview

This course offers data engineers more experience with watsonx.data 2.0.2. You will gain knowledge in the areas such as infrastructure management, data management, running SQL statements by using watsonx.data console (user interface). You gain skills in access control, ingesting data, creating schemas, running queries that combines data from multiple data sources, and rolling back a table to previous point in time.

Audience

Data Engineers, Data Administrators, Data Analysts

Prerequisites

Before you start this course, you should be able to complete the following tasks:

• Explain the purpose of watsonx.data and the value that it brings to the business
• Describe the architecture and components of watsonx.data
• DL19003G-IBM watsonx.data Technical Essentials course

Objective

By the end of this course, you will be able to:

• Describe the benefits, value, and use cases for watsonx.data
• Explain the common components of watsonx.data
• Explore watsonx.data web-based user interface, including infrastructure management, data management, running SQL statements, and managing user access
• Utilize watsonx.data console to collect, store, query, and analyze all your enterprise data
• Manage infrastructure access and data access policies using Access Control in watsonx.data
• Utilize Presto watsonx.data’s user interface (UI) and command line interface (CLI) for effective execution of SQL queries
• Explore MinIO Object Storage to load or store data
• Create different database connections (IBM Db2, PostgreSQL) to migrate data to watsonx.data
• Run queries that combine data from multiple data sources

Course Outline

• Introduction
• Introduction to watsonx.data
• Using the watsonx.data console (UI)
• Data warehouse modernization
• Incorporate operational data for analytics
• Review and evaluation