Learn Matillion Etl - Cloud Native Data Integration Platform
Learn Matillion Etl - Cloud Native Data Integration Platform
Published 6/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.49 GB | Duration: 3h 1m
Learn Matillion ETL integrating with AWS Redshift
What you'll learn
Matillion ETL
Matillion ETL Data Integration Process
Cloud Data Integration
Redshift Integration
Requirements
No programming experience required. Good to have basic ETL knowledge
Description
Modern cloud-native ETL platform Matillion extracts your data, loads it into your cloud data warehouse (CDW), then uses the power and flexibility of your CDW or Delta Lake to transform your data into meaningful business insights.Matillion ETL is an ETL/ELT tool built specifically for cloud database platforms including Amazon Redshift, Google BigQuery, Snowflake and Azure Synapse. It is a modern, browser-based UI, with powerful, push-down ETL/ELT functionality. With a fast setup, you are up and running in minutes.Unlocks the power of your data warehouse: Matillion ETL pushes down data transformations to your data warehouse. Process millions of rows in seconds, with real-time feedback.Modern, beautiful, browser-based environment: including collaboration, version control, full-featured graphical job development, and more than 20 data read, write, join, and transform components.Fast setup: Launch and be developing ETL jobs within minutes.To get started with Matillion ETL, you will need to decide which version and instance type of Matillion ETL is best for you. The instance type you select affects the maximum number of concurrent users who can access Matillion ETL and the maximum number of environments you can connect to.Once you have launched Matillion ETL, you should be able to connect and start creating workflows in minutes
Overview
Section 1: Introduction
Lecture 1 What will you Learn?
Lecture 2 Matillion - Navigating through the Console and Properties
Lecture 3 Configuring Matillion ETL instance in AWS
Lecture 4 Creating First Job in Matillion
Section 2: Working with Read & Write Components
Lecture 5 Fixed Flow
Lecture 6 Multi Table Input
Lecture 7 Table Delete Row
Lecture 8 Table Update - Delete/Insert
Lecture 9 Table Update - Update/Insert
Lecture 10 Rewrite Table
Lecture 11 Create View
Section 3: Transform
Lecture 12 Calculator
Lecture 13 Aggregate
Lecture 14 Detect Changes
Lecture 15 Distinct
Lecture 16 Filter
Lecture 17 First/Last
Lecture 18 Lead/Lag
Lecture 19 Map Values
Lecture 20 Rank
Lecture 21 Rename
Lecture 22 Replicate
Lecture 23 Sql
Lecture 24 Transpose Row
Section 4: Join
Lecture 25 Except
Lecture 26 Intersect
Lecture 27 Join
Lecture 28 Join Multiple
Lecture 29 Self Join - Method1
Lecture 30 Self Join - Method2
Lecture 31 Cartesian Join
Lecture 32 Unite
Section 5: Orchestration
Lecture 33 Overview
Lecture 34 Orchestration Job
ETL Developers,ETL Architects,Data Integration Specialists,Cloud Data Engineers,Data Engineers,Data Warehouse Developers
![Learn Matillion Etl - Cloud Native Data Integration Platform]()
What you'll learn
Matillion ETL
Matillion ETL Data Integration Process
Cloud Data Integration
Redshift Integration
Requirements
No programming experience required. Good to have basic ETL knowledge
Description
Modern cloud-native ETL platform Matillion extracts your data, loads it into your cloud data warehouse (CDW), then uses the power and flexibility of your CDW or Delta Lake to transform your data into meaningful business insights.Matillion ETL is an ETL/ELT tool built specifically for cloud database platforms including Amazon Redshift, Google BigQuery, Snowflake and Azure Synapse. It is a modern, browser-based UI, with powerful, push-down ETL/ELT functionality. With a fast setup, you are up and running in minutes.Unlocks the power of your data warehouse: Matillion ETL pushes down data transformations to your data warehouse. Process millions of rows in seconds, with real-time feedback.Modern, beautiful, browser-based environment: including collaboration, version control, full-featured graphical job development, and more than 20 data read, write, join, and transform components.Fast setup: Launch and be developing ETL jobs within minutes.To get started with Matillion ETL, you will need to decide which version and instance type of Matillion ETL is best for you. The instance type you select affects the maximum number of concurrent users who can access Matillion ETL and the maximum number of environments you can connect to.Once you have launched Matillion ETL, you should be able to connect and start creating workflows in minutes
Overview
Section 1: Introduction
Lecture 1 What will you Learn?
Lecture 2 Matillion - Navigating through the Console and Properties
Lecture 3 Configuring Matillion ETL instance in AWS
Lecture 4 Creating First Job in Matillion
Section 2: Working with Read & Write Components
Lecture 5 Fixed Flow
Lecture 6 Multi Table Input
Lecture 7 Table Delete Row
Lecture 8 Table Update - Delete/Insert
Lecture 9 Table Update - Update/Insert
Lecture 10 Rewrite Table
Lecture 11 Create View
Section 3: Transform
Lecture 12 Calculator
Lecture 13 Aggregate
Lecture 14 Detect Changes
Lecture 15 Distinct
Lecture 16 Filter
Lecture 17 First/Last
Lecture 18 Lead/Lag
Lecture 19 Map Values
Lecture 20 Rank
Lecture 21 Rename
Lecture 22 Replicate
Lecture 23 Sql
Lecture 24 Transpose Row
Section 4: Join
Lecture 25 Except
Lecture 26 Intersect
Lecture 27 Join
Lecture 28 Join Multiple
Lecture 29 Self Join - Method1
Lecture 30 Self Join - Method2
Lecture 31 Cartesian Join
Lecture 32 Unite
Section 5: Orchestration
Lecture 33 Overview
Lecture 34 Orchestration Job
ETL Developers,ETL Architects,Data Integration Specialists,Cloud Data Engineers,Data Engineers,Data Warehouse Developers
