Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Cart
Close icon
You have no products in your basket yet
Save more on your purchases!
Savings automatically calculated. No voucher code required
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Home > Data > Database Administration > Azure SQL Data Warehouse Synapse Analytics Service [Video]
Azure SQL Data Warehouse Synapse Analytics Service [Video]
Azure SQL Data Warehouse Synapse Analytics Service [Video]

Azure SQL Data Warehouse Synapse Analytics Service: Learn Cloud Data Warehouse in Azure Synapse Analytics Service (Formerly Azure SQL Data Warehouse) [Video]

By Eshant Garg
$54.99
Full star icon Full star icon Full star icon Full star icon Full star icon 5 (1 Ratings)
Video Mar 2022 6 hours 28 minutes 1st Edition
Video
$54.99
Subscription
$15.99 Monthly
Video
$54.99
Subscription
$15.99 Monthly

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Buy Now
Table of content icon View table of contents Download code icon Download Code

Key benefits

  • Learn security, configuration, backup, monitoring, and other important topics
  • Learn different migration techniques and advantages of PolyBase over other techniques
  • Learn with the help of demos and real-world assignments

Description

Welcome to Azure Synapse Analytics Service (formerly Azure SQL Data Warehouse). In this course, we will start with understanding what Azure Synapse Analytics service is and then understand traditional versus modern versus synapse data warehouse architecture. Next, you will learn why Microsoft Synapse Analytics will be a game-changer in the data analytics space and learn how to set up the Azure Synapse Analytics service, customize it, and grow it. Then, you will learn about the cloud data warehouse MPP architecture, table types, partitioning, distribution keys, and a variety of other crucial concepts. As we progress through the course, you will learn about different migration procedures and the advantages of PolyBase over other ways, as well as security, setup, backups, monitoring, and other important topics through a variety of demos. By the end of this course, you will have a thorough grasp of Synapse Service and will be able to operate in a production setting right away. The complete code bundle for this course is available at https://github.com/PacktPublishing/Azure-SQL-Data-Warehouse-Synapse-Analytics-Service

What you will learn

Get introduced to Microsoft Synapse Analytics Service Differences between traditional, modern, and synapse architecture Learn about MPP, partitioning, sharding patterns, and distribution keys Understand what is PolyBase, data migration, and security Learn about configuration, backups, pricing, monitoring Learn the fundamentals of Microsoft SQL Data Warehouse

Product Details

Country selected
Publication date : Mar 21, 2022
Length 6 hours 28 minutes
Edition : 1st Edition
Language : English
ISBN-13 : 9781803233178
Vendor :
Microsoft
Category :
Data
Concepts :
Database Administration
Tools :
Azure (Beginner)

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Buy Now

Product Details

Publication date : Mar 21, 2022
Length 6 hours 28 minutes
Edition : 1st Edition
Language : English
ISBN-13 : 9781803233178
Vendor :
Microsoft
Category :
Data
Concepts :
Database Administration
Tools :
Azure (Beginner)

Table of Contents

