astramieri/azure-data-fundamentals

Note-taking repository for Azure Data Fundamentals certification course (DP-900)

Azure Data Fundamentals

Note-taking repository for Azure Data Fundamentals certification course (DP-900).

Links

• Course Syllabus
• FreeCodeCamp Youtube Course

Modules

1. Core data concepts

• Data formats
• File storage
• Databases
• Transactional data processing
• Analytical data processing
• Row and Column Store
• Data techniques
• Data analysis

2. Data roles and services

• Data roles
• Data services

3. Fundamental relational data concepts

• Relational data
• Normalization
• SQL
• Database objects

4. Relational database services in Azure

• Azure SQL services and capabilities
• Azure services for open-source databases

5. Azure Storage for non-relational data

• Azure Storage Redundancy
• Azure Blob Storage
• Azure DataLake Storage Gen2
• Azure Files
• Azure Tables

6. Fundamentals of Azure Cosmos DB

• Azure Cosmos DB
• Azure Cosmos DB APIs

7. Fundamentals of large-scale analytics

• Large-scale data analytics
• Data warehousing architecture
• Data ingestion pipelines
• Analytical data stores
• Platform-as-a-Service (PaaS) solutions
• Microsoft Fabric

8. Fundamentals of real-time analytics

• Batch and stream processing
• Architecture for stream processing
• Azure Stream Analytics
• Apache Spark on Microsoft Azure
• Realtime Analytics in Microsoft Fabric

9. Fundamentals of data visualization

• Power BI tools and workflow
• Core concepts of data modeling
• Considerations for data visualization