Why choose AWS for building a data warehouse?

AWS offers a scalable and secure cloud infrastructure with services like Amazon Redshift, which is a fully managed data warehouse solution. It provides high-performance analytics, integrates seamlessly with other AWS services, and enables users to pay solely for the resources they utilize.

What is Amazon Redshift, and how does it differ from traditional databases?

Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. It differs from traditional databases in its ability to handle large-scale analytics workloads with high performance, scalability, and ease of management.

What Amazon Redshift cluster configurations are used in the course?

You’ll learn how to create, configure, and scale Redshift clusters, exploring node types and workload management.

Does the course cover Redshift Spectrum or external table integration with S3?

Yes, Redshift Spectrum and S3 integration are demonstrated for querying external data directly.

Will I learn how to secure a Redshift data warehouse using IAM roles and encryption?

Yes, you’ll configure IAM roles, encryption, and access controls to secure your warehouse.

Does the course walk through cost monitoring in AWS for Redshift usage?

Yes, cost tracking and optimization strategies are included to help you manage Redshift spend.

What will I get if I purchase the Certificate?

When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Build a Data Warehouse in AWS

Q: What will I learn from this course?

This course covers essential AWS services, SQL, and data warehousing, focusing on key topics such as Redshift's architecture, data modeling, efficient data loading, and optimized querying. Emphasis is placed on performance optimization, cluster management, monitoring, and security practices to safeguard sensitive data.

位教师：Edureka

包含在 Coursera Plus 中

了解更多

4个模块

深入了解一个主题并学习基础知识。

中级等级

推荐体验

2 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

4个模块

深入了解一个主题并学习基础知识。

中级等级

推荐体验

2 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将学到什么

Configure and manage Amazon Redshift clusters, IAM roles, and secure storage.
Integrate Redshift with S3, Redshift Spectrum, and AWS Glue for ETL workflows.
Optimize, scale, and monitor Redshift clusters with best practices.
Connect BI tools to Redshift for reporting and insights.

您将获得的技能

要了解的详细信息

可分享的证书

添加到您的领英档案

作业

21 项作业

授课语言：英语（English）

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

该课程共有4个模块

Data Warehouse in AWS is a hands-on course designed to help you master the fundamentals of Amazon Redshift and cloud-based data warehousing. This course provides practical knowledge to help you build, manage, and optimize data warehouses using AWS services.

Throughout the course, you will explore core AWS data warehousing concepts, work with real-world data, and learn how to use Amazon Redshift for scalable, high-performance analytics. By the end of this course, you will be able to: - Explore and understand the concepts of AWS Services used for Data Warehousing in AWS. - Gain proficiency in creating and managing IAM users and groups, understanding IAM policies and roles, and applying this knowledge in practical, hands-on scenarios. - Differentiate between traditional and cloud storage, operate Simple Storage Service, and understand various storage classes and versioning in AWS S3. - Gain a solid understanding of Amazon Redshift and effectively utilize it for data warehousing needs. - Effectively set up and managed a data warehouse using Amazon Redshift. - Develop a thorough understanding and practical expertise in implementing ETL (Extract, Transform, Load) processes in Amazon Redshift. - Acquire knowledge on monitoring and optimizing the performance of Amazon Redshift environments. This course is designed for Data Engineers, Cloud Solution Architects, Data Analysts, Database Administrators (DBAs), Software Developers, and Engineers seeking to explore the AWS Data Warehouse and its applications. Prior working experience with RDBMS, SQL, and AWS is recommended but optional for this course. Begin an educational journey to learn about the Data Warehouse in AWS and its concepts for handling and analyzing large volumes of data.

Welcome to this module highlighting AWS essentials, encompassing the AWS Free Tier account, AWS Identity and Access Management (IAM), compute services, and storage services. Explore foundational aspects for account security, delve into IAM for access control, and discover compute and storage services for robust cloud solutions.

涵盖的内容

25个视频10篇阅读材料6个作业5个讨论话题2个插件

25个视频总计118分钟

