DP-900 Microsoft Azure Data Fundamentals Certification

Explore relational data stores on azure by examining the azure sql database, microsoft sql server on an azure virtual machine, and the azure sql managed instance, with exam-focused insights.

Explore infrastructure as a service via virtual machines and platform as a service with Azure SQL Database for hosting relational databases on Azure, including pay-as-you-use pricing.

connect to a deployed sql virtual machine in azure using native rdp, download the rdp file, and log in with sqladmin credentials via its public ip address.

Explore how Azure SQL Database as a platform as a service lets you host Microsoft SQL Server databases without managing the underlying server, with automatic backups and patches.

Install Azure Data Studio on your laptop, covering Windows system installer (x64) and macOS availability, with download, license acceptance, next, and install steps. Launch the app to explore the interface.

Install Azure Data Studio on macOS, connect to a Microsoft SQL Server, and explore databases and tables, including the App DB.

Explore core database terms like database, relational database, table, columns and rows, SQL, and result set to understand how data is stored, organized, and retrieved.

Master the ACID properties of a database system, including atomicity, consistency, isolation, and durability, and how they ensure all-or-nothing transactions, data integrity, and durable logs even during failures.

Learn to use the select statement to retrieve rows from tables, choose all or specific columns, and apply aliases, viewing results in Azure Data Studio and Azure SQL database.

Sort query results using the order by clause, ordering by unit price in ascending or descending order. Combine order by with where clauses to create multi-clause queries in SQL.

Group by the product id to get the maximum order quantity per product, alias the result as order quantity, and order by that alias and by product id.

Learn how to use the SQL inner join to combine data from the SalesOrderDetail and Product tables, using ProductID in the ON clause and table aliases for clarity.

Discover database normalization using first and second normal forms to cut data duplication by splitting data into students, courses, and orders and linking them with IDs.

Create a table with the create table command, define student_id and student_name, and enforce not null and primary key constraints while practicing inserts and schema basics like dbo.

Learn how to create and relate course, student, and orders tables by defining primary keys and foreign keys, enforce relationships, and perform updates, inserts, deletes, and drops.

Create a new sql login in the master database, map it to a user in appdb, and grant select permission on tables to enable data access for the new user.

Demonstrates creating a customers table and a clustered index on customer id, showing how the index transforms a full table scan into a fast, index-based lookup.

Learn how stored procedures bundle SQL statements and run on the database server, improving security, then define a change_age procedure with customer_id and new_age to update a customer's age.

Master the sqlcmd command line utility to connect to Azure SQL Database, run interactive queries like select from customers, and view results in tabular format, for dp-900 azure data fundamentals.

Learn how transparent data encryption protects data at rest in Azure SQL Database, SQL Managed Instance, and Azure Synapse by encrypting disk-stored files with a key.

Enable and manage the server firewall for the Azure SQL Database by adding firewall rules with names and IP addresses, saving changes, and allowing access from other Azure services.

Explore the Azure SQL managed instance, a fully managed paas offering with 100 percent SQL Server compatibility and automated backups, deployed in a private virtual network.

Explore the Azure SQL Database serverless compute tier, billed per second and automatically pausing when idle, ideal for variable usage patterns compared to DTU-based purchasing.

Compare data manipulation language with data definition language, and confirm atomic transactions in relational data. Assess Azure SQL Database service and Azure SQL Managed Instance for compatibility and admin tasks.

Create an Azure storage account by selecting a subscription and resource group, entering a unique name in North Europe, selecting locally-redundant storage, and exploring blob, file shares, queues, and tables.

Explore Azure blob storage access tiers: hot, cool, cold, archive—and compare their storage and access costs, including minimum durations of 30, 90, and 180 days and archive rehydration.

Learn how to connect to an Azure file share from macOS by using the macOS script, copy it to the clipboard, paste into the terminal, and access files.

Explore Azure Storage Explorer on macOS ARM64, sign in with Azure, load subscriptions, and navigate storage accounts, containers, and file shares.

Explore Azure Cosmos DB concepts, including the NoSQL API, databases and containers, logical partitions guided by partition keys, and throughput via request units for fast, scalable queries.

Create an azure cosmos db account with the nosql api, configure resource group and region, set provisioned throughput (request units), and apply the free tier before creation.

Learn to set up an azure cosmos db account using the nosql api, create databases and containers, choose a partition key, manage throughput, add items, and query with sql-like syntax.

Explore global data replication in Azure Cosmos DB with read and write regions, reducing latency and costs, and understand when to enable multiple region writes.

Create a Cosmos DB account with the Table API, define a table, and add entities with a partition key and the real key, highlighting low latency access and global replication.

Create an Azure Cosmos DB account with the Gremlin API, then build a graph of employees and departments by adding vertices and edges, using city as the partition key.

Review non-relational data concepts and flexible schemas. Outline Azure storage services, including blob, file share, table, and queue, storage tiers, and Cosmos DB APIs with geo-redundancy.

Explore Azure Blob Storage and Azure Data Lake Gen2, Azure SQL Database, and Azure Cosmos DB, and learn to extract data, transform, and move to a destination with Azure Synapse.

Process data from multiple sources with batch or stream methods, handling formats like JSON, relational, XML, audio, and video; batch yields nightly reports, stream enables real-time analytics.

