
Explore the DP-900 Azure Data Fundamentals exam basics, covering core data concepts, relational and non-relational databases, and the data analytics portion to prep for the certification.
Explore the DP-900 exam requirements for Azure data fundamentals, covering four major objectives: describe core data concepts, identify considerations for relational data, describe considerations for non-relational data, and analytics workloads.
Learn to use the Udemy video player with playback speed control, captions in multiple languages, and a transcript, while understanding how reviews and q&a improve the course experience.
Structured, semi-structured, and unstructured data: definitions, features, and examples for recognizing different data representations.
Common data file formats (CSV, JSON, XML, Parquet) and main database types: relational (SQL) and non-relational (NoSQL).
Explore common data workloads: OLTP for day-to-day transactions, OLAP for analytical processing, and data warehouses for reporting.
Identify the database administrator's role in design, security, backups, and disaster recovery; the data engineer's data movement, cleaning, governance, and pipelines; and the data analyst's insight generation.
Explore core data concepts including structured, unstructured, and semi-structured data, storage options, common workloads like oltp and olap, and the roles of database administrators, data engineers, and data analysts.
Identify the features of relational databases on Azure, including tables, rows, columns, and a predesigned schema; learn about primary keys, indexes, and views, plus how joins retrieve related data.
Explore normalization to design data tables that reduce redundancy and improve accuracy, enforce referential integrity, and use primary keys or compound primary keys to manage employee and manager relationships.
Explore normalization and the first three normal forms, learning how primary keys and atomic columns reduce data redundancy in relational databases.
Watch a live demo of a sample database dp900demo, explore tables and constraints, and learn how SQL selects, filters, and updates data in Azure SQL Server.
Explore the SQL standard and vendor variants like T-SQL, PL/SQL, and the DDL, DML, and DCL statements (create, alter, drop, truncate, select, insert, update, delete).
Watch a live demo in SQL Server Management Studio showing how to replace the star with specific columns and create a view with CREATE. The LimitedCustomer view demonstrates restricted access.
Create and use stored procedures to encapsulate queries, accept input parameters, execute complex statements, and improve performance as the database compiles and optimizes execution.
Learn how indexes improve query speed by sorting data, using a primary key and a first name index, and weigh the trade-offs on inserts and updates.
Explore Azure relational database options, including SQL Server on VM, SQL managed instance, Azure SQL Database, open-source databases like MySQL, PostgreSQL, MariaDB, and CosmosDB’s PostgreSQL option.
Explore Azure's relational database options—from SQL Server in a virtual machine (IaaS) to Azure SQL Database (PaaS) and Managed Instance, plus open-source options and Synapse Analytics insights.
Provision an Azure SQL database in the portal, choose server and database options, select a pricing model, configure access with firewall rules, and load sample data for testing.
Explore Azure resource manager ARM templates for automating SQL database deployments beyond portal. Download templates, script repeated deployments, and see resources, storage accounts, and dependencies, with Bicep as an abstraction.
Explore networking security with private links and firewall controls, identity security with Microsoft Entra, encryption with Azure Key Vault, and logging and auditing for SQL database.
Learn relational query tools for Azure data, including the Azure portal query editor, Azure Data Studio, SQL Server Management Studio, and the SQL command line utility.
Learn the basics of SQL for Azure data, including DDL, DML, and DCL commands. Understand SQL standards versus vendor-specific extensions like T-SQL and Oracle SQL.
Create an Azure storage account and upload mixed media, illustrating non-relational storage. Explore general purpose v2 and premium options, plus redundancy such as LRS, ZRS, and GRS with encryption.
Explore azure blob storage via containers, create and manage containers, upload diverse files, and switch access tiers from hot to cool to archive, with virtual folders and programmatic access.
Create and connect Azure file shares using SMB for centralized server storage, with hot or cool options, and map a drive like Z for direct access.
Explore Azure Table storage as a non-relational, semi-structured data store with entities identified by partition key and row key, offering flexible properties and no foreign keys.
Discover non relational data, its difference from relational databases, and why scale drives optimized data stores; learn about noSQL, core sequel, and data formats like XML and JSON.
Explore non-relational data types, from JSON document storage and column family structures to key-value table APIs, graph databases, and time series data, plus blob storage and Azure search options.
Compare relational and non-relational databases in azure, and learn how to select cosmos db, data warehouse, and storage for IoT and analytics, guided by normalization and data integrity concepts.
Learn Azure non-relational options, focusing on Cosmos DB’s multi-model, API-compatible design with tunable consistency and single-digit millisecond latencies, and compare table, blob, and file storage for cost and scale.
Explore Azure Cosmos DB, which provides six APIs for non-relational data, stores JSON documents, supports provisioned and serverless throughput, multi-region writes, backups, and private networking with key management.
Learn to create a Cosmos DB database and container, set a partition key, and store json documents in a nosql collection using the sql api.
Explore how ARM templates automate Cosmos DB deployments using Azure Resource Manager. Download, export, or view templates, apply parameterized settings, and deploy from the portal, CLI, or REST APIs.
Cosmos DB can be moved from public internet to a private network using firewalls and allowlists. Access relies on primary, secondary, or read-only keys.
Explore Cosmos DB geo-replication by creating read-only copies in East US and Northern Europe from a western United States database, and learn how multi-region writes boost performance and cost.
Explore data analytics workloads in Azure, including OLTP, OLAP, and data warehouses, to extract insights from relational databases and build business intelligence reports.
Explore how OLTP databases serve as back-end systems for read and write operations, normalization, data integrity, and immediate consistency in Azure options.
Learn how OLAP enables fast, multi dimensional analysis by separating analytics from OLTP production, providing read-only preprocessing, stable reads, and fast reports using cubes, dimensions, measures, and column store.
Consolidate data from OLTP sources into a data warehouse to support reporting and archiving. Enable scalable analytics with Azure Synapse Analytics for end-of-day and end-of-month reports using massively parallel processing.
Explore the modern data warehouse architecture, from diverse data sources and ingestion with Azure Data Factory to data lake, Azure Databricks, Synapse Analytics, Analysis Services, and Power BI.
Explore Microsoft Fabric, an all-in-one unification platform that integrates data tools like Power BI, Synapse, and Data Factory on OneLake, with built-in Purview protection and an AI assistant Co-Pilot.
Explore Azure data factory as the data orchestration tool for ingesting, transforming, and scheduling data with pipelines and activities, including SSIS imports and tumbling windows.
Pass the DP-900 Azure Data Fundamentals exam with 4.5 hours of focused video and an end-of-course practice test. No data background needed.
Complete preparation for the DP-900 Azure Data Fundamentals exam.
The content of this exam was updated for the latest exam changes.
Describe core data concepts (25-30%)
Describe how to work with relational data on Azure (20-25%)
Describe how to work with non-relational data on Azure (15-20%)
Describe an analytics workload on Azure (25-30%)
This course completely covers the DP-900 exam from start to finish. Always updated with the latest requirements. This course goes over each requirement of the exam in detail. If you have no background in databases and want to learn about them and want to learn more about database concepts and services within Azure, or have some background in databases and want to progress eventually to an Azure Data Engineer or Data Analyst type role, this course is a great resource for you.
Microsoft Azure is still the fastest-growing large cloud platform. The opportunities for jobs in cloud computing are still out there, and finding well-qualified people is the #1 problem that businesses have.
If you're looking to change your career, this would be a good entry point into cloud computing on the data side.
Sign up today!
Added English, Spanish, and Portuguese closed captions.