Table of Contents
About the Authors
About the Technical Reviewer
Acknowledgments
Introduction
Part I: The Basics
Chapter 1: Azure Basics
The Different Cloud Service Models
Infrastructure as a Service (IaaS)
Platform as a Service (PaaS)
Software as a Service (SaaS)
Cloud Model Responsibilities
The Structure of Microsoft Azure
Azure Geographies
Azure Regions
Azure Availability Zones
Azure Account
Azure Subscription
Azure Resource Groups
Azure Resource Manager
Creating and Naming the Resources
Creating Resources
Naming Resources
Overview of Data Services
Data Categories
Azure Data Services
Summary
Chapter 2: Serverless Computing
Cloud Software Delivery
Serverless Delivery
The Cost of Perfection
Handling Data
Chapter 3: Data-Driven Applications
ETL the Classic Way
Transformation: What Does That Mean?
Different Data Models for Different Applications
OLTP: The Relational Model
Table
Key
Relationship
OLAP: Star and Snowflake Schemas
Modern Data Warehouses and Data Applications
Part II: Hands-On
Chapter 4: Azure Functions
The Flavors of Azure Functions
Triggers and Bindings
Creating Your First Azure Function
Creating the Azure Resources
Creating the Function
A Look at the Code
Testing the Function
Deploying Your Function
Handling State
The Basics
The Code
Running It in the Cloud
Chapter 5: Logic Apps
Principles of Code-Free Implementation
Creating a Logic App
The Logic Apps UI
Chapter 6: Azure Data Factory
The Building Blocks of ADF
Working with Azure Data Factory
Creating an ADF Using Azure CLI
Preparing Resources
Creating a Pipeline
Parametrizing Your Pipeline
Creating a Data Flow
Best Practices
Using Git
Using Azure Key Vault
Chapter 7: Database and Storage Options
Relational and Non-Relational Data Explained
Storage Accounts
Storage Account Basics
Creating a Storage Account
Using Azure Table Storage
Azure Queue Storage
Cosmos DB
Use Cases for Cosmos DB Accounts
Azure SQL DB Serverless
Creating a Serverless SQL Database
When to Choose What?
Chapter 8: IoT Hub, Event Hub, and Streaming Data
IoT Hub
Event Hub
Service Bus
Stream Analytics
Chapter 9: Power BI
Power BI Service and Power BI Desktop
Building Data Visualizations with Power BI Reports
Visualizing Data Streams
Sharing Content
Licensing of Power BI
Part III: Design Practices
Chapter 10: Achieving Resiliency
What Is Resiliency?
How Is Resiliency Ensured?
Different Areas to Be Resilient
Patterns That Support Resiliency
Choosing the Right Services for Resiliency
Achieving Resiliency
Chapter 11: Queues, Messages, and Commands
Messages
Events
Commands
Scenarios for Events and Commands
Implementing the Scenario
Chapter 12: Processing Streams of Data
Streaming Data—What Is It About?
Stream Processing: Lambda Architecture
Implementing a Lambda Architecture in Azure
There’s More…
Chapter 13: Monitoring Serverless Applications
Monitoring and Alerting
Serverless and Monitoring
Implementing Monitoring
Implementing Alerting
Part IV: Putting It All Together
Chapter 14: Tools and Helpers
Visual Studio Code
Azure Data Studio
Docker / Docker Desktop
Azure CLI
PowerShell
Bicep / ARM Templates
Azure Storage Explorer
Azure DevOps
dbatools
Azure Quickstart Templates
Git
Git Kraken
Chocolatey
Azure Data Community
Useful Visual Studio Code Plugins
Chapter 15: Data-Loading Patterns
Data-Loading Patterns for Flat Files
Data-Loading Patterns for REST APIs
Data-Loading Patterns for Databases
Data-Loading Patterns for Data Streams
Chapter 16: Data Storage Patterns
Relational Databases
Storage Accounts
Non-Relational Databases
Chapter 17: Architecture for a Modern Data-Driven Application
REST API, Tracking & Transaction Data
Communicating with the Shops
Data Warehousing and Analytics
Index