Last updated 11/2021MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 1.30 GB | Duration: 3h 9m
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 teal 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 Eeers,Data Architects,Data Migration Specialists,Cloud Data Eeers,Students,Professionals who wants to switch their career to ETL and Data Eeering HomePage:
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.