Integrating Data in Microsoft Azure

Focused View

Marcelo Pastorino

2:22:51

20 View

00. Course Overview

00. Course Overview.mp4

01:58

01. Data Integration Services on Azure

00. Introduction.mp4

00:50

01. Learning About Azure Data Integration Services.mp4

03:26

02. Understanding Data Integration Requirements.mp4

03:53

03. Summary.mp4

00:23

02. Migrate On-premise Data to Azure SQL Server

00. Introduction.mp4

00:35

01. Creating an Azure SQL Server and Database.mp4

02:54

02. Using Data Migration Assistance to Detect Compatibility Issues and Migrate Data.mp4

06:23

03. Introducing Azure Data Factory.mp4

02:08

04. Understanding Pipelines, Activities, Datasets, and Linked Services.mp4

03:48

05. Getting to Know Integration Runtimes.mp4

01:25

06. Identifying On-premise and Azure SQL Database Assets.mp4

01:16

07. Getting Familiar with the Azure Data Factory UI.mp4

03:42

08. Creating Your First Azure Data Factory Pipeline.mp4

01:43

09. Creating Your First Data Pipeline Activity.mp4

05:18

10. Querying an On-premise Table by Using a Self-hosted Integration Runtime.mp4

04:36

11. Copying Data Incrementally from On-premise to Azure SQL Database.mp4

04:55

12. Executing a Parameterized Stored Procedure in an Azure Data Factory Pipeline.mp4

03:04

13. Running and Monitoring a Pipeline Execution.mp4

04:09

14. Summary.mp4

00:57

03. Migrate Data from Amazon S3 to Azure Blob Storage

00. Introduction.mp4

00:33

01. Identifying Azure Blob Storage Assets.mp4

01:14

02. Getting the Amazons S3 Access Key.mp4

01:49

03. Creating the Pipeline and Copy Activity.mp4

00:57

04. Creating the Source Dataset and Linked Service.mp4

03:22

05. Creating the Sink Dataset and Linked Service.mp4

02:08

06. Validating, Debugging, Publishing, Triggering, and Monitoring Pipeline Execution.mp4

04:25

07. Summary.mp4

00:38

04. Create Data Pipelines with Azure Data Factory Copy Data Tool

00. Introduction.mp4

00:33

01. Getting to Know Copy Data Tool.mp4

02:13

02. Creating a Pipeline with ADF Copy Data Tool.mp4

04:22

03. Reviewing Pipeline Components Created by Copy Data Tool.mp4

00:58

04. Summary.mp4

00:45

05. Create Data Pipelines with Azure Data Factory

00. Introduction.mp4

00:49

01. Creating the Pipeline and Pipeline Parameters.mp4

01:17

02. Adding a GetMetaData Activity to the Pipeline.mp4

02:39

03. Adding a Filter Activity to the Pipeline.mp4

02:00

04. Creating a Reusable Dataset.mp4

02:21

05. Adding a ForEach Activity to the Pipeline.mp4

04:55

06. Introducing Azure Databricks.mp4

02:52

07. Transforming Data with a Databricks Notebook Activity.mp4

05:27

08. Sending Transactional Email with Azure LogicApps.mp4

03:35

09. Deleting Staging Files with a Delete Activity.mp4

01:35

10. Executing and Monitoring Pipeline Execution.mp4

01:56

11. Creating a Trigger That Runs a Pipeline on a Schedule.mp4

00:48

12. Introducing Data Flows.mp4

01:32

13. Learning About Other Ways to Create Azure Data Factory Resources.mp4

01:42

14. Learning About Other Type of Integrations That ADF Makes Possible.mp4

01:41

15. Summary.mp4

00:45

06. Create Real-time Data Pipelines with Azure EventHubs and Azure Stream Analytics

00. Introduction.mp4

00:32

01. Creating and Configuring EventHubs.mp4

02:06

02. Introducing the Air Pollution Sensor Generator.mp4

02:14

03. Creating a Stream Analytics Job.mp4

01:54

04. Creating a Stream Analytics Job Input.mp4

02:46

05. Creating a Stream Analytics Job Reference Input.mp4

00:59

06. Creating a Stream Analytics Job Output.mp4

01:54

07. Creating a Stream Analytics Job Query.mp4

02:48

08. Starting a Stream Analytics Job and Reviewing Monitoring Tools.mp4

01:48

09. Summary.mp4

00:30

07. Real-time Monitoring with Power BI

00. Introduction.mp4

00:22

01. Configuring Stream Analytics for Power BI.mp4

03:49

02. Consuming Real-time Pipeline Events in Power BI.mp4

03:06

03. Summary.mp4

00:49

Description

With over 2.5 quintillion bytes of data generated each day, you need to rely on modern tools to efficiently use and analyze data. In this course, you will learn how to leverage the power of Azure to create data integration pipelines in the cloud.

What You'll Learn?

Data-driven decision making is the path to business success. In this course, Integrating Data in Microsoft Azure, you will gain foundational knowledge to integrate data utilizing the power of Microsoft Azure.

First, you will learn how to migrate data from on-premise and Amazon Web Services to Azure. Next, you will discover how to easily construct ETL processes and create data integration pipelines using Azure Data Factory.

Finally, you will explore how to create a real-time pipeline, to ingest and process real-time events sent by IoT devices using Azure EventHubs, Azure Stream Analytics, and Power BI.

When you’re finished with this course, you will have the skills and knowledge needed to create data integration pipelines using some of the great tools that are part of the Azure ecosystem.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Microsoft Azure

Marcelo Pastorino

Instructor's Courses

Marcelo has over 20 years of professional experience solving business problems and creating new opportunities for companies by architecting solutions and developing software for the web, cloud, and mobile devices. He started coding for fun in the early 90s in an old IBM 8086 XT, in now-defunct programming languages like Clipper, Pascal, and dBase III and sold his first piece of software for the DOS operating system at age 16. These days, his preferred stacks are Microsoft's .NET, C#, Xamarin, Azure and JavaScript, TypeScript, React, React Native, Next.js, and everything around these fantastic technologies. Marcelo is a passionate and pragmatic developer, an avid learner, and a fan of clean code and best practices. He has worked for companies in various software development roles with pride in building quality software. In his spare time, he is creating SoftwareDeveloper.io, an app to enable Software Developers and other tech roles to find their perfect remote job opportunities and help them stand out as professionals.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.