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.
Build a Data Warehouse in AWS
通过 Coursera Plus 提高技能，仅需 239 美元/年（原价 399 美元）。立即节省
深入了解一个主题并学习基础知识。
中级 等级
推荐体验
推荐体验
中级
Prior working experience with RDBMS, SQL, and AWS is recommended but optional for this course.
2 周 完成
在 10 小时 一周
灵活的计划
自行安排学习进度
深入了解一个主题并学习基础知识。
中级 等级
推荐体验
推荐体验
中级
Prior working experience with RDBMS, SQL, and AWS is recommended but optional for this course.
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）
了解顶级公司的员工如何掌握热门技能
该课程共有4个模块
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个讨论话题
25个视频•总计119分钟
- Course Introduction•4分钟
- Introduction to Cloud Computing•8分钟
- Cloud Computing Service Models•6分钟
- Cloud Computing Deployment Models •4分钟
- Amazon Web Services and Its Benefits•4分钟
- Amazon Regions and Availability Zones•7分钟
- What is a Free Tier Account?•5分钟
- Signup an AWS Free Tier Account•4分钟
- Different Amazon Web Services•6分钟
- Ways to access AWS: CLI, Console, and SDKs•4分钟
- Identity and Access Management (IAM)•5分钟
- Concept of Creating and Managing an IAM Users •3分钟
- Creating and Managing IAM Users on Management Console•5分钟
- Create a New IAM User Group•5分钟
- Creating an IAM Role•4分钟
- IAM Policies•5分钟
- Amazon Elastic Compute Cloud (EC2)•4分钟
- Amazon Machine Image (AMI) and Instance Types•5分钟
- Security Groups in AWS•5分钟
- Creating an EC2 instance•4分钟
- Creating a Custom AMI•4分钟
- Overview of Simple Storage Service•5分钟
- Working on S3 and Bucket Policy•4分钟
- Creation of an S3 Bucket•4分钟
- Versioning in AWS S3•4分钟
10篇阅读材料•总计55分钟
- Course Syllabus: Build a Data Warehouse in AWS•5分钟
- Data Center and Virtualization•5分钟
- How to Use Discussion Forums•4分钟
- Configuration of AWS CLI•7分钟
- Creating Policies for New Users•7分钟
- Miscellaneous topics on IAM•5分钟
- Networking Layer in EC2•7分钟
- Elastic Block Store (EBS)•5分钟
- Traditional Storage and Cloud Storage•5分钟
- Summary•5分钟
6个作业•总计45分钟
- Practice Knowledge Check: Introduction to Cloud Computing and AWS•5分钟
- Practice Knowledge Check: AWS Free Tier Account•5分钟
- Practice Knowledge Check: Identity and Access Management in AWS•5分钟
- Practice Knowledge Check: Compute Services in AWS•5分钟
- Practice Knowledge Check: Storage Services in AWS•5分钟
- 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分钟
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个讨论话题
18个视频•总计79分钟
- Overview of Virtual Private Cloud (VPC) and its Components•6分钟
- VPC and Subnets•6分钟
- Internet Gateways and Route Tables•6分钟
- Database Services Provided by AWS•4分钟
- Amazon RDS•4分钟
- RDS Database Instances•4分钟
- Identity and Access Management in Amazon RDS•3分钟
- Creation of RDS•5分钟
- Introduction to SQL•4分钟
- DDL Commands•4分钟
- DQL Commands•4分钟
- DML Commands•3分钟
- DCL Commands•4分钟
- Introduction to Data Warehousing•5分钟
- Data Warehouse Components•3分钟
- Data Modeling in Data Warehousing•3分钟
- ELT Processes in Data Warehousing•4分钟
- Benefits and Challenges of Data Warehousing•5分钟
4篇阅读材料•总计25分钟
- CIDR, Private vs Public IP•5分钟
- AWS Networking Terminologies•10分钟
- TCL Commands•5分钟
- Summary•5分钟
5个作业•总计40分钟
- Practice Knowledge Check: Networking using AWS•5分钟
- Practice Knowledge Check: Databases in AWS•5分钟
- Practice Knowledge Check: Overview of SQL•5分钟
- Practice Knowledge Check: Introduction to Data Warehousing•5分钟
- 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 reliability•5分钟
- How do AWS databases enhance scalability and performance in cloud applications? Discuss key services and considerations for various use cases•5分钟
- 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分钟
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个讨论话题
21个视频•总计107分钟
- Introduction to Amazon Redshift•7分钟
- Features of Amazon Redshift: Key Features and Capabilities•5分钟
- Features of Amazon Redshift: Price Performance•3分钟
- Architecture of Redshift Data Warehouse•6分钟
- Working of Redshift•7分钟
- Data Processing Flow in Amazon Redshift•7分钟
- Why use Amazon Redshift: Setup Process•4分钟
- Why use Amazon Redshift: Better Performance•4分钟
- Amazon Redshift Serverless•7分钟
- Amazon Redshift Serverless Architecture•6分钟
- Amazon Redshift Provisioned Clusters: Introduction•4分钟
- Amazon Redshift Provisioned Clusters: Key Components•4分钟
- Amazon Redshift provisioned clusters Architecture: Illustration•3分钟
- Amazon Redshift provisioned clusters Architecture: Components•4分钟
- Comparison between Amazon Redshift Serverless and Provisioned Clusters•7分钟
- Clusters in Redshift•6分钟
- Nodes in Redshift•6分钟
- Amazon Redshift Serverless workgroups and namespaces•4分钟
- Columnar Storage in Amazon Redshift•5分钟
- Security in Amazon Redshift: Introduction•4分钟
- Security in Amazon Redshift: Data Encryption•4分钟
3篇阅读材料•总计25分钟
- Benefits and real-life use cases of Amazon Redshift•10分钟
- Redshift Pricing Model•10分钟
- Users and Groups in Amazon Redshift•5分钟
4个作业•总计35分钟
- Getting Started with Amazon Redshift•5分钟
- Classification of Amazon Redshift•5分钟
- Key Elements in Amazon Redshift•5分钟
- Fundamentals of Amazon Redshift•20分钟
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分钟
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个讨论话题
31个视频•总计159分钟
- AWS Secrets Manager•7分钟
- Creating KMS for Redshift Serverless•5分钟
- IAM Roles Configuration for Redshift Query Editor v2•5分钟
- Creating Data Warehouse in Amazon Redshift•5分钟
- Creating Data Warehouse in Amazon Redshift: Demonstration•9分钟
- Uploading Sample Data to S3•4分钟
- Uploading Sample Data to S3: Demonstration•4分钟
- Create Tables in Query Editor v2•7分钟
- Loading Data from S3 to Amazon Redshift•5分钟
- Loading Data from S3 to Amazon Redshift: Demonstration•5分钟
- Running Sample Queries•5分钟
- Visualizing Queries•3分钟
- Visualizing Queries Demonstration•6分钟
- Materialized Views•4分钟
- Materialized Views Demonstration•6分钟
- Amazon Redshift Spectrum•6分钟
- Querying Data using Redshift Spectrum: IAM Role and Cluster Creation•4分钟
- Querying Data using Redshift Spectrum: Creating External Schema•4分钟
- Querying Data using Redshift Spectrum Demonstration: IAM Role and Cluster Creation•5分钟
- Querying Data using Redshift Spectrum Demonstration: Creating External Schema and Tables•6分钟
- ETL (Extract, Transform and Load): Introduction•4分钟
- ETL (Extract, Transform and Load): Working of ETL•4分钟
- Zero-ETL•7分钟
- Zero-ETL with Amazon Redshift Demonstration: Creating Database and Tables•7分钟
- Zero-ETL with Amazon Redshift Demonstration: Connecting to Aurora•5分钟
- Zero-ETL with Amazon Redshift Demonstration: Running Zero-ETL Queries•6分钟
- Monitoring cluster performance data•5分钟
- Monitoring query history data•4分钟
- Monitoring database performance data•5分钟
- Monitoring workload concurrency and concurrency scaling data•5分钟
- Course Summary: Build a Data Warehouse in AWS•2分钟
4篇阅读材料•总计90分钟
- Redshift Spectrum Pricing Model•10分钟
- Considerations when using zero-ETL integrations with Amazon Redshift•10分钟
- Introduction to Monitoring in Redshift•10分钟
- Practice Project•60分钟
6个作业•总计50分钟
- Setting up Data Warehouse in Amazon Redshift•5分钟
- Redshift Spectrum•5分钟
- ETL in Amazon Redshift•5分钟
- Monitoring in Amazon Redshift•5分钟
- Build a Data Warehouse in Amazon Redshift•10分钟
- Build a Data Warehouse in AWS•20分钟
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分钟
位教师
提供方
提供方
Edureka
Edureka is an online education platform focused on delivering high-quality learning to working professionals. We have the highest course completion rate in the industry and we strive to create an online ecosystem for our global learners to equip themselves with industry-relevant skills in today’s cutting edge technologies.
从 Cloud Computing 浏览更多内容
状态：免费试用免费试用WWhizlabs
课程
状态：免费试用免费试用
状态：免费试用免费试用AAmazon Web Services
课程
AAmazon Web Services
课程
人们为什么选择 Coursera 来帮助自己实现职业发展
Felipe M.
自 2018开始学习的学生
''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情，我就可以学习。'
Jennifer J.
自 2020开始学习的学生
''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'
Larry W.
自 2021开始学习的学生
''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'
Chaitanya A.
''学习不仅仅是在工作中做的更好：它远不止于此。Coursera 让我无限制地学习。'
常见问题
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.
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.
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.
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.
You’ll learn how to create, configure, and scale Redshift clusters, exploring node types and workload management.
Yes, Redshift Spectrum and S3 integration are demonstrated for querying external data directly.
Yes, you’ll configure IAM roles, encryption, and access controls to secure your warehouse.
Yes, cost tracking and optimization strategies are included to help you manage Redshift spend.
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.
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.
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.
更多问题
提供助学金，