Prerequisite: None

Course Outline

The enterprise of the 2020’s needs a modern data warehouse that can meet demanding new requirements for machine learning, data variety, scale, and real-time analytics—and these will often be implemented in part or entirely in the cloud. In this course, you will learn about the major cloud data warehouse platforms, their ability to support the modern data warehouse, key architectural features, and what makes them different from one another.

This course will help you understand why data warehouse platforms differ greatly in performance, operating cost, scalability, and ease of development for certain data warehouse requirements. We will cover the technical reasons why scaling is sometimes easy and sometimes very hard—in a way that is relevant to architects, strategists, and decision makers. You need this understanding to choose the best platform for your cloud data warehouse or workload—and to avoid platform mistakes that can be catastrophic.

You Will Learn

• Key concepts of modern data warehouse architecture
• Platform architecture and scalability
• Performance and cost
• Workload requirements and how to apply them in selection
• Data and analytics variety
• Machine learning and advanced analytics inside the data warehouse
• Near real-time data and analytics
• Relevant features of leading cloud data warehouse platforms such as AWS Redshift, Azure Synapse Analytics, Cloudera Data Warehouse, Data Bricks, Google BigQuery, Oracle ADW, Snowflake Data Warehouse, and Teradata Vantage

Geared To

• Data architects
• Data strategists
• Decision recommenders/decision makers
• Data analysts/data scientists
• Project managers
• Enterprise/cloud architects

Richard Winter is an industry expert in analytics data management at scale. Mr. Winter advises decision makers on the data strategy and the data architecture of the modern data warehouse and the data lake. He has been retained to make architecture and platform recommendations or perform engineering tests for over 50 leading enterprises, government agencies, and technology vendors. He is a recognized thought leader and an expert in platform evaluation and benchmarking, having published more than 100 technical reports and articles.