Course curriculum

  • 1

    1 - Welcome to the DP-200 Course!

    • Hello and Welcome

    • Azure Free Account

    • Setting a Budget
  • 2

    2 - Implement Non-Relational Data Storage Solutions

    • Relational vs Non-Relational Databases Overview

    • Overview of Non-Relational Databases in Azure

    • Live Demo: Overview of Azure and the Azure Portal

    • Live Demo: Create a Cosmos DB Account

    • Live Demo: Add Data to Cosmos DB

    • Live Demo: Data Replication with Cosmos DB

    • Live Demo: Manual vs Automatic Failover

    • Cosmos DB Consistency

    • Accessing Cosmos DB Data and Access Keys

    • Private Networks and Private Endpoints

    • Querying Cosmos DB and Data Explorer
  • 3

    3 - Implement Relational Data Storage Solutions

    • Overview of Azure Relational Databases

    • Live Demo: Create an Azure SQL Database (Basic Tab)

    • Live Demo: Create an Azure SQL Database (Advanced)

    • Live Demo: Verify SQL Database

    • Live Demo: Resize Database

    • Geo-Replication

    • Automatic Failover Groups

    • Connecting through Failover Groups

    • (Optional) Downloading SSMS

    • Connecting Through SSMS

    • Azure Active Directory Authentication

    • Azure Synapse Analytics (formerly SQL Data Warehouse)

    • SQL DW Scaling and Maintenance Windows

    • SQL DW Firewall and Connection

    • Using Polybase with SQL DW
  • 4

    4 - Manage Data Security

    • Azure Data Security Features Overview

    • Encryption At Rest, In Transit and Always Encrypted

    • Live Demo: Azure Data Security Features
  • 5

    5 - Develop Batch Processing Solutions

    • Introduction to Azure Data Factory

    • Create Your First Azure Data Factory

    • Navigating to the ADF Authoring Tool

    • Live Demo: Setting Up the Demo

    • Live Demo: Create Data Factory Blob Linked Service

    • Live Demo: Create a Data Factory Pipeline

    • Introduction to Azure Databricks

    • Live Demo: Create Databricks Workspace

    • Live Demo: Jupyter Notebooks

    • Live Demo: Controlling Clusters
  • 6

    6 - Develop Streaming Solutions

    • Introduction to Azure Stream Analytics

    • Live Demo: Stream Analytics
  • 7

    7 - Monitor Data Storage

    • Monitor Blob Storage Account

    • Use Insights Preview Feature and Azure Monitor

    • Create an Azure Data Lake Gen2

    • Monitor Azure Data Lake Gen2

    • Monitor SQL Database

    • Log Analytics

    • Monitor Synapse SQL Pool (Data Warehouse)
  • 8

    8 - Monitor Data Processing

    • Monitor Data Processing
  • 9

    9 - Optimize Azure Data Solutions

    • Data Partitioning

    • Optimize Data Lake and Stream Analytics
  • 10

    10 - Wrap-Up & Summary

    • Thank You!