Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React CSS Angular Node.Js PHP HTML5 WordPress
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate Microsoft AZ-900
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence Blockchain MySQL Data Analysis
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Mobile Game Development
Google Flutter Android Development iOS Development React Native Swift Dart (programming language) Mobile Development Kotlin SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Canva Art Composition Design Theory
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Cognitive Behavioral Therapy Sound Therapy
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Business Plan Startup Online Business Blogging Home Business
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Email Marketing Copywriting YouTube Marketing Advertising Strategy

IT Certifications Microsoft DP-900

DP-900 Microsoft Azure Data Fundamentals Certification 2021

DP-900 Azure Data Fundamentals Exam Preparation Course
Rating: 4.6 out of 54.6 (1,386 ratings)
8,045 students
Created by Alan Rodrigues
Last updated 12/2021
English
English [Auto]

What you'll learn

  • Students will be better prepared for the DP-900 certification exam
  • Students will learn the important aspects for what is required from an exam perspective

Requirements

  • Students should have prior knowledge on databases and data
  • Students should have some prior knowledge on basic concepts on processing data

Description

Version 2.0 - Feb 2021

  • Added chapters on

    • Azure SQL Managed Instance

    • Azure Cosmos DB - Mongo DB API

    • Azure Cosmos DB - Gremlin API

  • Revised chapters on Azure Databricks

  • Updated chapters on Azure Synapse Analytics to reflect recent changes in Azure on this service

  • Added a completely NEW SECTION. This section includes

    • Working with SQL commands on data

    • Working with data in Power BI

    • Additional aspects related to Azure Data Factory

This course is designed for students who want to attempt the Exam DP-900: Microsoft Azure Data Fundamentals

This course has contents for the Exam DP-900

The objectives covered in this course are

  • Describe core data concepts (15-20%)

  • Describe how to work with relational data on Azure (25-30%)

  • Describe how to work with non-relational data on Azure (25-30%)

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

The following key aspects are covered in this course

  • Working with SQL databases - Here we will see how to work with SQL databases using Microsoft SQL Server on an Azure virtual machine.

  • We will then explore the Azure SQL database service

  • We will look at non-relational data stores such as Azure Storage accounts and Azure Cosmos DB

  • We will look at Analytical services such as Azure Synapse

  • We will see how to use Azure Data Factory as an ETL tool

This course has a number of videos that will help the student be prepared for the DP-900 exam. Right from the basics on understanding the different data services to knowing how they can work together.

Who this course is for:

  • Those who want to pursue the Microsoft Azure Data Fundamentals Certification
  • Those who want to pass the Microsoft exam DP-900

Course content

