Requirements

Basic understanding about ETL and Basic SQL will be useful, but not necessary.

I will take you through everything necessary to learn this course.

Description

Welcome to Fivetran Bootcamp! Fivetran helps you centralize data from disparate sources which you can manage directly from your browser. In this course you will learn to extract your data and load it into your data destination. This course will help you in preparing and mastering your Fivetran ETL tool concepts.

Highlights of the Course:

• Designed to keep only précised information no beating around the bush.

• Real-time implementation, learn with Practical.

• It will help you to showcase your experience in interviews and discussions.

• Involve complex architecture solution which is aligned with industry best practices.

• Added the Best Practices to be used with Fivetran

Topics Covered in the Course:

• What is a data pipeline

• What is ETL

• Challenges in the traditional ETL

• what is Fivetran

• Create A Free Account

• Fivetran plans

• Fivetran types of destinations

• Types of Accounts and Create Managed destination

• Create Snowflake Free Trial Account

• Create Redshift Cluster

• set up Redshift destination

• set up snowflake destination

• Fivetran and DBT set up

• what is Transformation

• Fivetran Data Transformations

• Fivetran Acrhitecture

• Fivetran: Account Management Overview

Fivetran helps you centralize data from disparate sources which you can manage directly from your browser. We extract your data and load it into your data destination. If you already have an account, setup takes anywhere from 5 minutes to 2 hours (depending on the complexity of your internal firewalls and integration setups). The first step is to connect a data warehouse. After that, you'll be taken to the Dashboard, where you can add new connectors. Adding a new connector will lead you to the setup page with detailed notes on the screen and verification for the configuration. Once your first connector is created, it will begin syncing immediately and once that is done you can start using that data in your data warehouse. You can add as many connectors as needed to complete your initial setup.

Who this course is for:

• Data engineering Professionals

• University students looking for a career in Data Engineering

• IT developers working on other disciplines trying to move to Data Engineering

• Data Engineers/ Data Warehouse Developers currently working on on-premises technologies, or other cloud platforms such as AWS or GCP who want to learn Azure Technologies

• Data Architects looking to gain an understanding about cloud based ETL tool

• Data Scientists who want to extend their knowledge into data engineering