DP-900 Microsoft Azure Data Fundamentals Certification
DP-900 Azure Data Fundamentals Exam Preparation Course
Lo que serás capaz de hacer
Version 4.0 - June 2024 Entire course revamped with all chapters re-recorded. This is to align the course with the updated exam objectives and services on the Azure platform. Version 3.1 - July 2023 Changed the chapters which relate onto the working of the storage account service. This is to keep in line with the changes made to the service. For Azure Databricks, changed the way we access data in a storage account. This is to keep in line with the recent recommendations on accessing a storage account from Azure Databricks. Version 3.0 - Nov 2022 Carried out a major refresh of the course. The major refresh includes updating all of the videos to reflect the newer changes to Azure services. This refresh was also done to align with the newer exam objectives. Version 2.0 - Feb 2021 Added chapters on Azure SQL Managed Instance Azure Cosmos DB - Mongo DB API Azure Cosmos DB - Gremlin API Revised chapters on Azure Databricks Updated chapters on Azure Synapse Analytics to reflect recent changes in Azure on this service Added a completely NEW SECTION. This section includes Working with SQL commands on data Working with data in Power BI Additional aspects related to Azure Data Factory This course is designed for students who want to attempt the Exam DP-900: Microsoft Azure Data Fundamentals This course has contents for the Exam DP-900 The objectives covered in this course are Describe core data concepts (15-20%) Describe how to work with relational data on Azure (25-30%) Describe how to work with non-relational data on Azure (25-30%) Describe an analytics workload on Azure (25-30%) The following key aspects are covered in this course Working with SQL databases - Here we will see how to work with SQL databases using Microsoft SQL Server on an Azure virtual machine. We will then explore the Azure SQL database service We will look at non-relational data stores such as Azure Storage accounts and Azure Cosmos DB We will look at Analytical services such as Azure Synapse We will see how to use Azure Data Factory as an ETL tool This course has a number of videos that will help the student be prepared for the DP-900 exam. Right from the basics on understanding the different data services to knowing how they can work together.
- This course is designed to test foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services.
- Students will learn about securing data in Azure including encryption, access control, and role-based access control (RBAC).
- Students will learn about Azure HDInsight for big data processing with services like Hadoop, Spark, and more.
- Students will learn how to use Azure Blob Storage to store unstructured data like text, images or video.
Temario
UNIDAD 1 - Describe core data concepts · 13 leccionesUNIDAD 1 - Describe core data concepts
UNIDAD 1 - Describe core data concepts
- Slides and Diagrams download
- Describe ways to represent data
- Describe common data workloads
- Identify options for data storage
- Identify roles and responsibilities for data workloads
- What's next
- Introduction to Azure
- The Azure Free Account
- Creating the Azure Free Account
- Tour around the Azure Portal
- Disabling security defaults
- Section Revision
- Section Quiz
UNIDAD 2 - Identify considerations for relational data on Azure · 53 leccionesUNIDAD 2 - Identify considerations for relational data on Azure
UNIDAD 2 - Identify considerations for relational data on Azure
- Section Introduction
- A database system
- Different options for hosting a database
- Lab - Creating a virtual machine
- Lab - Connecting to the Virtual Machine
- Lab - Installing Microsoft SQL Server
- Lab - Working with the SQL Server Instance
- Lab - Working with the SQL Server Instance - Resources
- Azure SQL Database
- Lab - Creating an Azure SQL Database
- Lab - Installing Azure Data Studio
- Lab - Using Azure Data Studio
- Lab - Using Azure Data Studio on macOS
- Installing SQL Server Management Studio on your local machine
- Understanding key database terms
- ACID Properties
- The different types of SQL statements
- Lab - SQL - SELECT Statement
- Lab - SQL - SELECT Statement - Resources
- Lab - SQL - WHERE Clause
- Lab - SQL - WHERE Clause - Resources
- Lab - SQL - ORDER BY Clause
- Lab - SQL - ORDER BY Clause - Resources
- Lab - SQL - Aggregate Functions
- Lab - SQL - Aggregate Functions - Resources
- Lab - SQL - GROUP BY Clause
- Lab - SQL - GROUP BY Clause - Resources
- Lab - SQL - JOIN Clause
- Lab - SQL - JOIN Clause - Resources
- Database Normalization
- Lab - SQL - CREATE TABLE statement
- Lab - SQL - CREATE TABLE statement - Resources
- Lab - SQL - Using relationships between tables
- Lab - SQL - Using relationships between tables - Resources
- Lab - Granting another user access
- Lab - Table Views
- Lab - Table Views - Resources
- Indexes in tables
- Lab - Working with Indexes
- Lab - Working with Indexes - Resources
- Lab - Stored Procedure
- Lab - Stored Procedure - Resources
- Lab - Using sqlcmd
- Lab - Using sqlcmd - Resources
- Azure SQL Database - Transparent Data Encryption
- Just a quick note on the server-level firewall
- Azure SQL Managed Instance
- Azure SQL Databases - Serverless
- Lab - Azure Database for MySQL
- Lab - Azure Database for MySQL - Resources
- Deleting our Azure SQL database as well
- Section Revision
- Section Quiz
UNIDAD 3 - Describe how to work with non-relational data on Azure · 26 leccionesUNIDAD 3 - Describe how to work with non-relational data on Azure
UNIDAD 3 - Describe how to work with non-relational data on Azure
- Introduction to Azure Storage Accounts
- Lab - Azure Storage Accounts - Creating a storage account
- Lab - Azure Storage Account - Blob service
- Storage Accounts - Data Redundancy
- Azure Storage Accounts - Access tiers
- Lab - Azure Blob storage - Access tiers
- Lab - Azure Storage Account - File service
- Connecting to a file share from macOS
- Lab - Azure Storage Account - Table service
- Lab - Azure Storage Explorer
- Azure Storage Explorer - macOS
- About the Azure Storage Firewall
- Azure Storage - Lifecycle management policies
- What is Azure Cosmos DB
- Important concepts in Azure Cosmos DB
- About JSON
- Lab - Creating an Azure Cosmos DB account
- Lab - Azure Cosmos DB - Adding data
- Lab - Azure Cosmos DB - Adding data - Resources
- Azure Cosmos DB and multiple regions
- Note on the Table API in Azure Cosmos DB
- Lab - Azure Cosmos DB - Gremlin API
- Lab - Azure Cosmos DB - Gremlin API - Resources
- Review on the different data stores
- Section Review
- Section Quiz
UNIDAD 4 - Describe an analytics workload on Azure · 48 leccionesUNIDAD 4 - Describe an analytics workload on Azure
UNIDAD 4 - Describe an analytics workload on Azure
- Recap on the common data workloads
- Data Processing
- Extract, transform and load
- Lab - Azure Data Lake Storage
- Azure Synapse Analytics
- Lab - Azure Synapse - Creating a workspace
- Azure Synapse - Serverless Pool Compute option
- Lab - Azure Synapse - Serverless SQL pool
- Lab - Azure Synapse - Serverless SQL pool - Resources
- Designing a data warehouse
- Fact and Dimension tables
- Lab - Azure Synpase - Creating a dedicated SQL pool
- Lab - Azure Synpase - Using the dedicated SQL pool
- Lab - Azure Synpase - Using the dedicated SQL pool - Resources
- Understanding Azure Synapse Architecture
- Azure Synapse - Spark pool
- Azure Synapse - Spark pool - Resources
- Azure Synapse - Data Explorer
- Azure Synapse - Data Explorer - Resources
- Azure Data Factory
- Lab - Azure Data Factory - CSV To Parquet
- Lab - Azure Data Factory - Parquet to Data pool
- Azure Data Factory - Triggers
- Lab - Azure Data Factory - Mapping Data Flow
- Lab - Azure Data Factory - Mapping Data Flow - Resources
- Azure Stream Analytics
- Lab - Azure Stream Analytics
- Lab - Azure Stream Analytics - Resources
- What is Azure Databricks
- Azure Databricks - Creating a workspace
- Azure Databricks - Reading data
- Azure Databricks - Reading data - Resources
- Installing Power BI Desktop
- Lab - Power BI Desktop - Azure Data Lake Gen2
- Power BI Desktop - Removing Null values
- Lab - Power BI Desktop - Azure SQL Database
- Lab - Power BI Desktop - Adding other datasets
- Lab - Power BI Desktop - Creating a calculated column - Power Query Editor
- Lab - Power BI Desktop - Creating a calculated column - DAX Expression
- Lab - Power BI Desktop - Clustered Column Chart
- The Power BI service
- Publishing to Power BI
- Quick Note - Power Report Builder
- Power BI - Different visualization charts
- Power BI Dashboards
- Note on Azure HDInsight
- Section Summary
- Section Quiz
UNIDAD 5 - Mini-Project · 8 leccionesUNIDAD 5 - Mini-Project
UNIDAD 5 - Mini-Project
- What are we going to implement
- Lab - Deploying an Azure Web App
- Azure Event Hubs
- Lab - Deploying an Azure Event Hub
- Lab - Setting up Azure Stream Analytics - Input
- Lab - Setting up Azure Stream Analytics - Output
- Lab - Setting up Azure Stream Analytics - Output - Resources
- Lab - Power BI Reports
UNIDAD 6 - Practice Section · 4 leccionesUNIDAD 6 - Practice Section
UNIDAD 6 - Practice Section
- Scheduling the exam and the sample questions
- Practice Test 1
- Practice Test 2
- Bonus Lecture
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
6 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
6 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
Muestra · verificable por folio y QR
- 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 Alan Rodrigues.
- 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.
- 6 unidades · 152 lecciones · 30 h
- 12 meses de acceso
- 6 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 Alan Rodrigues; 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.