7 Chapters
1. Course Introduction Chevron down icon Chevron up icon
Why You Should Buy This Course?
Course Introduction
2. Azure Synapse Analytics (Updated Dec 2020) Chevron down icon Chevron up icon
Introduction
Why Warehousing in Cloud
Traditional Versus Modern Warehouse Architecture
What is Synapse Analytics Service
Demo: Create Dedicated SQL Pool
Demo: Connect Dedicated SQL Pool with SSMS
Demo: Create Azure Synapse Analytics Studio Workspace
Demo: Explore Synapse Studio V2
Demo: Create Dedicated SQL Pool and Spark Pool
Demo: Analyze Data Using Dedicated SQL Pool
Demo: Analyze Data Using Apache Spark Notebook
Demo: Analyze Data Using Serverless SQL Pool
Demo: Data Factory from Synapse Analytics Studio
Demo: Monitor Synapse Studio
Azure Synapse Benefits
Synapse Unified Experience for All Data Professionals
Summary
3. Data Warehouse Internals and Architecture Chevron down icon Chevron up icon
Introduction
Azure Synapse MPP Architecture
Storage and Sharding Patterns
Data Distribution and Distributing Keys
Data Types and Table Types
Partitioning
Best Practices for Fact and Dimension Tables
Demo - Analyze Data Distribution Before Migration to Azure Synapse
Summary
4. Data Migration Chevron down icon Chevron up icon
Introduction
Five Best Practices for Data Load
Different Loading Methods
Loading with SSIS Versus PolyBase
Demo - Loading with SSIS
Demo - Loading with PolyBase
Demo Loading with Data Factory
Summary
Assignment - Lab Request
Assignment - Lab Solution
5. Security Layers Chevron down icon Chevron up icon
Introduction
Advance Data Security
Auditing
Network Security
Transparent Data Encryption
Dynamic Data Masking
Access Management
Summary
6. Configuring and Optimizing Chevron down icon Chevron up icon
Introduction
Configuration Options
Performing Other Common Tasks
Backup and Restore
Price Optimization
Monitoring
Support and Troubleshooting
Managing Workloads
Delete Resource
Summary
7. Data Warehouse Crash Course Chevron down icon Chevron up icon
Introduction
What is Data Warehouse
Why We Need Data Warehouse
Ideal Data Warehouse Solution
Responsibility of Data Warehouse Designer
SQL Server (OLTP) Versus Data Warehouse (OLAP)
Dimensional Modelling
Facts and Fact Table
Dimensions and Dimension Table
Star Versus Snowflake
Summary

Recommendations for you

Left arrow icon
Building LLM Powered Applications
Building LLM Powered Applications
Read more
May 2024 342 pages
ebook
eBook
  • ebook eBook $39.99
  • print Print $49.99
$39.99
$49.99
Machine Learning with PyTorch and Scikit-Learn
Machine Learning with PyTorch and Scikit-Learn
Read more
Feb 2022 774 pages
Full star icon 5
ebook
eBook
  • ebook eBook $43.99
  • print Print $54.99
$43.99
$54.99
Transformers for Natural Language Processing and Computer Vision
Transformers for Natural Language Processing and Computer Vision
Read more
Feb 2024 728 pages
ebook
eBook
  • ebook eBook $43.99
  • print Print $54.99
$43.99
$54.99
The Definitive Guide to Power Query (M)
The Definitive Guide to Power Query (M)
Read more
Mar 2024 758 pages
ebook
eBook
  • ebook eBook $43.99
  • print Print $54.99
$43.99
$54.99
Building Smart Chatbots with LangChain
Building Smart Chatbots with LangChain
Read more
Jun 2024 4h 15m
video Video
$298.99
The Machine Learning Solutions Architect Handbook
The Machine Learning Solutions Architect Handbook
Read more
Apr 2024 602 pages
ebook
eBook
  • ebook eBook $32.99
  • print Print $40.99
$32.99
$40.99
Microsoft Azure AI Fundamentals AI-900 Exam Guide
Microsoft Azure AI Fundamentals AI-900 Exam Guide
Read more
May 2024 288 pages
ebook
eBook
  • ebook eBook $35.99
  • print Print $44.99
$35.99
$44.99
Generative AI with LangChain
Generative AI with LangChain
Read more
Dec 2023 360 pages
Full star icon 3
ebook
eBook
  • ebook eBook $39.99
  • print Print $39.98
$39.99
$39.98 $49.99
Mastering NLP from Foundations to LLMs
Mastering NLP from Foundations to LLMs
Read more
Apr 2024 340 pages
ebook
eBook
  • ebook eBook $42.99
  • print Print $52.99
$42.99
$52.99
Python Data Cleaning Cookbook
Python Data Cleaning Cookbook
Read more
May 2024 486 pages
ebook
eBook
  • ebook eBook $39.99
  • print Print $49.99
$39.99
$49.99
Right arrow icon

Customer reviews

Top Reviews
  • Top Reviews
  • Most Recent
Rating distribution
Full star icon Full star icon Full star icon Full star icon Full star icon 5
(1 Ratings)
5 star 100%
4 star 0%
3 star 0%
2 star 0%
1 star 0%
Filter icon Filter
Top Reviews
  • Top Reviews
  • Most Recent

