Azure Data Fundamentals Certification (DP-900)
Learn about data core concepts, databases, data warehouses, data lakes and transformation tools.
Get Access NowUSD $24.00
USD $60.00
(60% off)

This Course Includes:
1 Year Access
4.5
Hours of Video
112
Lectures
10
Follow Alongs
11
Cheat Sheets
94
Flashcards
1
Practice Exams
Quiz on Every Lecture
Certificate of Completion
Course Outline
Getting Started
12m 21s
Introduction to the DP-900
5m 49s
Lecture
Watch
Meet Your Instructor
1m 32s
Lecture
Exam Guide
5m
Lecture
Data Concepts
1h 19m 59s
Azure Core Data Related Services
4m 39s
Lecture
Types of Cloud Computing
1m 57s
Lecture
Azure Data Related Roles
1m 42s
Lecture
Database Administrator Common tools
1m 41s
Lecture
Data Engineering Common tools
1m 12s
Lecture
Data Analyst Common tools
39s
Lecture
Data Overview
1m 13s
Lecture
Introduction to Data
45s
Lecture
Data documents
54s
Lecture
Data sets
2m 57s
Lecture
Data types
3m 40s
Lecture
Schema vs Schemaless
1m 50s
Lecture
Query and Querying
1m 41s
Lecture
Batch vs Stream processing
2m 32s
Lecture
Relational data
2m 1s
Lecture
Relational data Relationships
1m 28s
Lecture
Row-store vs Column-store
1m 33s
Lecture
Database Index
1m 17s
Lecture
Data Integegrity vs Data Corruption
2m 2s
Lecture
Normalized vs Denomralized data
1m 17s
Lecture
Pivot table
1m 34s
Lecture
Strongly consistent vs Eventually consistent
1m 19s
Lecture
Synchronus vs Asynchronous
1m 52s
Lecture
Non-relational data
56s
Lecture
Data source
1m 8s
Lecture
Data store
47s
Lecture
Database
1m 20s
Lecture
Data warehouse
1m 39s
Lecture
Data mart
53s
Lecture
Data lakes
1m 2s
Lecture
Data lakehouse
1m 26s
Lecture
Data structures
46s
Lecture
Unstructured data
40s
Lecture
Semi-structured
1m 19s
Lecture
Semi-structured Data Structures
1m 2s
Lecture
Semi-structure - JSON
51s
Lecture
semi structure - ORC
1m 24s
Lecture
semi structure - Parquets
52s
Lecture
semi structure - AVRO
46s
Lecture
Structured Data
27s
Lecture
Data mining
1m 2s
Lecture
Data mining methods
1m 22s
Lecture
Data wrangling
59s
Lecture
Ddata modeling
1m 43s
Lecture
ETL vs ELT
1m 56s
Lecture
Data analytics
52s
Lecture
Key performance indicators (KPI)
1m 5s
Lecture
Data Analytic Techniques
1m 35s
Lecture
Microsoft One Drive
1m 14s
Lecture
Microsoft Sharepoint
1m 25s
Lecture
Data Core Concepts CheatSheet
7m 43s
Cheatsheet
Azure Synapse and Data Lake
10m 17s
Azure Synapse Analytics
1m 46s
Lecture
Sypanse SQL and pools
1m 49s
Lecture
Synapse Key Features
1m 8s
Lecture
Azure Data Lake (Gen 2)
1m 28s
Lecture
Polybase
43s
Lecture
Synapse ELT
57s
Lecture
Azure Data Lake Analytics
1m 10s
Lecture
Azure Sypanse and Data Lakes CheatSheet
1m 16s
Cheatsheet
Account Storage
3m 30s
Azure Blob Storage
51s
Lecture
Azure Files
1m 50s
Lecture
Azure Storage Accounts CheatSheet
49s
Cheatsheet
Power BI
11m 55s
Business Intelligence
29s
Lecture
Power BI
2m 45s
Lecture
Power BI Visualizations
1m 40s
Lecture
Power BI Embedded
45s
Lecture
Power BI Interactive Reports
1m 30s
Lecture
Power BI Service and Dashboards
1m 7s
Lecture
Reports vs Dashboards
56s
Lecture
Paginated Reports
1m 6s
Lecture
Power BI CheatSheet
1m 37s
Cheatsheet
Relational Databases
13m 2s
Structured Query Language
1m 6s
Lecture
OLAP vs OLAP
1m 22s
Lecture
Open Source Relational Databases
2m 43s
Lecture
Read Replicas
1m 5s
Lecture
Citus Postgres Hyperscale
49s
Lecture
Azure SQL Family
2m 23s
Lecture
Elastic pools
1m 11s
Lecture
Relational Databases CheatSheet
2m 23s
Cheatsheet
T-SQL
7m 17s
T-SQL
1m 24s
Lecture
Data Defintion Language
59s
Lecture
Data Manipulation Language
1m 15s
Lecture
Data Query Language
1m 2s
Lecture
Data Control Language
24s
Lecture
Transaction Control Langauge
42s
Lecture
SQL Document Comparsions
44s
Lecture
T SQL CheatSheet
47s
Cheatsheet
Database Security
11m 28s
Connectivity Architecture
1m 8s
Lecture
Database Authentication
1m 24s
Lecture
Network Connectivity
34s
Lecture
Azure Defender for SQL
31s
Lecture
Azure Database Server Firewalls
1m 2s
Lecture
Always Encrypted
43s
Lecture
Role-Based-Access-Controls
57s
Lecture
Transparent Data Encryption
57s
Lecture
Dynamic Data Masking
1m 9s
Lecture
Private Links
51s
Lecture
Database Security Cheatsheet
2m 12s
Cheatsheet
Azure Tables and CosmosDB
13m 40s
Key Value Store
1m 23s
Lecture
Document Store
49s
Lecture
Mongo DB
1m 58s
Lecture
Graph Database
1m 3s
Lecture
Apache Tinkerpop and Gremlin
1m 37s
Lecture
Azure Tables
1m 18s
Lecture
Azure Cosmos DB
1m 51s
Lecture
Azure Table Account Storage vs Cosmos DB
1m 55s
Lecture
Azure Tables and CosmosDB CheatSheet
1m 46s
Cheatsheet
Hadoop Systems
4m 36s
Apache Hadoop
1m 24s
Lecture
Apache Kafka
52s
Lecture
HDInsights
1m 8s
Lecture
Hadoop CheatSheet
1m 12s
Cheatsheet
Azure Databricks
5m 13s
Apache Spark
1m 39s
Lecture
Azure Databricks
2m 8s
Lecture
Apache Spark and Databricks CheatSheet
1m 26s
Cheatsheet
ELT and SQL Tools
6m 28s
SQL Server Management Studio
47s
Lecture
SQL Server Data Tools
1m 17s
Lecture
Azure Data Studio
46s
Lecture
Azure Data Factory
1m 7s
Lecture
SQL Server Integration Services
1m 5s
Lecture
ETL and SQL Tools CheatSheet
1m 26s
Cheatsheet
Follow Alongs
1h 41m 23s
Install and Use Power BI
2m 35s
Follow Along
Launch Azure SQL and Use Data Studio
26m 32s
Follow Along
Use Azure SQL as data source in Power BI
9m 23s
Follow Along
Use SSMS to perform a query on Azure SQL
3m 13s
Follow Along
Create Blob and File storage
9m 55s
Follow Along
Explore CosmosDB various NoSQL engines
29m 28s
Follow Along
Create a ELT job from Azure SQL to Blob Storage
5m 54s
Follow Along
Explore Azure Databricks
6m 39s
Follow Along
Explore Azure Synapse Analytics
4m 54s
Follow Along
Cleanup
2m 50s
Follow Along