Snowflake Database - The Modern Data Lake

See how Snowflake can become your new modern data lake along with your data warehouse and everything else

What you'll learn
How Snowflake Can Replace the Traditional Data Lake
How Snowflake Can Supplement the Traditional Data Lake
How Snowflake Can Act as a Query Engine for Your Data Lake
History of Data Lakes
Data Lake vs. Data Warehouse
How Data Lakes Become Data Swamps
Case Studies of Companies Making the Transition from Data Lakes to Snowflake
Requirements
Some basic knowledge of Snowflake would be useful
Description
The failure rate on big data traditional data lake projects is between 60% and 80%. Hadoop was billed as the platform to store and analyze data. It promised to minimize data silos with the concept of a Data Lake. But, Hadoop has largely failed in its ability to consider the operational side of data and what it takes to actually run a business. Big data systems like Hadoop are complex and require teams of expensive engineers to build and maintain them. This course shows how Snowflake changes all this. Snowflake is the complete modern cloud based data platform that can integrate with, or completely replace your data lake. This course shows how this is made possible. We do an in-depth discussion of the history of data lakes and the architecture of the modern on-premises or cloud-based data lake. We talk about what's good about data lakes and what's bad about them. We talk about data lakes becoming data swamps. Most importantly, we discuss how Snowflake can completely replace the traditional data lake and be your single repository for corporate data.Finally we present three case studies of companies that tried to make the traditional on-premises (or cloud-based) data lake architecture work for them and finally scrapped it and settled on Snowflake. We wrap up the course with some questions to test your knowledge of the material.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Traditional Data Lakes

Lecture 2 Overview

Lecture 3 History of the Data Lake

Lecture 4 The Problems (Hadoop)

Lecture 5 Data Lakes and Data Warehouses

Lecture 6 The Data Swamp

Section 3: The Cloud Data Platform

Lecture 7 A Better Approach - Overview

Lecture 8 Steps to Implementing

Lecture 9 Introducing Snowflake

Lecture 10 Snowflake Overview

Lecture 11 Snowflake High-level Architecture

Lecture 12 Creating a Demo Snowflake Account

Lecture 13 The Snowflake Web UI

Section 4: Snowflake Database as a Data Lake

Lecture 14 Snowflake vs Data Lakes - A Comparison

Lecture 15 Traditional Data Lake Architecture

Lecture 16 Snowflake Data Lake Architecture

Lecture 17 Snowflake Data Lake Demo

Section 5: Case Studies

Lecture 18 Devon Energy

Lecture 19 Portland Gas and Electric

Lecture 20 Chesapeake Energy

Section 6: Time to Test Your Knowledge

Lecture 21 Questions to Test Your Knowledge

Snowflake developers, Snowflake Architects and Snowflake Administrators