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.
Big Data & Data Engineering
A Day of Azure Data Factory
Description
In this session we provision an Azure Data Factory (ADF) and demonstrate many uses for ADF in the modern data enterprise, including:
- Editing ADF pipeline JSON
- Version control integration
- Copying data with the copy data activity
- Parameters and use cases for parameterization (dynamic property values and expressions)
- Design patterns for the hybrid data estate
- Loading data from an on-premises data source
- Survey newer activities
- Debugging and troubleshooting ADF pipelines
- Looping, iteration, and conditionals
- Monitoring
- Execution automation (triggers + )
- ADF REST API
- security required to interact with Azure Blob Storage, Azure SQL DB, REST API, integration runtimes, git, and on-premises (plus Key Vault)
- Provisioning and using integration runtimes
- Editing ADF pipeline JSON
- Version control integration
- Copying data with the copy data activity
- Parameters and use cases for parameterization (dynamic property values and expressions)
- Design patterns for the hybrid data estate
- Loading data from an on-premises data source
- Survey newer activities
- Debugging and troubleshooting ADF pipelines
- Looping, iteration, and conditionals
- Monitoring
- Execution automation (triggers + )
- ADF REST API
- security required to interact with Azure Blob Storage, Azure SQL DB, REST API, integration runtimes, git, and on-premises (plus Key Vault)
- Provisioning and using integration runtimes
Learning Objectives
1. How to get started developing with ADF; how to navigate the development user experience.
2. How to monitor and administer ADF; security required for interaction with helpful Azure services.
3. General tips and tricks, design patterns, troubleshooting.
Previous Experience
Familiarity with T-SQL and data integration is helpful but not necessary.
Tech Covered
Azure, Move to the cloud, Developing, Managing, Monitoring, Big Data & Data Engineering, Data Loading Patterns & Techniques