<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE FL_Course SYSTEM "https://www.flane.de/dtd/fl_course095.dtd"><?xml-stylesheet type="text/xsl" href="https://portal.flane.ch/css/xml-course.xsl"?><course productid="26441" language="de" source="https://portal.flane.ch/swisscom/xml-course/amazon-bdasar" lastchanged="2025-08-27T17:03:23+02:00" parent="https://portal.flane.ch/swisscom/xml-courses"><title>Building Data Analytics Solutions Using Amazon Redshift</title><productcode>BDASAR</productcode><vendorcode>AW</vendorcode><vendorname>Amazon Web Services</vendorname><fullproductcode>AW-BDASAR</fullproductcode><version>1.0</version><essentials>&lt;p&gt;Sie sollten mindestens ein Jahr Erfahrung in der Verwaltung von Data Warehouses mitbringen und folgende Kurse vorher besucht haben:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;Entweder &lt;span class=&quot;cms-link-marked&quot;&gt;&lt;a class=&quot;fl-href-prod&quot; href=&quot;/swisscom/course/amazon-awse&quot;&gt;&lt;svg role=&quot;img&quot; aria-hidden=&quot;true&quot; focusable=&quot;false&quot; data-nosnippet class=&quot;cms-linkmark&quot;&gt;&lt;use xlink:href=&quot;/css/img/icnset-linkmarks.svg#linkmark&quot;&gt;&lt;/use&gt;&lt;/svg&gt;AWS Technical Essentials &lt;span class=&quot;fl-prod-pcode&quot;&gt;(AWSE)&lt;/span&gt;&lt;/a&gt;&lt;/span&gt; oder &lt;span class=&quot;cms-link-marked&quot;&gt;&lt;a class=&quot;fl-href-prod&quot; href=&quot;/swisscom/course/amazon-awsa&quot;&gt;&lt;svg role=&quot;img&quot; aria-hidden=&quot;true&quot; focusable=&quot;false&quot; data-nosnippet class=&quot;cms-linkmark&quot;&gt;&lt;use xlink:href=&quot;/css/img/icnset-linkmarks.svg#linkmark&quot;&gt;&lt;/use&gt;&lt;/svg&gt;Architecting on AWS &lt;span class=&quot;fl-prod-pcode&quot;&gt;(AWSA)&lt;/span&gt;&lt;/a&gt;&lt;/span&gt;&lt;/li&gt;&lt;li&gt;&lt;span class=&quot;cms-link-marked&quot;&gt;&lt;a class=&quot;fl-href-prod&quot; href=&quot;/swisscom/course/amazon-bdla&quot;&gt;&lt;svg role=&quot;img&quot; aria-hidden=&quot;true&quot; focusable=&quot;false&quot; data-nosnippet class=&quot;cms-linkmark&quot;&gt;&lt;use xlink:href=&quot;/css/img/icnset-linkmarks.svg#linkmark&quot;&gt;&lt;/use&gt;&lt;/svg&gt;Building Data Lakes on AWS &lt;span class=&quot;fl-prod-pcode&quot;&gt;(BDLA)&lt;/span&gt;&lt;/a&gt;&lt;/span&gt;&lt;/li&gt;&lt;/ul&gt;</essentials><audience>&lt;p&gt;Dieser Kurs richtet sich an Data Warehouse Engineers, Data Platform Engineers, sowie Architects und Operators, die Datenanalyse-Pipelines erstellen und verwalten.&lt;/p&gt;</audience><contents>&lt;ul&gt;
&lt;li&gt;Module A: Overview of Data Analytics and the Data Pipeline&lt;/li&gt;&lt;li&gt;Module 1: Using Amazon Redshift in the Data Analytics Pipeline&lt;/li&gt;&lt;li&gt;Module 2: Introduction to Amazon Redshift&lt;/li&gt;&lt;li&gt;Module 3: Ingestion and Storage&lt;/li&gt;&lt;li&gt;Module 4: Processing and Optimizing Data&lt;/li&gt;&lt;li&gt;Module 5: Security and Monitoring of Amazon Redshift Clusters&lt;/li&gt;&lt;li&gt;Module 6: Designing Data Warehouse Analytics Solutions&lt;/li&gt;&lt;li&gt;Module B: Developing Modern Data Architectures on AWS&lt;/li&gt;&lt;/ul&gt;</contents><outline>&lt;h5&gt;Module A: Overview of Data Analytics and the Data Pipeline&lt;/h5&gt;
&lt;ul&gt;
&lt;li&gt;Data analytics use cases&lt;/li&gt;&lt;li&gt;Using the data pipeline for analytics&lt;/li&gt;&lt;/ul&gt;&lt;h5&gt;Module 1: Using Amazon Redshift in the Data Analytics Pipeline&lt;/h5&gt;
&lt;ul&gt;
&lt;li&gt;Why Amazon Redshift for data warehousing?&lt;/li&gt;&lt;li&gt;Overview of Amazon Redshift&lt;/li&gt;&lt;/ul&gt;&lt;h5&gt;Module 2: Introduction to Amazon Redshift&lt;/h5&gt;
&lt;ul&gt;
&lt;li&gt;Amazon Redshift architecture&lt;/li&gt;&lt;li&gt;Interactive Demo 1: Touring the Amazon Redshift console&lt;/li&gt;&lt;li&gt;Amazon Redshift features&lt;/li&gt;&lt;li&gt;Practice Lab 1: Load and query data in an Amazon Redshift cluster&lt;/li&gt;&lt;/ul&gt;&lt;h5&gt;Module 3: Ingestion and Storage&lt;/h5&gt;
&lt;ul&gt;
&lt;li&gt;Ingestion&lt;/li&gt;&lt;li&gt;Interactive Demo 2: Connecting your Amazon Redshift cluster using a Jupyter notebook with Data API&lt;/li&gt;&lt;li&gt;Data distribution and storage&lt;/li&gt;&lt;li&gt;Interactive Demo 3: Analyzing semi-structured data using the SUPER data type&lt;/li&gt;&lt;li&gt;Querying data in Amazon Redshift&lt;/li&gt;&lt;li&gt;Practice Lab 2: Data analytics using Amazon Redshift Spectrum&lt;/li&gt;&lt;/ul&gt;&lt;h5&gt;Module 4: Processing and Optimizing Data&lt;/h5&gt;
&lt;ul&gt;
&lt;li&gt;Data transformation&lt;/li&gt;&lt;li&gt;Advanced querying&lt;/li&gt;&lt;li&gt;Practice Lab 3: Data transformation and querying in Amazon Redshift&lt;/li&gt;&lt;li&gt;Resource management&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;
 
