Learn Xplenty - A Cloud Based Data Integration 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

Homepage

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