Who is this training for?
The primary audience for this course is data professionals who are familiar with data modeling, extraction, and analytics. It is designed for professionals who are interested in gaining knowledge about data warehouse in Microsoft Fabric platform, and how to enable integrated analytics using these technologies.
Training objectives
You'll learn how to efficiently load, monitor, and query a data warehouse in Microsoft Fabric.
Summary
This course is designed to build your foundational skills in data engineering on Microsoft Fabric, focusing on data warehouse concepts. This course explores how to load, monitor and query a data warehouse in Microsoft Fabric using tools, and transactional T-SQL capabilities for easy data management and analysis. This course includes a combination of lectures and hands-on exercises that will prepare you to work with data warehouses in Microsoft Fabric.
Course outline
- Get started with data warehouses in Microsoft Fabric
- Load data into a Microsoft Fabric data warehouse
- Query a data warehouse in Microsoft Fabric
- Monitor a Microsoft Fabric data warehouse
Approach and methodology
Practical and structured approach combining focused theory and guided workshops. Participants gradually implement a data warehouse with Microsoft Fabric through real-world exercises inspired by professional scenarios, promoting immediate application of learning. They learn how to design, integrate, and model data, as well as optimize the performance and governance of analytics solutions within Fabric. Led by a Microsoft-certified trainer, the training focuses on interactivity and the development of directly transferable technical skills to deploy decision-making solutions in a professional context.
Prerequisites
You need to be familiar with basic database concepts and terminology.
Recommendations
- Relational database basics Knowledge of SQL (queries, joins, aggregations)
- Understanding of data modeling concepts (schemas, tables)
- Notions of data processing (ETL/ELT)
- General knowledge of cloud or data platform environments