Explore the etl process—extract data from a data lake or logs, transform and clean it, then load into a data warehouse for analytics, outlining OLTP versus OLAP.

Create an Azure Data Lake Gen2 storage account on top of Azure Storage accounts, enable hierarchical namespace, and organize data with containers and directories for raw data analytics.

Explore Azure Synapse Analytics as an enterprise data platform, covering Synapse SQL, Apache Spark, Data Factory features, Data Lake Storage Gen2, and Studio‑driven tooling for ingestion, processing, and reporting.

Explore using the Azure Synapse serverless SQL pool to analyze CSV data in an Azure Data Lake Gen2 storage account via Open Synapse Studio, with costs based on data processed.

Explain how a SQL data warehouse supports analysis with OLAP design, contrasting online transactional processing with historical data storage, and describing fact and dimension tables in star or snowflake schemas.

Explore how fact tables store quantitative sales data and how dimension tables provide context with product and region details for effective SQL data warehouse design and analysis.

Learn to set up a dedicated SQL pool in Azure Synapse, manage data warehousing units and cost, pause compute, and build a fact-based table by joining SalesOrderHeader and SalesOrderDetail.

Set up a dedicated sql pool in azure synapse, create a fact table, and copy data from azure sql into the pool using a data factory pipeline, with monitoring.

Understand Azure Synapse sql architecture, including the serverless pool for external data sources and dedicated pool for hosting sql data, and how the control node distributes queries across compute nodes.

Explore how to create and use an Apache Spark pool in Azure Synapse to read data from a Data Lake Gen2 storage account using notebooks and a data frame.

Explore Azure Data Factory, a cloud-based ETL and data integration service that builds pipelines to extract, transform, and load data across sources and destinations.

Create an Azure Data Factory resource, design a pipeline with copy data activity to convert CSV to Parquet, and copy Parquet to a dedicated SQL pool in Azure Synapse.

Use mapping data flows in Azure Data Factory to transform data with spark. Filter null resource groups from CSV in data lake Gen2 and load into SQL pool via pipeline.

Learn how to use Azure Stream Analytics to process real-time data from Blob Storage, Event Hubs, and IoT Hub within a Stream Analytics job by defining inputs, queries, and outputs.

Create an Azure stream analytics job with a csv input from Azure Data Lake Gen2 and an Azure Synapse dedicated sql pool output, then verify results after uploading ActivityLog.csv.

Introduce Azure Databricks and the data lakehouse concept, combining data lake flexibility with SQL data warehouse capabilities to handle rapid, semi-structured data, governance, and transactions.

Create an Azure Databricks workspace by selecting a resource group and North Europe location, choosing the trial pricing, configuring networking, encryption, security, and tags, then review and create.

Learn to read csv data from an Azure Data Lake Gen2 storage using a Spark-based Databricks notebook, creating a minimal compute cluster, loading into a data frame, and displaying results.

Install Power BI Desktop to start building reports on Windows; download the x64 version or via the Microsoft Store, accept the license, and complete the setup.

Learn to connect Power BI Desktop to Azure Data Lake Gen2 Storage, fetch activity log data with a SAS token, transform via Power Query, and visualize operation counts by status.

Connect Power BI Desktop to an Azure SQL database, load the AdventureWorks product data (SalesLT Product), and visualize it with a tree map to explore product variations.

Load multiple tables from an Azure SQL Database into Power BI Desktop, such as the Sales Order Header and Sales Order Detail, and model one-to-many relationships for cross-table insights.

Learn to create a calculated column in Power BI Desktop using the Power Query Editor by multiplying order quantity by unit price to compute an initial total.

Discover another method to create a calculated column in Power BI Desktop using a DAX expression in the model, by defining InitialTotal as OrderQuantity multiplied by UnitPrice in Table view.

Use Power BI Desktop to create a clustered column chart from ActivityLog.csv in Azure Data Lake Gen2, showing counts by status with a month-based X-axis.

Publish Power BI Desktop reports to the cloud-based Power BI service, share visuals and dashboards with free licenses, and set up Microsoft Entra ID and license admin roles.

Master paginated reports with Power BI Report Builder, publish to the Power BI service, and understand that advanced license is required beyond free Power BI for multi-page tables.

Explore the range of Power BI visualizations, from bar and column charts to maps and scatter charts, and learn how charts like key influencers, KPIs, tables, and treemaps convey data.

Create Power BI dashboards in the service by pinning tiles from reports and combining multiple datasets with standalone elements like text, images, and streaming content for an executive overview.

Explore Azure HDInsight as a managed cloud analytics service for DP-900 Microsoft Azure data fundamentals, supporting Apache Spark, Apache Hive, Kafka, and Hadoop for enterprise data analysis, with cluster creation.

Create and configure an Azure web app in your existing resource group, select .NET 8, and use a free app service plan to deploy it.

Deploy an Azure Event Hubs namespace and an Event Hub in North Europe with basic pricing. Configure diagnostic settings to stream web app logs to the Event Hub.

Configure an Azure Stream Analytics input from an Azure Event Hub to process web app http logs, extract method, status, uri, and ip with cross apply and test query.

Connect to the Azure SQL database, load data into Power BI, and visualize status by IP address with a pie chart. Then stop the stream analytics job and delete resources.

Schedule your DP-900 exam through Pearson after finishing the course. Practice with the assessment and quizzes to reinforce key Azure data fundamentals concepts.