You're reading from Cloud Scale Analytics with Azure Data Services Build modern data warehouses on Microsoft Azure

Product type Paperback

Published in Jul 2021

Publisher Packt

ISBN-13 9781800562936

Length 520 pages

Edition 1st Edition

Tools

Azure

Concepts

Data Streaming

Author (1):

Patrik Borosch

View More author details

Table of Contents (20) Chapters

Preface

1. Section 1: Data Warehousing and Considerations Regarding Cloud Computing

2. Chapter 1: Balancing the Benefits of Data Lakes Over Data Warehouses FREE CHAPTER

3. Chapter 2: Connecting Requirements and Technology

4. Section 2: The Storage Layer

5. Chapter 3: Understanding the Data Lake Storage Layer

6. Chapter 4: Understanding Synapse SQL Pools and SQL Options

7. Section 3: Cloud-Scale Data Integration and Data Transformation

8. Chapter 5: Integrating Data into Your Modern Data Warehouse

9. Chapter 6: Using Synapse Spark Pools

10. Chapter 7: Using Databricks Spark Clusters

11. Chapter 8: Streaming Data into Your MDWH

12. Chapter 9: Integrating Azure Cognitive Services and Machine Learning

13. Chapter 10: Loading the Presentation Layer

14. Section 4: Data Presentation, Dashboarding, and Distribution

15. Chapter 11: Developing and Maintaining the Presentation Layer

16. Chapter 12: Distributing Data

17. Chapter 13: Introducing Industry Data Models

18. Chapter 14: Establishing Data Governance

19. Other Books You May Enjoy

Chapter 4: Understanding Synapse SQL Pools and SQL Options

In this chapter, you will learn what Massively Parallel Processing (MPP) means in terms of a cloud PaaS database service. You will examine the concepts of distributing and replicating data in a database. Furthermore, you will see how to manage the workload in this database to your benefit by avoiding early scaling and leveraging all the performance capabilities of the service. Partitioning will extend your options when it comes to massive amounts of data when you need to grow from terabytes to petabytes. You will also learn how to load data efficiently into your database service.

Finally, we will have a look at the next evolutionary steps of the SQL pools in Azure Synapse and other SQL components, such as SQL on-demand compute.

At the end, we will compare other SQL database services and their options in Azure and how they may fit into your architecture.

You will find the following sections covered in this chapter...