دانلود کتاب MC Microsoft Certified Azure Data Fundamentals Study Guide: Exam DP-900

فهرست مطالب :

Cover
Title Page
Copyright Page
Acknowledgments
About the Author
About the Technical Editor
Contents at a Glance
Contents
Introduction
Who Should Read This Book?
What’s Included in the Book?
Recommended Home Lab Setup
Interactive Online Learning Environment and Test Bank
DP-900 Exam Objectives
Domain 1: Describe Core Data Components
Subdomain 1a: Describe types of core data workloads
Subdomain 1b: Describe data analytics core concepts
Domain 2: Describe How to Work with Relational Data on Azure
Subdomain 2a: Describe relational data workloads
Subdomain 2b: Describe relational Azure data services
Subdomain 2c: Identify basic management tasks for relational data
Subdomain 2d: Describe query techniques for data using SQL language
Domain 3: Describe How to Work with Nonrelational Data on Azure
Subdomain 3a: Describe nonrelational data workloads
Subdomain 3b: Describe nonrelational data offerings on Azure
Subdomain 3c: Identify basic management tasks for nonrelational data
Domain 4: Describe an Analytics Workload on Azure
Subdomain 4a: Describe analytics workloads
Subdomain 4b: Describe the components of a modern data warehouse
Subdomain 4c: Describe data ingestion and processing on Azure
Subdomain 4d: Describe data visualization in Microsoft Power BI
Assessment Test
Answers to the Assessment Test
Chapter 1 Core Data Concepts
Describe Types of Core Data Workloads
Data Value
Data Volume
Data Variety
Data Velocity
Describe Data Analytics Core Concepts
Data Processing Techniques
Describe Analytics Techniques
Describe Data Visualization Techniques
Summary
Exam Essentials
Review Questions
Chapter 2 Relational Databases in Azure
Relational Database Features
Relational Database Design Considerations
Relational Database Offerings in Azure
Azure SQL
Azure Synapse Analytics Dedicated SQL Pools
Open-Source Databases in Azure
Management Tasks for Relational Databases in Azure
Deployment Scripting and Automation
Migrating to Azure SQL
Database Security
Common Connectivity Issues
Management Tools
Query Techniques for SQL
DDL vs. DML Commands
Query Relational Data in Azure SQL, MySQL, MariaDB, and PostgreSQL
Summary
Exam Essentials
Review Questions
Chapter 3 Nonrelational Databases in Azure
Nonrelational Database Features
Key-Value Store
Document Database
Columnar Database
Graph Database
Azure Cosmos DB
High Availability
Request Units
Azure Cosmos DB APIs
Management Tasks for Azure Cosmos DB
Deployment Options
Azure Cosmos DB Security
Azure Cosmos DB Common Connectivity Issues
Management Tools
Summary
Exam Essentials
Review Questions
Chapter 4 File, Object, and Data Lake Storage
File and Object Storage Features
Azure Storage
Performance Tiers
Data Redundancy
Deploying through the Azure Portal
Azure Storage Services
Management Tasks for Azure Storage
Deployment Scripting and Automation
Azure Storage Security
Azure Storage Common Connectivity Issues
Management Tools
Summary
Exam Essentials
Review Questions
Chapter 5 Modern Data Warehouses in Azure
Analytical Workload Features
Transactional vs. Analytical Workloads
Data Processing Techniques
Modern Data Warehouse Components
Data Modeling Best Practices for Data Warehouses
Azure Services for Modern Data Warehouses
End-to-End Analytics with Azure Synapse Analytics
Deploying an Azure Synapse Analytics Workspace
Navigating the Synapse Studio UI
Dedicated SQL Pools
Serverless SQL Pools
Summary
Exam Essentials
Review Questions
Chapter 6 Reporting with Power BI
Power BI at a Glance
Working with Power BI
Summary
Exam Essentials
Review Questions
Appendix Answers to the Review Questions
Chapter 1: Core Data Concepts
Chapter 2: Relational Databases in Azure
Chapter 3: Nonrelational Databases in Azure
Chapter 4: File, Object, and Data Lake Storage
Chapter 5: Modern Data Warehouses in Azure
Chapter 6: Reporting with Power BI
Index
EULA