{"product_id":"azure-data-factory-training-designing-and-implementing-data-integration-solutions","title":"Azure Data Factory Training: Designing and Implementing Data Integration Solutions","description":"\u003cdiv\u003e\u003cp\u003eThis \u003cb\u003eAzure Data Factory Training\u003c\/b\u003e covers all key aspects of the Azure Data Factory v2 platform. Special attention is paid to covering Azure services which are commonly used with ADF v2 solutions. These services are Azure Data Lake Storage Gen 2, Azure SQL Database, Azure Databricks, Azure Key Vault, Azure Functions, and a few others.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eAzure Data Factory Training: Designing and Implementing Data Integration Solutions Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this Azure Data Factory course, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuild end-to-end ETL and ELT solutions using Azure Data Factory v2\u003c\/li\u003e\n\u003cli\u003eArchitect, develop and deploy sophisticated, high-performance, easy-to-maintain and secure pipelines that integrate data from a variety of Azure and non-Azure data sources.\u003c\/li\u003e\n\u003cli\u003eApply the latest DevOps best practices available for the ADF v2 platform.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eLearning Tree course 8566, Introduction to Cloud Infrastructure (AZ-900), or equivalent experience.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eAzure Data Factory Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introduction to ADF\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eHistorical background: SSIS, ADF v1, other ETL\/ELT tools\u003c\/li\u003e\n\u003cli\u003eKey capabilities and benefits of ADF v2\u003c\/li\u003e\n\u003cli\u003eRecent feature updates and enhancements\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Core Architectural Components \u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eConnectors: Azure services, databases, NoSQL, files, generic protocols, services \u0026amp; apps, custom\u003c\/li\u003e\n\u003cli\u003ePipelines\u003c\/li\u003e\n\u003cli\u003eActivities: data movement, data transformation, control flow\u003c\/li\u003e\n\u003cli\u003eDatasets: source, sink\u003c\/li\u003e\n\u003cli\u003eIntegration Runtimes: Azure, Self-Hosted, Azure-SSIS\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Building and Executing Your First Pipeline\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eCreating ADF v2 instance\u003c\/li\u003e\n\u003cli\u003eCreating a pipeline and associated activities\u003c\/li\u003e\n\u003cli\u003eExecuting the pipeline\u003c\/li\u003e\n\u003cli\u003eMonitoring execution\u003c\/li\u003e\n\u003cli\u003eReviewing results\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Data Movement\u003c\/h4\u003e\n\u003cp\u003eCopying Tools and SDKS\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCopy Data Tool\/Wizard\u003c\/li\u003e\n\u003cli\u003eCopy activity\u003c\/li\u003e\n\u003cli\u003eSDKs: Python, .NET\u003c\/li\u003e\n\u003cli\u003eAutomation: PowerShell, REST API, ARM Templates\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eCopying Considerations\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eFile formats: Avro, binary, delimited, JSON, ORC, Parquet\u003c\/li\u003e\n\u003cli\u003eData store support matrix\u003c\/li\u003e\n\u003cli\u003eWrite behavior: append, upsert, overwrite, write with custom logic\u003c\/li\u003e\n\u003cli\u003eSchema and data type mapping\u003c\/li\u003e\n\u003cli\u003eFault tolerance options\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Data Transformation\u003c\/h4\u003e\n\u003cp\u003eTransformation with Mapping Data Flows\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIntroduction to mapping data flows\u003c\/li\u003e\n\u003cli\u003eData flow canvas\u003c\/li\u003e\n\u003cli\u003eDebug mode\u003c\/li\u003e\n\u003cli\u003eDealing with schema drift\u003c\/li\u003e\n\u003cli\u003eExpression builder \u0026amp; language\u003c\/li\u003e\n\u003cli\u003eTransformation types: Aggregate, Alter row, Conditional split, Derived column, Exists, Filter, Flatten, Join, Lookup, New branch, Pivot, Select, Sink, Sort, Source, Surrogate key, Union, Unpivot, Window\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eTransformation with External Services\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDatabricks: Notebook, Jar, Python\u003c\/li\u003e\n\u003cli\u003eHDInsight: Hive, Pig, MapReduce, Streaming, Spark\u003c\/li\u003e\n\u003cli\u003eAzure Machine Learning service\u003c\/li\u003e\n\u003cli\u003eSQL Stored procedures\u003c\/li\u003e\n\u003cli\u003eAzure Data Lake Analytics U-SQL\u003c\/li\u003e\n\u003cli\u003eCustom activities with .NET or R\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Control Flow\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003ePurpose of activity dependencies: branching and chaining\u003c\/li\u003e\n\u003cli\u003eActivity dependency conditions: succeeded, failed, skipped, completed\u003c\/li\u003e\n\u003cli\u003eControl flow activities: Append Variable, Azure Function, Execute Pipeline, Filter, ForEach, Get Metadata, If Condition, Lookup, Set Variable, Until, Wait, Web\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Runtime and Operations\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eDebugging\u003c\/li\u003e\n\u003cli\u003eMonitoring: visual, Azure Monitor, SDKs, runtime-specific best practices\u003c\/li\u003e\n\u003cli\u003eScheduling execution with triggers: event-based, schedule, tumbling window\u003c\/li\u003e\n\u003cli\u003ePerformance, scalability, tuning\u003c\/li\u003e\n\u003cli\u003eCommon troubleshooting scenarios in activities, connectors, data flows and integration runtimes\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 8: DevOps with ADF\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eQuick introduction to source control with Git\u003c\/li\u003e\n\u003cli\u003eIntegration with GitHub and Azure DevOps platforms\u003c\/li\u003e\n\u003cli\u003eEnvironment management: Development, QA, Production\u003c\/li\u003e\n\u003cli\u003eIterative development best practices\u003c\/li\u003e\n\u003cli\u003eContinuous Integration (CI) pipelines\u003c\/li\u003e\n\u003cli\u003eContinuous Delivery (CD) pipelines\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 9: Promoting Reuse\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eTemplates: out-of-the-box and organizational\u003c\/li\u003e\n\u003cli\u003eParameters\u003c\/li\u003e\n\u003cli\u003eNaming convention\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 10: Security\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eData movement security\u003c\/li\u003e\n\u003cli\u003eAzure Key Vault\u003c\/li\u003e\n\u003cli\u003eSelf-hosted IR considerations\u003c\/li\u003e\n\u003cli\u003eIP address blocks\u003c\/li\u003e\n\u003cli\u003eManaged identity\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267A37US \/ 2026-07-08T09:00:00 \/ Herndon, VA","offer_id":47389186556074,"sku":"US-1231-IL","price":2785.0,"currency_code":"USD","in_stock":true},{"title":"268A06CN \/ 2026-08-19T09:00:00 \/ Ottawa","offer_id":47389186588842,"sku":"US-1231-IL","price":2785.0,"currency_code":"USD","in_stock":true},{"title":"26AA64US \/ 2026-10-07T09:00:00 \/ Austin","offer_id":47978749657258,"sku":"US-1231-IL","price":2785.0,"currency_code":"USD","in_stock":true},{"title":"26AA65US \/ 2026-10-28T09:00:00 \/ New York","offer_id":47978749690026,"sku":"US-1231-IL","price":2785.0,"currency_code":"USD","in_stock":true},{"title":"26BA50US \/ 2026-11-23T09:00:00 \/ Herndon, VA","offer_id":47978749722794,"sku":"US-1231-IL","price":2785.0,"currency_code":"USD","in_stock":true},{"title":"271A05CN \/ 2027-01-06T09:00:00 \/ Ottawa","offer_id":47978749755562,"sku":"US-1231-IL","price":2785.0,"currency_code":"USD","in_stock":true},{"title":"273A42US \/ 2027-03-03T09:00:00 \/ Austin","offer_id":48061184442538,"sku":"US-1231-IL","price":2785.0,"currency_code":"USD","in_stock":true},{"title":"273A43US \/ 2027-03-23T09:00:00 \/ New York","offer_id":48134530236586,"sku":"US-1231-IL","price":2785.0,"currency_code":"USD","in_stock":true},{"title":"274A42US \/ 2027-04-21T09:00:00 \/ Herndon, VA","offer_id":48230039257258,"sku":"US-1231-IL","price":2785.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternational-wmata.myshopify.com\/products\/azure-data-factory-training-designing-and-implementing-data-integration-solutions","provider":"Learning Tree International","version":"1.0","type":"link"}