Module 1: Explore fundamentals of data
Core data concepts
- What is data?
- How is data stored?
- Transactional data workloads
- Analytical data workloads
Data roles and services
- Data professional roles
- Microsoft cloud services for data
Module 2: Explore fundamentals of relational data in Azure
Explore relational data concepts
- Relational tables
- Normalization
- Structured Query Language (SQL)
- Other common database objects
Explore Azure services for relational data
- Azure SQL
- Azure Database services for open-source
Lab: Provision Azure relational database services
Module 3: Explore fundamentals of non-relational data in Azure
Fundamentals of Azure Storage
- Azure Blob Storage
- Azure Data Lake Store Gen 2
- Azure Files
- Azure Table Storage
Lab: Explore Azure Storage
Fundamentals of Azure Cosmos DB
- What is Azure Cosmos DB?
- Azure Cosmos DB APIs
Lab: Explore Azure Cosmos DB
Module 4: Explore fundamentals of data analytics
Large-scale data warehousing
- What is large-scale data warehousing?
- Data ingestion and processing pipelines
- Analytical data stores
- Choose an analytical data store service
Lab: Explore Azure Synapse Analytics
Streaming and real-time analytics
- Batch vs stream processing
- Real-time data processing with Azure Stream Analytics
- Real-time log and telemetry analysis with Azure Data Explorer
Lab: Analyze streaming data
Data visualization
- Introduction to data visualization with Power BI
- Analytical data modeling
- Common data visualizations in reports
Lab: Visualize data with Power BI