Description

Gain a solid foundation in core data concepts and discover how they are implemented using Microsoft Azure data services. This Microsoft Official Courseware (MOC) training introduces the fundamentals of relational and non-relational databases, big data, and modern analytics workloads to prepare you for the DP-900 certification.

What You'll Learn

• Core data concepts (differences between relational, non-relational, structured, and unstructured data)

• Transactional (OLTP) vs. Analytical (OLAP) data workloads

• Working with relational data on Azure (Azure SQL Database, Azure Database for PostgreSQL, and MySQL)

• Working with non-relational data on Azure (Azure Cosmos DB, Azure Blob, and Table Storage)

• Modern data warehouse analytics (Azure Data Factory, Azure Synapse Analytics, and Azure Databricks)

• Fundamentals of data visualization and reporting using Microsoft Power BI

Who Should Enroll

• Individuals starting their journey in cloud data, databases, and analytics

• IT professionals and developers looking to understand Azure's data offerings

• Business analysts, data consumers, and stakeholders exploring data-driven solutions

• Anyone preparing for the Microsoft Certified: Azure Data Fundamentals (DP-900) exam

Course Outline

• Module 1: Explore core data concepts (Data formats, workloads, and data roles)

• Module 2: Explore relational data in Azure (SQL services and deployment options)

• Module 3: Explore non-relational data in Azure (Cosmos DB and Azure Storage options)

• Module 4: Explore modern data warehouse analytics in Azure (Data ingestion, processing, and Power BI basics)

Pre-requisites

• No prior technical IT experience or Azure experience is required

• Basic awareness of computing and internet concepts

• A general interest in data, databases, and business analytics

Course Detail

• Format: Instructor-led or Online

• Includes: Hands-on labs (provisioning databases, querying data, and exploring analytics tools in the Azure portal), interactive exercises, and demonstrations

• Certification Prep: Microsoft Certified: Azure Data Fundamentals (Exam DP-900)