Course Introduction4分钟
Introduction to Cloud Computing8分钟
Cloud Computing Service Models5分钟
Cloud Computing Deployment Models 3分钟
Amazon Web Services and Its Benefits4分钟
Amazon Regions and Availability Zones6分钟
What is a Free Tier Account?5分钟
Signup an AWS Free Tier Account4分钟
Different Amazon Web Services6分钟
Ways to access AWS: CLI, Console, and SDKs3分钟
Identity and Access Management (IAM)4分钟
Concept of Creating and Managing an IAM Users 3分钟
Creating and Managing IAM Users on Management Console5分钟
Create a New IAM User Group5分钟
Creating an IAM Role3分钟
IAM Policies5分钟
Amazon Elastic Compute Cloud (EC2)4分钟
Amazon Machine Image (AMI) and Instance Types4分钟
Security Groups in AWS4分钟
Creating an EC2 instance4分钟
Creating a Custom AMI4分钟
Overview of Simple Storage Service5分钟
Working on S3 and Bucket Policy4分钟
Creation of an S3 Bucket4分钟
Versioning in AWS S33分钟

10篇阅读材料总计55分钟

Course Syllabus: Build a Data Warehouse in AWS5分钟
Data Center and Virtualization5分钟
How to Use Discussion Forums4分钟
Configuration of AWS CLI7分钟
Creating Policies for New Users7分钟
Miscellaneous topics on IAM5分钟
Networking Layer in EC27分钟
Elastic Block Store (EBS)5分钟
Traditional Storage and Cloud Storage5分钟
Summary5分钟

6个作业总计45分钟

Practice Knowledge Check: Introduction to Cloud Computing and AWS5分钟
Practice Knowledge Check: AWS Free Tier Account5分钟
Practice Knowledge Check: Identity and Access Management in AWS5分钟
Practice Knowledge Check: Compute Services in AWS5分钟
Practice Knowledge Check: Storage Services in AWS5分钟
Graded Knowledge Check: Introduction to AWS Services 20分钟

5个讨论话题总计25分钟

How does AWS and cloud computing improve business efficiency? 5分钟
How has AWS Free Tier impacted your cloud experience?5分钟
How does AWS IAM strengthen security? Share best practices for user access in AWS.5分钟
How does EC2's elasticity optimize costs in AWS? 5分钟
What makes Amazon S3 stand out in AWS storage? Discuss its advantages, use cases, and how it addresses common challenges for businesses in the cloud.5分钟

2个插件总计10分钟

Your Baseline Knowledge Checkpoint5分钟
End Module Knowledge Checkpoint5分钟

Welcome to this module, which focuses on AWS networking, databases, SQL overview, and data warehousing introduction. Explore AWS networking concepts, master database solutions on AWS, and grasp SQL fundamentals. Gain insights into data warehousing for efficient data management. Acquire skills to optimize AWS resources, ensuring robust data storage, protection, and sharing strategies.

涵盖的内容

18个视频4篇阅读材料5个作业4个讨论话题1个插件

18个视频总计78分钟

Overview of Virtual Private Cloud (VPC) and its Components6分钟
VPC and Subnets6分钟
Internet Gateways and Route Tables6分钟
Database Services Provided by AWS4分钟
Amazon RDS3分钟
RDS Database Instances3分钟
Identity and Access Management in Amazon RDS3分钟
Creation of RDS4分钟
Introduction to SQL4分钟
DDL Commands3分钟
DQL Commands3分钟
DML Commands3分钟
DCL Commands3分钟
Introduction to Data Warehousing5分钟
Data Warehouse Components3分钟
Data Modeling in Data Warehousing3分钟
ELT Processes in Data Warehousing3分钟
Benefits and Challenges of Data Warehousing4分钟

4篇阅读材料总计25分钟

CIDR, Private vs Public IP5分钟
AWS Networking Terminologies10分钟
TCL Commands5分钟
Summary5分钟

5个作业总计40分钟

Practice Knowledge Check: Networking using AWS5分钟
Practice Knowledge Check: Databases in AWS5分钟
Practice Knowledge Check: Overview of SQL5分钟
Practice Knowledge Check: Introduction to Data Warehousing5分钟
Graded Knowledge Check: Empowering Data Warehousing using SQL and AWS 20分钟

4个讨论话题总计20分钟

