DP-200 Implementing Azure Data Exam Prep In One Day
A complete course that covers the DP-200 exam
Hello and Welcome
Azure Free Account
Setting a Budget
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
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
Azure Data Security Features Overview
Encryption At Rest, In Transit and Always Encrypted
Live Demo: Azure Data Security Features
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
Introduction to Azure Stream Analytics
Live Demo: Stream Analytics