What is the Difference between a Data Lake and a Data Warehouse?

Contents

SAA-C03 Introduction
RDS vs. EC2
4
RDS vs. EC2
PREVIEW9m 33s
DynamoDB
11
Amazon DynamoDB
PREVIEW9m 43s
DynamoDB Accelerator
SAA-C03 Review
Start course
Difficulty
Beginner
Duration
2h 52m
Students
2282
Ratings
4.8/5
starstarstarstarstar-half
Description

This section of the Solution Architect Associate learning path introduces you to the AWS database services relevant to the SAA-C03 exam. We then understand the service options available and learn how to select and apply AWS database services to meet specific design scenarios relevant to the Solution Architect Associate exam. 

Want more? Try a lab playground or do a Lab Challenge

Learning Objectives

  • Understand the various database services that can be used when building cloud solutions on AWS
  • Learn how to build databases using Amazon RDS, DynamoDB, Redshift, DocumentDB, Keyspaces, and QLDB
  • Learn how to create Elasticache and Neptune clusters
  • Understand AWS database costs
  • Learn about data lakes and how to build a data lake in AWS
Transcript

What is the difference between a data lake and a data warehouse?

When first getting into this space there might be some confusion between data lakes and data warehouses. That is fairly common.

The main difference between a data lake and a data warehouse is specificity and structure. 

A data lake is a formless blob of information, it is a pool of knowledge where we try to capture any relevant data from our business so that we can perform analytics on it.

A data warehouse is a specialized tool that allows you to perform analysis on a portion of that data, so you can make meaningful decisions from it. Generally, it is a subset of the data from the data lake with a specialized purpose. Your data warehouse Is an optimized database that is dealing with normalized, transformed, and cleaned-up versions of the data from the data lake.

 

About the Author
Students
218516
Labs
1
Courses
214
Learning Paths
174

Stuart has been working within the IT industry for two decades covering a huge range of topic areas and technologies, from data center and network infrastructure design, to cloud architecture and implementation.

To date, Stuart has created 150+ courses relating to Cloud reaching over 180,000 students, mostly within the AWS category and with a heavy focus on security and compliance.

Stuart is a member of the AWS Community Builders Program for his contributions towards AWS.

He is AWS certified and accredited in addition to being a published author covering topics across the AWS landscape.

In January 2016 Stuart was awarded ‘Expert of the Year Award 2015’ from Experts Exchange for his knowledge share within cloud services to the community.

Stuart enjoys writing about cloud technologies and you will find many of his articles within our blog pages.