e-Attendance
Please follow the steps to complete your e-attendance
- Click this link
- Get your Student ID
- Class ID: 32094
- User Guide
Prerequisite
- Course Pre-requisite
- Better if you have good knowledge on Azure Services (AZ-900)
- Get your e-books
- Go to Skillpipe
- Create an account
- Redeem your License Code (Click for Code) and get your e-copy of the DP-900 Student Book
Course Outline
Module 1 Explore core data concepts
- Explore core data concepts
- Explore roles and responsibilities in the world of data (optional lesson)
- Describe concepts of relational data
- Explore concepts of non-relational data
- Explore concepts of data analytics
Module 2 Explore relational data in Azure
- Explore relational data offerings in Azure
- Explore provisioning and deploying relational database offerings in Azure
- Query relational data in Azure
Module 3 Explore non-relational data in Azure
- Explore non-relational data offerings in Azure
- Explore provisioning and deploying non-relational data services in Azure
- Manage non-relational data stores in Azure
Module 4 Explore modern data warehouse analytics
- Examine components of a modern data warehouse
- Explore large-scale data analytics
- Get started building with Power BI
Azure Services
- Explore Azure Services here
- Deep dive through Azure Fundamentals aka.ms/HN/learnaz
- Microsoft Azure Blog. Keep current on what’s happening in Azure, including what’s now in preview, generally available, news & updates, and more.
- Azure Newsletter. Stay informed on the latest Azure features, events, and community activities. Browse through past newsletters or subscribe and get the latest Azure news delivered to your inbox.
Lab Files
You can find all Lab Files and Instructions here.
Instructions for starting Lab:
Go to https://alh.learnondemand.net.
First time users:
-
- Click the Register with Training Key button
- Input your training key in the Register with a Training Key field
- Click Register
- This opens a registration page to create a user account. Input your registration information, and then click Save
- Saving your user registration opens your enrollment
Returning users:
-
- Click the Sign In button
- Input username and password
- Click Sign in
- Logging in opens your Current Training page
- Click the Redeem Training Key link
- Input the Training Key supplied and click the Redeem Training Key button
- This opens your enrollment
Please launch a test lab to check for connectivity issues and read through the instructions in the lab interface to become familiar with using it. Once class starts Launch buttons will appear beside the lab modules. For assistance anytime, click the Contact link on our website or click here https://alh.learnondemand.net/Home/Contact to go to the page now.
Study Guide
Topic 1: Describe core data concepts
1.1 Describing types of core data workloads
- describing batch data (Microsoft Documentation: Azure Batch)
- explaining streaming data (Microsoft Documentation: Azure Stream Analytics)
- describing the difference between batch and streaming data (Microsoft Documentation: the difference between batch and streaming data)
- explaining the characteristics of relational data
1.2 Describing data analytics core concepts
- describe data visualization (e.g., visualization, reporting, business intelligence (Microsoft Documentation: Data visualization with Azure Data Explorer)
- describing the basic chart types like bar charts and pie charts (Microsoft Documentation: Visualization types)
- describe analytics techniques (e.g., descriptive, diagnostic, predictive, prescriptive, cognitive) Advanced Analytics Architecture
- describing ELT and ETL processing (Microsoft Documentation: Extract, transform, and load (ETL))
- describe the concepts of data processing
Topic 2: Describe how to work with relational data on Azure
2.1 Describe relational data workloads
- identifying the right data offering for a relational workload (Microsoft Documentation: Azure databases)
- describe relational data structures (e.g., tables, index, views)
2.2 Describe relational Azure data services
- describe and compare PaaS, IaaS, and SaaS delivery models (Microsoft Documentation: Types of cloud services)
- describe Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines
- explaining Azure Synapse Analytics (Microsoft Documentation: Azure Synapse Analytics)
- describing Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for MySQL (Microsoft Documentation: Azure Database for PostgreSQL, Azure Database for MariaDB, Azure Database for MySQL)
2.3 Identify basic management tasks for relational data
- describing provisioning and deployment of relational data services (Microsoft Documentation: Provisioning an Azure SQL database)
- describing a method for deployment including ARM templates and Azure Portal (Microsoft Documentation: Create an Azure SQL Database single database, Creating a single database using an ARM template)
- Identifying the data security components (e.g., firewall, authentication) (Microsoft Documentation: Azure Active Directory authentication, features of Azure SQL Database security)
- recognizing the basic connectivity issues such as accessing from on-premises, access with Azure VNets, access from the Internet, authentication, firewalls (Microsoft Documentation: Troubleshooting connectivity issues with Azure SQL Database and Azure SQL Managed Instance)
- identifying the query tools (e.g., Azure Data Studio, SQL Server Management Studio, sqlcmd utility, etc.) (Microsoft Documentation: Azure Data Studio, SQL Server Management Studio (SSMS), sqlcmd utility)
2.4 Describe query techniques for data using SQL language
- compare DDL versus DML
- querying relational data in PostgreSQL, MySQL, and Azure SQL Database (Microsoft Documentation: Using the Azure portal’s query editor, Using MySQL Workbench, Using Azure Data Studio)
Topic 3: Describe how to work with non-relational data on Azure
3.1 Describe non-relational data workloads
- describe the characteristics of non-relational data
- describe the types of non-relational and NoSQL data (Microsoft Documentation: Non-relational data and NoSQL)
- recommend the correct datastore (Microsoft Documentation: Typical requirements)
- determine when to use non-relational data
3.2 Describe non-relational data offerings on Azure
- identify Azure data services for non-relational workloads (Microsoft Documentation: NoSQL databases)
- describe Azure Cosmos DB APIs (Microsoft Documentation: Identifying the technology options)
- describing Azure Table storage (Microsoft Documentation: Azure Table storage)
- describe Azure Blob storage (Microsoft Documentation: Azure Blob storage)
- describing Azure File storage (Microsoft Documentation: Azure Files)
3.3 Identify basic management tasks for non-relational data
- describing provisioning and deployment of non-relational data services (Microsoft Documentation: Creating Apache HBase cluster in Azure HDInsight using ARM template, Creating an Azure Cosmos account, database, container, and items from the Azure portal)
- explaining a method for deployment including ARM templates, Azure Portal, Azure PowerShell, and the Azure command-line interface (CLI) (Microsoft Documentation: Creating an Azure Cosmos account, database, container, and items from the Azure portal, create an Azure Cosmos DB and a container by using an ARM template)
- identify data security components (e.g., firewall, authentication, encryption) (Microsoft Documentation: Configure IP firewall in Azure Cosmos DB, Security in Azure Cosmos DB)
- Identifying the basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from the Internet, authentication, firewalls) (Microsoft Documentation: Troubleshooting issues with an IP access control policy, Diagnose and troubleshoot issues)
- identify management tools for non-relational data (Microsoft Documentation: Working with data using Azure Cosmos explorer)
Topic 4: Describe an analytics workload on Azure
4.1 Describe analytics workloads
- describe transactional workloads (Microsoft Documentation: Online transaction processing (OLTP))
- describing the difference between a transactional and an analytics workload
- describe the difference between batch and real-time (Microsoft Documentation: Real-time processing)
- describe data warehousing workloads
- determine when a data warehouse solution is needed
4.2 Describe the components of a modern data warehouse
- describing Azure data services for modern data warehousing like Azure Data Lake, Storage Gen2, Azure Synapse Analytics, Azure Databricks, and Azure HDInsight (Microsoft Documentation: Azure Data Lake Analytics, Azure Synapse Analytics, Azure Databricks, Azure HDInsight)
- explaining modern data warehousing architecture and workload (Microsoft Documentation: Modern Data Warehouse Architecture)
4.3 Describe data ingestion and processing on Azure
- explaining common practices for data loading (Microsoft Documentation: Data loading strategies for Synapse SQL pool)
- describing the components of Azure Data Factory (e.g., pipeline, activities, etc.) (Microsoft Documentation: Pipelines and activities in Azure Data Factory)
- describing data processing options (e.g., HDI, Azure Databricks, Azure Synapse Analytics, Azure Data Factory) (Microsoft Documentation: Azure Data Factory, Azure Synapse Analytics, Azure Databricks, Azure HDInsight)
4.4 Describe data visualization in Microsoft Power BI
-
-
- describing the role of paginated reporting (Microsoft Documentation: Paginated reports in Power BI Premium)
- describe the role of interactive reports
- describing the role of dashboards (Microsoft Documentation: Dashboards for Power BI service consumers)
- describe the workflow in Power BI
-