What You Need to Know Before
You Start

Starts 6 July 2025 13:59

Ends 6 July 2025

00 Days
00 Hours
00 Minutes
00 Seconds
course image

Unlocking The Data Lake With Azure Synapse SQL Serverless

Join this insightful session on utilizing Azure Synapse's SQL Serverless to revolutionize how you handle data in Azure data lakes. This event is ideal for professionals looking to excel in handling extensive datasets effortlessly. Throughout the session, you'll learn practical techniques to harness T-SQL for powerful data analysis, business in.
PASS Data Community Summit via YouTube

PASS Data Community Summit

2825 Courses


58 minutes

Optional upgrade avallable

Not Specified

Progress at your own speed

Conference Talk

Optional upgrade avallable

Overview

Join this insightful session on utilizing Azure Synapse's SQL Serverless to revolutionize how you handle data in Azure data lakes. This event is ideal for professionals looking to excel in handling extensive datasets effortlessly.

Throughout the session, you'll learn practical techniques to harness T-SQL for powerful data analysis, business intelligence tasks, and machine learning applications, all at a scale capable of managing petabytes of data. Elevate your data processing skills and prepare to transform your organization's data strategies.

Syllabus

  • Introduction to Azure Synapse Analytics
  • Overview of Synapse and its components
    Understanding Azure data lakes
    Introduction to SQL Serverless
  • Setting Up Azure Synapse Environment
  • Creating a Synapse workspace
    Configuring data lake storage
    Security and access management
  • Basics of T-SQL for Synapse
  • Introduction to T-SQL syntax
    Querying data in Azure data lakes
    Exploring metadata and system views
  • Working with SQL Serverless
  • Creating serverless SQL pools
    Understanding resource consumption
    Best practices for query optimization
  • Data Exploration and Transformation
  • Loading and exploring large datasets
    Data transformation techniques
    Using external tables and views
  • Integration with BI Tools
  • Connecting Synapse to Power BI
    Building interactive dashboards
    Analyzing data with visualization techniques
  • Machine Learning with SQL Serverless
  • Integrating ML models in Synapse
    Deploying and managing ML pipelines
    Analyzing model outputs with SQL
  • Advanced Analytics Techniques
  • Performing distributed data processing
    Advanced querying techniques for large datasets
    Utilizing functions and stored procedures
  • Real-world Use Cases
  • Case studies on data analytics with Synapse
    Examples of petabyte-scale data processing
    Lessons learned and best practices
  • Course Conclusion and Next Steps
  • Recap of key concepts
    Resources for continued learning
    Opportunities for certification and further training

Subjects

Conference Talks