Learn Xplenty - A Cloud Based Data Integration Platform

Learn Xplenty a cloud based ETL Tool, its transformations and the advanced configurations of the platform

What you'll learn

Learn Xplenty From Scratch

Cloud Based Data Integration Solution

Advanced Transformations for ETL and ELT

Cross Cloud Platform Integration

Creating Data Pipelines Across Multiple Cloud Architectures

Requirements

No programming experience required. Basic understanding of ETL/ELT and Cloud Architecture is an advantage, but not mandatory

Description

The course is about Xplenty and its features of integrating the data across cloud platformsXplenty is an advanced ETL/ELT tool which provides an excellent interface for data pipelines in the cloud architecture. The tool's graphical user interface enables the developers to create the flow in an efficient and optimistic way providing better solution on integrating the dataXplenty can be simply termed as one platform for all you data integration needsThe tool provides the interface of below transformations,Select                     Sample                     Filter Sort                        Join                           Assert Rank                       Cross Join                 Aggregate Limit                       Clone                        Cube Window                  Union                       Distinct                                      These pre-built transformations allows the users to transform their data and integrate with the destinations. Also the tool enables to integrate with multiple cloud application and services. We can also integrate with the social media platforms like YouTube, Facebook, LinkedIn, Instagram. etc., very easily. REST API's interface allows to connect with any web service platform and extract the data. There are numerous connections like Databases, File Storage's,  API's, Data Warehouse, Google Analytics, Google Adwords, Facebook Ads Insights, Salesforce, Snowflake, Google Spanner, NoSql .etc., are available in XplentyNo prior coding experience is required to start with XplentyXplenty provides an interface called, X-Console which is an excellent terminal enables the developers to test the transformation functions

Overview

Section 1: Introduction

Lecture 1 About the Course

Lecture 2 What is Xplenty?

Section 2: Getting Started

Lecture 3 Overview Of Xplenty Interface

Lecture 4 Data Set And Schema

Lecture 5 Creating Connections

Section 3: Migrating Data from S3 to PostgreSQL RDS Instance

Lecture 6 Migration Part1

Lecture 7 Migration Part2

Section 4: Transformations in Xplenty

Lecture 8 Select

Lecture 9 Sort

Lecture 10 Rank

Lecture 11 Limit

Lecture 12 Window

Lecture 13 Sample

Lecture 14 Join

Lecture 15 Cross Join

Lecture 16 Clone

Lecture 17 Union

Lecture 18 Filter

Lecture 19 Assert

Lecture 20 Aggregate

Lecture 21 Cube

Lecture 22 Distinct

Section 5: Operation Type in Database

Lecture 23 Append (Insert only)

Lecture 24 Overwrite (Truncate and insert)

Lecture 25 Overwrite (Delete all rows on table and insert)

Lecture 26 Merge with existing data using delete and insert

Lecture 27 Merge with existing data using update and insert

Section 6: Advanced Configurations

Lecture 28 X-Console

Lecture 29 Cluster Creation

Lecture 30 Add Missing Columns

Lecture 31 Where Clause

Lecture 32 Query Data

Lecture 33 Pre-Post Action Sql

ETL Developers,Data Engineers,Data Architects,Data Migration Specialists,Cloud Data Engineers,Students,Professionals who wants to switch their career to ETL and Data Engineering