SESSION Details

Beginner's Guide to Data Integration using Azure Data Factory or Azure Synapse Analytics

What is at the core of every Business Intelligence, Data Science, and Machine Learning project?

Data.

You need data to understand what has happened in the past, to predict what may happen in the future, to discover patterns and anomalies, and to gain the insight necessary for making faster and better decisions.

But before you can do any of those things, you need to collect, store, transform, integrate, and prepare your data.

That's where you and I fit in! 🤓

In this full-day workshop, you will learn the skills you need to build and maintain data integration solutions in Azure Data Factory or Azure Synapse Analytics.

We will start completely from scratch with a conceptual overview, discuss when and why you would choose Azure Data Factory or Azure Synapse Analytics, and build a solution for ingesting data. Then, we will look at options for transforming and preparing data for further analysis, cover how to work with both on-premises and cloud data stores, and build dynamic pipelines as part of a metadata-driven solution. As we move from individual development to team development, we will cover source control, security, and review options for continuous integration and continuous deployment (CI/CD). Throughout the day, we will cover best practices for development and evaluate how to optimize our solutions for both performance and pricing.

Get ready for a day full of learning, networking, and new ideas! 💡

Feedback link https://sqlb.it/?7149

Starts: 09:00 8th Mar 2022
Ends: 17:00 8th Mar 2022

Q&As

Short Description
- In this full-day workshop, you will learn the skills you need to build and maintain data integration solutions in Azure Data Factory or Azure Synapse Analytics.
Should delegates bring a laptop with them?
- Not required, but recommended if you want to test anything yourself.
If so what Spec?
- We will be working in Azure, so any modern laptop should be sufficient.
What software and licences do they need?
- 1) Microsoft Edge or Google Chrome. 2) If you don’t already have an Azure Subscription with Owner or Contributor permissions, you can create a free account on azure.microsoft.com/free. This lasts 30 days, so time it wisely!
What is the structure of the day?
- The workshop is divided into the following main sections: 1) Overview and Fundamentals, 2) Ingesting Data, 3) Transforming Data, 4) Dynamic Pipelines, 5) Security and Management, 6) Team Development, 7) Best Practices
What internet requirements do the delegates have?
- Delegates will need a stable internet connection throughout the day.
What will the delegates get out of the day?
- Delegates will learn everything they need to get started building and maintaining data integration solutions in Azure Data Factory or Azure Synapse Analytics. During the day, we will reinforce learning through quizzes and Q&As.
Other technologies
- Azure Data Factory

Slidedeck Link

SQLBits - Cathrine Wilhelmsen - Beginners Guide to Data Integration.pdf

Speakers

Cathrine Wilhelmsen

Tags

AzureData IntegratorDevelopingData Transformation and IntegrationSynapse AnalyticsBeginnerHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference

Previous
Next

Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.