Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Create and query a dedicated SQL pool in Azure using SSMS
Rating: 5.0 out of 5(1 rating)
505 students

Create and query a dedicated SQL pool in Azure using SSMS

Step-by-Step Guide to Creating and Querying Azure SQL Pools
Created byBluelime Learning Solutions
Last updated 3/2026
English

What you'll learn

  • Understand what Microsoft Azure is and how it fits into modern cloud computing.
  • Understand what Azure Synapse Analytics is and how it supports big data workloads.
  • Install and configure SQL Server Management Studio (SSMS) on a local machine.
  • Create a Synapse workspace to begin working with data analytics in Azure.
  • Deploy a dedicated SQL pool within your Synapse workspace.
  • Set up a server-level firewall rule to securely access your Azure SQL resources
  • Connect to an Azure SQL server using SSMS as a server admin.
  • Execute and manage SQL queries against your dedicated SQL pool using SSMS.
  • Retrieve and analyze data stored in Azure using T-SQL and query tools.
  • Recognize the importance of SQL Server in enterprise-level data solutions.
  • Build foundational skills to explore more advanced cloud data analytics and Azure Synapse features.

Course content

3 sections • 15 lectures • 56m total length

  • Introduction0:20
  • What is Azure3:15
  • Create a free Azure Subscription Account5:43
  • How to access Azure Services1:45

Requirements

  • Microsoft Azure account (We’ll show you how to set up a free Azure subscription in the course.)
  • Basic computer literacy (You should be comfortable navigating your computer and installing software.)
  • Familiarity with basic SQL (If you’ve written simple SELECT queries or worked with a relational database before, you’re good to go.)
  • Some exposure to cloud computing or Azure is helpful, but not required (We’ll walk you through account setup and navigation.)
  • A laptop or desktop computer (Windows is recommended for best compatibility with SSMS, but the course can still be followed on macOS with alternatives.)
  • Stable internet connection (You'll need this to access Azure services and download software.)
  • SQL Server Management Studio (SSMS) (Free software used to connect to and query your Azure SQL resources — installation covered in the course.)

Description

Are you ready to take your data skills to the cloud? This hands-on course will guide you step by step through creating and querying a dedicated SQL pool in Microsoft Azure using SQL Server Management Studio (SSMS) — one of the most in-demand skill sets in data analytics and engineering today.

Whether you're a student, aspiring data professional, or tech enthusiast, this course is designed to give you a practical introduction to cloud-based data warehousing and querying with Microsoft’s powerful tools: Azure Synapse Analytics and SSMS.

We begin with the basics: what is Azure, and how can you access it? You’ll learn how to set up a free Azure subscription, navigate the Azure portal, and explore the services available. Next, we dive into Synapse Analytics, where you’ll understand the role of dedicated SQL pools — scalable cloud-based data warehouses designed to handle massive amounts of data efficiently.

You’ll get hands-on with the SQL Server Management Studio (SSMS), a popular desktop application for writing and executing SQL queries. You'll install and configure SSMS, connect it to your dedicated SQL pool, and run queries to retrieve and manage data — all in real time.

In this course, you will:

  • Create and configure a Synapse workspace

  • Set up a dedicated SQL pool to store and process large datasets

  • Establish server-level firewall rules to allow secure access

  • Connect to your SQL pool using SSMS as a server admin

  • Write and execute SQL queries using T-SQL

  • Understand how Azure handles data at scale

  • Learn the importance of SQL Server in enterprise data environments

We explain every step with clear, beginner-friendly guidance — no prior experience with Azure or cloud platforms is required. By the end of the course, you'll have the skills and confidence to set up a dedicated SQL pool, connect and manage it using SSMS, and run queries that give you real insights from data.

What You’ll Gain:

  • Real-world experience with Azure Synapse Analytics

  • Hands-on practice using SSMS to manage and query cloud data

  • A strong foundation in cloud-based SQL environments

  • The confidence to continue exploring Azure and cloud data engineering

If you want to gain a future-ready skillset by working with real cloud tools, this course is the perfect starting point.

Who this course is for:

  • A beginner or aspiring data professional who wants to learn how to set up and query cloud-based SQL data warehouses
  • A student, IT enthusiast, or self-learner looking to build real-world skills in cloud data platforms
  • A business analyst or reporting professional wanting to understand how to connect and run SQL queries in Azure
  • A developer or database admin exploring Microsoft Azure’s data services for the first time
  • A data engineer in training preparing to work with Azure Synapse and large-scale data infrastructure
  • A project manager or team lead who wants technical insight into how modern cloud-based analytics solutions are built and queried

Report abuse