К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Snowflake - Build and Architect Data Pipelines Using AWS · LearnSpace
Назад в каталог
courseraIT и технологии

Snowflake - Build and Architect Data Pipelines Using AWS

Курс от Packt
Средний≈ 16.2 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

This course features Coursera Coach! A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. Learn how to design and build robust data pipelines using Snowflake and AWS in this comprehensive course. You will explore Snowflake's architecture, including its virtual warehouses, billing components, and object hierarchy, to fully understand how to leverage this powerful platform. In addition to that, you'll dive into key areas like data ingestion, partitioning, clustering, and performance optimization techniques, while getting hands-on experience with labs to reinforce your learning. By the end of the course, you will be able to create optimized, cost-effective data pipelines that integrate seamlessly with AWS services like S3, Lambda, and Glue. The journey includes building tasks and queries, utilizing streams for real-time data tracking, and understanding how to set up user-defined and external functions. As you progress, you will also explore advanced concepts such as Snowpark for Data Science, streaming with Kafka, and data governance techniques to ensure your data pipeline meets security and compliance standards. This course is designed for those seeking hands-on expertise in building scalable data pipelines using Snowflake and AWS. Whether you're an aspiring data engineer or an experienced professional looking to sharpen your skills, this course will provide you with the tools and knowledge to implement real-world data engineering solutions effectively.

Навыки, которые вы освоите

Snowflake SchemaData PipelinesData GovernanceReal Time DataPerformance TuningApache AirflowPySparkAmazon S3Data SecurityApache KafkaExtract, Transform, LoadStored ProcedureAmazon Web ServicesData Import/ExportData ProcessingData WarehousingRole-Based Access Control (RBAC)SQLData Architecture

Программа курса

14 модулей · 125 учебных материалов

01Introduction to the Course3 материалов

Introduction to the Course

Course RoadmapВидеоPrerequisites and How to Succeed in This CourseВидеоFull Course ResourcesЧтение
02Introduction to Snowflake and AWS11 материалов

Introduction to Snowflake and AWS

Учитесь у экспертов

Packt - Course Instructors

Преподаватель курса

Snowflake - Build and Architect Data Pipelines Using AWS
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 16.2 ч

14 модулей

Язык: Английский

Субтитры: Казахский

Часть программы вашего университета
What Is Data-Warehouse?Видео
Two Aspects of a Data EcosystemВидео
Lab - Set Up Snowflake Trial AccountВидео
Snowflake ArchitectureВидео
Snowflake Object HierarchyВидео
Snowflake - Virtual WarehousesВидео
Snowflake - Different Billing ComponentsВидео
Snowflake - Track Your ConsumptionВидео
Snowflake- Resource MonitorsВидео
Understanding Cloud Data WarehousesDIALOGUE
Introduction to Snowflake and AWS - AssessmentЗадание
03Snowflake - Tables8 материалов

Snowflake - Tables

Introduction - Different Tables in SnowflakeВидеоLab - Create Tables in SnowflakeВидеоSnowflake - Views, Materialized Views and Secure ViewsВидеоLab - Create Views in SnowflakeВидеоLab - Create Secure Views in SnowflakeВидеоMore about Views in SnowflakeВидеоUnderstanding Table Types in SnowflakeDIALOGUESnowflake - Tables - AssessmentЗадание
04Snowflake - Partitioning, Clustering, and Performance Optimization11 материалов

Snowflake - Partitioning, Clustering, and Performance Optimization

Section OverviewВидеоIntroduction to Partitions and Clustering KeysВидеоLab - Micro-Partitions and Clustering KeysВидеоBenefits of Micro-Partitions and ClusteringВидеоUnderstanding Clustering Depth and Cluster OverlapВидеоLab - Selecting Your Clustering KeysВидеоLab - Check Query Profile and HistoryВидеоLab - Query Processing and CachingВидеоSearch Optimization FeatureВидеоExploring Micro-Partitions and Clustering in SnowflakeDIALOGUESnowflake - Partitioning, Clustering, and Performance Optimization - AssessmentЗадание
05Snowflake - Data Loading/Ingestion and Extraction11 материалов

Snowflake - Data Loading/Ingestion and Extraction

Section OverviewВидеоData Ingestion - Real-World Use CasesВидеоLab - Create an Integration Object to Connect Snowflake with AWS S3ВидеоLab - Ingest CSV from S3 to SnowflakeВидеоLab - Ingest JSON from S3 to SnowflakeВидеоIntroduction to Continuous Data Ingestion in SnowflakeВидеоLab - Create and Implement Snow PipeВидеоSnow pipe - Billing Estimation and Key Considerations for Data IngestionВидеоLab - Extracting/Unload Data from Snowflake to S3ВидеоData Ingestion into SnowflakeDIALOGUESnowflake - Data Loading/Ingestion and Extraction - AssessmentЗадание
06Snowflake - Tasks and Query Scheduling6 материалов

Snowflake - Tasks and Query Scheduling

