{"course":{"productid":13341,"modality":1,"active":true,"language":"en","title":"Data Warehousing on AWS","productcode":"DWAWS","vendorcode":"AW","vendorname":"Amazon Web Services","fullproductcode":"AW-DWAWS","courseware":{"has_ekit":true,"has_printkit":false,"language":"en"},"url":"https:\/\/portal.flane.ch\/course\/amazon-dwaws","objective":"<p>In this course, you will learn to:\n<\/p>\n<ul>\n<li>Describe Amazon Redshift architecture and its roles in a modern data architecture<\/li><li>Design and implement a data warehouse in the cloud using Amazon Redshift<\/li><li>Identify and load data into an Amazon Redshift data warehouse from a variety of sources<\/li><li>Analyze data using SQL QEV2 notebooks<\/li><li>Design and implement a disaster recovery strategy for an Amazon Redshift data warehouse<\/li><li>Perform maintenance and performance tuning on an Amazon Redshift data warehouse<\/li><li>Secure and manage access to an Amazon Redshift data warehouse<\/li><li>Share data between multiple Redshift clusters in an organization<\/li><li>Orchestrate workflows in the data warehouse using AWS Step Functions state machines<\/li><li>Create an ML model and configure predictors using Amazon Redshift ML<\/li><\/ul>","essentials":"<p>We recommend that attendees of this course have completed the following courses:\n<\/p>\n<ul>\n<li>Fundamentals of Analytics on AWS &ndash; Part 1 (Digital course)<\/li><li>Fundamentals of Analytics on AWS &ndash; Part 2 (Digital course)<\/li><li>Building Data Lakes on AWS <span class=\"cms-link-marked\"><a class=\"fl-href-prod\" href=\"\/swisscom\/en\/course\/amazon-bdla\"><svg role=\"img\" aria-hidden=\"true\" focusable=\"false\" data-nosnippet class=\"cms-linkmark\"><use xlink:href=\"\/css\/img\/icnset-linkmarks.svg#linkmark\"><\/use><\/svg>Building Data Lakes on AWS <span class=\"fl-prod-pcode\">(BDLA)<\/span><\/a><\/span> (Instructor led Training)<\/li><li>Building Data Analytics Solutions Using Amazon Redshift <span class=\"cms-link-marked\"><a class=\"fl-href-prod\" href=\"\/swisscom\/en\/course\/amazon-bdasar\"><svg role=\"img\" aria-hidden=\"true\" focusable=\"false\" data-nosnippet class=\"cms-linkmark\"><use xlink:href=\"\/css\/img\/icnset-linkmarks.svg#linkmark\"><\/use><\/svg>Building Data Analytics Solutions Using Amazon Redshift <span class=\"fl-prod-pcode\">(BDASAR)<\/span><\/a><\/span> (Instructor led Training)<\/li><\/ul>","audience":"<p>This course is intended for:\n<\/p>\n<ul>\n<li>Data engineers<\/li><li>Data architects<\/li><li>Database architects<\/li><li>Database administrators<\/li><li>Database developers<\/li><\/ul>","outline":"<p><strong>Day 1<\/strong><\/p>\n<h4>Module 1: Data Warehouse Concepts<\/h4><ul>\n<li>Modern data architecture<\/li><li>Introduction to the course story<\/li><li>Data warehousing with Amazon Redshift<\/li><li>Amazon Redshift Serverless architecture<\/li><li>Hands-On Lab: Launch and Configure an Amazon Redshift Serverless Data Warehouse<\/li><\/ul><h4>Module 2: Setting up Amazon Redshift<\/h4><ul>\n<li>Data models for Amazon Redshift<\/li><li>Data management in Amazon Redshift<\/li><li>Managing permissions in Amazon Redshift<\/li><li>Hands-On Lab: Setting up a Data Warehouse using Amazon Redshift Serverless<\/li><\/ul>\n<h4>Module 3: Loading Data<\/h4><ul>\n<li>Overview of data sources<\/li><li>Loading data from Amazon Simple Storage Service (Amazon S3)<\/li><li>Extract, transform, and load (ETL) and extract, load, and transform (ELT)<\/li><li>Loading streaming data<\/li><li>Loading data from relational databases<\/li><li>Hands-On Lab: Populating the data warehouse<\/li><\/ul><p><strong>Day 2<\/strong><\/p>\n<h4>Module 4: Deep Dive into SQL Query Editor v2 and Notebooks<\/h4><ul>\n<li>Features of Amazon Redshift Query Editor v2<\/li><li>Demonstration: Using Amazon Redshift Query Editor v2<\/li><li>Advanced queries<\/li><li>Hands-On Lab: Data Wrangling on AWS<\/li><\/ul><h4>Module 5: Backup and Recovery<\/h4><ul>\n<li>Disaster recovery<\/li><li>Backing up and restoring Amazon Redshift provisioned<\/li><li>Backing up and restoring Amazon Redshift Serverless<\/li><\/ul><h4>Module 6: Amazon Redshift Performance Tuning<\/h4><ul>\n<li>Factors that impact query performance<\/li><li>Table maintenance and materialized views<\/li><li>Query analysis<\/li><li>Workload management<\/li><li>Tuning guidance<\/li><li>Amazon Redshift monitoring<\/li><li>Hands-On Lab: Performance Tuning the Data Warehouse<\/li><\/ul><h4>Module 7: Securing Amazon Redshift<\/h4><ul>\n<li>Introduction to Amazon Redshift security and compliance<\/li><li>Authentication with Amazon Redshift<\/li><li>Access control with Amazon Redshift<\/li><li>Data encryption with Amazon Redshift<\/li><li>Auditing and compliance with Amazon Redshift<\/li><li>Hands-On Lab: Securing Amazon Redshift<\/li><\/ul><p><strong>Day 3<\/strong><\/p>\n<h4>Module 8: Orchestration<\/h4><ul>\n<li>Overview of data orchestration<\/li><li>Orchestration with AWS Step Functions<\/li><li>Orchestration with Amazon Managed Workflows for Apache Airflow (MWAA)<\/li><li>Hands-On Lab: Orchestrating the Data Warehouse Pipeline<\/li><\/ul><h4>Module 9: Amazon Redshift ML<\/h4><ul>\n<li>Machine Learning Overview<\/li><li>Getting started with Amazon Redshift ML<\/li><li>Amazon Redshift ML workflow scenarios<\/li><li>Amazon Redshift ML Usage<\/li><li>Hands-On Lab: Predicting customer churn with Amazon Redshift ML<\/li><\/ul><h4>Module 10: Amazon Redshift Data Sharing<\/h4><ul>\n<li>Overview of data sharing in Amazon Redshift<\/li><li>Amazon DataZone for Data as a service<\/li><\/ul>\n<h4>Module 11: Wrap-Up<\/h4><ul>\n<li>Hands-On Lab: End of course challenge lab<\/li><\/ul>","summary":"<p>Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift. This course demonstrates how to ingest, store, and transform data in the data warehouse. Topics covered include: the purpose of Amazon Redshift, how Amazon Redshift addresses business and technical challenges, features and capabilities of Amazon Redshift, designing a Data Warehousing Solution on AWS by applying best practices based on the Well-Architected Framework, integration with AWS and non-AWS products and services, performance tuning, orchestration, and securing and monitoring Amazon Redshift.<\/p>","objective_plain":"In this course, you will learn to:\n\n\n\n- Describe Amazon Redshift architecture and its roles in a modern data architecture\n- Design and implement a data warehouse in the cloud using Amazon Redshift\n- Identify and load data into an Amazon Redshift data warehouse from a variety of sources\n- Analyze data using SQL QEV2 notebooks\n- Design and implement a disaster recovery strategy for an Amazon Redshift data warehouse\n- Perform maintenance and performance tuning on an Amazon Redshift data warehouse\n- Secure and manage access to an Amazon Redshift data warehouse\n- Share data between multiple Redshift clusters in an organization\n- Orchestrate workflows in the data warehouse using AWS Step Functions state machines\n- Create an ML model and configure predictors using Amazon Redshift ML","essentials_plain":"We recommend that attendees of this course have completed the following courses:\n\n\n\n- Fundamentals of Analytics on AWS \u2013 Part 1 (Digital course)\n- Fundamentals of Analytics on AWS \u2013 Part 2 (Digital course)\n- Building Data Lakes on AWS Building Data Lakes on AWS (BDLA) (Instructor led Training)\n- Building Data Analytics Solutions Using Amazon Redshift Building Data Analytics Solutions Using Amazon Redshift (BDASAR) (Instructor led Training)","audience_plain":"This course is intended for:\n\n\n\n- Data engineers\n- Data architects\n- Database architects\n- Database administrators\n- Database developers","outline_plain":"Day 1\n\nModule 1: Data Warehouse Concepts\n\n\n- Modern data architecture\n- Introduction to the course story\n- Data warehousing with Amazon Redshift\n- Amazon Redshift Serverless architecture\n- Hands-On Lab: Launch and Configure an Amazon Redshift Serverless Data Warehouse\nModule 2: Setting up Amazon Redshift\n\n\n- Data models for Amazon Redshift\n- Data management in Amazon Redshift\n- Managing permissions in Amazon Redshift\n- Hands-On Lab: Setting up a Data Warehouse using Amazon Redshift Serverless\n\nModule 3: Loading Data\n\n\n- Overview of data sources\n- Loading data from Amazon Simple Storage Service (Amazon S3)\n- Extract, transform, and load (ETL) and extract, load, and transform (ELT)\n- Loading streaming data\n- Loading data from relational databases\n- Hands-On Lab: Populating the data warehouse\nDay 2\n\nModule 4: Deep Dive into SQL Query Editor v2 and Notebooks\n\n\n- Features of Amazon Redshift Query Editor v2\n- Demonstration: Using Amazon Redshift Query Editor v2\n- Advanced queries\n- Hands-On Lab: Data Wrangling on AWS\nModule 5: Backup and Recovery\n\n\n- Disaster recovery\n- Backing up and restoring Amazon Redshift provisioned\n- Backing up and restoring Amazon Redshift Serverless\nModule 6: Amazon Redshift Performance Tuning\n\n\n- Factors that impact query performance\n- Table maintenance and materialized views\n- Query analysis\n- Workload management\n- Tuning guidance\n- Amazon Redshift monitoring\n- Hands-On Lab: Performance Tuning the Data Warehouse\nModule 7: Securing Amazon Redshift\n\n\n- Introduction to Amazon Redshift security and compliance\n- Authentication with Amazon Redshift\n- Access control with Amazon Redshift\n- Data encryption with Amazon Redshift\n- Auditing and compliance with Amazon Redshift\n- Hands-On Lab: Securing Amazon Redshift\nDay 3\n\nModule 8: Orchestration\n\n\n- Overview of data orchestration\n- Orchestration with AWS Step Functions\n- Orchestration with Amazon Managed Workflows for Apache Airflow (MWAA)\n- Hands-On Lab: Orchestrating the Data Warehouse Pipeline\nModule 9: Amazon Redshift ML\n\n\n- Machine Learning Overview\n- Getting started with Amazon Redshift ML\n- Amazon Redshift ML workflow scenarios\n- Amazon Redshift ML Usage\n- Hands-On Lab: Predicting customer churn with Amazon Redshift ML\nModule 10: Amazon Redshift Data Sharing\n\n\n- Overview of data sharing in Amazon Redshift\n- Amazon DataZone for Data as a service\n\nModule 11: Wrap-Up\n\n\n- Hands-On Lab: End of course challenge lab","summary_plain":"Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift. This course demonstrates how to ingest, store, and transform data in the data warehouse. Topics covered include: the purpose of Amazon Redshift, how Amazon Redshift addresses business and technical challenges, features and capabilities of Amazon Redshift, designing a Data Warehousing Solution on AWS by applying best practices based on the Well-Architected Framework, integration with AWS and non-AWS products and services, performance tuning, orchestration, and securing and monitoring Amazon Redshift.","skill_level":"Intermediate","version":"2.0","duration":{"unit":"d","value":3,"formatted":"3 days"},"pricelist":{"List Price":{"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":1995},"AT":{"country":"AT","currency":"EUR","taxrate":20,"price":1995},"OM":{"country":"OM","currency":"USD","taxrate":5,"price":1480},"QA":{"country":"QA","currency":"USD","taxrate":5,"price":1480},"SA":{"country":"SA","currency":"USD","taxrate":5,"price":1480},"KE":{"country":"KE","currency":"USD","taxrate":null,"price":1480},"ZA":{"country":"ZA","currency":"USD","taxrate":14,"price":1480},"KW":{"country":"KW","currency":"USD","taxrate":5,"price":1480},"DZ":{"country":"DZ","currency":"USD","taxrate":null,"price":1480},"MA":{"country":"MA","currency":"USD","taxrate":null,"price":1480},"TN":{"country":"TN","currency":"USD","taxrate":null,"price":1480},"LB":{"country":"LB","currency":"USD","taxrate":null,"price":1480},"JO":{"country":"JO","currency":"USD","taxrate":null,"price":1480},"LR":{"country":"LR","currency":"USD","taxrate":null,"price":1480},"US":{"country":"US","currency":"USD","taxrate":null,"price":2025},"IT":{"country":"IT","currency":"EUR","taxrate":20,"price":1650},"SI":{"country":"SI","currency":"EUR","taxrate":20,"price":1995},"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":1995},"AE":{"country":"AE","currency":"USD","taxrate":5,"price":1800},"RU":{"country":"RU","currency":"RUB","taxrate":18,"price":127500},"SG":{"country":"SG","currency":"USD","taxrate":8,"price":1895},"IL":{"country":"IL","currency":"ILS","taxrate":17,"price":6920},"GR":{"country":"GR","currency":"EUR","taxrate":null,"price":1995},"MK":{"country":"MK","currency":"EUR","taxrate":null,"price":1995},"BE":{"country":"BE","currency":"EUR","taxrate":21,"price":2195},"NL":{"country":"NL","currency":"EUR","taxrate":21,"price":2195},"HU":{"country":"HU","currency":"EUR","taxrate":20,"price":1995},"PL":{"country":"PL","currency":"PLN","taxrate":23,"price":5200},"GB":{"country":"GB","currency":"GBP","taxrate":20,"price":2655},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":2680},"CA":{"country":"CA","currency":"CAD","taxrate":null,"price":2795},"FR":{"country":"FR","currency":"EUR","taxrate":19.6,"price":2550}}},"lastchanged":"2025-12-24T11:15:38+01:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/en\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course-schedule\/13341","source_lang":"en","source":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course\/amazon-dwaws"}}