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.
Azure Data Factory Deep Dive
Description
This immersive full day hands on session will arm you with all the skills you need to build and orchestrate pipelines using Azure Data Factory v2 that solve both traditional data integration problems and also adapt to newer challenges such as real-time and complex event processing.
We will start with a conceptual overview, and then get into how you can use metadata to build scalable serverless pipelines to move data from disparate data sources including On-Premises and Platform As A Service. We will look at how to leverage SSIS Lift and shift to maximize reuse for your existing code base and review the pros and cons of this approach. We will dive deep into the newly released Data Flow capabilities and cover the design patterns and architectures for modern Data Warehouses and big data pipelines. We will also review best practices for operationalizing solutions including configuring monitoring, logging and alerting. And did I mention DevOps? We will implement DevOps best practices like CI/CD within the data factory.
This day is everything you need to do amazing things with Azure Data Factory.
Pre-requisites
Some Familiarity with Azure and ETL will be helpful but not required
Laptop Required:Yes
- Software: SSMS / Azure Data Studio. I will send out a detailed list prior to the session if other tools are required.
- Subscriptions: A trial subscription to Azure is required
Learning Objectives
Previous Experience
Tech Covered
Azure, SSIS, ETL, DevOps, Flow, Azure Data Studio, Big Data, Tools