DP-900 prep: Microsoft Azure Data Fundamentals
Work with Azure data in the cloud, inc. relational (Azure SQL) and non-relational (Cosmos DB) databases. For exam DP-900
Lo que serás capaz de hacer
This course is the foundation for the Microsoft Certificate DP-900 "Azure Data Fundamentals", and focuses on relational and non-relational data, together with analytics workloads. It is updated in line with the exam updates as of the minor updates as of 1 November 2024 and 1 November 2025. Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft. What do people like you say about this course? Girma says: " Great! – Azure would never be difficult (as most of us think) after thoroughly going through this course. " Ankona says: " Very good course. Philip proves why is indeed the go to guy for everything to do with databases. I have taken a couple of his courses on various aspects of databases and he never disappoints. " Karen says: " This course helped me to clear the exam with 903. " We'll start off with looking at relational data . We'll create an Azure account, install an Azure SQL Database and query it. We'll then look at the 6 different clauses of the SELECT statement - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY. After this, we'll have a look at other relational databases, including Azure Databases for PostgreSQL, MariaDB and MySQL. After that, we'll look at non-relational data using semi-structured and non-structured data. We'll look at the five different Cosmos DB database interfaces or APIs, and which one you should use for your particular needs. We'll also look at Table, Blob and File storage. We'll then look at analytics workloads , including Azure data services for modern data warehouses such as Azure Data Lake, Synapse Analytics, Databricks and HDInsight. Finally, we'll look at Microsoft Power BI and how to create basic reports and dashboards. No prior knowledge is required - we'll even see how to get a free Azure trial! There are regular quizzes to help you remember the information, so you can be sure that you are learning. Once you have finished this course, you will have a good introductory knowledge of core data concepts and how they are implemented using Microsoft Azure data services. And with some practice, you could even go for an official Microsoft certification - wouldn't that look good on your CV or resume? And if you are an American college student, you might even get college credit for passing that exam.
- Understand types of core data workloads and data analytics core concepts
- Understand how to work with relational data on Azure, including Azure SQL Database and Managed Instance
- Understand how to work with non-relational data on Azure, including Cosmos DB APIs, Table, Blob and File storage
- Describe analytics workloads, including data warehouses, data ingestion and processing on Azure
- Describe data visualization in Microsoft Power BI, including reports and dashboards
Temario
UNIDAD 1 - Introduction · 6 leccionesUNIDAD 1 - Introduction
UNIDAD 1 - Introduction
- Introduction
- Welcome to Udemy
- The Udemy Interface
- Do you want auto-translated subtitles in more languages?
- Curriculum
- Resources
UNIDAD 2 - Let's start using Microsoft Azure · 3 leccionesUNIDAD 2 - Let's start using Microsoft Azure
UNIDAD 2 - Let's start using Microsoft Azure
- What is Azure
- Creating an Azure account
- 15. Install Azure SQL Database with sample data
UNIDAD 3 - Creating SELECT statements · 7 leccionesUNIDAD 3 - Creating SELECT statements
UNIDAD 3 - Creating SELECT statements
- 13. Query relational data in PostgreSQL, MySQL, and Azure SQL Database - SELECT
- Create your first SELECT statement
- Reducing the number of columns and rows
- Summarise data
- Refining your results
- Rearranging the results
- The SELECT statement clauses
UNIDAD 4 - Programs used for querying relational data · 3 leccionesUNIDAD 4 - Programs used for querying relational data
UNIDAD 4 - Programs used for querying relational data
- Programs used for querying relational data: SQL Server Management Studio
- Programs used for querying relational data: Azure Data Studio
- Differences between SSMS and Azure Data Studio
UNIDAD 5 - Describe relational data workloads · 8 leccionesUNIDAD 5 - Describe relational data workloads
UNIDAD 5 - Describe relational data workloads
- 1, 11, 12. Describe the characteristics of relational data - Tables
- 1, 11, 12. Describe the characteristics of relational data - Normalization
- 1, 11, 12. Characteristics of relational data - Primary and Foreign Keys
- 1, 11, 12. Describe the characteristics of relational data
- 14. Describe relational data structures: Indexes
- 14. Describe relational data structures: Views
- 14. Other relational data structures
- 11. Describe relational data structures (e.g., tables, index, views)
UNIDAD 6 - Describe relational Azure data services - SQL Server · 8 leccionesUNIDAD 6 - Describe relational Azure data services - SQL Server
UNIDAD 6 - Describe relational Azure data services - SQL Server
- On Prem versus the Cloud
- Describe and compare PaaS, IaaS, and SaaS delivery models
- 15. Creating Azure SQL Database (in detail) - Part 1 (including Regions)
- 15. Creating Azure SQL Database - Elastic Pools, compute and storage
- 15. Creating Azure SQL Database - other settings
- 15. Describe Azure SQL Managed Instance
- 15. Describe SQL Server on Azure Virtual Machine
- SQL Server and PaaS, IaaS and SaaS
UNIDAD 7 - Describe relational Azure data services - Other Azure relational Databases · 6 leccionesUNIDAD 7 - Describe relational Azure data services - Other Azure relational Databases
UNIDAD 7 - Describe relational Azure data services - Other Azure relational Databases
- 16. Describe Azure Database for PostgreSQL
- 16. Describe Azure Database for MySQL
- 16. Describe Azure Database for MariaDB
- 4, 5. Identify the right data offering for a relational workload
- 8-10. Identify roles and responsibilities for data workloads
- Other Azure relational Databases
UNIDAD 8 - Non-relational Data - Semi-structured Data · 8 leccionesUNIDAD 8 - Non-relational Data - Semi-structured Data
UNIDAD 8 - Non-relational Data - Semi-structured Data
- 2, 3. Non-relational data - an introduction
- 20, 21. Azure Cosmos DB APIs - Creating a Core (SQL) Cosmos DB
- 20, 21. Azure Cosmos DB APIs - Querying a Core (SQL) Cosmos DB
- 20, 21. Replicating Data Globally
- 20, 21. Azure Cosmos DB APIs - Gremlin API (Graph)
- 20, 21. Other Azure Cosmos DB APIs
- 4, 5. Recommend the correct data store
- Describe non-relational data workloads
UNIDAD 9 - Describe non-relational data offerings on Azure · 7 leccionesUNIDAD 9 - Describe non-relational data offerings on Azure
UNIDAD 9 - Describe non-relational data offerings on Azure
- Storage Accounts
- Replication Options
- 19. Describe Azure Table storage
- 17. Creating and uploading to Azure Blob storage
- 17. Accessing and assigning access tiers to BLOB Storage
- 18. Describe Azure File storage
- Describe non-relational data offerings on Azure
UNIDAD 10 - Describe analytics workloads · 6 leccionesUNIDAD 10 - Describe analytics workloads
UNIDAD 10 - Describe analytics workloads
- 6. What is a transaction?
- 6. Describe transactional workloads: ACID, Locks and Distributed Databases
- 22. Describe data warehousing workloads: Ingestion and common practices
- 25. Describe the difference between batch and real time (streaming)
- 7. Describe the difference between a transactional and an analytics workload
- Describe analytics workloads
UNIDAD 11 - Describe the components of a modern data warehouse · 11 leccionesUNIDAD 11 - Describe the components of a modern data warehouse
UNIDAD 11 - Describe the components of a modern data warehouse
- Azure Data Factory and concepts of data processing
- SQL Server Integration Services (SSIS)
- Azure Data Lake
- 24a. Azure Databricks
- 26b. Azure Synapse Data Explorer
- 24a. Azure Synapse Analytics
- 26c. Spark structured streaming
- SQL Server Analysis Services (SSAS)
- Azure HDInsight
- 24b. Microsoft Fabric
- Describe the components of a modern data warehouse
UNIDAD 12 - Describe data visualization in Microsoft Power BI · 7 leccionesUNIDAD 12 - Describe data visualization in Microsoft Power BI
UNIDAD 12 - Describe data visualization in Microsoft Power BI
- 27. Identify capabilities of Power BI
- 28. Describe the workflow in Power BI
- 27. Describe the role of interactive reports
- 29. Describe basic chart types such as bar charts and pie charts
- 29. Advanced Chart Types
- 27. Describe the role of paginated reporting
- 27. Describe the role of dashboards
UNIDAD 13 - Congratulations · 3 leccionesUNIDAD 13 - Congratulations
UNIDAD 13 - Congratulations
- Practice Test
- You've finished this course - what should you do to prepare for the exam?
- Well done
UNIDAD 14 - Additional - Identify basic management tasks for non-relational data · 3 leccionesUNIDAD 14 - Additional - Identify basic management tasks for non-relational data
UNIDAD 14 - Additional - Identify basic management tasks for non-relational data
- No longer needed for DP-900 exam
- Describe method for deployment
- Identify data security components and basic connectivity issues
UNIDAD 15 - Additional - Analytics workloads and Power BI · 5 leccionesUNIDAD 15 - Additional - Analytics workloads and Power BI
UNIDAD 15 - Additional - Analytics workloads and Power BI
- Describe ELT and ETL processing
- Determine when a data warehouse solution is needed
- Describe modern data warehousing architecture and workload
- Describe analytics techniques
- Analytics workloads and Power BI
UNIDAD 16 - Bonus Lecture · 1 leccionesUNIDAD 16 - Bonus Lecture
UNIDAD 16 - Bonus Lecture
- Bonus Lecture - DP-900
Tu certificado lo emite la SEP, no solo una plataforma
Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.
Tu certificado con INEC
- Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
- Documento oficial con folio verificable en línea
- Lo otorga la Universidad Tecnológica Fidel Velázquez
Otras plataformas en línea
- Constancia privada emitida por la misma plataforma
- Solo acredita horas cursadas o asistencia
- Sin respaldo de una autoridad educativa
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
16 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
11 cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
- Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
- Contenido impartido por Phillip Burton • over one million students so far.
- Folio y QR verificables para compartirlo con quien te contrate.
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 16 unidades · 92 lecciones · 60 h
- 12 meses de acceso
- 11 cuestionarios de evaluación
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Sobre tu inscripción
¿Cómo es el pago?
Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.
¿Cuánto tiempo tengo acceso?
12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.
¿Quién imparte el contenido?
El curso es impartido por Phillip Burton • over one million students so far; INEC gestiona tu inscripción, evaluación y certificado.
¿Qué pasa cuando vence mi acceso?
Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.


