Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Azure Data Fundamentals (DP900 Certification)
Rating: 4.1 out of 5(8 ratings)
3,462 students

Azure Data Fundamentals (DP900 Certification)

Azure DP900 Clearly explained with Practical in most simplest explanation and In-Depth
Created byHarish Masand
Last updated 11/2023
English
English [Auto],

What you'll learn

  • DP-900: Microsoft Azure Data Fundamentals
  • Full Syllabus Covered
  • Explanation in Most Simplest Language
  • Prepared to take Azure DP900 Certification

Course content

1 section • 21 lectures • 11h 1m total length

  • Introduction to Azure Data Engg/ Data Science Career Path0:54

    Explore Azure data fundamentals with a focus on data engineering and data science careers, career path options, and success stories, plus how to connect via Udemy or WhatsApp.

  • A01 - Core Data Concepts2:01:38

    Learn core data concepts, from binary storage of bits to terabytes, and classify data as structured, semi-structured, or unstructured for big data.

  • A02 - Data Roles and Services22:03

    Identify key data roles: administrator, engineer, analyst, scientist, and architect, and review Azure data services, including SQL, Cosmos DB, storage, Data Factory, Synapse, Databricks, and Power BI.

  • A03 - Fundamentals of Relational Database - 134:43

    Explore the fundamentals of relational databases, including tables, rows, columns, primary keys, and foreign keys, and see how normalization enhances data integrity and reduces duplication.

  • A04 - Fundamentals of Relational Database - 21:12:17

    Explore normalization and referential integrity in relational databases, using primary and foreign keys, and learn core sql commands across ddl, dcl, and dml.

  • A05 - Relational Database Services in Azure30:28

    Explore relational database services in Azure, including Azure SQL options and open source MySQL or PostgreSQL. Compare IaaS and PaaS, learn about elastic pools, backups, threat detection, and audit.

  • A05 - Practical - Create Azure Account4:19

    Create an Azure account in the portal, sign in or sign up with your email, verify with a code, then explore dashboard, all services, favorites, search, subscriptions, directory, and support.

  • A05 - Practical - Validate Yourself and Create Subscription5:31

    Authenticate your azure account with phone and card details, then create a resource and start with free credits. Manage subscriptions, directories, and a pay-as-you-go option with a $200 starter credit.

  • A05 - Practical - Relational Database Services in Azure26:19

    Create and configure an Azure SQL database with the Adventure Works sample database, then query and join product and product category tables using aliases and primary-foreign keys.

  • A06 - Non-Relational Data Services in Azure38:30

    Explore Azure storage for non-relational data, including blob storage with block, page, and append blobs, data lake Gen2 folders, Azure Files, and NoSQL table storage with partition keys.

  • A06 - Practical - Azure Storage27:44

    Learn to provision a resource group and Azure storage account, create containers and a virtual directory, migrate to gen2, upload data, and use file shares and tables.

  • A07 - Azure CosmosDB Fundamentals44:34

    Azure Cosmos DB fundamentals present a multi-api, multi-model database service for document, key-value, column-family, and graph data, supporting SQL, MongoDB, and Azure Table APIs with serverless scaling and multi-region replication.

  • A07 - Practical Azure Cosmos DB21:40

    Create an Azure Cosmos DB for NoSQL, use Data Explorer to view and edit items, run SQL queries, and learn about throughput options and resource cleanup.

  • A08 - Large Scale Data Warehousing Fundamentals33:17

    Learn large scale data warehousing fundamentals, covering transactional data sources, ingestion, ETL/ELT, data lake and lakehouse concepts with delta lake and spark, plus star and snowflake schemas.

  • A08 - Practical - Azure Synapse32:39

    Link Used: https://raw.githubusercontent.com/MicrosoftLearning/DP-900T00A-Azure-Data-Fundamentals/master/Azure-Synapse/products.csv

  • A09 - Real Time Analytics Fundamentals36:50

    Explore real time analytics fundamentals, comparing batch and streaming processing, and learn to use Azure Stream Analytics, Spark Structured Streaming, and Azure Data Explorer with IoT data.

  • A09 - Practical 1 - Azure Steam Analytics14:00

    Git Clone Used: git clone https://github.com/MicrosoftLearning/DP-900T00A-Azure-Data-Fundamentals dp-900

  • A09 - Practical 2 - Spark Straming and Data Explorer35:37

    Python Notebook and file attached

  • A10 - Data Visualization Fundamentals44:46

    Explore data visualization fundamentals and data modeling in business intelligence, then build interactive Power BI dashboards from diverse data sources using measures, dimensions, and star and snowflake schemas.

  • A10 - Practical Power BI13:34

    Links Used:

    Download link: https://aka.ms/power-bi-desktop


    Git Hub Links:

    Customer Data:

    https://github.com/MicrosoftLearning/DP-900T00A-Azure-Data-Fundamentals/raw/master/power-bi/customers.csv


    Product Data:

    https://github.com/MicrosoftLearning/DP-900T00A-Azure-Data-Fundamentals/raw/master/power-bi/products.csv


    Order Data:

    https://github.com/MicrosoftLearning/DP-900T00A-Azure-Data-Fundamentals/raw/master/power-bi/orders.csv


  • Practice Questions - Sample Paper0:01

Requirements

  • No Prerequisites.

Description

Learn Azure DP-900 Microsoft Azure Data Fundamentals (In-Depth)


From the instructor of successful Data Engineering courses on "Big Data Hadoop and Spark with Scala", "Scala Programming In-Depth" and "Apache Spark In-Depth (Spark with Scala)"


  • From Data file formats to Data Processing

  • From Relational Databases to (Non Relational Database) NoSQL Databases.

  • From Batch Processing to Real Time Processing

  • From Azure Data Factory, Azure Synapse to Azure File Explorer


Contents all you need for in-depth study of Azure Data Fundamentals and to clear DP-900 Microsoft Azure Data Fundamentals Exam and Interview.


Taught in very simple English language so any one can follow the course very easily.


No Prerequisites, Good to know basics about Hadoop and Scala


Perfect place to start learning Azure Data Engineering


Contents:

  • Describe core data concepts (25-30%)

  • Identify considerations for relational data on Azure (20-25%)

  • Describe considerations for working with non-relational data on Azure (15-20%)

  • Describe an analytics workload on Azure (25-30%)


More About Exam:

This exam is intended for candidates beginning to work with data in the cloud.

Candidates should be familiar with the concepts of relational and non-relational data, and different types of data workloads such as transactional or analytical.

Azure Data Fundamentals can be used to prepare for other Azure role-based certifications like Azure Database Administrator Associate or Azure Data Engineer Associate, but it is not a prerequisite for any of them.

You may be eligible for ACE college credit if you pass this certification exam. See ACE college credit for certification exams for details.


Exam Vouchers:

Some times i do come across discounted vouchers. Will Pass it as available. Else Exam Fees is 99 USD

Who this course is for:

  • Data Engineers and Data Scientists Looking for Cloud Certifications
  • Interested in Getting Fundamental Data Concepts Cleared

Report abuse