The training program focuses on advanced topics in Data Integration, including SQL, API, ETL and the Creation of Integration Bridges. Participants will engage in hands-on exercises, discussions, and collaborative activities to enhance their skills in database optimization, ETL processes, system integration, and the development of integration solutions. The virtual training encourages active participation, open communication, and the practical application of learned concepts in real-world scenarios.
Live Developer Training: Data Integration and APIs
Learn To:
- • Integrate various applications (Salesforce, Shopify, Oracle MSSQL, Google cloud storage etc)
- • Integrate Data from multiple Sources (API, Database, etc)
- • Work with APIs and SQL.
- • Configure variety of Data Sources and Targets
- • Tackle industry-based challenges in ETL processes and integrations.
- • Apply your expertise in solving complex Business problems.
Benefits to you:
By taking this course, you'll become familiar with various real-world integration use cases. You'll get a chance to learn about types of authentication, applications and API configuration.
Prerequisites:
- • Experience with PaaS and SaaS concepts
- • Basic knowledge of SQL and Integration
- • Sign up on eZintegration Platform
Audience:
- • Integration Developer
- • Application Integration Specialist
- • Integration Consultant
- • Data Consultant
- • Data Engineer
- • IT & MBA Students
Objectives:
- • Learn real-world integration use-cases.
- • Acquire proficiency in the processes of data transformation, wrangling, cleaning, and orchestration.
- • Understand Advanced SQL and Database concepts.
- • Understand eZintegration components, features, and capabilities.
- • Use pre-built API Catelogue and utilize the API Marketplace.
- • Understand the steps for creating integration bridge on eZintegration.
- • Configure Data Source and Data Target.
- • Learn Basic auth, Auth 1.0 and Auth 2.0
- • Use Rest and Soap API concepts.
- • Configure API to Database integration.
- • Configure Database to API integration.
Topics:
eZintegration overview:
- • Basic product overview
- • Understanding features and capabilities.
- • API Introduction
- • Using eZintegration API Marketplace
- • Configuration of API in eZintegration
- • Types of Authentications
- • Understanding Integration and Integration Bridges
Advanced SQL:
- • SQL Queries
- • Joins
- • GraphQL
- • SQL and integration
Data Source Configuration
- • Types of Applications Configuration
- • API as Data Source
- • Database as Data Source
- • Authentication
Advanced Data Operations
- • Transforming Data using Data Operations in eZintegration
- • Use cases of Data Operations
- • Understanding types of Data operations
Database
- • Introduction to Databases
- • Types of Data
- • Use case of Database
Data Target Configuration
- • API as Data Target
- • Database as Data Target
- • Scheduling of Integrations
- • Describe end to end Integration