Filter reviews by

Lars Ørum Hansen Jun 8, 2022
Full star icon Full star icon Full star icon Full star icon Full star icon 5
hi quality, comes all around
Feefo Verified review Feefo image

People who bought this also bought

Left arrow icon
Machine Learning with PyTorch and Scikit-Learn
Machine Learning with PyTorch and Scikit-Learn
Read more
Feb 2022 774 pages
Full star icon 5
ebook
eBook
  • ebook eBook $9.99
  • print Print $54.99
$9.99 $43.99
$54.99
Machine Learning for Time-Series with Python
Machine Learning for Time-Series with Python
Read more
Oct 2021 370 pages
ebook
eBook
  • ebook eBook $9.99
  • print Print $54.99
$9.99 $43.99
$54.99
Modern Time Series Forecasting with Python
Modern Time Series Forecasting with Python
Read more
Nov 2022 552 pages
Full star icon 5
ebook
eBook
  • ebook eBook $9.99
  • print Print $52.99
$9.99 $42.99
$52.99
Deep Learning with TensorFlow and Keras – 3rd edition
Deep Learning with TensorFlow and Keras – 3rd edition
Read more
Oct 2022 698 pages
Full star icon 5
ebook
eBook
  • ebook eBook $9.99
  • print Print $49.99
$9.99 $39.99
$49.99
Hands-On Data Preprocessing in Python
Hands-On Data Preprocessing in Python
Read more
Jan 2022 602 pages
Full star icon 5
ebook
eBook
  • ebook eBook $9.99
  • print Print $54.99
$9.99 $43.99
$54.99
Azure SQL Data Warehouse Synapse Analytics Service
Azure SQL Data Warehouse Synapse Analytics Service
Read more
Mar 2022 6h 28m
video Video
$9.99 $54.99
Right arrow icon

About the author

Left arrow icon
Profile icon Eshant Garg
LinkedIn
Eshant Garg has 16 years of extensive professional experience with expertise in database and business intelligence solutions, advanced analytics, design and solution architecture, reporting, and cloud computing technologies (Azure and AWS). He loves to explain complicated things in a simple and effective way. As a developer and architect, he has worked closely with customers, users, and colleagues to support business solutions across a variety of industries including healthcare, insurance, finance, and government ranging from small companies to Fortune 500 companies. Outside of the technical world, he loves yoga and meditation. He is a student of the ancient yogic text, the Bhagavad Gita, and loves to discuss and practice philosophical teachings.
Read more
See other products by Eshant Garg
Right arrow icon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How can I download a video package for offline viewing? Chevron down icon Chevron up icon
  1. Login to your account at Packtpub.com.
  2. Click on "My Account" and then click on the "My Videos" tab to access your videos.
  3. Click on the "Download Now" link to start your video download.
How can I extract my video file? Chevron down icon Chevron up icon

All modern operating systems ship with ZIP file extraction built in. If you'd prefer to use a dedicated compression application, we've tested WinRAR / 7-Zip for Windows, Zipeg / iZip / UnRarX for Mac and 7-Zip / PeaZip for Linux. These applications support all extension files.

How can I get help and support around my video package? Chevron down icon Chevron up icon

If your video course doesn't give you what you were expecting, either because of functionality problems or because the content isn't up to scratch, please mail customercare@packt.com with details of the problem. In addition, so that we can best provide the support you need, please include the following information for our support team.

  1. Video
  2. Format watched (HTML, MP4, streaming)
  3. Chapter or section that issue relates to (if relevant)
  4. System being played on
  5. Browser used (if relevant)
  6. Details of support
Why can’t I download my video package? Chevron down icon Chevron up icon

In the even that you are having issues downloading your video package then please follow these instructions:

  1. Disable all your browser plugins and extensions: Some security and download manager extensions can cause issues during the download.
  2. Download the video course using a different browser: We've tested downloads operate correctly in current versions of Chrome, Firefox, Internet Explorer, and Safari.