Learn Azure Synapse Step By Step Playlist
Aulas do Curso
(120 vídeos)
0 de 120 aulas concluídas
0%
Progresso salvo somente neste navegador.
0
Learn Azure Synapse Step By Step With Project - Course Introduction
Master Azure Synapse Analytics, Microsoft’s powerful unified analytics platform, through this hands-on, project-based co…
1
01 Introduction to Azure Synapse Analytics
Learn about Azure Synapse Analytics, a unified analytics platform that brings together data integration, data warehousin…
2
Data Warehouse Vs. Data Lakes
Explore the differences between traditional data warehousing and modern data lakes. Learn when to use each approach and …
3
Inception of Azure Synapse Analytics
Discover the origins of Azure Synapse Analytics and how it evolved to become a powerful analytics platform. Understand t…
4
Create Synapse Analytics Workspace Lab
#AzureSynapseAnalytics, #Tutorial, #HandsOn, #CloudComputing, #DataEngineering, #DataScience
5
Azure Synapse Workspace Overview
Explore the different components of a Synapse Analytics workspace, including the data engineering pipeline, data explora…
6
Azure Synapse Studio Overview
Learn how to navigate the Azure Synapse Studio interface. Discover the various tools and features available for data eng…
7
Data Hub Overview
Explore the Data Hub in Azure Synapse Analytics, a centralized location for storing and managing data. Learn how to inge…
8
Develop Hub Overview
Dive into the Develop Hub in Azure Synapse Analytics, where you can write and execute SQL queries, create notebooks, and…
9
Integrate Hub Overview
Learn how to use the Integrate Hub to orchestrate data pipelines, automate data flows, and integrate with other Azure se…
10
Monitor Hub Overview
Discover the monitoring tools and features available in Azure Synapse Analytics. Learn how to monitor the health of your…
11
Manage Hub Overview
In this video we will learn about Manage Hub Overview in Synapse
12
Project Overview
Get an overview of the project and its goals. Understand the business problem it aims to solve and the expected outcomes…
13
Project DataSet Overview
Explore the dataset that will be used in the project. Understand its structure, schema, and data quality issues.
14
Project Data File Types Overview
Learn about different data file formats, such as CSV, JSON, and Parquet. Understand the advantages and disadvantages of …
15
Import Project Data to Data Lake
Learn how to import data into Azure Data Lake Storage from various sources, including on-premises systems and cloud-base…
16
Project Requirements Overview
Break down the project requirements into smaller, more manageable tasks. Identify the specific data transformations and …
17
Synapse Project - Solution Architecture Overview (Medallion Architecture)
#SolutionArchitecture, #DataArchitecture, #DataEngineering, #CloudComputing, #DataScience
18
Serverless SQL Pool Overview
Learn about the Serverless SQL Pool in Azure Synapse Analytics, a fully managed, serverless SQL engine for analytics. Un…
19
Serverless SQL Pool Introduction
Explore the technical details of the Serverless SQL Pool, including its architecture, query processing engine, and perfo…
20
Serverless SQL Pool Cost Control
Learn how to optimize the cost of using Serverless SQL Pool by understanding its pricing model and implementing best pra…
21
Connect Azure SQL Pool Using Azure Studio
Learn how to connect to Azure SQL Pool using Azure Data Studio, a powerful tool for managing and querying data.
22
How to use Serverless SQL Pool to Query CSV Files Overview
Learn how to query CSV files stored in Azure Data Lake Storage using Serverless SQL Pool. Understand the OPENROWSET func…
23
OPENROWSET Function Overview
Explore the OPENROWSET function in detail, including its syntax, parameters, and use cases. Learn how to use it to query…
24
Query Taxi Zone CSV File in Synapse
Follow a hands-on tutorial to query CSV files using the OPENROWSET function. Learn how to handle different data formats …
25
How to Specify the DataType in Synapse
Learn how to specify data types for columns in your queries. Understand the importance of data types for accurate data a…
26
How to Specify Collation in Synapse
Learn how to set the collation for your queries, which determines how character data is sorted and compared. Understand …
27
How To Query Query Subset Of Columns in Synapse
Learn how to query specific columns from a CSV file using the OPENROWSET function. Understand how to select the desired …
28
How To Do Debugging and Identifying Errors in Synapse
Learn how to debug and troubleshoot SQL queries. Understand common error messages and how to fix them. Learn how to use …
29
How to Use External Data Source in Synapse
Learn how to query data from external data sources, such as Azure Blob Storage, Azure SQL Database, and other relational…
30
Query Calendar File CSV File in Synapse
Learn how to query a CSV file containing calendar data using Serverless SQL Pool. Understand how to handle date and time…
31
How To Query Quoted And Escaped Columns In Synapse
Learn how to handle CSV files with quoted and escaped columns. Understand how to properly parse and interpret such data …
32
How to Query Tab separated File In Synapse
Learn how to query tab-separated files (TSV) using Serverless SQL Pool. Understand the differences between CSV and TSV f…
33
How to Query JSON Serverless SQL Pool In Synapse
Learn how to query JSON data using Serverless SQL Pool. Understand the OPENJSON function and its usage for parsing and e…
34
How To Query Single Line JSON in Serverless SQL Pool in Synapse
Learn how to query single-line JSON objects using the OPENJSON function. Understand how to extract specific fields and v…
35
How to Use OpenJSON Function In Synapse
Explore the OPENJSON function in detail, including its syntax, parameters, and use cases. Learn how to use it to parse a…
36
How To Query JSON Array In Synapse
Learn how to query JSON arrays using the OPENJSON function. Understand how to extract individual elements from the array…
37
How to Query Standard JSON In Synapse
Learn how to query JSON data in standard format, including nested objects and arrays. Understand how to use the OPENJSON…
38
How To Query MultiLine JSON In Synapse
Learn how to query multi-line JSON data using the OPENJSON function. Understand how to handle different JSON formats and…
39
How To Query Folder And MultipleFiles In Synapse
Learn how to query data from multiple files within a folder or across different folders using Serverless SQL Pool. Under…
40
How To Use File Metadata Functions In Synapse
Learn how to use file metadata functions to extract information about files, such as their creation date, modification d…
41
How To Query Parquet
Learn how to query Parquet files using Serverless SQL Pool. Understand the advantages of Parquet format for efficient da…
42
How To Query Folders and Sub Folders Of Parquet Columnar Format Data In Synapse
Learn how to query Parquet data stored in multiple folders and subfolders. Understand how to use wildcards and other tec…
43
How To Query Delta Files In Synapse
Learn how to query Delta Lake tables using Serverless SQL Pool. Understand the benefits of using Delta Lake for data ver…
44
How to Data Discovery using Serverless SQL Pool In Synapse
Learn how to discover and explore data using Serverless SQL Pool. Understand how to use SQL queries to analyze data, ide…
45
How To Identify Duplicate Data In Synapse
Learn how to identify and remove duplicate data from your datasets. Understand different techniques for detecting and el…
46
How To do Data Quality Check In Synapse
Learn how to ensure the quality of your data by identifying and correcting errors, inconsistencies, and missing values. …
47
How To Join Files In Synapse
Learn how to join data from multiple files into a single dataset. Understand different join types and how to use them to…
48
How to Transform Data In Synapse
Learn how to transform and clean data using SQL queries and other techniques. Understand how to handle data inconsistenc…
49
Learning Task Data Discovery
Practice data discovery techniques by working on a real-world dataset. Learn how to explore data, identify patterns, and…
50
Understand Data Virtualization Concept
Learn about data virtualization and its benefits for data integration and access. Understand how to create virtual views…
51
Understand External Tables In Synapse
Learn how to create external tables to access data stored in external data sources, such as Azure Blob Storage, Azure Da…
52
How To Create External Table In Synapse
Learn how to create external tables for different data formats, including CSV, JSON, and Parquet. Understand the syntax …
53
How To Handle Invalid Records In Synapse
Learn how to handle invalid records in external tables. Understand error handling mechanisms and how to filter out or co…
54
Learning Assignment Create External Table For CSV
Learn how to create external tables for CSV data stored in Azure Blob Storage or Azure Data Lake Storage. Understand how…
55
How to Create External Table For Parquet In Synapse
Learn how to create external tables for Parquet data stored in Azure Blob Storage or Azure Data Lake Storage. Understand…
56
How To Create External Table Delta In Synapse
Learn how to create external tables for Delta Lake tables. Understand how to access and query data from Delta Lake using…
57
Understand Views In Synapse
Learn about views and how they can be used to simplify complex queries and improve data security. Understand how to crea…
58
Create View For JSON Files In Synapse
Learn how to create views to simplify access to JSON data. Understand how to use the OPENJSON function to create views t…
59
How To Create View for JSON files Learning Assignment
Practice creating views for JSON data by working on a real-world dataset. Learn how to create views that extract specifi…
60
Understand Partition Pruning In Synapse
Learn about partition pruning and how it can improve query performance. Understand how to partition tables and optimize …
61
Data Ingestion Overview - Synapse
Learn about different data ingestion techniques, including bulk copy, PolyBase, and Azure Data Factory. Understand how t…
62
Data Transformation In Synapse
Learn about data transformation techniques, such as data cleaning, data normalization, and data enrichment. Understand h…
63
How To Transform To Parquet - In Synapse
Learn how to transform data into Parquet format, a columnar storage format that is optimized for analytical workloads. U…
64
Transform to Parquet Learning Assignment
Practice transforming data into Parquet format by working on a real-world dataset. Learn how to use tools and techniques…
65
Transform JSON to Parquet In Synapse
Learn how to transform
66
Transform JSON To Parquet Learning Assignment
Practice transforming JSON data into Parquet format by working on a real-world dataset. Learn how to use tools and techn…
67
How To Transform to Parquet Format Partitioned Files In Synapse
Learn how to transform data into partitioned Parquet format to improve query performance and storage efficiency. Underst…
68
Stored Procedure Introduction
Learn about stored procedures and how they can be used to encapsulate complex data transformation and manipulation logic…
69
Transform partitioned Data Solution In Synapse
Explore different approaches to transforming partitioned data, including using SQL queries, stored procedures, and Azure…
70
How To Transform Partitioned Data Learning Task
Practice transforming partitioned data using SQL queries and stored procedures. Learn how to handle different partitioni…
71
Create View Learning Assignment
Practice creating views to simplify data access and query performance. Learn how to create views for different data scen…
72
Data Transformation What we will learn In Synapse
Learn about the different types of data transformations, including data cleaning, data normalization, and data enrichmen…
73
Learning Task Project Requirement - Data Transformation In Synapse
Learn how to analyze project requirements and identify the necessary data transformations. Understand how to translate b…
74
Select Statement In Synapse
Learn how to use the SELECT statement to transform data, including filtering, sorting, and aggregating data. Understand …
75
Using Stored Procedure In Synapse
Learn how to use stored procedures to encapsulate complex data transformation logic. Understand the benefits of using st…
76
Create View For Transformation In Synapse
Learn how to create views to simplify data access and query performance. Understand how to create views to encapsulate c…
77
Learning Assignment - Applying Transformation Techniques to a Project In Synapse
Practice applying data transformation techniques to a real-world project. Learn how to clean, transform, and enrich data…
78
Synapse Pipeline Overview
Learn about Azure Synapse Pipelines, a powerful tool for orchestrating data pipelines and automating data flows. Underst…
79
Understanding Synapse Pipeline Components
Explore the different components of a Synapse pipeline, including activities, triggers, and datasets. Understand how to …
80
Designing Transformation Pipelines In Synapse
Learn how to design effective data transformation pipelines using Synapse Pipelines. Understand how to break down comple…
81
Create Linked Service & Dataset In Synapse
Learn how to create linked services and datasets in Synapse Pipelines to connect to data sources and define data schemas…
82
Create Pipeline - Delete Activity In Synapse
Learn how to use the Delete activity to delete data from data stores. Understand how to configure the Delete activity to…
83
Create Pipeline - Script Activity In Synapse
Learn how to use the Script activity to execute custom scripts, including Python and SQL scripts. Understand how to pass…
84
Using the Stored Procedure Activity in Synapse Pipelines
Learn how to use the Stored Procedure activity to execute stored procedures in Azure SQL Database or Synapse Analytics. …
85
Understanding Parameters and Variables In Azure Synapse Pipelines
Learn about parameters and variables in Synapse Pipelines. Understand how to use parameters to make pipelines more flexi…
86
Azure Synapse Parameters & Variables LAB
Practice using parameters and variables in Synapse Pipelines to create dynamic and flexible pipelines. Learn how to pass…
87
Understanding Dynamic Pipeline In Azure Synapse
Learn about dynamic pipelines and how to create pipelines that can adapt to changing data volumes and schemas. Understan…
88
Designing Pipelines for Partitioned Files In Azure Synapse
Learn how to design and implement data pipelines for partitioned data. Understand how to handle partitioned data in diff…
89
Creating Pipelines for Partitioned Files: Delete Activity In Azure Synapse
Learn how to use the Delete activity to delete partitioned data based on specific criteria. Understand how to target spe…
90
Creating Pipelines for Partitioned Files: Stored Procedure and Script Activity In Azure Synapse
Learn how to use stored procedures and scripts to transform and process partitioned data. Understand how to pass partiti…
91
Pipeline Dependencies In Azure Synapse
Learn how to assign partitioned data to a gold table, which is a high-quality, curated dataset. Understand how to ensure…
92
Setting Up Manual Trigger In Azure Synapse
Learn how to set up manual triggers to start pipelines on demand. Understand how to configure manual triggers and contro…
93
Setting Up Automated Triggers In Azure Synapse
Learn how to set up automated triggers to start pipelines based on schedules or events. Understand how to configure time…
94
Create Pipeline Partitioned File Assignment Gold Table
Create Pipeline Partitioned File Assignment Gold Table
95
Spark Pool - Section Overview
Spark Pool - Section Overview
96
Understanding Spark Pool
Explore the architecture and components of Spark Pool. Understand how to configure and manage Spark clusters.
97
Create Spark Pool LAB
Learn how to create a Spark Pool in Azure Synapse Analytics. Understand how to configure the pool size, node type, and o…
98
Notebooks Overview In Azure Synapse
Learn about notebooks in Azure Synapse Analytics, a collaborative environment for data exploration, visualization, and m…
99
Integrating Spark Pool and Serverless SQL Pool In Azure Synapse
Learn how to integrate Spark Pool and Serverless SQL Pool to leverage the strengths of both technologies. Understand how…
100
Hands-on: Integrating Spark Pool and Serverless SQL Pool In Azure Synapse
Practice integrating Spark Pool and Serverless SQL Pool to perform real-world data analysis tasks. Learn how to write Sp…
101
Using Notebooks in Synapse Pipelines
Learn how to use notebooks as part of Synapse pipelines to automate data processing and analysis tasks. Understand how t…
102
Power BI Integration Overview
Learn how to integrate Power BI with Azure Synapse Analytics to create interactive and visually appealing reports and da…
103
Connecting to Synapse Data from Power BI Desktop
104
Creating Reports with Synapse Data (Report 1)
Create a sample report using Synapse data in Power BI. Learn how to visualize data using charts, tables, and other visua…
105
Creating Reports with Synapse Data (Report 2)
Create another sample report using Synapse data in Power BI. Learn how to create interactive dashboards and use advanced…
106
Synapse Link - Section Overview
Learn about Synapse Link, a feature that enables real-time analytics on large datasets. Understand how Synapse Link can …
107
Understanding Synapse Link
Explore the architecture and components of Synapse Link. Understand how it works and how to configure it for different u…
108
Complete Project Requirements for Azure Synapse Link | 2026 Guide
Are you ready to harness the power of Azure Synapse Link for real-time analytics? In this video, we break down project r…
109
Master Cosmos DB Creation | Step by Step Guide 2026
Unlock the power of Cosmos DB with our step-by-step guide! Learn to create a Cosmos DB service and configure it for opti…
110
Ultimate Guide to Data Preparation for Azure Synapse 2026
Master the art of data preparation for real-time processing using Azure Synapse! This comprehensive guide will walk you …
111
Querying Data with Serverless SQL Pool In Azure Synapse
Learn how to query real-time data stored in Cosmos DB using Serverless SQL Pool. Understand how to use SQL queries to an…
112
Querying Data with Spark Pool
Learn how to query real-time data stored in Cosmos DB using Spark. Understand how to write Spark jobs to process and ana…
113
Overview of Dedicated SQL Pool in Azure Synapse 2026
Gain a quick yet comprehensive overview of the Dedicated SQL Pool in Azure Synapse. Perfect for those looking to optimiz…
114
Understanding Dedicated SQL Pool
Explore the architecture and components of Dedicated SQL Pool. Understand how to configure and manage Dedicated SQL Pool…
115
Creating a Dedicated SQL Pool
Learn how to create a Dedicated SQL Pool in Azure Synapse Analytics. Understand how to configure the pool size, compute …
116
Project Requirements for Dedicated SQL Pool
Learn how to identify the use cases for Dedicated SQL Pool in a specific project. Understand the data requirements and p…
117
Copying Data to Dedicated Pool Using Polybase
Learn how to use Polybase to copy data from external sources, such as Azure Blob Storage or Azure Data Lake Storage, int…
118
Copying Data to Dedicated Pool Using the COPY Command
Learn how to use the COPY command to copy data from external sources into Dedicated SQL Pool. Understand the different o…
119
Connecting to Dedicated SQL Pool from Azure Data Studio and Power BI
Learn how to connect to Dedicated SQL Pool from Azure Data Studio and Power BI. Understand how to query data, create rep…