Snowflake - Architect Datawarehouse and Datalake solutions using AWS
Data engineering and architecting pipelines using snowflake & AWS cloud
Data & Analytics,Data Warehousing,Snowflake,Data Science and AI ML
Lectures -97
Resources -12
Duration -8.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
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
![Snowflake - Architect Datawarehouse and Datalake solutions using AWS Snowflake - Architect Datawarehouse and Datalake solutions using AWS](https://d3mxt5v3yxgcsr.cloudfront.net/courses/15250/course_15250_image.png)
Curriculum
Check out the detailed breakdown of what’s inside the course
Course Introduction
3 Lectures
-
Course Roadmap 02:54 02:54
-
Prerequisites and How to Success in this course 02:51 02:51
-
Repo for the Course
Introduction to Snowflake and AWS
9 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Snowflake - Tables
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Snowflake - Partitioning , Clustering and Performance Optimization
9 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Snowflake - Data Loading/Ingestion and Extraction
9 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Snowflake - Tasks and Query Scheduling
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Snowflake - Streams and Change Data Capture
11 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Snowflake - User Defined Functions
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Snowflake - External Functions
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Snowflake with Python,Spark and Airflow on AWS
12 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Real Time Streaming with Kafka and Snowflake
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Snowpark - For Data Pipelines and Data Science
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Snowflake - Data Protection and Governance
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![siddharth raghunath](https://www.tutorialspoint.com/assets/profiles/650200/profile/200_1787469-1693479332.jpg)
siddharth raghunath
I am a Business oriented Data Architect with a vast experience in the field of Software Development,Distributed processing and data engineering on cloud . I have worked on different cloud platforms such as AWS & GCP and also with on-prem hadoop clusters. I also give seminars on Distributed processing using Spark , real time streaming and analytics and best practices for ETL and data governance.I am also a passionate coder ,love writing and building optimal data pipelines for robust data processing and streaming solutions .
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)