Discuss the advantages and challenges of networking on AWS, focusing on key features and best practices for scalability and reliability5分钟
How do AWS databases enhance scalability and performance in cloud applications? Discuss key services and considerations for various use cases5分钟
What are the key principles and functionalities of SQL, and how does it serve as a fundamental tool for managing and manipulating relational databases?5分钟
How does data warehousing contribute to effective decision-making in organizations? Discuss key concepts, benefits, and real-world applications.5分钟

1个插件总计5分钟

End Module Checkpoint5分钟

Welcome to "Getting Started with Amazon Redshift." This course introduces you to Redshift’s features, architecture, and benefits, explores serverless vs. provisioned clusters, and covers key elements like nodes, workgroups, storage, and security. By the end, you’ll gain a solid foundation to apply Amazon Redshift in real-world data warehousing and analytics projects.

涵盖的内容

21个视频3篇阅读材料4个作业3个讨论话题1个插件

21个视频总计107分钟

Introduction to Amazon Redshift7分钟
Features of Amazon Redshift: Key Features and Capabilities4分钟
Features of Amazon Redshift: Price Performance3分钟
Architecture of Redshift Data Warehouse6分钟
Working of Redshift6分钟
Data Processing Flow in Amazon Redshift6分钟
Why use Amazon Redshift: Setup Process3分钟
Why use Amazon Redshift: Better Performance4分钟
Amazon Redshift Serverless7分钟
Amazon Redshift Serverless Architecture5分钟
Amazon Redshift Provisioned Clusters: Introduction4分钟
Amazon Redshift Provisioned Clusters: Key Components3分钟
Amazon Redshift provisioned clusters Architecture: Illustration3分钟
Amazon Redshift provisioned clusters Architecture: Components4分钟
Comparison between Amazon Redshift Serverless and Provisioned Clusters6分钟
Clusters in Redshift5分钟
Nodes in Redshift5分钟
Amazon Redshift Serverless workgroups and namespaces4分钟
Columnar Storage in Amazon Redshift5分钟
Security in Amazon Redshift: Introduction4分钟
Security in Amazon Redshift: Data Encryption3分钟

3篇阅读材料总计25分钟

Benefits and real-life use cases of Amazon Redshift10分钟
Redshift Pricing Model10分钟
Users and Groups in Amazon Redshift5分钟

4个作业总计35分钟

Getting Started with Amazon Redshift5分钟
Classification of Amazon Redshift5分钟
Key Elements in Amazon Redshift5分钟
Fundamentals of Amazon Redshift20分钟

3个讨论话题总计15分钟

Share reasons why organizations might choose Amazon Redshift over other data warehousing solutions.5分钟
Discuss the real-world examples or case studies highlighting the effective use of Amazon Redshift Serverless and Provisioned Clusters.5分钟
Discuss the advantages of columnar storage over traditional row-based storage, especially in terms of query performance and data compression.5分钟

1个插件总计5分钟

End Module Checkpoint5分钟

This module guides you through setting up and managing a data warehouse in Redshift with hands-on practice. You’ll configure AWS Secrets Manager, KMS, and IAM Roles, upload and manage data from S3, and create and query tables using Query Editor v2. The course also covers Redshift Spectrum, ETL processes (including Zero-ETL), performance monitoring, and query optimization. By the end, you’ll gain practical skills to build secure, efficient, and scalable data warehouses in Amazon Redshift.

涵盖的内容

31个视频4篇阅读材料6个作业4个讨论话题1个插件

31个视频总计158分钟