Section OverviewВидеоIntroduction to TasksВидеоLab - Create Standalone and Dependent Tree of TasksВидеоLab - Billing and Query History for TasksВидеоUnderstanding Snowflake Tasks and Task SchedulingDIALOGUESnowflake - Tasks and Query Scheduling - AssessmentЗадание
07Snowflake - Streams and Change Data Capture13 материалов

Snowflake - Streams and Change Data Capture

Section OverviewВидеоIntroduction to StreamsВидеоLab - Implement Standard StreamsВидеоLab - Implement Append-Only StreamsВидеоLab - Streams in a TransactionВидеоStreams - Data Retention and StalenessВидеоLab - Change Tracking Using "Changes"ВидеоProject OverviewВидеоLab - Create Streams - Project SolutionВидеоLab - Create Streams - ContinuationВидеоLab - End-to-End Pipeline in ActionВидеоUnderstanding Streams and Change Data Capture in SnowflakeDIALOGUESnowflake - Streams and Change Data Capture - AssessmentЗадание
08Snowflake - User-Defined Functions9 материалов

Snowflake - User-Defined Functions

Introduction to User-Defined Functions and UDF TypesВидеоLab - Write and Implement a Scalar UDFВидеоLab - Write Tabular UDF in SQLВидеоLab - Implement JavaScript UDFsВидеоWhat Is Pushdown in UDF?ВидеоLab - How Can Pushdown Expose the Underlying Data?ВидеоLab - Write Secure UDFsВидеоExploring User Defined Functions (UDFs) in SnowflakeDIALOGUESnowflake - User-Defined Functions - AssessmentЗадание
09Snowflake - External Functions9 материалов

Snowflake - External Functions

Section OverviewВидеоIntroduction to External FunctionsВидеоLab - Deploy AWS Lambda FunctionВидеоCreate IAM RoleВидеоLab - Create API GatewayВидеоLab - Secure and Deploy API GatewayВидеоLab - Create External Function in SnowflakeВидеоCreating External Functions in Snowflake with AWS IntegrationDIALOGUESnowflake - External Functions - AssessmentЗадание
10Snowflake with Python, Spark, and Airflow on AWS14 материалов

Snowflake with Python, Spark, and Airflow on AWS

Section OverviewВидеоLab - Connect Python with Snowflake in Your Local MachineВидеоIntroduction to AWS GlueВидеоLab - Deploy and Execute Python Script to AWS GlueВидеоLab - Parameterize Your Python Script on AWS GlueВидеоLab - Python Pandas with Snowflake on AWS GlueВидеоWhat Is Pushdown in Spark 3.1?ВидеоLab - Deploy a PySpark Script Using AWS GlueВидеоLab - Set Up Managed Airflow Cluster on AWSВидеоLab - Configure Snowflake Connectivity in AirflowВидеоLab - Deploy a PySpark Transformation job in AWS GlueВидеоLab - Set Up Airflow DAGВидеоUsing Airflow with Snowflake and GlueDIALOGUESnowflake with Python, Spark, and Airflow on AWS - AssessmentЗадание
11Real-Time Streaming with Kafka and Snowflake8 материалов

Real-Time Streaming with Kafka and Snowflake

Section OverviewВидеоLab - Download the Necessary JAR FilesВидеоLab - Set Up Kafka in your local systemВидеоLab - Set Up Kafka Snowflake ConnectorВидеоLab - Set Up Encryption Keys for Kafka-Snowflake ConnectivityВидеоLab - Streaming Data in ActionВидеоKafka and Snowflake Real-time Streaming SetupDIALOGUEReal-Time Streaming with Kafka and Snowflake - AssessmentЗадание
12Snowflake - Data Protection and Governance8 материалов

Snowflake - Data Protection and Governance

Section OverviewВидеоWhat Is Time Travel and Failsafe in Snowflake?ВидеоLab - Time Travel and Data RecoveryВидеоLab - Column Level Dynamic Data MaskingВидеоWhat Is Row Level Security?ВидеоLab - Create and Implement Row Level Access PolicyВидеоUnderstanding Snowflake Time Travel and Data MaskingDIALOGUESnowflake - Data Protection and Governance - AssessmentЗадание
13Snowpark - For Data Pipelines and Data Science11 материалов

Snowpark - For Data Pipelines and Data Science

Introduction - What Is Snowpark?ВидеоLab - Getting Started with SnowparkВидеоOverview - UDFs and Store ProceduresВидеоLab - Deploy Python UDFsВидеоLab - Deploy Stored Procedures for ETL Batch ProcessingВидеоData Science - Use Case Overview and Data PreparationВидеоLab - Deploy Model - Training Code for Scikit-Learn Using Stored ProceduresВидеоLab - Deploy Model Serving/Prediction Serving Pipeline Using UDFsВидеоMore Learning Reference and Coupon CodeВидеоExploring Snowpark for Data PipelinesDIALOGUESnowpark - For Data Pipelines and Data Science - AssessmentЗадание
14Wrap Up and More Learning3 материалов

Wrap Up and More Learning

More Updates and What's NextВидеоFull Course Practice AssessmentЗаданиеFull Course AssessmentЗадание