Cargando…
MICROSOFT CERTIFIED AZURE DATA FUNDAMENTALS (EXAM DP-900) CERTIFICATION GUIDE the comprehensive guide to passing the DP-900 exam on your first attempt /
Learn how to implement successful Azure Data projects and get the skills to clear the DP-900 certification exam with the help of mock tests and self-assessment scenarios for better preparation Key Features Get the knowledge you need to pass the DP-900 exam on your first attempt Gain fundamental know...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[S.l.] :
PACKT PUBLISHING LIMITED,
2022.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 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
- 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
- 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