This is the code repository for Data Modeling for Azure Data Services, published by Packt.
Implement professional data design and structures in Azure
Data is at the heart of all applications and forms the foundation of modern data-driven businesses. With the multitude of data-related use cases and the availability of different data services, choosing the right service and implementing the right design becomes paramount to successful implementation.
This book covers the following exciting features:
- Model relational database using normalization, dimensional, or Data Vault modeling
- Provision and implement Azure SQL DB and Azure Synapse SQL Pools
- Discover how to model a Data Lake and implement it using Azure Storage
- Model a NoSQL database and provision and implement an Azure Cosmos DB
- Use Azure Data Factory to implement ETL/ELT processes
- Create a star schema model using dimensional modeling
If you feel this book is for you, get your copy today!
All of the code is organized into folders. For example, Chapter06.
The code will look like the following:
CREATE TABLE [dbo].[Customer]
(
CustomerID INT IDENTITY(1,1) NOT NULL,
CompanyName NVARCHAR(40) NOT NULL,
ContactName NVARCHAR(30) NULL,
ContactTitle NVARCHAR(30) NULL,
Address NVARCHAR(60) NULL,
City NVARCHAR(15) NULL,
Region NVARCHAR(15) NULL,
PostalCode NVARCHAR(10) NULL,
Country NVARCHAR(15) NULL,
Phone NVARCHAR(24) NULL,
Fax NVARCHAR(24) NULL
);
GO
Following is what you need for this book: This book is for business intelligence developers and consultants who work on (modern) cloud data warehousing and design and implement databases. Beginner-level knowledge of cloud data management is expected.
With the following software and hardware list you can run all code files present in the book (Chapter 1-11).
Chapter | Software required | OS required |
---|---|---|
1-11 | Microsoft Azure Account, Azure Data Studio | Windows, Mac OS X, and Linux (Any) |
6 | Azure CosmosDB Data Migration Tool | Windows, Mac OS X, and Linux (Any) |
We also provide a PDF file that has color images of the screenshots/diagrams used in this book. Click here to download it.
Peter ter Braake He started working as a developer in 1996 after studying physics in Utrecht, the Netherlands. Databases and business intelligence piqued his interest the most, leading to him specializing in SQL Server and its business intelligence components. He has worked with Power BI from the tool's very beginnings. Peter started working as an independent contractor in 2008. This has enabled him to divide his time between teaching data-related classes, consulting with customers, and writing articles and books.
If you have already purchased a print or Kindle version of this book, you can get a DRM-free PDF version at no cost.
Simply click on the link to claim your free PDF.
https://packt.link/free-ebook/9781801077347