Description
This five-day, instructor-led live course provides a comprehensive exploration of relational and non-relational data concepts within the Azure ecosystem. Students will master the essentials of Azure SQL, Cosmos DB, and modern data warehousing utilizing Azure Synapse. This foundational curriculum is designed to demystify complex cloud data roles and technologies, empowering you to select the optimal storage and processing solutions for any business requirement.
The journey continues as you transition into the role of a Fabric Analytics Engineer, designing and deploying large-scale solutions within a unified SaaS environment. You will gain practical experience with OneLake, Lakehouses, and Warehouses while mastering data ingestion through Data Factory and Spark. The week concludes with advanced sessions on semantic modeling, DAX, and robust security frameworks like RLS and OLS, leaving you fully prepared to pass both exams and deliver elite business intelligence.
The Microsoft Certified Fabric boot camp is taught using Microsoft Official Courseware –
DP-900T00: Introduction to Microsoft Azure Data
DP-600T00: Microsoft Fabric Analytics Engineer
Everything You Need to Succeed – What’s Included
Microsoft Certified Trainer (MCT) Instructor Led Live Training
2 Microsoft Official Courses (DP-900 / DP-600)
2 Microsoft Official Exam Vouchers (DP-900 / DP-600)
2 Retake Vouchers (1 per exam, if needed)
Microsoft Official Hands on Labs
Microsoft Vetted Practice Exams
Onsite & Online Pearson Vue Testing
Skills Gained:
Get started with Microsoft Fabric
Implement a data warehouse with Microsoft Fabric
Work with semantic models in Microsoft Fabric
Administer and govern Microsoft Fabric
Ingest data with Microsoft Fabric
Implement a Lakehouse with Microsoft Fabric
Implement Real-Time Intelligence with Microsoft Fabric
Implement a data warehouse with Microsoft Fabric
Manage a Microsoft Fabric environment
Topics Covered in this Official Boot Camp:
Explore core data concepts
Identify data formats
Explore file storage
Explore databases
Explore transactional data processing
Explore analytical data processing
Explore data roles and services
Explore job roles in the world of data
Identify data services
Explore fundamentals relational data concepts
Understand relational data
Understand normalization
Explore SQL
Describe database objects
Explore relational database services in Azure
Describe Azure SQL services and capabilities
Describe Azure services for open-source databases
Explore Azure Storage for non-relational data
Explore Azure blob storage
Explore Azure Data Lake Storage Gen2
Explore Microsoft OneLake in Fabric
Explore Azure Files
Explore Azure Tables
Explore fundamentals of Azure Cosmos DB
Describe Azure Cosmos DB
Identify Azure Cosmos DB APIs
Explore fundamentals of large-scale analytics
Describe data warehousing architecture
Explore data ingestion pipelines
Explore analytical data stores
Explore fundamentals of real-time analytics
Understand batch and stream processing
Explore common elements of stream processing architecture
Explore Microsoft Fabric Real-Time Intelligence
Explore Apache Spark structured streaming
Explore fundamentals of data visualization
Describe Power BI tools and workflow
Describe core concepts of data modeling
Describe considerations for data visualization
Introduction to end-to-end analytics using Microsoft Fabric
Explore end-to-end analytics with Microsoft Fabric
Explore data teams and Microsoft Fabric
Enable and use Microsoft Fabric
Get started with lakehouses in Microsoft Fabric
Describe lakehouse features and capabilities
Ingest and transform data in a lakehouse
Query and analyze lakehouse data
Get started with data warehouses in Microsoft Fabric
Understand data warehouses
Understand data warehouses in Fabric
Query and transform data
Model data in a warehouse
Secure and monitor a warehouse
Get started with Real-Time Intelligence in Microsoft Fabric
What is real-time data analytics?
Real-Time Intelligence in Microsoft Fabric
Ingest and transform real-time data
Store and query real-time data
Visualize real-time data
Automate actions
Get started with data science in Microsoft Fabric
Understand the data science process
Explore and process data with Microsoft Fabric
Train and score models with Microsoft Fabric
Get started with SQL Database in Microsoft Fabric
Work with SQL databases
Secure databases in Fabric
Explore Copilot for SQL Database
Simplify data management with mirroring and virtualization
Design semantic models for scale in Microsoft Fabric
Choose a storage mode
Design star schema for semantic models
Design scalable calculations
Configure settings for scale
Understand Microsoft Fabric IQ fundamentals
Get started with Fabric IQ
Explore Microsoft Fabric IQ components
Understand the ontology modeling paradigm
Introduction to end-to-end analytics using Microsoft Fabric
Explore end-to-end analytics with Microsoft Fabric
Explore data teams and Microsoft Fabric
Enable and use Microsoft Fabric
Get started with data warehouses in Microsoft Fabric
Understand data warehouses
Understand data warehouses in Fabric
Query and transform data
Model data in a warehouse
Secure and monitor a warehouse
Load data into a Microsoft Fabric data warehouse
Explore data load strategies
Use data pipelines to load a warehouse
Load data using T-SQL
Load and transform data with Dataflow Gen2
Query a data warehouse in Microsoft Fabric
Query data
Use the SQL query editor
Explore the visual query editor
Use client tools to query a warehouse
Monitor a Microsoft Fabric data warehouse
Monitor capacity metrics
Monitor current activity
Monitor queries
Security a Microsoft Fabric data warehouse
Explore dynamic data masking
Implement row-level security
Implement column-level security
Configure SQL granular permissions using T-SQL
Create DAX calculations in semantic models
Create calculated tables
Create calculated columns
Understand implicit measures
Create explicit measures
Use iterator functions
Design scalable semantic models
Choose the best storage mode
Configure semantic models for large data
Work with relationships
Write DAX for readability with complex calculations
Create dynamic calculation elements
Optimize a model for performance in Power BI
Describe semantic model optimization techniques
Review performance of measures, relationships, and visuals
Use variables to improve performance and troubleshooting
Reduce cardinality
Optimize DirectQuery models with table level storage
Create and manage aggregations
Create and manage Power BI assets
Create reusable Power BI assets
Manage development lifecycle for Power BI assets
Use lineage view and endorse data assets
Manage a Power BI semantic model using XMLA endpoint
Enforce Power BI model security
Restrict access to Power BI model data
Restrict access to Power BI model objects
Apply good modeling practices
Administer a Microsoft Fabric environment
Understand the Fabric Architecture
Understand the Fabric administrator role
Manage Fabric security
Govern data in Fabric
Security data access in Microsoft Fabric
Understand the Fabric security model
Configure workspace and item permissions
Apply granular permissions
Secure a Microsoft Fabric data warehouse
Explore dynamic data masking
Implement row-level security
Implement column-level security
Configure SQL granular permissions using T-SQL
Govern data in Microsoft Fabric with Purview
Govern data in Microsoft Fabric
Why use Microsoft Purview with Microsoft Fabric?
Govern data in the Microsoft Purview hub


