SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
From Zero to Azure Data Factory
Description
From Zero to Azure Data Factory is designed to jumpstart data engineering and data integration developers, introducing them to Azure Data Factory (ADF). ADF is a cloud data engineering and data integration platform designed to orchestrate data-related activities and move data between sources and sinks in the cloud, on-premises, and combinations thereof.
Lesson 0: Introduction
Lesson 1: Provision a Data Factory
- Examine Azure Portal
- Survey ADF artifacts
- Create Your First ADF Pipeline
Lesson 2: Basic Data Movement
- Copy Data Activity
- Delete Activity
- Stored Procedure Activity
Lesson 3: Pipeline Orchestration
- Conditional, Lookup, ForEach Activities
- Debugging
- Triggers
Lesson 4: Monitoring
- ADF Portal
Lesson 5: Azure-SSIS
- Provision an Azure-SSIS instance
- Azure-SSIS execution options
- Lifting and shifting on-premises SSIS to Azure-SSIS
Lesson 6: Enterprise ADF Execution Patterns
- Leveraging the Parent-Child design pattern.
Learning Objectives
Previous Experience
Tech Covered
Deploying, Cloud, Azure, SSIS, SQL 2019, Azure Data Factory, Data transformation and integration, Move to the cloud, ADF, Azure-SSIS, Developing, Managing, Monitoring