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.
A Day Full of Azure Data Factory
Description
If we want to achieve any data processing in Azure you need an umbrella service to manage, monitor and schedule your solution. For a long time when working on premises, the SQL Agent has been our go-to tool, combined with T-SQL and SSIS packages. It’s now time to upgrade our skills and start using cloud native services to achieve the same thing on the Microsoft Cloud Platform. Within a PaaS only Modern Data Platform, the primary component for delivering that orchestration is Azure Data Factory, combined with various other compute resources.
In this full day of training we’ll start with the basics and learn how to orchestrate your Azure Data Platform end to end. You will learn how to build our Azure ETL/ELT pipelines using all Data Factory has to offer. Plus, consider hybrid architectures, dynamic design patterns, think about lifting and shifting legacy packages, and explore complex bootstrapping to orchestrate everything within your solution.
COMPLETE SESSION AGENDA- Module 1: Data Factory Fundamentals
- What is it and why use it?
- Resource Components
- Common Activities
- Execution Dependencies
- Module 3: Using SSIS Packages in Azure
- SSIS Integration Runtime
- Packages Running on PaaS
- Scaling Out Package Execution
- Module 5: Metadata Driven Pipelines
- Expressions
- Dynamic Pipelines
- Orchestration Framework – ADFprocfwk.com
- Module 6: Monitoring Alerting Security
- Module 7: Pricing & Limitations
- Module 8: CI/CD with Azure DevOps
- Source Control vs Developer UI
- ARM Template Deployments
- PowerShell Deployments
- Module 10: Wrap Up
- Conclusions
- Questions
- Homework
If that’s not enough content for one day, you will also get access to a set of hands-on labs that you can work through at your own pace. Whether you are new to Azure Data Factory or have some experience, you will leave this workshop with new skills and ideas for your projects.
Learning Objectives
Previous Experience
Tech Covered
Deploying, Securing, Cloud, SQL 2019, Azure SQL Database, Azure Data Factory, Developing, Monitoring