Introduction |
|
xvii | |
Assessment Test |
|
xxvi | |
Answers to the Assessment Test |
|
xxxix | |
|
Chapter 1 Core Data Concepts |
|
|
1 | (48) |
|
Describe Types of Core Data Workloads |
|
|
2 | (1) |
|
|
3 | (7) |
|
|
10 | (1) |
|
|
11 | (3) |
|
|
14 | (7) |
|
Describe Data Analytics Core Concepts |
|
|
21 | (1) |
|
Data Processing Techniques |
|
|
21 | (11) |
|
Describe Analytics Techniques |
|
|
32 | (2) |
|
Describe Data Visualization Techniques |
|
|
34 | (6) |
|
|
40 | (1) |
|
|
41 | (3) |
|
|
44 | (5) |
|
Chapter 2 Relational Databases in Azure |
|
|
49 | (90) |
|
Relational Database Features |
|
|
51 | (1) |
|
Relational Database Design Considerations |
|
|
51 | (10) |
|
Relational Database Offerings in Azure |
|
|
61 | (2) |
|
|
63 | (27) |
|
Azure Synapse Analytics Dedicated SQL Pools |
|
|
90 | (2) |
|
Open-Source Databases in Azure |
|
|
92 | (4) |
|
Management Tasks for Relational Databases in Azure |
|
|
96 | (1) |
|
Deployment Scripting and Automation |
|
|
96 | (9) |
|
|
105 | (1) |
|
|
106 | (7) |
|
Common Connectivity Issues |
|
|
113 | (2) |
|
|
115 | (4) |
|
|
119 | (1) |
|
|
120 | (5) |
|
Query Relational Data in Azure SQL, MySQL, MariaDB, and PostgreSQL |
|
|
125 | (4) |
|
|
129 | (1) |
|
|
130 | (2) |
|
|
132 | (7) |
|
Chapter 3 Nonrelational Databases in Azure |
|
|
139 | (38) |
|
Nonrelational Database Features |
|
|
140 | (1) |
|
|
141 | (1) |
|
|
142 | (1) |
|
|
143 | (1) |
|
|
144 | (1) |
|
|
145 | (1) |
|
|
146 | (2) |
|
|
148 | (2) |
|
|
150 | (4) |
|
Management Tasks for Azure Cosmos DB |
|
|
154 | (1) |
|
|
154 | (11) |
|
|
165 | (2) |
|
Azure Cosmos DB Common Connectivity Issues |
|
|
167 | (2) |
|
|
169 | (1) |
|
|
170 | (1) |
|
|
171 | (3) |
|
|
174 | (3) |
|
Chapter 4 File, Object, and Data Lake Storage |
|
|
177 | (48) |
|
File and Object Storage Features |
|
|
178 | (1) |
|
|
179 | (1) |
|
|
180 | (1) |
|
|
181 | (1) |
|
Deploying through the Azure Portal |
|
|
182 | (5) |
|
|
187 | (11) |
|
Management Tasks for Azure Storage |
|
|
198 | (1) |
|
Deployment Scripting and Automation |
|
|
198 | (3) |
|
|
201 | (11) |
|
Azure Storage Common Connectivity Issues |
|
|
212 | (1) |
|
|
213 | (4) |
|
|
217 | (1) |
|
|
218 | (3) |
|
|
221 | (4) |
|
Chapter 5 Modern Data Warehouses in Azure |
|
|
225 | (76) |
|
Analytical Workload Features |
|
|
226 | (1) |
|
Transactional vs. Analytical Workloads |
|
|
226 | (3) |
|
Data Processing Techniques |
|
|
229 | (4) |
|
Modern Data Warehouse Components |
|
|
233 | (1) |
|
Data Modeling Best Practices for Data Warehouses |
|
|
233 | (1) |
|
Azure Services for Modern Data Warehouses |
|
|
234 | (34) |
|
End-to-End Analytics with Azure Synapse Analytics |
|
|
268 | (2) |
|
Deploying an Azure Synapse Analytics Workspace |
|
|
270 | (1) |
|
Navigating the Synapse Studio UI |
|
|
271 | (4) |
|
|
275 | (12) |
|
|
287 | (5) |
|
|
292 | (1) |
|
|
293 | (2) |
|
|
295 | (6) |
|
Chapter 6 Reporting with Power BI |
|
|
301 | (28) |
|
|
302 | (1) |
|
|
303 | (21) |
|
|
324 | (1) |
|
|
325 | (1) |
|
|
326 | (3) |
|
Appendix Answers to the Review Questions |
|
|
329 | (10) |
|
Chapter 1 Core Data Concepts |
|
|
330 | (1) |
|
Chapter 2 Relational Databases in Azure |
|
|
331 | (2) |
|
Chapter 3 Nonrelational Databases in Azure |
|
|
333 | (1) |
|
Chapter 4 File, Object, and Data Lake Storage |
|
|
334 | (1) |
|
Chapter 5 Modern Data Warehouses in Azure |
|
|
335 | (2) |
|
Chapter 6 Reporting with Power BI |
|
|
337 | (2) |
Index |
|
339 | |