Interactive Demo 4: Applying mixed workload management on Amazon Redshift
 
&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;Automation and optimization&lt;/li&gt;&lt;li&gt;Interactive demo 5: Amazon Redshift cluster resizing from the dc2.large to ra3.xlplus cluster&lt;/li&gt;&lt;/ul&gt;&lt;h5&gt;Module 5: Security and Monitoring of Amazon Redshift Clusters&lt;/h5&gt;
&lt;ul&gt;
&lt;li&gt;Securing the Amazon Redshift cluster&lt;/li&gt;&lt;li&gt;Monitoring and troubleshooting Amazon Redshift clusters&lt;/li&gt;&lt;/ul&gt;&lt;h5&gt;Module 6: Designing Data Warehouse Analytics Solutions&lt;/h5&gt;
&lt;ul&gt;
&lt;li&gt;Data warehouse use case review&lt;/li&gt;&lt;li&gt;Activity: Designing a data warehouse analytics workflow&lt;/li&gt;&lt;/ul&gt;&lt;h5&gt;Module B: Developing Modern Data Architectures on AWS&lt;/h5&gt;
&lt;ul&gt;
&lt;li&gt;Modern data architectures&lt;/li&gt;&lt;/ul&gt;</outline><essentials_plain>Sie sollten mindestens ein Jahr Erfahrung in der Verwaltung von Data Warehouses mitbringen und folgende Kurse vorher besucht haben:


- Entweder AWS Technical Essentials (AWSE) oder Architecting on AWS (AWSA)
- Building Data Lakes on AWS (BDLA)</essentials_plain><audience_plain>Dieser Kurs richtet sich an Data Warehouse Engineers, Data Platform Engineers, sowie Architects und Operators, die Datenanalyse-Pipelines erstellen und verwalten.</audience_plain><contents_plain>- Module A: Overview of Data Analytics and the Data Pipeline
- Module 1: Using Amazon Redshift in the Data Analytics Pipeline
- Module 2: Introduction to Amazon Redshift
- Module 3: Ingestion and Storage
- Module 4: Processing and Optimizing Data
- Module 5: Security and Monitoring of Amazon Redshift Clusters
- Module 6: Designing Data Warehouse Analytics Solutions
- Module B: Developing Modern Data Architectures on AWS</contents_plain><outline_plain>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 of Amazon Redshift Clusters



- Securing the Amazon Redshift cluster
- Monitoring and troubleshooting Amazon Redshift clusters
Module 6: Designing Data Warehouse Analytics Solutions



- Data warehouse use case review
- Activity: Designing a data warehouse analytics workflow
Module B: Developing Modern Data Architectures on AWS



- Modern data architectures</outline_plain><duration unit="d" days="1">1 Tag</duration><pricelist><price country="DE" currency="EUR">795.00</price><price country="AT" currency="EUR">795.00</price><price country="SE" currency="EUR">750.00</price><price country="SI" currency="EUR">795.00</price><price country="IT" currency="EUR">725.00</price><price country="PL" currency="PLN">2000.00</price><price country="US" currency="USD">675.00</price><price country="AE" currency="USD">650.00</price><price country="GR" currency="EUR">795.00</price><price country="MK" currency="EUR">795.00</price><price country="HU" currency="EUR">795.00</price><price country="NL" currency="EUR">795.00</price><price country="BE" currency="EUR">795.00</price><price country="GB" currency="GBP">900.00</price><price country="CH" currency="CHF">870.00</price><price country="CA" currency="CAD">930.00</price></pricelist><miles/></course>