Azure Synapse Analytics Tutorial: This playlist guides data professionals through building robust data solutions using Azure Synapse Analytics. It covers data integration, various SQL pool types, Synapse pipelines, data flows, and real-world analytics use cases, making it ideal for data engineers, analysts, and architects
Chapter 1: Introduction to Azure Synapse Analytics
What is Azure Synapse Analytics?
Creating an Azure Synapse Analytics Workspace
Azure Synapse Analytics Billing Explained
Understanding Serverless SQL Pool
Chapter 2: Serverless SQL Pool – File-Based Querying
5. Querying CSV, Parquet, and JSON Files in ADLS Gen2 with Serverless SQL
6. Checking File Schema Using Serverless SQL Pool
7. Using OPENROWSET with Explicit Schema
8. Creating a Serverless SQL Pool Database and External Table
9. Dropping External Tables, Data Sources, File Formats, and Listing Metadata for Auditing
10. Cost Management for Serverless SQL Pool
11. Reading Files from Folders and Subfolders Using Wildcards + Adding FileName & FilePath
12. Creating Views in Azure Synapse Analytics for Serverless SQL Pool
13. Filtering and Sorting Data in Azure Synapse SQL
14. SQL GROUP BY with External Table and CSV File
15. Exporting Data to CSV, JSON or XML & Saving Scripts in Folders
16. Performing JOINs Between Files in Azure Synapse Serverless SQL Pool
17. Creating Stored Procedures in Serverless SQL Pool Database
18. Connecting to Serverless SQL Pool Using SQL Server Management Studio (SSMS)
19. Joining Parquet File with CSV Using OPENROWSET in Serverless SQL Pool
20. Performing Cross-Database Queries Using Serverless SQL Pool
21. Understanding Schema in Azure Synapse Analytics & How to Create It
22. Azure Synapse Serverless SQL Pool Feature Support – What’s Allowed and What’s Not
Chapter 3: Dedicated SQL Pool – Architecture & Development
23. Azure Synapse Analytics Dedicated SQL Pool Overview
24. Creating a Dedicated SQL Pool Database
25. Creating Tables in Dedicated SQL Pool with Distribution Keys
26. Connecting to Synapse Analytics Dedicated SQL Pool Using SSMS, Azure Data Studio, or VS Code
27. Using COPY INTO or Bulk Loading CSV/Parquet Files into Dedicated SQL Pool
28. Creating External Tables in Azure Synapse Dedicated Pool for CSV & Parquet Files
29. Using CTAS (Create Table As Select) in Azure Synapse Analytics
30. CTAS vs SELECT INTO in Azure Synapse Analytics
31. Primary Key & Unique Constraints in Azure Synapse Dedicated SQL Pool
32. Indexing in Azure Synapse Dedicated SQL Pool Explained
33. Understanding IDENTITY Behavior in Azure Synapse SQL Pool
34. Views & Materialized Views in Azure Synapse Dedicated SQL Pool
35. Temporary Tables in Azure Synapse Dedicated SQL Pool
36. Optimizing Query Performance with Statistics in Azure Synapse Dedicated SQL Pool
37. Cost Analysis for Azure Synapse Analytics Components
38. Schemas in Azure Synapse Dedicated SQL Pool
39. Getting Table Size, Row Count & Database Size in Azure Synapse Dedicated SQL Pool
40. Tracking User Activity & SQL Queries Executed in Azure Synapse Dedicated SQL Pool
41. Table Partitioning in Azure Synapse Dedicated SQL Pool
42. Backup and Restore for Dedicated SQL Pools in Azure Synapse Analytics
Chapter 4: Apache Spark Pools & Notebooks
43. What Are Apache Spark Pools in Azure Synapse Analytics
44. Creating and Configuring Spark Pools
45. Creating Your First Azure Synapse Notebook
46. Using Magic Commands in Azure Synapse Notebooks
47. Writing Single CSV, Parquet, JSON Files Using Apache Spark Pool
48. Reading CSV, Parquet & JSON Files Using Apache Spark Pool
49. Incrementally Writing Data to Delta Lake in Azure Synapse Analytics
50. Joining CSV & Parquet Files in PySpark
Chapter 5: Lake Database in Synapse
51. Mounting ADLS Gen2 Storage Using Linked Service
52. Fixing “File Cannot Be Opened” Error in Azure Synapse
53. Writing, Reading & Appending Data to Dedicated SQL Pool Table Using Notebook
54. Reading CSV File & Loading to Dedicated SQL Pool Table Using Apache Spark Pool Notebook
55. Exporting Data from Synapse Dedicated SQL Pool to Single CSV File in ADLS Gen2
56. Lake Database in Azure Synapse: Spark SQL vs Delta vs Parquet
57. Managed vs External Tables in Spark SQL Lake Database
58. Spark Table Formats in Azure Synapse: Parquet, CSV, Delta, JSON, Avro & ORC
59. Delta Table Tutorial in Azure Synapse: Create, Insert, Update, Delete & Merge
60. Querying Tables from Lake Database Using Serverless SQL Pool
61. What Are Views in Lake Databases
62. Reading Lake Database Tables & Views Using PySpark
Chapter 6: Data Pipelines, Data Flows & Integration
63. Introduction to Azure Synapse Pipelines
64. Linked Services, Datasets & Copy Data Tool
65. Creating a Synapse Pipeline to Copy Data from CSV to Dedicated SQL Pool
66. DataFlow vs Copy Activity
67. Creating a Notebook to Join Two CSV Files and Write to Lake Database in Synapse Pipelines
68. Reading Data from Dedicated SQL Pool and Creating CSV in ADLS Gen2
69. What is Azure Data Explorer in Synapse?
TechBrothersIT YouTube Channel is your trusted hub for step-by-step tutorials in data engineering, cloud platforms, and enterprise tools. We cover SQL Server, Azure Data Factory, Databricks, PySpark, GCP Cloud SQL, BigQuery, Kusto Query Language (KQL), and T-SQL. Dive into hands-on guides for SQL Server DBA, SSIS, SSRS, Data Warehousing, Microsoft Dynamics AX, Azure, AWS, and Team Foundation Server. Learn from real-world projects, master interview questions, and sharpen your skills with practical scenarios. Whether you're a data engineer, BI developer, or cloud architect, this channel helps you stay ahead of the curve.