Course Duration
1 Day
Microsoft
Authorized Training
IT
Course cost:
was £1,075
£881
IT Certification Overview
This one-day instructor-led course provides data professionals with the knowledge and practical skills required to implement and work with data warehouses in Microsoft Fabric. Aligned with the Microsoft DP-602 Applied Skills curriculum, the course focuses on creating, loading, querying, monitoring and securing Microsoft Fabric Data Warehouses using built-in Fabric tools and T-SQL.
Through a combination of instructor-led learning and hands-on labs, learners explore warehouse creation, data loading strategies, query development and monitoring capabilities. By the end of the course, participants will be able to confidently implement and manage Microsoft Fabric Data Warehouses to support analytical workloads and business reporting requirements.
Newto Training Reviews
What Our Happy Alumni Say About Us
I had absolutely no experience in this field, but Newto Training recognised my potential and supported me every step of the way. The real-life scenarios were invaluable in making me job-ready.
The tutors at Newto are consistently patient, clear and more than willing to help. I couldn't have asked for a better learning environment.
From day one I felt welcomed and supported. The live sessions were interactive and the resources well thought-out. I passed my exam on the first attempt thanks to them.
I was nervous about switching careers but the practical approach and continual 1-to-1 support gave me the confidence I needed to succeed."
The training material was excellent, and the instructors really brought the subject to life with hands-on lab work. I feel fully prepared for the workplace."
What impressed me most was the flexibility and responsiveness of the support team. Whenever I had a question, they were there even outside of normal hours.
The course structure was superb. A great mix of theory and practice delivered at a pace that made sense even for beginners. Highly recommended.
Switching into IT felt overwhelming, but Newto Training made the journey manageable and quite enjoyable. Their coaching style is top class.
I particularly appreciated the way complex topics were broken down into manageable chunks, and the tutor actively encouraged questions at every stage.
The live-taught interactive classes set Newto apart from other providers. It wasn't just video-based learning and the real engagement made all the difference.
The cyber course exceeded my expectations. They've been on hand for everything and are constantly in touch with me
The resources provided were spot on and the teaching style made everything easy to understand. I particularly appreciated the extra help offered when needed.
Enrolling with Newto was one of the best decisions I've made. The job-readiness focus, strong teaching and excellent support all stood out.
I completed my SQL course and now feel confident in my skills. The real-world examples and supportive tutors made it all click.
I've just passed my AZ-900 exam thanks to the support received from Ken in the boot camp and his exam preparation sessions.
I've gained a qualification and the confidence to use it in real-world scenarios.
Their commitment to student success is obvious from the personalised guidance to the quality of delivery. I'd recommend them without hesitation.
Every tutor I encountered was professional, encouraging and keen to see me succeed. That personal touch made a big difference.
I'm now in a role I once thought was out of reach, thank you to the all the team
The bootcamps were excellent, we were given practical projects to complete and I feel so much more confident with my coding skills
I had absolutely no experience in this field, but Newto Training recognised my potential and supported me every step of the way. The real-life scenarios were invaluable in making me job-ready.
The tutors at Newto are consistently patient, clear and more than willing to help. I couldn't have asked for a better learning environment.
From day one I felt welcomed and supported. The live sessions were interactive and the resources well thought-out. I passed my exam on the first attempt thanks to them.
I was nervous about switching careers but the practical approach and continual 1-to-1 support gave me the confidence I needed to succeed."
The training material was excellent, and the instructors really brought the subject to life with hands-on lab work. I feel fully prepared for the workplace."
What impressed me most was the flexibility and responsiveness of the support team. Whenever I had a question, they were there even outside of normal hours.
The course structure was superb. A great mix of theory and practice delivered at a pace that made sense even for beginners. Highly recommended.
Switching into IT felt overwhelming, but Newto Training made the journey manageable and quite enjoyable. Their coaching style is top class.
I particularly appreciated the way complex topics were broken down into manageable chunks, and the tutor actively encouraged questions at every stage.
The live-taught interactive classes set Newto apart from other providers. It wasn't just video-based learning and the real engagement made all the difference.
I had absolutely no experience in this field, but Newto Training recognised my potential and supported me every step of the way. The real-life scenarios were invaluable in making me job-ready.
The tutors at Newto are consistently patient, clear and more than willing to help. I couldn't have asked for a better learning environment.
From day one I felt welcomed and supported. The live sessions were interactive and the resources well thought-out. I passed my exam on the first attempt thanks to them.
I was nervous about switching careers but the practical approach and continual 1-to-1 support gave me the confidence I needed to succeed."
The training material was excellent, and the instructors really brought the subject to life with hands-on lab work. I feel fully prepared for the workplace."
What impressed me most was the flexibility and responsiveness of the support team. Whenever I had a question, they were there even outside of normal hours.
The course structure was superb. A great mix of theory and practice delivered at a pace that made sense even for beginners. Highly recommended.
Switching into IT felt overwhelming, but Newto Training made the journey manageable and quite enjoyable. Their coaching style is top class.
I particularly appreciated the way complex topics were broken down into manageable chunks, and the tutor actively encouraged questions at every stage.
The live-taught interactive classes set Newto apart from other providers. It wasn't just video-based learning and the real engagement made all the difference.
The cyber course exceeded my expectations. They've been on hand for everything and are constantly in touch with me
The resources provided were spot on and the teaching style made everything easy to understand. I particularly appreciated the extra help offered when needed.
Enrolling with Newto was one of the best decisions I've made. The job-readiness focus, strong teaching and excellent support all stood out.
I completed my SQL course and now feel confident in my skills. The real-world examples and supportive tutors made it all click.
I've just passed my AZ-900 exam thanks to the support received from Ken in the boot camp and his exam preparation sessions.
I've gained a qualification and the confidence to use it in real-world scenarios.
Their commitment to student success is obvious from the personalised guidance to the quality of delivery. I'd recommend them without hesitation.
Every tutor I encountered was professional, encouraging and keen to see me succeed. That personal touch made a big difference.
I'm now in a role I once thought was out of reach, thank you to the all the team
The bootcamps were excellent, we were given practical projects to complete and I feel so much more confident with my coding skills
The cyber course exceeded my expectations. They've been on hand for everything and are constantly in touch with me
The resources provided were spot on and the teaching style made everything easy to understand. I particularly appreciated the extra help offered when needed.
Enrolling with Newto was one of the best decisions I've made. The job-readiness focus, strong teaching and excellent support all stood out.
I completed my SQL course and now feel confident in my skills. The real-world examples and supportive tutors made it all click.
I've just passed my AZ-900 exam thanks to the support received from Ken in the boot camp and his exam preparation sessions.
I've gained a qualification and the confidence to use it in real-world scenarios.
Their commitment to student success is obvious from the personalised guidance to the quality of delivery. I'd recommend them without hesitation.
Every tutor I encountered was professional, encouraging and keen to see me succeed. That personal touch made a big difference.
I'm now in a role I once thought was out of reach, thank you to the all the team
The bootcamps were excellent, we were given practical projects to complete and I feel so much more confident with my coding skills
Prerequisites
Participants should have:
- A basic understanding of data analytics and data warehousing concepts.
- Experience working with relational databases and SQL.
- Familiarity with Microsoft Fabric or Azure data services is recommended.
- An understanding of data modelling principles.
- Familiarity with basic data integration concepts is beneficial.
Target audience
This course is designed for:
- Data engineers implementing Microsoft Fabric solutions.
- Analytics engineers working with modern data warehouse platforms.
- Database professionals transitioning to Microsoft Fabric.
- Data professionals responsible for loading, querying and managing analytical data.
- Professionals preparing for the Microsoft Applied Skills credential: Implement a Data Warehouse with Microsoft Fabric.
Learning Objectives
By the end of this course, learners will be able to:
- Create and configure Microsoft Fabric Data Warehouses.
- Load and transform data using Data Pipelines, Dataflow Gen2 and T-SQL.
- Query warehouse data using T-SQL and Fabric query tools.
- Monitor warehouse performance, activity and capacity utilisation.
- Implement warehouse security using Row-Level Security, Column-Level Security and Dynamic Data Masking.
- Apply Microsoft best practices when managing and securing Microsoft Fabric Data Warehouses.
Implement a Data Warehouse with Microsoft Fabric Course Content
Module 1: Get Started with Data Warehouses in Microsoft Fabric
- Understand data warehouse concepts and relational analytics.
- Create and configure a Fabric Data Warehouse.
- Create and manage tables within a warehouse.
- Work with fact tables and dimensions.
- Prepare warehouse data for analytical workloads.
Module 2: Load Data into a Microsoft Fabric Data Warehouse
- Explore data loading strategies.
- Load warehouse data using Data Pipelines.
- Load and transform data using Dataflow Gen2.
- Load data using T-SQL.
- Validate and prepare data for analytical workloads.
Module 3: Query a Data Warehouse in Microsoft Fabric
- Query warehouse data using T-SQL.
- Use SQL Query Editor and Visual Query Editor.
- Create views and reusable database objects.
- Use client tools to connect to and query a warehouse.
- Develop efficient T-SQL queries for analytical workloads.
Module 4: Monitor a Microsoft Fabric Data Warehouse
- Monitor warehouse activity and performance.
- Analyse query execution and workload activity.
- Review capacity metrics and utilisation.
- Identify operational issues and bottlenecks.
- Apply monitoring best practices.
Exams and assessments
This course prepares learners for the Microsoft Applied Skills credential: Implement a Data Warehouse with Microsoft Fabric. Throughout the course, learners complete practical labs and guided exercises that reinforce the skills required to create, load, query, monitor and secure Microsoft Fabric Data Warehouses. The exam is not included but is available seaprately.
Hands-on learning
This course includes:
- Practical Microsoft Fabric Data Warehouse labs.
- Hands-on exercises creating and managing Fabric Data Warehouses.
- Guided activities using Data Pipelines, Dataflow Gen2 and T-SQL.
- Practical exercises querying, monitoring and monitoring warehouse environments.
- Instructor-led demonstrations and practical workshops.
Implement a Data Warehouse with Microsoft Fabric Dates
Next 3 available training dates for this course
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
1 DAYS
|
ALL DAY
Thu 05 Nov 2026
AVAILABLE
was £1,075
£881
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
1 DAYS
|
ALL DAY
Fri 23 Apr 2027
AVAILABLE
was £1,075
£881
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
1 DAYS
|
ALL DAY
Mon 13 Sep 2027
AVAILABLE
was £1,075
£881
Advance Your Career with Implement a Data Warehouse with Microsoft Fabric
Gain the skills you need to succeed. Enrol in Implement a Data Warehouse with Microsoft Fabric with Newto Training today.
