Login

OTP sent to

Azure Data Fundamentals

Home > Courses > Azure Data Fundamentals

Azure Data Fundamentals

Azure

Duration
45 Hours

Course Description

             The Microsoft Azure Data Fundamentals (DP-900) certification focuses on foundational knowledge of data concepts and related Azure data services. It's designed for individuals who are starting to work with data in the cloud and want to build a solid understanding of core data concepts and how they are implemented using Azure. 

Course Outline For Azure Data Fundamentals

1. Explore core data concepts

  • Data Types and Storage: This section covers different types of data (structured, semi-structured, unstructured) and common data formats. It also explores options for storing data in files and databases.
  • Data Workloads: Learn about different types of data workloads, including transactional workloads (focused on efficiency and reliability for day-to-day operations) and analytical workloads (focused on insights and trends).
  • Data Professional Roles: Understand the responsibilities of various data professionals, including database administrators, data engineers, and data analysts. 

2. Explore relational data in Azure

  • Relational Concepts: Dive into the characteristics of relational data and databases, the importance of normalization, and common SQL statements. You'll also learn about common database objects like tables, views, and indexes.
  • Azure SQL Services: Explore the Azure SQL family of products, including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines. It also covers Azure database services for open-source systems like MySQL, PostgreSQL, and MariaDB.
  • Provisioning and Querying Relational Data: Learn how to provision and deploy relational databases using the Azure portal, Azure CLI, and Azure PowerShell. You'll also develop skills in querying relational data using tools provided within the Azure ecosystem. 

3. Explore non-relational data in Azure

  • Non-Relational Concepts: Focus on the characteristics of non-relational data, different types of NoSQL databases (document, key-value, graph), and when to use them.
  • Azure Storage: Explore the features and capabilities of Azure Blob Storage for unstructured data, Azure File Storage for managed file shares, and Azure Table Storage for NoSQL data.
  • Azure Cosmos DB: Understand the features and capabilities of Azure Cosmos DB, including its various APIs (SQL, MongoDB, Cassandra, Gremlin, Table).
  • Provisioning and Managing Non-Relational Data: Learn to provision and deploy non-relational data services on Azure and manage non-relational data stores. 

4. Explore an analytics workload on Azure

  • Modern Data Warehousing: Examine the components of a modern data warehouse and explore how Azure services like Azure Synapse Analytics, Azure Databricks, and Azure HDInsight can be used to build and manage large-scale data analytics solutions.
  • Data Ingestion and Processing: Explore common practices for data ingestion and processing in Azure, including using services like Azure Data Factory for ETL/ELT workflows.
  • Real-time Analytics: Compare batch and stream processing and explore Azure services for real-time analytics like Azure Stream Analytics and Spark Structured Streaming.
  • Data Visualization: Learn the fundamentals of data visualization and reporting using Microsoft Power BI. 
Enquire Now