Microsoft Certified: Azure Data Fundamentals: DP-900: Microsoft Azure Data Fundamentals
Certification Exam:
- 1 Course | 56m
- 1 Book | 7h 12m
- Includes Lab
- Includes Test Prep
- 7 Courses | 5h 8m 31s
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.
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 6m
Assessment
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 26m
Assessment
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 20m
Assessment
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 43m
Assessment
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 7m
Assessment
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 6m
Assessment
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 |
52m
Assessment
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 |
54m
Assessment
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 26m
Assessment
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 26m
Assessment
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 PowerShell to create a Synapse SQL pool and Azure Data Lake Analytics. You'll learn about data warehousing workloads and when to use a data warehouse solution. Finally, you'll learn about the different Azure Data Lake Analytics. This course is one in a series that prepares learners for the Microsoft Azure Data Fundamentals (DP-900) exam.
12 videos |
59m
Assessment
Badge
Azure Data Fundamentals: Azure Data Ingestion & Processing
Data ingestion and processing allows your data to be assessed, used, and analyzed. In this course, you'll learn about Azure data ingestion and processing, including loading strategies for Synapse SQL Pools. You'll examine Azure data factory pipelines and activities, as well as how to create an Azure data factory. Next, you'll learn how to use the data factory copy data tool to copy data. Finally, you'll explore how to use SQL Server Integration Services, Azure Databricks, Azure Synapse Analytics, and Azure Data Lake to ingest data. This course is one in a series that prepares learners for the Microsoft Azure Data Fundamentals (DP-900) exam.
11 videos |
1h 12m
Assessment
Badge
Azure Data Fundamentals: Azure Data Visualization
Power BI allows you to visualize your data and gain deeper insight by creating interactive and immersive dashboards and reports. In this course, you'll learn how to use Microsoft Power BI to optimize data, load datasets, and create dashboards. Next, you'll explore how to use Power BI for paginated and interactive reports, as well as for publishing reports. You'll also examine how to use the different types of Power BI visualizations. Finally, you'll learn about workflows and Power BI security and administration. This course is one in a series that prepares learners for the Microsoft Azure Data Fundamentals (DP-900) exam.
12 videos |
1h
Assessment
Badge
Azure Data Fundamentals: Modern Data Warehousing
Modern data warehousing lets you bring your data together at any scale and provide insights through analytics. This course, you'll learn about the components of a modern data warehouse and its architecture and how it can benefit your organization. You'll start by learning about modern data warehousing, and then the data warehousing architecture. You'll then learn about Azure Data Factory, Azure Data Lake, and Azure Databricks. You'll then go on to explore Azure Analysis Services and Azure HDInsights. Finally, you'll discover Azure Distributed Data Engineering Toolkit. This course is one in a series that prepares learners for the Microsoft Azure Data Fundamentals (DP-900) exam.
11 videos |
1h 7m
Assessment
Badge
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Azure Data Fundamentals: Structured Data
Data plays a pivotal role in today's digital landscape, with organizations relying on various data types to make informed decisions and streamline operations. Understanding the differences between structured, semi-structured, and unstructured data, as well as how to manage, store, and process these different types, is essential for data professionals. In this course, learn the key concepts of structured data, beginning with data classification and structured data characteristics. Next, examine structured data use cases and formats. Finally, discover how to use specific tools and platforms, such as Azure, to handle XML file processing and store, query, and index JSON data in SQL Server. This course is one of a collection that prepares learners for the DP-900: Microsoft Azure Data Fundamentals exam.
8 videos |
41m
Assessment
Badge
Azure Data Fundamentals: Semi-Structured & Unstructured Data
Semi-structured and unstructured data types comprise the majority of the data generated today. They offer valuable insights for decision-making and trend analysis, are pivotal for training AI and machine learning models, and are essential for advanced analytics techniques in the era of big data. In this course, learn about the characteristics that define semi-structured data, including how it compares to structured and unstructured formats. Next, explore the practical uses of semi-structured data in various scenarios and how to index nested JSON blobs in Azure. Finally, examine unstructured data, industry-specific case studies, and storing and managing large volumes of unstructured data using Azure. This course is one of a collection that prepares learners for the DP-900: Microsoft Azure Data Fundamentals exam.
9 videos |
44m
Assessment
Badge
Azure Data Fundamentals: Azure Data Storage
In today's data-driven world, understanding how to effectively store, manage, and process vast amounts of information is crucial for businesses and organizations. In this course, learn the core concepts of Azure data storage, beginning with Azure data storage solution fundamentals, the different data store models, and using Azure Table storage and Queue Storage. Next, explore Azure Blob Storage and create an Azure SMB file share and Azure SQL Database using the CLI. Finally, discover how to create a Data Explorer pool using the Azure portal and send device data to Azure Storage using IoT Hub message routing. This course is one of a collection that prepares learners for the DP-900: Microsoft Azure Data Fundamentals exam.
11 videos |
1h
Assessment
Badge
Azure Data Fundamentals: Data Storage Considerations
Whether you're dealing with structured, semi-structured, or unstructured data, there are key considerations you need to take into account when choosing the most appropriate storage solution and technology. In this course, learn about managing both relational and non-relational databases and choosing the appropriate data store. Next, discover how to handle large datasets with big data storage, how NoSQL database storage benefits non-relational data, and which database technology works best in common database scenarios. Finally, explore data pipeline orchestration and various data transfer methods. This course is one of a collection that prepares learners for the DP-900: Microsoft Azure Data Fundamentals exam.
9 videos |
37m
Assessment
Badge
Azure Data Fundamentals: Azure Analysis Services
As data analytics becomes increasingly central to business strategy, understanding the tools and processes for managing and analyzing vast amounts of data is essential. In this course, learn about Azure Analysis Services, beginning with an overview of Azure Analysis Services and its importance in the data analysis landscape, as well as how to set up a scalable analysis environment. Next, discover how to add and manage data models, configure roles for user permissions and security, and examine workload roles. Finally, explore the fundamentals of online analytical processing (OLAP), its real-world use cases, and how to implement OLAP in Azure to support scalable, cloud-based data solutions. This course is one of a collection that prepares learners for the DP-900: Microsoft Azure Data Fundamentals exam.
10 videos |
41m
Assessment
Badge
Azure Data Fundamentals: Analytical Workloads
Tools like Power BI, SQL Server Analysis Services (SAAS), and Azure Stream Analytics can significantly enhance decision-making through their robust data visualization capabilities, scalability, and the capacity to handle large datasets. In this course, learn how to connect Power BI Desktop to data sources for interactive analytics, how columnstore indexes in SQL Server improves query performance, and how SAAS can be used to build and deploy OLAP and data mining models. Next, explore the SAAS installation process and the different types of data analytics workloads for business intelligence. Finally, explore Azure Stream Analytics and how to create and configure Stream Analytics jobs for processing live data streams. This course is one of a collection that prepares learners for the DP-900: Microsoft Azure Data Fundamentals exam.
9 videos |
47m
Badge
Azure Data Fundamentals: Online Transaction Processing (OLTP)
Managing and optimizing databases is essential for businesses that rely on high-performance data transactions and scalable cloud solutions. In this course, learn about various aspects of online transaction processing (OLTP) and cloud-based database solutions, particularly in the Azure environment. Next, explore the foundations of OLTP, its best practices, and real-world use cases to help you understand how to handle high volumes of transactional data effectively. Finally, examine In-Memory OLTP and memory-optimized tables, which are designed to accelerate data processing and enhance system responsiveness, especially in high-demand applications. This course is one of a collection that prepares learners for the DP-900: Microsoft Azure Data Fundamentals exam.
8 videos |
36m
Badge
SHOW MORE
FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.BOOKS INCLUDED
Book
MC Microsoft Certified Azure Data Fundamentals Study Guide: Exam DP-900The book prepares you for the test - and for a new career in Azure data analytics, architecture, science, and more - with a laser-focus on the job roles and responsibilities of Azure data professionals.
7h 12m
By Jake Switzer
SKILL BENCHMARKS INCLUDED
Microsoft Azure Data Fundamentals: Core Data Concepts Literacy (Beginner Level)
The Microsoft Azure Data Fundamentals: Core Data Concepts Literacy (Beginner Level) benchmark measures your ability to identify and recognize basic data concepts and how it is represented and used. You will be measured on your knowledge of concepts such as different data formats, types of storage, databases, and types of data processing. A learner who scores high on this benchmark demonstrates that they have the necessary knowledge of data fundamentals and the skills to start exploring Azure.
9m
| 9 questions
Microsoft Azure Data Fundamentals: Azure Data Analytics Literacy (Beginner Level)
The Microsoft Azure Data Fundamentals: Azure Data Analytics Literacy (Beginner Level) benchmark measures your ability to identify and recognize the basic concepts of data analytics, data visualization, Azure Storage services, ELT, and ETL. You will be evaluated on your ability to recognize concepts such as analytics and reporting, analytical techniques, stream analytics and data types, and processing data using ETL and ELT. A learner who scores high on this benchmark demonstrates that they have the necessary Azure data analytics knowledge to start exploring analytics on the Azure platform.
11m
| 11 questions
Microsoft Azure Data Fundamentals: Azure Data Analytics Competency (Intermediate Level)
The Microsoft Azure Data Fundamentals: Azure Data Analytics Competency (Intermediate Level) benchmark measures your ability to identify, recognize, and apply concepts of data analytics, the Azure Synapse Analytics architecture, and transactional and analytical workloads. You will be evaluated on your ability to recognize concepts about Synapse Analytics, Synapse SQL pool, batch and real-time data processing, and using the Azure portal, Azure PowerShell, Azure Data Lake Analytics, and Azure Data Factory. A learner who scores high on this benchmark demonstrates that they have the necessary Azure data analytics skills to perform analytics on the Azure platform with minimal supervision.
19m
| 19 questions
Microsoft Azure Data Fundamentals: Azure Data Analytics Proficiency (Advanced Level)
The Microsoft Azure Data Fundamentals: Azure Data Analytics Proficiency (Advanced Level) benchmark measures your ability to identify, recognize, and apply the concepts of data analytics, data visualization with Microsoft Power BI, and modern data warehousing. You will be evaluated on your ability to recognize concepts such as optimizing data, datasets, dashboards, reporting, visualization types, data warehousing benefits, and using Azure Data Factory, Azure Data Lake, Azure Databricks, Azure Analysis Services, Azure HDInsight, and the Azure Distributed Data Engineering Toolkit (AZTK). A learner who scores high on this benchmark demonstrates that they have the necessary Azure data analytics skills to perform analytics on the Azure platform independently.
19m
| 19 questions
Microsoft Azure Data Fundamentals: Azure Non-relational Data Workloads Proficiency (Advanced Level)
The Microsoft Azure Data Fundamentals: Azure Non-relational Data Workloads Proficiency (Advanced Level) benchmark measures your ability to identify, recognize, and apply concepts of Azure non-relational data workloads. You will be evaluated on your ability to recognize concepts such as Azure Cosmos DB, provisioning and configuring an Azure Cosmos database, non-relational data management, and more. A learner who scores high on this benchmark demonstrates that they have the necessary Azure non-relational data skills to perform non-relational data workloads on the Azure platform independently.
23m
| 23 questions
Microsoft Azure Data Fundamentals: Azure Non-relational Data Workloads Competency (Intermediate Level)
The Microsoft Azure Data Fundamentals: Azure Non-relational Data Workloads Competency (Intermediate Level) benchmark measures your ability to identify, recognize, and apply concepts of Azure non-relational data workloads. You will be evaluated on your ability to recognize concepts such as non-relational data stores, processing CSV and JSON files, time series solutions, provisioning and configuring non-relational data services, Azure Blob Storage, and more. A learner who scores high on this benchmark demonstrates that they have the necessary Azure non-relational data skills to perform non-relational data workloads on the Azure platform with minimal supervision.
15m
| 15 questions
Microsoft Azure Data Fundamentals: Azure Relational Data Workloads Competency (Intermediate Level)
The Microsoft Azure Data Fundamentals: Azure Relational Data Workloads Competency (Intermediate Level) benchmark measures your ability to identify, recognize, and apply the concepts of relational data workloads in Azure. You will be evaluated on your ability to recognize concepts such as relational data stores and delivery models, SQL relational databases, SaaS in Azure, OLAP and OLTP, Azure SQL security features, and more. A learner who scores high on this benchmark demonstrates that they have the necessary Azure relational data skills to perform relational data workloads on the Azure platform with minimal supervision.
20m
| 20 questions
Microsoft Azure Data Fundamentals: Azure Relational Data Workloads Proficiency (Advanced Level)
The Microsoft Azure Data Fundamentals: Azure Relational Data Workloads Proficiency (Advanced Level) benchmark measures your ability to identify, recognize, and apply concepts of provisioning and configuring relational data services on Azure, as well as Azure SQL querying techniques. You will be evaluated on your ability to recognize concepts such as Azure Database for PostgreSQL, MySQL, and MariaDB. A learner who scores high on this benchmark demonstrates that they have the necessary Azure relational data skills to perform relational data workloads on the Azure platform independently.
16m
| 16 questions
SHOW MORE
FREE ACCESS