6 sections • 144 lectures • 10h 13m total length

  • Important Course instructions
    00:28
  • Preview02:37
  • Preview02:41
  • Preview04:08
  • Types of systems
    07:57
  • Notes on Types of systems
    02:52

  • Section Introduction
    00:47
  • Overview of storing and accessing relational data
    03:54
  • Relationships between tables
    05:45
  • Introduction to relational database software
    06:15
  • Why Azure?
    05:41
  • Concepts in Azure
    03:57
  • Azure Free account
    04:43
  • Quick view of the Azure Portal
    03:40
  • About Azure Active Directory
    02:33
  • Preview03:25
  • Preview07:34
  • Preview07:06
  • Lab - Connecting to Microsoft SQL Server
    06:57
  • Lab - Using SQL Server template
    06:40
  • Lab - Creating an Azure SQL Database
    10:18
  • IaaS vs PaaS
    02:29
  • Deleting Azure resources
    06:07
  • Type of SQL statements
    02:17
  • Lab - Azure SQL Database - Working with data
    05:52
  • Lab - Azure SQL Database - Working with data - Foreign keys
    06:26
  • Lab - Azure SQL Database - Working with data - Resources
    00:58
  • Lab - Additional SQL statements
    03:09
  • Lab - Creating another Azure SQL database
    03:33
  • Lab - Table Views
    02:49
  • Lab - Table Views - Resources
    00:07
  • Indexes in tables
    06:19
  • NEW - Lab - Working with Indexes
    09:17
  • NEW - Lab - Working with Indexes - Resources
    00:38
  • Different ways to deploy Azure resources - Overview
    02:00
  • Lab - Creating an Azure SQL Database - PowerShell
    07:14
  • Lab - Creating an Azure SQL Database - Azure CLI
    03:41
  • Lab - Creating Azure SQL Databases - ARM Templates
    04:39
  • Creating Azure SQL Databases - Resources
    00:48
  • NEW - Azure SQL Managed Instance
    05:17
  • NEW - Lab - Creating an Azure SQL Managed Instance resource
    04:15
  • NEW - Lab - Connecting to the Azure SQL Managed Instance
    07:32
  • Roles and tools
    02:45
  • Lab - Azure Data Studio
    04:53
  • Using Visual Studio Code
    03:37
  • Lab - Using sqlcmd
    02:34
  • Lab - Using sqlcmd - Resources
    00:09
  • Lab - Azure Database for MySQL
    06:04
  • Lab - Azure Database for MariaDB
    04:48
  • Lab - Azure Database for PostgreSQL
    04:42
  • Commands for other databases
    00:20
  • Azure SQL Encryption
    03:12
  • Azure SQL - Read Replica
    03:11
  • Azure SQL Database - Adding SQL users
    03:29
  • Azure SQL Database - Adding SQL users - Resources
    00:13
  • Azure SQL Database - Azure Active Directory
    03:42
  • Lab - Azure SQL Database - Firewall
    07:34

  • Section Introduction
    00:37
  • Non-relational data
    03:22
  • Different types of non-relational data stores
    02:31
  • Azure Storage Accounts - Introduction
    03:18
  • Lab - Azure Storage Accounts - Creating a storage account
    05:16
  • Lab - Azure Storage Account - Blob service
    06:38
  • Lab - Azure Storage Account - Table service
    05:19
  • Lab - Azure Storage Account - File service
    04:18
  • Azure Storage Explorer
    03:50
  • Storage Accounts - Data Redundancy
    03:48
  • Lab - Azure Blob storage - Service tiers
    06:26
  • Lab - Azure Storage Account - Firewall
    04:59
  • Lab - Azure Cosmos DB
    04:45
  • NEW - Optional - Introduction to JSON
    02:43
  • NEW - Optional - JSON Data types
    04:41
  • Lab - Azure Cosmos DB - Working with data
    11:17
  • Lab - Azure Cosmos DB - Working with data - Resource
    00:12
  • NEW - Azure Cosmos DB - More on Partitions
    08:18
  • The different API's in Azure Cosmos DB
    03:54
  • Lab - Azure Cosmos DB - Table API
    03:14
  • NEW - Lab - Azure Cosmos DB - MongoDB API
    06:23
  • NEW - Azure Cosmos DB - Gremlin API
    02:33
  • NEW - Lab - Azure Cosmos DB - Gremlin API
    05:47
  • NEW - Lab - Azure Cosmos DB - Gremlin API - Resources
    00:08
  • Azure Cosmos DB - High Availability
    06:35
  • Azure Storage Account - Azure CLI
    01:30
  • Azure Cosmos DB - Azure CLI
    03:05
  • Azure CLI - Commands
    00:31

  • Section Introduction
    00:54
  • Ingesting data
    04:08
  • Azure Data Lake Storage
    01:28
  • Lab - Azure Data Lake Storage
    05:40
  • Lab - Azure Event Hubs
    08:10
  • Lab - Azure Event Hubs - Azure Data Lake Storage
    04:20
  • Lab - Azure Stream Analytics
    07:07
  • NEW - What is Azure Databricks
    03:44
  • NEW - Lab - Azure Databricks - Let's create a workspace
    05:34
  • NEW - Lab - Azure Databricks - Let's create a cluster
    05:43
  • NEW - Lab - Azure Databricks - Lab - Let's create a notebook
    02:31
  • NEW - Lab - Azure Databricks - Reading data from a CSV file
    09:37
  • Lab - Azure Databricks - Resources
    00:26
  • About ETL and ELT
    03:43
  • UPDATED - Azure Data Factory
    05:20
  • UPDATED - Lab - Azure Data Factory
    12:11
  • Azure Synapse Analytics - SQL Data warehouse
    06:27
  • NEW - Lab - Azure Synapse Analytics - Creating a workspace
    09:39
  • NEW - Lab - From Azure SQL database to Azure Synapse
    09:52
  • NEW - SQL Data warehouse - Table aspects
    08:04
  • Data Analytics
    04:32
  • Batch and stream processing
    02:26
  • Points on Batch Processing
    02:52
  • A look at PowerBI Desktop
    06:38
  • A look at powerbi.com
    04:31
  • Performing Predictive Analysis
    02:51
  • Section - Notes
    02:26

  • Section Introduction
    01:02
  • NEW - Working with SQL - Understanding our data
    04:41
  • NEW - Lab - Building our resources in Azure
    07:40
  • NEW - Lab - Azure Data Factory - Copying data onto Azure SQL database
    08:50
  • NEW - Data types in Microsoft SQL Server
    04:34
  • NEW - Lab - Azure Data Factory - Using Mapping Data Flow
    08:11
  • NEW - Lab - Azure Data Factory - Our new pipeline
    04:55
  • NEW - Lab - Azure Data Factory - Pre-creating the table
    05:00
  • NEW - Lab - Azure Data Factory - Pre-creating the table - Resources
    00:16
  • NEW - SQL - Commands - Resources
    00:53
  • NEW - Lab - SQL - Aggregate Functions
    01:40
  • NEW - Lab - SQL - WHERE Clause
    03:50
  • NEW - Lab - SQL - ORDER BY Clause
    02:32
  • NEW - Lab - SQL - GROUP BY Clause
    04:03
  • NEW - Lab - Power BI - Loading data into Power BI Desktop
    03:54
  • NEW - Lab - Power BI - Removing a column from your data set
    04:38
  • NEW - Lab - Power BI - Removing NULL or blank values
    01:28
  • NEW - Lab - Adding another dataset to Power BI
    03:16
  • NEW - Lab - Creating a calculated column - Power Query Editor
    03:23
  • NEW - Lab - Creating a calculated column - via DAX expression
    02:16
  • NEW - Lab - Power BI - Table Visualization
    04:12
  • NEW - Lab - Power BI - Clustered column chart
    03:00
  • NEW - Lab - Power BI - Adding static elements
    01:57
  • NEW - Why even consider the Power BI Web service
    02:05
  • NEW - Lab - Publishing to Power BI Web Service
    03:33
  • NEW - About Apache Parquet
    02:21
  • NEW - Lab Azure Data Factory - From CSV to Apache Parquet
    07:31
  • NEW - Azure Synapse - External Tables
    04:17
  • NEW - Lab - Azure Synapse - External Tables
    07:29
  • NEW - Lab - Azure Synapse - External Tables - Resources
    00:38
  • NEW - Lab - Azure Data Factory - Using triggers
    05:19

  • Practice Test 1
    45 questions
  • Practice Test 2
    45 questions
  • Bonus Lecture
    00:17

Instructor

Alan Rodrigues
Software Engineering Evangelist
Alan Rodrigues
  • 4.5 Instructor Rating
  • 81,161 Reviews
  • 353,698 Students
  • 21 Courses

A Software technology evangelist with over 15+ years in the software Industry. 

A certification buff with numerous certifications with the most recent ones being 

1. Microsoft Certified Azure Fundamentals

2. Microsoft Certified Microsoft Azure Solutions Architect Expert

3. Microsoft Certified Azure Data Fundamentals

4. Microsoft Certified Microsoft Azure Administrator Associate

5. Microsoft Certified Azure DevOps Engineer Expert

6. Microsoft Certified Azure Security Engineer Associate

7. Microsoft Certified Microsoft Azure Developer Associate

I have also ghostwritten Exam Question banks , and developed courses for various high profile clients.

Hence creating courses for the mass public is just what I do best.

I just have one quote for all my students

"Just follow your passion , never limit your potential. Never stop , just go on and achieve your dreams"

  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2021 Udemy, Inc.