MICROSOFT CERTIFIED AZURE DATA FUNDAMENTALS (EXAM DP-900) CERTIFICATION GUIDE the comprehensive guide to passing the DP-900 exam on your first attempt
What you will learn Explore the concepts of IaaS and PaaS database services on Azure Query, insert, update, and delete relational data using SQL Explore the concepts of data warehouses in Azure Perform data analytics with an Azure Synapse Analytics workspace Upload and retrieve data in Azure Cosmos...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
[S.l.]
PACKT PUBLISHING LIMITED
2022
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Answer key
- Chapter 4: Working with Non-Relational Data
- Exploring the characteristics of non-relational data
- Understanding the types of non-relational data
- Non-structured data
- Semi-structured data
- Non-relational data basic storage
- Exploring NoSQL databases
- What is a NoSQL database?
- Key-value store
- Document database
- Column family database
- Graph database
- Identifying non-relational database use cases
- Case study
- A 360-degree customer view
- Fraud detection
- financial institutions
- Summary
- Sample questions and answers
- Answer key
- Cover
- Title Page
- Copyright
- Dedication
- Contributors
- Table of Contents
- Preface
- Part 1: Core Data Concepts
- Chapter 1: Understanding the Core Data Terminologies
- Understanding the core data concepts
- What is data?
- How is data stored in a modern cloud environment?
- Describing a data solution
- Transactional databases
- Analytical databases
- Defining the data type and proper storage
- Characteristics of relational and non-relational databases
- A transactional workload
- An analytical workload
- Understanding data ingestion
- Understanding batch load
- Understanding data streaming
- Case study
- Summary
- Sample questions and answers
- Answer key
- Chapter 2: Exploring the Roles and Responsibilities in Data Domain
- Different workforces in a data domain
- Most common roles in a data domain
- Database Administrator
- Data engineer
- Data analyst
- Tasks and tools for database administration profiles
- Tasks of the DBA
- Tools for the DBA
- Tasks and tools for data engineer profiles
- Tasks of the data engineer
- Tools for the data engineer
- Tasks and tools for the data analyst
- Tasks of the data analyst
- Tools for the data analyst
- Case study
- Summary
- Sample questions and answers
- Answer key
- Chapter 3: Working with Relational Data
- Exploring the characteristics of relational data
- Tables and entities
- Relationship between entities
- Exploring relational data structures
- Data normalization
- Introducing SQL
- Key advantages of SQL
- Key disadvantages of SQL
- Understanding the categories of SQL commands
- DDL
- DML and DQL
- Describing the database components
- Views
- Stored procedures
- Triggers
- Indexes
- Case study
- Summary
- Sample questions and answers
- Chapter 5: Exploring Data Analytics Concepts
- Exploring data ingestion and processing
- Data pipelines
- Data ingestion types
- Data source connectors
- Exploring the analytical data store
- Data warehouse
- Data lake
- Hybrid approaches
- Exploring an analytical data model
- Facts and dimensions
- Exploring data visualization
- Case study
- Data-driven culture
- Summary
- Sample questions and answers
- Answer key
- Part 2: Relational Data in Azure
- Chapter 6: Integrating Relational Data on Azure
- Exploring relational Azure data services
- Elastic pool
- Use cases