Data Warehouse Schulungen finden - Das passende Seminar in Ihrer Nähe

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. 

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. 

Module A: Overview of Data Analytics and the Data Pipeline

• Data analytics use cases
• Using the data pipeline for analytics

Module 1: Using Amazon Redshift in the Data Analytics Pipeline

• Why Amazon Redshift for data warehousing?
• Overview of Amazon Redshift

Module 2: Introduction to Amazon Redshift

• Amazon Redshift architecture
• Interactive Demo 1: Touring the Amazon Redshift console
• Amazon Redshift features
• Practice Lab 1: Load and query data in an Amazon Redshift cluster

Module 3: Ingestion and Storage

• Ingestion
• Interactive Demo 2: Connecting your Amazon Redshift cluster using a Jupyter notebook with Data API
• Data distribution and storage
• Interactive Demo 3: Analyzing semi-structured data using the SUPER data type
• Querying data in Amazon Redshift
• Practice Lab 2: Data analytics using Amazon Redshift Spectrum

Module 4: Processing and Optimizing Data

• Data transformation
• Advanced querying
• Practice Lab 3: Data transformation and querying in Amazon Redshift
• Resource management

Interactive Demo 4: Applying mixed workload management on Amazon Redshift

• Automation and optimization
• Interactive demo 5: Amazon Redshift cluster resizing from the dc2.large to ra3.xlplus cluster

Module 5: Security and Monitoring...

Nach dem Seminar kennen Sie die wichtigsten Konzepte des Wissensmanagements aus Betriebswirtschaft, IT und Soziologie. Sie können abschätzen, welche der Konzepte für Ihre Unternehmenssituation angemessen und eventuell sogar erforderlich sind. Sie lernen ein Wissensmanagement-Projekt aufzusetzen und werden mit der Rolle Wissensmanager vertraut. Sie wissen, wie aus einem Data Warehouse ein Knowledge Warehouse wird. Sie können ein ISO15504 konformes Wissensmanagement Audit gestalten