Microsoft Certified: Azure Data Fundamentals: DP-900: Microsoft Azure Data Fundamentals

  • 14 Courses | 18h 10m 6s
Likes 20 Likes 20
 
Explore core data concepts, relational and non-relational data on Azure, and analytic workload on Azure as you prepare for the DP-900: Microsoft Azure Data Fundamentals certification exam.

GETTING STARTED

Azure Data Fundamentals: Data Workloads

  • Playable
    1. 
    Course Overview
    1m 50s
    NOW PLAYING
  • Playable
    2. 
    Workload Management
    6m 12s
    UP NEXT

COURSES INCLUDED

Azure Data Fundamentals: Data Workloads
Data workloads refer to the system's ability to handle and process work. In this course, you'll learn about core data workloads and workload management, including the need for data solutions and the various types of data storage. You’ll then explore transactional and analytical workloads, Azure Batch, and real time processing. Finally, you’ll learn about the differences between batch data and streaming data and the fundamentals of relational data. This course is one in a collection that prepares learners for Microsoft Azure Data Fundamentals (DP-900) exam.
11 videos | 1h 11m
has Assessment available Badge
Azure Data Fundamentals: Data Analytics
Data analytics enables you to extract valuable insights from data and uncover patterns. In this course, you'll learn about data analytics core concepts. You'll examine data visualization, including business intelligence and reporting using Azure Data Explorer, a fully-managed big data analytics cloud platform. You'll then learn about SQL Server Reporting Services, data chart types, and different analytic techniques. You'll explore stream analytics and the associated data types. Finally, you'll learn to use extract, load, and transform data processing and also extract, transform, and load data processing. This course is one of a series that prepares you for the Microsoft Azure Data Fundamentals (DP-900) exam.
13 videos | 1h 31m
has Assessment available Badge
Azure Data Fundamentals: Relational Data Workloads
Relational data is stored in tables, which allows users to easily categorize and query the data. In this course, you'll learn about the characteristics of relational data and different relational databases. You'll explore how to use indexes and views in a relational database, as well as the different delivery models for relational data. Next, you'll examine Platform as a Service, Infrastructure as a Service, and Software as a Service. Finally, you'll learn about online transaction and analytical processing. This course is one in a series that prepares learners for the Microsoft Azure Data Fundamentals (DP-900) exam.
12 videos | 1h 25m
has Assessment available Badge
Azure Data Fundamentals: Relational Data Management
Relational data management ensures cloud database systems are versatile and functionable. In this course, you'll explore how to work with relational data on Azure, including basic management tasks for relational data such as SQL database and the security features within. You'll then learn about Azure Data Studio, Azure SQL Server Management Studio, SQL Server, and the sqlcmd utility. Finally, you'll learn about SQL Managed Instance, Azure Synapse Analytics, as well as different connectivity issues such as authentication or firewall. This course is one in a series that prepares learners for the Microsoft Azure Data Fundamentals (DP-900) exam.
14 videos | 1h 49m
has Assessment available Badge
Azure Data Fundamentals: Provisioning & Configuring Relational Data Services
Azure database services are fully managed, which frees up valuable time otherwise spent on managing them. In this course, you'll learn how to provision relational data services and a Microsoft Azure SQL Database. You’ll explore how to provision a Microsoft Azure SQL Database for PostgreSQL, MySQL, and MariaDB. Next, you'll discover how to configure a Microsoft Azure SQL Database. Finally, you’ll learn how to configure Azure Database for PostgreSQL, MySQL, and MariaDB. This course is one in a series that prepares learners for the Microsoft Azure Data Fundamentals (DP-900) exam.
11 videos | 1h 12m
has Assessment available Badge
Azure Data Fundamentals: Azure SQL Querying Techniques
Azure SQL is used for extracting and organizing data that is stored in a relational database. In this course, you'll learn how to recognize and apply data querying techniques using SQL, Data Definition Language, and Data Manipulation Language. You’ll start by learning about Structured Query Language including its uses, features, and limitations. You’ll examine how to work with the Data Definition Language and Data Manipulation Language. Next, you'll learn how to query Azure SQL Database using the Azure portal, SSMS, Data Studio, and the sqlcmd utility. Finally, you'll discover how to query relational data in PostgreSQL, MySQL, and MariaDB. This course is one in a series that prepares learners for the Microsoft Azure Data Fundamentals (DP-900) exam.
12 videos | 1h 11m
has Assessment available Badge
Azure Data Fundamentals: Non-relational Data Workloads
Non-relational databases use a storage model that is optimized for the data being stored. In this course, you'll learn about characteristics of non-relational data, including the different types of non-relational data. You'll learn when to use non-relational versus relational data. Next, you'll explore the use of CSV and JSON files for non-relational data and the requirements of non-relational data stores. You’ll examine free-form text for search, including architecture and challenges. Finally, you'll learn about time series solutions, including their benefits and challenges. This course is one in a series that prepares learners for the Microsoft Azure Data Fundamentals (DP-900) exam.
9 videos | 55m
has Assessment available Badge
Azure Data Fundamentals: Non-relational Data Services
Non-relational data repositories can store data in its original format and allow fast storage and retrieval access. In this course, you'll learn about the non-relational data services, including Azure Table Storage, Azure Blob Storage, and Azure File Storage. You'll also learn how to provision and configure non-relational data services and manage Azure Blob Storage and Azure File Storage. This course is one in a series that prepares learners for the Microsoft Azure Data Fundamentals (DP-900) exam.
10 videos | 58m
has Assessment available Badge
Azure Data Fundamentals: Azure Cosmos DB
Cosmos DB is a fully managed NoSQL database for modern app development. In this course, you'll learn about non-relational data offerings on Azure, including Cosmos DB and the different entities in the resource model. You'll learn how to provision and configure Cosmos DB and query data. Next, you'll explore the various Cosmos DB APIs and learn how to use Core (SQL) API for Cosmos DB. Finally, you'll examine how to use the Cosmos DB API, as well as how to use the Cassandra, Azure Table, and Gremlin APIs in Cosmos DB. This course is one in a series that prepares learners for Microsoft Azure Data Fundamentals (DP-900) exam.
13 videos | 1h 31m
has Assessment available Badge
Azure Data Fundamentals: Non-relational Data Management
Non-relational data does not use SQL for queries and instead it uses other programming languages and constructs to query the data. This course covers basic management tasks for non-relational data, including how to deploy data using the Azure portal, Azure Resource Manager Templates, Azure PowerShell, and the Azure CLI. You'll learn about Cosmos DB firewall, authentication, and other security components. Finally, you'll explore Azure Cosmos DB Explorer and Geo-replication, as well as various issues that may arise with access control, .NET SDKs, and Java SDKs. This course is one in a series that prepares learners for the Microsoft Azure Data Fundamentals (DP-900) exam.
14 videos | 1h 32m
has Assessment available Badge
Azure Data Fundamentals: Azure Analytics Workloads
Azure Synapse Analytics is a limitless analytics service that brings together data warehousing and big data analytics. In this course, you will learn about analytics workloads, including Azure Synapse Analytics, Azure Synapse SQL pool, Data Warehouse Units. You'll also learn about the difference between transactional and analytic workloads and batch and real time data processing. You'll use Azure Portal and Azure Pow