Overview

This course offers data engineers more experience with watsonx.data on Red Hat OpenShift Container Platform. You learn to gain knowledge in the areas such as infrastructure management, data management, running SQL statements. You gain skills in 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

Objective

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

• Use the watsonx.data console to collect, store, query, and analyze all your enterprise data.
• Extend the functionality of the watsonx.data by seamlessly integrating with Spark Analytic Engine to run your analytics and ETL workloads on all of your data across any environment.
• Manage infrastructure access and data access policies using Access Control
• Use the 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 connection to run federated queries and migrate data to watsonx.data

Course Outline

• Course introduction
• Introduction to watsonx.data
• Using the watsonx.data console
• Data warehouse modernization
• Incorporate operational data for analytics
• Review and evaluation