AWS Secrets Manager6分钟
Creating KMS for Redshift Serverless5分钟
IAM Roles Configuration for Redshift Query Editor v24分钟
Creating Data Warehouse in Amazon Redshift5分钟
Creating Data Warehouse in Amazon Redshift: Demonstration9分钟
Uploading Sample Data to S34分钟
Uploading Sample Data to S3: Demonstration3分钟
Create Tables in Query Editor v26分钟
Loading Data from S3 to Amazon Redshift4分钟
Loading Data from S3 to Amazon Redshift: Demonstration4分钟
Running Sample Queries5分钟
Visualizing Queries3分钟
Visualizing Queries Demonstration5分钟
Materialized Views4分钟
Materialized Views Demonstration5分钟
Amazon Redshift Spectrum5分钟
Querying Data using Redshift Spectrum: IAM Role and Cluster Creation3分钟
Querying Data using Redshift Spectrum: Creating External Schema4分钟
Querying Data using Redshift Spectrum Demonstration: IAM Role and Cluster Creation4分钟
Querying Data using Redshift Spectrum Demonstration: Creating External Schema and Tables6分钟
ETL (Extract, Transform and Load): Introduction4分钟
ETL (Extract, Transform and Load): Working of ETL4分钟
Zero-ETL6分钟
Zero-ETL with Amazon Redshift Demonstration: Creating Database and Tables7分钟
Zero-ETL with Amazon Redshift Demonstration: Connecting to Aurora4分钟
Zero-ETL with Amazon Redshift Demonstration: Running Zero-ETL Queries5分钟
Monitoring cluster performance data5分钟
Monitoring query history data3分钟
Monitoring database performance data4分钟
Monitoring workload concurrency and concurrency scaling data4分钟
Course Summary: Build a Data Warehouse in AWS2分钟

4篇阅读材料总计90分钟

Redshift Spectrum Pricing Model10分钟
Considerations when using zero-ETL integrations with Amazon Redshift10分钟
Introduction to Monitoring in Redshift10分钟
Practice Project60分钟

6个作业总计50分钟

Setting up Data Warehouse in Amazon Redshift5分钟
Redshift Spectrum5分钟
ETL in Amazon Redshift5分钟
Monitoring in Amazon Redshift5分钟
Build a Data Warehouse in Amazon Redshift10分钟
Build a Data Warehouse in AWS20分钟

4个讨论话题总计20分钟

Discuss the importance of Key Management Service (KMS) in the context of Redshift Serverless. How does it contribute to data encryption and security in a serverless environment?5分钟
Discuss strategies for optimizing performance when querying data using Redshift Spectrum. How can users fine-tune their queries to achieve faster results? Share your experiences in overcoming performance bottlenecks and ensuring efficient data retrieval.5分钟
Discuss key features of Amazon Redshift that make it suitable for Zero-ETL integrations.5分钟
Explore how monitoring individual queries and loads can contribute to performance tuning and optimization efforts.5分钟

1个插件总计10分钟

End Course Checkpoint10分钟

位教师

Edureka

98 门课程102,796 名学生

提供方

Edureka

从 Cloud Computing 浏览更多内容

状态：免费试用
Packt
AWS Data Processing and Analysis
课程
Amazon Web Services
Data Analytics and Databases on AWS
课程
状态：免费试用
Whizlabs
AWS: Databases
课程
状态：免费试用
Whizlabs
AWS: Data Analytics
课程

人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

自 2018开始学习的学生

''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情，我就可以学习。'

Jennifer J.

自 2020开始学习的学生

''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'

Larry W.

自 2021开始学习的学生

''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'

Chaitanya A.

''学习不仅仅是在工作中做的更好：它远不止于此。Coursera 让我无限制地学习。'

通过 Coursera Plus 开启新生涯

无限制访问 10,000+ 世界一流的课程、实践项目和就业就绪证书课程 - 所有这些都包含在您的订阅中

了解更多

通过在线学位推动您的职业生涯

获取世界一流大学的学位 - 100% 在线

探索学位

加入超过 3400 家选择 Coursera for Business 的全球公司

提升员工的技能，使其在数字经济中脱颖而出

了解更多

常见问题

The AWS Data Warehouse course provides an introduction to various AWS services for managing the data warehouse. This course covers multiple aspects, including important AWS services, SQL, an overview of data warehousing, Redshift's architecture, data modeling, efficient data loading, and optimized querying. The courses emphasize performance optimization, cluster management, monitoring, and security practices for safeguarding sensitive data.

This course is tailored for professionals such as Data Engineers, Cloud Solution Architects, Data Analysts, Database Administrators, Software Developers, and Engineers. It focuses on exploring AWS Data Warehouse and its applications, covering topics like data extraction, transformation, loading, architecture optimization, database management, and integration with AWS services.

While prior experience with RDBMS, SQL, and AWS is recommended for this course, it's optional. The curriculum is designed to accommodate learners with varying levels of familiarity, providing comprehensive modules for those without prior exposure.

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.