Skills Pragati
YouTube
IntermediateEnglish

Learn Azure Synapse Step By Step With Project

Azure Synapse Analytics end to end: workspace and Studio hubs, data lakes vs warehouses, pipelines, SQL pools and Spark, with a project.

  • 120 videos
  • 11.6 h of video
  • VideosFree on YouTube
  • Hands-on labNot for this course
  • Practice simulationNot for this course
  • Mock examNot for this course
Open the playlist on YouTube

Plays the full course playlist from YouTube in privacy-enhanced mode. Nothing loads from YouTube until you press play.

About this course

Learn Azure Synapse Step By Step Playlist

Course videos

All 120 videos, in order

Playlist on YouTube
  1. 14:11Learn Azure Synapse Step By Step With Project - Course IntroductionOverview
  2. 22:2001 Introduction to Azure Synapse AnalyticsHands-on
  3. 34:41Data Warehouse Vs. Data LakesHands-on
  4. 49:07Inception of Azure Synapse AnalyticsHands-on
  5. 510:48Create Synapse Analytics Workspace LabHands-on
  6. 65:05Azure Synapse Workspace OverviewHands-on
  7. 77:59Azure Synapse Studio OverviewHands-on
  8. 87:59Data Hub OverviewHands-on
  9. 95:19Develop Hub OverviewHands-on
  10. 102:41Integrate Hub OverviewHands-on
  11. 112:20Monitor Hub OverviewHands-on
  12. 124:39Manage Hub OverviewHands-on
  13. 131:04Project OverviewHands-on
  14. 145:19Project DataSet OverviewHands-on
  15. 152:47Project Data File Types OverviewHands-on
  16. 166:29Import Project Data to Data LakeHands-on
  17. 173:17Project Requirements OverviewHands-on
  18. 185:38Synapse Project - Solution Architecture Overview (Medallion Architecture)Hands-on
  19. 190:59Serverless SQL Pool OverviewHands-on
  20. 208:08Serverless SQL Pool IntroductionHands-on
  21. 2110:04Serverless SQL Pool Cost ControlHands-on
  22. 228:08Connect Azure SQL Pool Using Azure StudioHands-on
  23. 232:09How to use Serverless SQL Pool to Query CSV Files OverviewHands-on
  24. 244:02OPENROWSET Function OverviewHands-on
  25. 257:39Query Taxi Zone CSV File in SynapseHands-on
  26. 267:05How to Specify the DataType in SynapseHands-on
  27. 275:36How to Specify Collation in SynapseHands-on
  28. 287:39How To Query Query Subset Of Columns in SynapseHands-on
  29. 292:13How To Do Debugging and Identifying Errors in SynapseHands-on
  30. 308:15How to Use External Data Source in SynapseHands-on
  31. 318:17Query Calendar File CSV File in SynapseHands-on
  32. 326:01How To Query Quoted And Escaped Columns In SynapseHands-on
  33. 332:30How to Query Tab separated File In SynapseHands-on
  34. 343:23How to Query JSON Serverless SQL Pool In SynapseHands-on
  35. 357:30How To Query Single Line JSON in Serverless SQL Pool in SynapseHands-on
  36. 365:32How to Use OpenJSON Function In SynapseHands-on
  37. 378:15How To Query JSON Array In SynapseHands-on
  38. 384:45How to Query Standard JSON In SynapseHands-on
  39. 392:10How To Query MultiLine JSON In SynapseHands-on
  40. 407:49How To Query Folder And MultipleFiles In SynapseHands-on
  41. 419:27How To Use File Metadata Functions In SynapseHands-on
  42. 427:52How To Query ParquetHands-on
  43. 433:59How To Query Folders and Sub Folders Of Parquet Columnar Format Data In SynapseHands-on
  44. 4411:12How To Query Delta Files In SynapseHands-on
  45. 453:14How to Data Discovery using Serverless SQL Pool In SynapseHands-on
  46. 465:02How To Identify Duplicate Data In SynapseHands-on
  47. 478:37How To do Data Quality Check In SynapseHands-on
  48. 487:45How To Join Files In SynapseHands-on
  49. 495:25How to Transform Data In SynapseHands-on
  50. 506:28Learning Task Data DiscoveryHands-on
  51. 513:55Understand Data Virtualization ConceptHands-on
  52. 528:30Understand External Tables In SynapseHands-on
  53. 5318:45How To Create External Table In SynapseHands-on
  54. 5414:19How To Handle Invalid Records In SynapseHands-on
  55. 556:47Learning Assignment Create External Table For CSVHands-on
  56. 564:34How to Create External Table For Parquet In SynapseHands-on
  57. 573:22How To Create External Table Delta In SynapseHands-on
  58. 582:57Understand Views In SynapseHands-on
  59. 596:19Create View For JSON Files In SynapseHands-on
  60. 602:14How To Create View for JSON files Learning AssignmentHands-on
  61. 618:20Understand Partition Pruning In SynapseHands-on
  62. 620:52Data Ingestion Overview - SynapseHands-on
  63. 635:09Data Transformation In SynapseHands-on
  64. 647:24How To Transform To Parquet - In SynapseHands-on
  65. 652:05Transform to Parquet Learning AssignmentHands-on
  66. 662:51Transform JSON to Parquet In SynapseHands-on
  67. 672:05Transform JSON To Parquet Learning AssignmentHands-on
  68. 684:26How To Transform to Parquet Format Partitioned Files In SynapseHands-on
  69. 693:09Stored Procedure IntroductionHands-on
  70. 704:03Transform partitioned Data Solution In SynapseHands-on
  71. 7112:47How To Transform Partitioned Data Learning TaskHands-on
  72. 723:34Create View Learning AssignmentHands-on
  73. 730:37Data Transformation What we will learn In SynapseHands-on
  74. 745:34Learning Task Project Requirement - Data Transformation In SynapseHands-on
  75. 7510:53Select Statement In SynapseHands-on
  76. 765:52Using Stored Procedure In SynapseHands-on
  77. 773:53Create View For Transformation In SynapseHands-on
  78. 787:06Learning Assignment - Applying Transformation Techniques to a Project In SynapseHands-on
  79. 791:14Synapse Pipeline OverviewHands-on
  80. 803:28Understanding Synapse Pipeline ComponentsHands-on
  81. 813:13Designing Transformation Pipelines In SynapseHands-on
  82. 828:39Create Linked Service & Dataset In SynapseHands-on
  83. 836:40Create Pipeline - Delete Activity In SynapseHands-on
  84. 848:06Create Pipeline - Script Activity In SynapseHands-on
  85. 855:09Using the Stored Procedure Activity in Synapse PipelinesHands-on
  86. 863:50Understanding Parameters and Variables In Azure Synapse PipelinesHands-on
  87. 878:23Azure Synapse Parameters & Variables LABHands-on
  88. 889:47Understanding Dynamic Pipeline In Azure SynapseHands-on
  89. 892:41Designing Pipelines for Partitioned Files In Azure SynapseHands-on
  90. 9010:13Creating Pipelines for Partitioned Files: Delete Activity In Azure SynapseHands-on
  91. 917:19Creating Pipelines for Partitioned Files: Stored Procedure and Script Activity In Azure SynapseHands-on
  92. 925:29Pipeline Dependencies In Azure SynapseHands-on
  93. 934:45Setting Up Manual Trigger In Azure SynapseHands-on
  94. 947:31Setting Up Automated Triggers In Azure SynapseHands-on
  95. 952:49Create Pipeline Partitioned File Assignment Gold TableHands-on
  96. 960:48Spark Pool - Section OverviewHands-on
  97. 977:03Understanding Spark PoolHands-on
  98. 988:39Create Spark Pool LABHands-on
  99. 9910:38Notebooks Overview In Azure SynapseHands-on
  100. 1003:55Integrating Spark Pool and Serverless SQL Pool In Azure SynapseHands-on
  101. 10110:27Hands-on: Integrating Spark Pool and Serverless SQL Pool In Azure SynapseHands-on
  102. 1026:16Using Notebooks in Synapse PipelinesHands-on
  103. 1033:00Power BI Integration OverviewHands-on
  104. 1046:56Connecting to Synapse Data from Power BI DesktopHands-on
  105. 1056:40Creating Reports with Synapse Data (Report 1)Hands-on
  106. 1063:07Creating Reports with Synapse Data (Report 2)Hands-on
  107. 1070:50Synapse Link - Section OverviewHands-on
  108. 1086:55Understanding Synapse LinkHands-on
  109. 1093:05Complete Project Requirements for Azure Synapse LinkHands-on
  110. 1105:31Master Cosmos DB CreationHands-on
  111. 1118:41Ultimate Guide to Data Preparation for Azure Synapse 2026Hands-on
  112. 1127:05Querying Data with Serverless SQL Pool In Azure SynapseHands-on
  113. 1135:07Querying Data with Spark PoolHands-on
  114. 1140:51Overview of Dedicated SQL Pool in Azure Synapse 2026Hands-on
  115. 1157:24Understanding Dedicated SQL PoolHands-on
  116. 1166:00Creating a Dedicated SQL PoolHands-on
  117. 1173:53Project Requirements for Dedicated SQL PoolHands-on
  118. 11810:50Copying Data to Dedicated Pool Using PolybaseHands-on
  119. 1196:22Copying Data to Dedicated Pool Using the COPY CommandHands-on
  120. 1203:11Connecting to Dedicated SQL Pool from Azure Data Studio and Power BIHands-on
Related articles

Read it step by step

More in Data & Fabric

DP-600Associate

Analytics Engineering with Microsoft Fabric

Build a sales performance platform end to end in Fabric: Dataflow Gen2, warehouse and lakehouse star schemas, KQL, a Direct Lake semantic model, DAX, security and deployment pipelines.

  • Hands-on lab
  • Practice sim
  • Mock exam

34 videos3.5 h11 practice labs

DP-700Associate

Data Engineering with Microsoft Fabric

Build a medallion data platform on New York taxi data: pipelines, shortcuts and mirroring, PySpark, a dimensional warehouse, orchestration, three kinds of streaming, security and governance.

  • Hands-on lab
  • Practice sim
  • Mock exam

42 videos8.7 h16 practice labs

Watch on YouTube