Matillion Masterclass

Matillion Masterclass, available at $44.99, has an average rating of 4.35, with 54 lectures, 4 quizzes, based on 33 reviews, and has 158 subscribers.

You will learn about Matillion and various product offering How Matillion fits in cloud ETL landscape Matillion component practicals in-depth Cloud DWH Project using Matillion as ETL Tool and example of SCD2 Helpful in Matillion Associate Certification Journey This course is ideal for individuals who are Data Engineer and Analyst who wish to understand Matillion in-depth and progress toward Matillion Certification It is particularly useful for Data Engineer and Analyst who wish to understand Matillion in-depth and progress toward Matillion Certification.

Enroll now: Matillion Masterclass

Summary

Title: Matillion Masterclass

Price: $44.99

Average Rating: 4.35

Number of Lectures: 54

Number of Quizzes: 4

Number of Published Lectures: 54

Number of Published Quizzes: 4

Number of Curriculum Items: 58

Number of Published Curriculum Objects: 58

Original Price: £54.99

Quality Status: approved

Status: Live

What You Will Learn

Matillion and various product offering
How Matillion fits in cloud ETL landscape
Matillion component practicals in-depth
Cloud DWH Project using Matillion as ETL Tool and example of SCD2
Helpful in Matillion Associate Certification Journey

Who Should Attend

Data Engineer and Analyst who wish to understand Matillion in-depth and progress toward Matillion Certification

Target Audiences

Data Engineer and Analyst who wish to understand Matillion in-depth and progress toward Matillion Certification

Matillion is a cloud-native data integration platform that enables organizations to extract, load and transform (ELT) data from various sources into their data warehouses, such as Amazon Redshift, Google BigQuery, and Snowflake. It is designed to help businesses accelerate their data integration processes and achieve faster time-to-insight. Matillion provides a visual, drag-and-drop interface that allows users to easily create ETL pipelines without writing any code. It also offers a range of pre-built connectors for popular data sources, including Salesforce, Google Analytics, and Facebook Ads. Matillion is a popular choice among data engineers, data analysts, and other data professionals looking to streamline their data integration workflows and increase their data agility. Its performance and integration options makes it a very popular amongst enterprises.

This course is intended for Data Engineers, ETL Engineers, Data Analyst and anyone with willingness to learn Matillion and though we tried to keep it simple as possible, you might require some basic knowledge of ETL, AWS, Snowflake.

In this course, Matillion Masterclass, you will learn the architecture of Matillion with in-depth hands-on exercise. When you have finished the course, you will have the skills and knowledge to work on Matillion and will assist you in your journey towards Matillion Associate Certification.

Course Curriculum

Chapter 1: Section 1 : Introduction

Lecture 1: Course Introduction

Lecture 2: Know your Instructor

Lecture 3: Course Download

Chapter 2: Section 2 : Matillion Overview and Architecture

Lecture 1: Matillion Overview

Lecture 2: What is ETL & ETL ?

Lecture 3: Matillion Product Offerings

Lecture 4: Matillion Competitors

Lecture 5: Matillion Architecture

Chapter 3: Initial Setup – Labs

Lecture 1: Create Free AWS Account

Lecture 2: Create Snowflake Account

Lecture 3: Create MS Azure Account

Lecture 4: MS Azure – Source SQL DB Setup

Lecture 5: Matillion Hub Account Creation

Lecture 6: Matillion Instance Setup

Lecture 7: Matillion Project Config

Lecture 8: Datwarehouse Setup

Chapter 4: Matillion Data Loader

Lecture 1: What is Matillion Data Loader or MDL ?

Lecture 2: Navigate to MDL

Lecture 3: Initial Load with Matillion Data Loader

Chapter 5: Matillion UI

Lecture 1: Matillion UI Overview

Lecture 2: Project Menu

Lecture 3: Admin Menu

Lecture 4: Certification Centric Summary – Matillion UI

Chapter 6: Variable

Lecture 1: What are Variables and Type of Variable in Matillion?

Lecture 2: Job Variable

Lecture 3: Environment Variable

Lecture 4: Grid Variable

Lecture 5: Automatic Variable

Chapter 7: Matillion Job

Lecture 1: Matillion Job and Job Types

Lecture 2: Orchestration Job and Components

Lecture 3: Transformation Job

Lecture 4: Transformation Job – Set operation

Lecture 5: Shared Job

Lecture 6: Load S3 Flat Files

Lecture 7: DDL Component Lab

Lecture 8: AWS Component Lab

Lecture 9: Load via API Component

Lecture 10: Flow Component Lab

Lecture 11: Load from Gmail

Lecture 12: Fixed Iterator

Lecture 13: Loop Iterator

Lecture 14: Table Iterator

Lecture 15: File Iterator

Lecture 16: Trasaction Component

Lecture 17: Snowflake Component

Lecture 18: Notification

Lecture 19: Error Log

Lecture 20: Data Transfer Component

Lecture 21: Certification Centric Summary – Orchestration and Transformation Job

Chapter 8: Dimension SCD Type 2 in Matillion

Lecture 1: SCD Type 2 Dimension using Matillion

Chapter 9: Building a Datawarehouse in Matillion and Snowflake

Lecture 1: Setup Source DB on Azure and create warehouse framework

Chapter 10: Matillion for Amazon Redshift

Lecture 1: What is Amazon Redshift

Lecture 2: Redshift as Matillion Destination warehouse

Chapter 11: Best Practises Matillion – What’s News ?

Lecture 1: What are Matillion Best Practise ?

Instructors

Ankit Joshi
Architect

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 7 votes
4 stars: 10 votes
5 stars: 15 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu