Exam DP-900 Microsoft Azure Data Fundamentals (Video)

Exam DP-900 Microsoft Azure Data Fundamentals (Video)

by Chris Sorensen
Released September 2021
Publisher(s): Microsoft Press
ISBN: 0137576706

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

4+ Hours of Video Instruction

Prepare for Microsoft Exam DP-900 and demonstrate your knowledge of fundamental data concepts and Microsoft Azure data services.

Description

This Exam DP-900: Microsoft Azure Data Fundamentals video is designed to help you begin to work with data in the cloud. This video focuses on the skills measured by the exam objectives, as updated by Microsoft in April 2021.
  • Describe core data concepts
  • Describe how to work with relational data on Azure
  • Describe how to work with non-relational data on Azure
  • Describe an analytics workload on Azure
Using his years of experience working with data and teaching data best practices to a variety of learners, Microsoft Certified Trainer Chris Sorensen explains core concepts related to working with data in Azure. In his engaging style grounded in real-world scenarios, Chris gives you insights to relational and non-relational data, different types of workloads, and analytical best practices. With Chris as your guide, you are well-equipped to successfully attempt the DP-900 exam and advance in your career as a data engineer or database administrator.

About the Instructor

Chris Sorensen, CPA, CGA, is the Founder and President of Iteration Insights, a tech-enabled data analytics solutions provider based in Calgary, Alberta. He is a Microsoft Certified Data Analyst Associate and Microsoft Certified Trainer with a combined 20+ years of industry and teaching experience. In his career, he has led numerous Analytics projects in more than 15 industries across small to enterprise-sized organizations.

As an adjunct instructor of the Business Intelligence program at SAIT, he plays a significant role in shaping new talent in Calgary's emerging tech sector. Following his lifelong learning approach, Chris also coordinates both Power Platform and Azure Analytics User Groups, providing a space dedicated to knowledge-sharing and growing Alberta's tech community. His favourite hashtag is #neverstoplearning.

Skill Level
  • Beginner to Intermediate
Who Should Take This Course
  • Certification candidates preparing for exam DP-900 Microsoft Azure Data Fundamentals
  • Analysts or admins beginning to work with data in the cloud
Course Requirements
  • Foundational knowledge of core data concepts
About Pearson Video Training

Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, Sams, and Que. Topics include IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more. Learn more about Pearson Video training at http://www.informit.com/video.

Table of contents

  1. Introduction
    1. Exam DP-900: Microsoft Azure Data Fundamentals: Introduction
  2. Module 1: Describe Core Data Concepts
    1. Module introduction
  3. Lesson 1: Describe Types of Core Data Workloads
    1. Learning objectives
    2. 1.1 Describe batch data
    3. 1.2 Describe streaming data
    4. 1.3 Describe the difference between batch and streaming data
    5. 1.4 Describe the characteristics of relational data
  4. Lesson 2: Describe Data Analytics Core Concepts
    1. Learning objectives
    2. 2.1 Describe data visualization
    3. 2.2 Describe basic chart types
    4. 2.3 Describe analytics techniques
    5. 2.4 Describe ELT and ETL processing
    6. 2.5 Describe the concepts of data processing
  5. Module 2: Describe How to Work with Relational Data on Azure
    1. Module introduction
  6. Lesson 3: Describe Relational Data Workloads
    1. Learning objectives
    2. 3.1 Identify the right data offering for a relational workload
    3. 3.2 Describe relational data structures
  7. Lesson 4: Describe Relational Azure Data Services
    1. Learning objectives
    2. 4.1 Describe Azure SQL family of products
    3. 4.2 Describe Azure Synapse Analytics
    4. 4.3 Describe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for MySQL
  8. Lesson 5: Identify Basic Management Tasks for Relational Data
    1. Learning objectives
    2. 5.1 Describe provisioning and deployment of relational data services
    3. 5.2 Describe method for deployment
    4. 5.3 Identify data security components
    5. 5.4 Identify basic connectivity issues
  9. Lesson 6: Describe Query Techniques for Data Using SQL Language
    1. Learning objectives
    2. 6.1 Compare Data Definition Language (DDL) versus Data Manipulation Language (DML)
    3. 6.2 Query relational data in Azure
  10. Module 3: Describe How to Work with Non-relational Data on Azure
    1. Module introduction
  11. Lesson 7: Describe Non-relational Data Workloads
    1. Learning objectives
    2. 7.1 Describe the characteristics of non-relational data
    3. 7.2 Describe the types of non-relational and NoSQL data
    4. 7.3 Recommend the correct data store
    5. 7.4 Determine when to use non-relational data
  12. Lesson 8: Describe Non-relational Data Offerings on Azure
    1. Learning objectives
    2. 8.1 Identify Azure data services for non-relational workloads
    3. 8.2 Describe Azure Cosmos DB APIs
    4. 8.3 Describe Azure Table Storage
    5. 8.4 Describe Azure Blob Storage
    6. 8.5 Describe Azure File Storage
  13. Lesson 9: Identify Basic Management Tasks for Non-relational Data
    1. Learning objectives
    2. 9.1 Describe provisioning and deployment of non-relational data services
    3. 9.2 Describe method for deployment
    4. 9.3 Identify data security components
    5. 9.4 Identify basic connectivity issues
    6. 9.5 Identify management tools for non-relational data
  14. Module 4: Describe an Analytics Workload on Azure
    1. Module introduction
  15. Lesson 10: Describe Analytics Workloads
    1. Learning objectives
    2. 10.1 Describe transactional workloads
    3. 10.2 Describe the difference between a transactional and an analytics workload
    4. 10.3 Describe the difference between batch and real time
    5. 10.4 Describe data warehousing workloads
    6. 10.5 Determine when a data warehouse solution is needed
  16. Lesson 11: Describe the Components of a Modern Data Warehouse
    1. Learning objectives
    2. 11.1 Describe Azure data services for modern data warehousing
    3. 11.2 Describe modern data warehousing architecture and workload
  17. Lesson 12: Describe Data Ingestion and Processing on Azure
    1. Learning objectives
    2. 12.1 Describe common practices for data loading
    3. 12.2 Describe the components of Azure Data Factory
    4. 12.3 Describe data processing options
  18. Lesson 13: Describe Data Visualization in Microsoft Power BI
    1. Learning objectives
    2. 13.1 Describe the workflow in Power BI
    3. 13.2 Describe the role of interactive reports
    4. 13.3 Describe the role of dashboards
    5. 13.4 Describe the role of paginated reporting
  19. Summary
    1. Exam DP-900: Microsoft Azure Data Fundamentals: Summary

Product information

  • Title: Exam DP-900 Microsoft Azure Data Fundamentals (Video)
  • Author(s): Chris Sorensen
  • Release date: September 2021
  • Publisher(s): Microsoft Press
  • ISBN: 0137576706