Udemy – Essential SQL: Azure Data Factory and Data Engineering 2023-11

Published on: 2024-09-25 16:43:38

Categories: 28

Descriptions

Essential SQL: Azure Data Factory and Data Engineering, Use Azure data factory to automate data engineering tasks. This is a great course to introduce yourself to Azure Data Factory’s capabilities. We’ll look at the data factory from a data engineer perspective. Through examples we’ll work side by side to create an Extract Transform and Load process to ingest movie rating data. We are going to explore two different ways to transform your data. The first is by using Azure Data Mapping flows. These are great no-code ways to do ETL. Lastly, we’ll look at how you can create pipelines to use your knowledge of SQL and stored procedures. What you’ll like about this course is that once you learn one way to transform the data, you can use that knowledge to learn about the other methods. So, if you’re a SQL expert but soft on python, you can learn the SQL way before trying another mapping method. In the end you come out learning and appreciating alternative methods to ingesting, transforming, and storing data. Keep in mind this is more of “work with me” than “me talking to you” style of course. There are sections where I will start out lecturing about a concept, but I’d say during 80% of the course I’m working the tools, and I highly encourage you to work them along side me. Pause, rewind, and build it with me!

What you’ll learn

Learn how to construct ELT solutions using Azure Data Factory and SQL Server.
Implement various ELT solutions using Mapping Data Flows, Copy Activities, and Stored Procedures.
Develop the skills to build and troubleshoot Azure Data Factory pipelines with confidence.
Enhance pipeline reliability by mastering the use of parameters to optimize your data workflows.
Learn efficient methods for storing and structuring data using Azure Storage services.
Understand the distinctive roles played by Azure Data Factory, Data Storage, SQL Server, and Data Bricks in the creation of an ELT solution.

Who this course is for

Aspiring Data Engineers: Individuals who are new to data engineering and want to learn how to use Azure Data Factory to build data solutions.
Business Analysts: Analysts who work with data to make business decisions. Understanding data engineering can help them better utilize and secure data for decision-making.
Business Intelligence Developers: BI developers seeking to automate data pipelines for their reporting and analytics needs using Azure Data Factory.
Cloud Architects: Professionals responsible for designing and implementing cloud solutions. They may want to understand how Azure Data Factory fits into their architecture.
Data Analysts: Analysts who want to expand their skills by learning how to move and transform data using Azure Data Factory for better analysis.
Data Architects: Professionals responsible for designing data architectures and systems. They need to ensure that the data solutions they design are secure, scalable, and well-managed.
Data Scientists: Data scientists who want to work with clean and well-organized data, making Azure Data Factory knowledge beneficial for data preparation.

Specificatoin of Essential SQL: Azure Data Factory and Data Engineering

Publisher : Udemy
Teacher : Kris Wenzel
Language : English
Level : All Levels
Number of Course : 47
Duration : 8 hours and 36 minutes

Content on 2024-2

Essential SQL_ Azure Data Factory and Data Engineering

Requirements

Familiarity with SQL and basic programming skills can be beneficial.
Proficiency in programming will be valuable when working with scripting and data transformation tasks
Experience in troubleshooting and debugging technical issues will aid in building and troubleshooting Azure Data Factory pipelines.