Stitch ETL - A Simple, Extensible ETL Built For Data Teams

What you'll learn
Stitch ETL from scratch
Data Migration
Data Replication
Streaming Data Pipeline
Requirements
No programming experience required. Basic understanding of ETL/ELT and Cloud Architecture is an advantage, but not mandatory
Description
The course is about Stitch, a product owned by Talend.What is Stitch?Stitch is a cloud-first, open source platform for rapidly moving data. A simple, powerful ETL service, Stitch connects to various data sources and replicates that data to a destination.• Stitch helps you replicate data into cloud data warehouses• Stitch rapidly moves data from 130+ sources into a cloud data warehouse with no coding• Stitch is Simple, extensible ETL built for data teamsThis course starts with,• Introduction of Stitch• Signing up with Stitch• Creating sources of AWS S3, AWS RDS PostgreSql• Creating the targets of Snowflake, AWS S3 and AWS RDS PostgreSql• Replicate the data from source to targetIt enables to,• Extract data from various sources• Load into the leading cloud data platforms• Analyze the data with the leading BI toolsReplicationStitch's replication process consists of three distinct phases:Extract: Stitch pulls data from your data sources and persists it to Stitch's data pipeline through the Import API.Prepare: Data is lightly transformed to ensure compatibility with the destination.Load: Stitch loads the data into your destination.A single occurrence of these three phases is called a replication job. You can keep an eye on a replication job's progress on any integration's Summary page.Stitch integrated with the target systems such as,• Amazon Redshift• AWS S3• Delta Lake on Databricks• Google BigQuery• Microsoft Azure Synapse Analytics• Microsoft SQL Server• Panoply• PostgreSQL• SnowflakeThis course is for,• ETL Developers• Data Engineers• Data Architects• Data Migration Specialists• Data Integration Specialists
Overview
Section 1: Introduction
Lecture 1 About the Course
Lecture 2 Introduction
Section 2: Signing Up
Lecture 3 Sign Up
Section 3: Integration
Lecture 4 AWS S3 Integration
Lecture 5 PostgreSql Integration
Section 4: Destination
Lecture 6 Snowflake Destination
Lecture 7 AWS S3 Destination
Lecture 8 PostgreSql Destination
Section 5: Replication
Lecture 9 AWS S3 to Snowflake
Lecture 10 AWS S3 to AWS S3
ETL Developers,Data Migration specialists,Data Engineers,Data Architects,Database Administrators

Homepage

https://www.udemy.com/course/stitch-etl/