Create and query a dedicated SQL pool in Azure using SSMS

Create and query a dedicated SQL pool in Azure using SSMS, available at $39.99, with 12 lectures, and has 504 subscribers.

You will learn about Create a free Azure Subscription Create a Synapse Workspace Create a dedicated SQL Pool Create a server-level firewall rule Install SQL Server Management Studio Connect to dedicated SQL Pool using SSMS Query a dedicated SQL Pool This course is ideal for individuals who are Beginner Data Engineers or Beginner Data Scientist or Beginner Data Analyst It is particularly useful for Beginner Data Engineers or Beginner Data Scientist or Beginner Data Analyst.

Enroll now: Create and query a dedicated SQL pool in Azure using SSMS

Summary

Title: Create and query a dedicated SQL pool in Azure using SSMS

Price: $39.99

Number of Lectures: 12

Number of Published Lectures: 12

Number of Curriculum Items: 12

Number of Published Curriculum Objects: 12

Original Price: $24.99

Quality Status: approved

Status: Live

What You Will Learn

Create a free Azure Subscription

Create a Synapse Workspace

Create a dedicated SQL Pool

Create a server-level firewall rule

Install SQL Server Management Studio

Connect to dedicated SQL Pool using SSMS

Query a dedicated SQL Pool

Who Should Attend

Beginner Data Engineers

Beginner Data Scientist

Beginner Data Analyst

Target Audiences

Beginner Data Engineers

Beginner Data Scientist

Beginner Data Analyst

Azure Synapse Dedicated SQL Pool (previously Azure SQL Data Warehouse), is a massively parallel processing database similar to other columnar-based, scale-out database technologies such as Snowflake, Amazon Redshift, and Google BigQuery.

Dedicated SQL pool (formerly SQL DW) stores data in relational tables with columnar storage. This format significantly reduces the data storage costs, and improves query performance. Once data is stored, you can run analytics at massive scale. Compared to traditional database systems, analysis queries finish in seconds instead of minutes, or hours instead of days. 

The analysis results can go to worldwide reporting databases or applications. Business analysts can then gain insights to make well-informed business decisions.

Azure Synapse Analytics is an analytics service that brings together enterprise data warehousing and Big Data analytics. Dedicated SQL pool (formerly SQL DW) refers to the enterprise data warehousing features that are available in Azure Synapse Analytics.

Dedicated SQL pool (formerly SQL DW) represents a collection of analytic resources that are provisioned when using Synapse SQL. The size of a dedicated SQL pool (formerly SQL DW) is determined by Data Warehousing Units (DWU).

Once your dedicated SQL pool is created, you can import big data with simple PolyBase T-SQL queries, and then use the power of the distributed query engine to run high-performance analytics. As you integrate and analyze the data, dedicated SQL pool (formerly SQL DW) will become the single version of truth your business can count on for faster and more robust insights.

Course Curriculum

Chapter 1: Azure Setup

Lecture 1: Introduction

Lecture 2: What is Azure

Lecture 3: Create a free Azure Subscription Account

Lecture 4: How to access Azure Services

Chapter 2: Connect and Query A Dedicated SQL Pool

Lecture 1: What is a dedicated SQL Pool

Lecture 2: What is Synapse Analytics

Lecture 3: Install SQL Server Management Studio -SSMS

Lecture 4: Create a Synapse workspace

Lecture 5: Create a dedicated SQL pool

Lecture 6: Create a server-level firewall rule

Lecture 7: Connect to the server as server admin

Lecture 8: Query a dedicated SQL Pool

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 0 votes

4 stars: 0 votes

5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!