★★★★★
"The structure, the practice exams, the instructor — all top tier. Passed first try."
AS
Aarti SharmaSenior Project Manager · TCS
— The journey
Course Outline
What the programme covers, module by module.
Module 1: Introduction to Data Fundamentals
- Data concepts
- Structured data
- Semi-structured data
- Unstructured data
- Data workloads
- Data-driven solutions
Module 2: Introduction to Microsoft Azure Data Services
- Azure cloud concepts
- Azure data ecosystem
- Data service categories
- Cloud-based data solutions
- Data architecture basics
- Common data workloads
Module 3: Core Data Concepts
- Data representation
- Data storage
- Data processing
- Batch data
- Streaming data
- Data analytics
Module 4: Relational Data Fundamentals
- Relational databases
- Tables
- Rows and columns
- Primary keys
- Foreign keys
- Relationships
Module 5: SQL Fundamentals
- SQL concepts
- SELECT statements
- Filtering
- Sorting
- Aggregations
- JOIN concepts
Module 6: Azure SQL Services
- Azure SQL Database
- Azure SQL Managed Instance
- SQL Server on Azure
- Service selection
- Cloud database concepts
- Common use cases
Module 7: Database Management Concepts
- Database objects
- Tables and views
- Index concepts
- Data integrity
- Database administration
- Database security basics
Module 8: Non-Relational Data Fundamentals
- NoSQL concepts
- Key-value data
- Document data
- Graph data
- Column-family concepts
- NoSQL use cases
Module 9: Azure Cosmos DB
- Cosmos DB concepts
- Global distribution
- Containers and items
- Partitioning concepts
- APIs
- Common workloads
Module 10: Azure Data Storage
- Azure Storage
- Blob Storage
- Data Lake Storage
- File storage
- Storage organization
- Data lake concepts
Module 11: Data Analytics Fundamentals
- Analytical workloads
- Data aggregation
- Data visualization
- Business intelligence
- Analytical models
- Insight generation
Module 12: Data Warehousing & Lakehouse Concepts
- Data warehouses
- Data lakes
- Lakehouse architecture
- ETL and ELT
- Structured analytics
- Modern analytics architecture
Module 13: Microsoft Fabric Fundamentals
- Microsoft Fabric overview
- OneLake concepts
- Data engineering
- Data warehousing
- Data science
- Power BI integration
Module 14: Real-Time & Large-Scale Data Analytics
- Batch processing
- Stream processing
- Real-time analytics
- Apache Spark concepts
- Event-based data
- Large-scale processing
Module 15: Practical Azure Data Fundamentals
- Selecting data services
- Relational solution scenarios
- Non-relational scenarios
- Analytics workload selection
- Data architecture scenarios
- Azure data solution planning
— 01.2 · Is it right for you?
Who it's for & what's included
Pick a delivery method to see exactly who it suits and everything you receive.
Who it's for
Classroom
Best for learners who want face-to-face tuition and to network with peers in person.
What's included
Everything you get
- ✓ Live instructor on-site
- ✓ Printed workbook & materials
- ✓ Group exercises & case studies
Who it's for
Online Instructor-Led
Best for learners who want a live instructor and a fixed schedule, without the travel.
What's included
Everything you get
- ✓ Live instructor via video call
- ✓ Digital workbook & resources
- ✓ Session recordings
Who it's for
Self-Paced
Best for self-motivated learners who need maximum flexibility around work and life.
What's included
Everything you get
- ✓ On-demand video lessons
- ✓ Interactive quizzes
- ✓ 24/7 access on any device