Tutorialspoint

Snowflake - Architect Datawarehouse and Datalake solutions using AWS

Data engineering and architecting pipelines using snowflake & AWS cloud

Course Description

Snowflake is the next big thing and it is becoming a full blown data eco-system . With the level of scalability & efficiency in handling massive volumes of data and also with a number of new concepts in it, this is the right time to wrap your head around Snowflake and have it in your toolkit. This course not only covers the core features of Snowflake but also teaches you how to deploy python/pyspark jobs in AWS Glue and Airflow that communicate with Snowflake, which is one of the most important aspects of building pipelines. 

Anyone who has a basic understanding of the cloud and belongs to one of the below backgrounds can benefit from this course :

  • Data Scientists / Analysts 
  • Data Engineers / Software Developers 
  • SQL Programmers or DBA's 
  • Aspiring Data analysts and scientists who are learning SQL and Python

This course covers :

  • What is Snowflake 

  • Most Crucial Aspects of Snowflake in a very practical manner 

  • Writing Python/Spark Jobs in AWS Glue Jobs for data transformation

  • Real Time Streaming using Kafka and Snowflake 

  • Interacting with External Functions & use cases

  • Security Features in Snowflake 

Prerequisites for this course are : 

  • Knowing SQL or at least some prior knowledge in writing queries 

  • Scripting in Python (or any language )

  • Willingness to explore ,learn and put in the extra effort to succeed 

  • An active AWS Account & know-how of basic cloud fundamentals 

Important Note -  You need to have an active AWS Account in order to perform tasks in sections related to Python and PySpark . This course will help you with Snowpro certifications as well 

Goals

  • Snowflake as a data-warehouse & automated pipelines within snowflake ecosystem
  • Use AWS Cloud with Snowflake as a Data-warehouse/Datalake
  • Integrating real time Streaming Data and Data orchestration with Airflow and Snowflake
  • Enough Knowledge to clear SnowPro Certification

Prerequisites

  • Prior programming experience in Sql and python is a must .
  • Prior basic experience or understanding of cloud services like AWS is important
Show More

Curriculum

  • Course Roadmap
    02:54
    Preview
  • Prerequisites and How to Success in this course
    02:51
  • Repo for the Course
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Feedbacks
  • No Feedbacks Posted Yet..!
Snowflake - Architect Datawarehouse and Datalake solutions using AWS
This Course Includes
  • 8.5 hours
  • 97 Lectures
  • 12 Resources
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

sample certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate

Talk to us

1800-202-0515