DP601: Implementing a Lakehouse with Microsoft Fabric Training Course
Microsoft Fabric is a comprehensive data management platform designed to streamline the process of building and managing data lakes and warehouses.
This instructor-led, live training (online or onsite) is aimed at intermediate-level data professionals who wish to implement a lakehouse solution using Microsoft Fabric.
By the end of this training, participants will be able to:
- Understand the architecture and components of Microsoft Fabric.
- Configure and manage a Lakehouse using Microsoft Fabric.
- Ingest and transform data using Apache Spark.
- Utilize Delta Lake tables for versioning and managing data.
- Implement data ingestion pipelines with Dataflows Gen2.
- Orchestrate data pipelines using Data Factory.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Course Outline
Introduction to End-to-End Analysis with Microsoft Fabric
- Overview of Microsoft Fabric
- Understanding the Lakehouse Architecture
- End-to-End Analytics Workflow
Getting Started with Lakehouses in Microsoft Fabric
- Core Features and Capabilities of Lakehouses
- Creating and Configuring a Lakehouse
- Data Ingestion into Lakehouse Tables
Using Apache Spark in Microsoft Fabric
- Configuring Apache Spark in Microsoft Fabric
- Leveraging Spark for Distributed Data Processing
- Analyzing and Transforming Data with Spark DataFrames
Working with Delta Lake Tables in Microsoft Fabric
- Introduction to Delta Lake and Delta Tables
- Managing and Versioning Data with Delta Tables
- Implementing Data Transformations and Queries
Ingesting Data with Dataflows Gen2 in Microsoft Fabric
- Capabilities of Dataflows Gen2
- Designing Dataflow Solutions for Data Ingestion
- Integrating Dataflows into Data Pipelines
Using Data Factory Pipelines in Microsoft Fabric
- Overview of Data Factory Pipelines
- Building and Orchestrating Data Pipelines
- Automating Data Movements and Transformations
Summary and Next Steps
Requirements
- An understanding of data management principles
- Experience with SQL databases
- Basic knowledge of cloud computing concepts
Audience
- Data engineers
- Database administrators
- Data analysts
Open Training Courses require 5+ participants.
DP601: Implementing a Lakehouse with Microsoft Fabric Training Course - Booking
DP601: Implementing a Lakehouse with Microsoft Fabric Training Course - Enquiry
DP601: Implementing a Lakehouse with Microsoft Fabric - Consultancy Enquiry
Consultancy Enquiry
Testimonials (2)
Adam was very knowledgeable and had a great layout.
Corey Reis - Lockheed Martin
Course - Advanced Slide Design in PowerPoint
some small tricks regarding image formating and templates - very useful :)
Natalia Wawrzyniak - Akademia Morska w Szczecinie
Course - Advanced MS PowerPoint
Upcoming Courses
Related Courses
Excel Advanced with VBA
21 HoursParticipants will be able to excel themselves, in the most optimal way to create, consolidate and manage data. A number of tools designed to streamline the work often significantly reduces the time to activities carried out so far and can help you design an application that could perform new tasks.
MS Word Basic
14 HoursCourse participants will learn how to create a clean, professional-looking documents (including official correspondence of all kinds - official and official), as well as make full use of the basic mechanisms enabling the transparent flow of information in both the shorter and longer documents.
Word Advanced
14 HoursCourse participants will learn how to automate the work to create complex documents, retrieve data from the database and prepare forms.
Advanced MS PowerPoint
7 HoursThis course aims to improve PowerPoint skills of the trainees by practical exercises supported by relevant theory. It’s designed for everyone, mostly presentation designers, but also conference speakers and team-meeting presenters.
Advanced Slide Design in PowerPoint
7 HoursThis course is aimed at anyone wanting to work more efficiently in PowerPoint when creating slides and to learn the basics of presenting them.
Advanced PowerPoint for sales teams
7 HoursThe course is dedicated to sales teams. It focuses on leveraging PowerPoint's functions that aid in the sales process, ie. how to show data effectively, how not to over-clutter slides, and what to focus on in a sales deck.
Delivering Impressive Presentation Decks - Social Skills Workshop
14 HoursObjective:
Improving the ability to prepare an attractive presentation using Powerpoint and other tools
Addressees:
Sales representatives, consultants, research and teaching staff, managers, teachers, corporate employees, SMEs and public institutions, for which the challenge is to stand in front of a group of people, say to them, arousing interest
AZ-400T00-A: Designing and Implementing Microsoft DevOps solutions
35 HoursThis course provides the knowledge and skills to design and implement DevOps processes and practices. Students will learn how to plan for DevOps, use source control, scale Git for an enterprise, consolidate artifacts, design a dependency management strategy, manage secrets, implement continuous integration, implement a container build strategy, design a release strategy, set up a release management workflow, implement a deployment pattern, and optimize feedback mechanisms.
Audience profile
Students in this course are interested in designing and implementing DevOps processes or in passing the Microsoft Azure DevOps Solutions certification exam.
Job role: DevOps Engineer
Preparation for exam: AZ-400
Skills gained
- Plan for the transformation with shared goals and timelines
- Select a project and identify project metrics and Key Performance Indicators (KPI's)
- Create a team and agile organizational structure
- Design a tool integration strategy
- Design a license management strategy (e.g. Azure DevOps and GitHub users)
- Design a strategy for end-to-end traceability from work items to working software
- Design an authentication and access strategy
- Design a strategy for integrating on-premises and cloud resources
- Describe the benefits of using Source Control
- Describe Azure Repos and GitHub
- Migrate from TFVC to Git
- Manage code quality including technical debt SonarCloud, and other tooling solutions
- Build organizational knowledge on code quality
- Explain how to structure Git repos
- Describe Git branching workflows
- Leverage pull requests for collaboration and code reviews
- Leverage Git hooks for automation
- Use Git to foster inner source across the organization
- Explain the role of Azure Pipelines and its components
- Configure Agents for use in Azure Pipelines
- Explain why continuous integration matters
- Implement continuous integration using Azure Pipelines
- Define Site Reliability Engineering
- Design processes to measure end-user satisfaction and analyze user feedback
- Design processes to automate application analytics
- Manage alerts and reduce meaningless and non-actionable alerts
- Carry out blameless retrospectives and create a just culture
- Define an infrastructure and configuration strategy and appropriate toolset for a release pipeline and application infrastructure
- Implement compliance and security in your application infrastructure
- Describe the potential challenges with integrating open-source software
- Inspect open-source software packages for security and license compliance
- Manage organizational security and compliance policies
- Integrate license and vulnerability scans into build and deployment pipelines
- Configure build pipelines to access package security and license ratings
AZ-500T00-A: Microsoft Azure Security Technologies
28 HoursThis course provides IT Security Professionals with the knowledge and skills needed to implement security controls, maintain an organization’s security posture, and identify and remediate security vulnerabilities. This course includes security for identity and access, platform protection, data and applications, and security operations.
Audience profile
This course is for Azure Security Engineers who are planning to take the associated certification exam, or who are performing security tasks in their day-to-day job. This course would also be helpful to an engineer that wants to specialize in providing security for Azure-based digital platforms and play an integral role in protecting an organization's data.
Skills gained
- Implement enterprise governance strategies including role-based access control, Azure policies, and resource locks.
- Implement an Azure AD infrastructure including users, groups, and multi-factor authentication.
- Implement Azure AD Identity Protection including risk policies, conditional access, and access reviews.
- Implement Azure AD Privileged Identity Management including Azure AD roles and Azure resources.
- Implement Azure AD Connect including authentication methods and on-premises directory synchronization.
- Implement perimeter security strategies including Azure Firewall.
- Implement network security strategies including Network Security Groups and Application Security Groups.
- Implement host security strategies including endpoint protection, remote access management, update management, and disk encryption.
- Implement container security strategies including Azure Container Instances, Azure Container Registry, and Azure Kubernetes.
- Implement Azure Key Vault including certificates, keys, and secretes.
- Implement application security strategies including app registration, managed identities, and service endpoints.
- Implement storage security strategies including shared access signatures, blob retention policies, and Azure Files authentication.
- Implement database security strategies including authentication, data classification, dynamic data masking, and always encrypted.
- Implement Azure Monitor including connected sources, log analytics, and alerts.
- Implement Azure Security Center including policies, recommendations, and just in time virtual machine access.
- Implement Azure Sentinel including workbooks, incidents, and playbooks.
DeepSeek and PowerPoint: Enhancing Presentations
7 HoursThis instructor-led, live training in Sri Lanka (online or onsite) is aimed at This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level business professionals, educators, and marketers who wish to integrate DeepSeek with PowerPoint to automate and optimize their presentations.
By the end of this training, participants will be able to:
- Automate the creation of text-based content in PowerPoint slides using DeepSeek.
- Generate data-driven visuals and infographics powered by DeepSeek models.
- Use AI to summarize long reports and turn them into presentation-ready slides.
- Integrate DeepSeek with PowerPoint for streamlined, dynamic presentations.
Hyper-V Virtualization
21 HoursThis instructor-led, live training in Sri Lanka (online or onsite) is aimed at intermediate-level system administrators who wish to effectively deploy, manage, and troubleshoot Hyper-V environments.
By the end of this training, participants will be able to:
- Understand virtualization concepts and configure Hyper-V.
- Create and manage virtual machines, VM storage, and networking.
- Utilize advanced Hyper-V features and secure Hyper-V environments.
- Monitor and optimize Hyper-V performance.
MS-100T01-A: Office 365 Management
14 HoursLearn about Office 365 Management, including key components of Office 365, how to move an organization to Office 365, how to configure Office 365, and how to manage Office 365 ProPlus deployments.
Audience profile
This course is designed for persons who are aspiring to the Microsoft 365 Enterprise Admin role and have completed one of the Microsoft 365 role-based administrator certification paths.
Skills gained
- Office 365 overview
- Moving an organization to Office 365
- Configuring Office 365
- Managing Office 365 ProPlus deployments
Microsoft Certified: Azure Developer Associate Exam Preparation (AZ-204)
35 HoursThis instructor-led, live training in Sri Lanka (online or onsite) is designed to help participants prepare for the Microsoft Azure Developer Associate (AZ-204) certification exam.
The course covers the concepts of developing Azure solutions, including Azure compute, storage, and security features. It provides a comprehensive introduction to Azure development, including tools and services for building, testing, and deploying applications.
PowerPoint and Camtasia for Marketing
21 HoursThis instructor-led, live training in Sri Lanka (online or onsite) is aimed at marketeers who wish to create video content and presentations with Camtasia and PowerPoint.
By the end of this training, participants will be able to:
- Create video content and share it on a video hosting platform.
- Employ assets within Camtasia such as music and icons for interactive content.
- Save on costs by producing HQ videos with Camtasia and PowerPoint.
Creating Slide Decks for the Financial World
7 HoursThis course will give you the knowledge about how to present finance information (numbers) in PowerPoint and not just the presentations skills itself. You will be able to present finance information in more professional way.