PROJECT 01
Medallion lakehouse in Fabric
Pipelines land raw data, notebooks build silver and gold Delta tables, all scheduled and monitored.
PipelinesNotebooksDelta
01 / OVERVIEW
What this course is about
Microsoft Fabric puts data engineering, warehousing, real-time analytics and Power BI into one platform, and companies are adopting it fast. I am a certified Fabric Data Engineer Associate. This track starts with SQL and Python, then covers every Fabric workload a data engineer touches, and finishes with DP-700 exam preparation and interview practice.
You learn by doing: every week has hands-on exercises on Google Classroom, and every module ends with something you built yourself.
01
Understand Fabric end to end
Capacities, workspaces, OneLake and how all the items fit together.
02
Build lakehouses
Delta tables, shortcuts and the SQL analytics endpoint.
03
Orchestrate data movement
Pipelines, Dataflow Gen2 and copy jobs with parameters and schedules.
04
Transform with Spark and T-SQL
Notebooks for the lakehouse and T-SQL for the warehouse.
05
Handle real-time data
Eventstreams, Eventhouse and KQL queries.
06
Deliver to Power BI
Semantic models, Direct Lake and secure, governed reports.
02 / CURRICULUM
Week by week
A clear plan from the first session to the last. The pace adapts to you: if you already know a topic we move faster, and if something needs more time we take it.
WEEKS 1 TO 3SQL foundations5 topics
- T-SQL queries, joins and CTEs
- Window functions
- Data modelling and star schemas
- Stored procedures
- SQL interview practice
WEEKS 4 TO 5Python and PySpark basics5 topics
- Python for data
- Spark DataFrames
- Reading and writing files
- Transformations and joins
- Notebook habits
WEEK 6Fabric fundamentals5 topics
- Capacities and F SKUs
- Workspaces and items
- OneLake concepts
- Licensing and trial
- Admin portal basics
WEEKS 7 TO 8Lakehouse5 topics
- Files vs tables
- Delta tables and V-Order
- Shortcuts to ADLS and other sources
- SQL analytics endpoint
- Table maintenance
WEEKS 9 TO 10Data Factory in Fabric5 topics
- Data pipelines
- Dataflow Gen2 and Power Query
- Copy job
- Parameters and variables
- Schedules and failure alerts
WEEKS 11 TO 12Spark notebooks5 topics
- PySpark and Spark SQL in Fabric
- Environments and libraries
- Medallion lakehouse design
- Incremental loads with MERGE
- Notebook orchestration
WEEKS 13 TO 14Data Warehouse5 topics
- Fabric warehouse with T-SQL
- COPY INTO and ingestion
- Cross database queries
- Stored procedures and views
- Warehouse vs lakehouse
WEEK 15Real-Time Intelligence5 topics
- Eventstreams
- Eventhouse and KQL databases
- KQL querysets
- Real-time dashboards
- Activator alerts
WEEKS 16 TO 17Power BI in Fabric5 topics
- Semantic models
- Direct Lake mode
- DAX essentials
- Reports and apps
- Refresh and performance
WEEK 18Security and governance5 topics
- Workspace roles and item permissions
- OneLake security
- Row and column level security
- Sensitivity labels
- Microsoft Purview in Fabric
WEEK 19Monitoring and optimisation5 topics
- Monitoring hub
- Capacity metrics app
- Spark performance tips
- OPTIMIZE and VACUUM
- Cost awareness
WEEK 20CI/CD5 topics
- Git integration
- Deployment pipelines
- Dev, test and prod workspaces
- Parameterising for environments
- Team workflow
WEEKS 21 TO 23Capstone project4 topics
- End to end Fabric solution
- Lakehouse, warehouse and report
- Documentation and demo
- Code review
WEEK 24DP-700 and interviews4 topics
- DP-700 study plan and practice questions
- Fabric interview questions
- CV and LinkedIn review
- Mock interviews with feedback
03 / PROJECTS
What you will build
Real projects you can put on GitHub and explain with confidence in interviews.
PROJECT 02
Real-time operations board
Stream events into an Eventhouse, query them with KQL and alert on problems with Activator.
EventstreamKQLActivator
PROJECT 03
Direct Lake sales report
A governed semantic model on the gold layer with row level security and a fast Power BI report.
Semantic modelDirect LakeRLS
04 / TOOLS
Tools and technologies
The same tools used by data teams in real companies.
Microsoft FabricOneLakeLakehouseFabric Data WarehouseData pipelinesDataflow Gen2Spark notebooksEventstreamKQLPower BIGit
05 / IS IT FOR YOU
Who this course is for
Who it is for
- Beginners who want a modern data engineering career path
- Power BI developers moving into data engineering
- Azure and SQL professionals adopting Fabric
- Anyone preparing for DP-700
What you need
- No prior experience needed, we start with SQL
- A laptop and stable internet
- A Fabric trial or company capacity, I guide the setup
Roles it leads to
- Fabric Data Engineer
- Data Engineer
- Analytics Engineer
- BI and Data Platform Engineer
06 / HOW YOU LEARN
What you get
Live and one-to-one
Every session is just you and me, never a batch. No recordings, so we can talk openly about your code.
3 sessions a week
Each session is 1 hour 15 minutes, on weekdays, weekends or both. We agree the schedule before starting.
Google Classroom
Assignments, projects, quizzes, interview questions and homework, all organised in one place.
Real projects
You build projects like the ones companies run, and get feedback on your code and design.
Interview preparation
Common questions, live coding practice and mock interviews with honest feedback.
Job placement support
CV, LinkedIn, applications and interviews. I stay with you until you are hired, as long as you do the work.
07 / PRICING
Simple pricing
You pay for your time with me, not per course. All prices are in US dollars.
Estimated total for Microsoft Fabric Data Engineer at the typical pace (6 months)
About 1200 USD
Full refund if it is not right for you after the first session. Go faster and it costs less.About 1200 USD
08 / YOUR MENTOR
Hikmat Ullah
Senior Data Engineer at Algo · Lahore, Pakistan
I build data platforms with Snowflake, Azure Databricks, Azure Data Factory and Microsoft Fabric every day, and I have been mentoring since 2021. I teach what I use at work, and I stay with you until you land the job.
7+years in data
100+students trained
80+placed in jobs
1:1always, never a batch
09 / FAQ
Questions about Microsoft Fabric Data Engineer
Do I need a paid Fabric capacity?+
Not to start. Microsoft offers a Fabric trial, and I show you how to make the most of it. Some students also use a capacity from their company.
Should I choose Fabric or the Azure Data Engineer track?+
Both lead to data engineering jobs. Fabric suits companies already on Power BI and Microsoft 365. Azure Data Engineer covers ADF, Databricks and Synapse. On a free call I help you pick based on the jobs you want.
Does this prepare me for DP-700?+
Yes. DP-700 is the Fabric Data Engineer Associate exam, which I have passed, and the last part of the course is dedicated to it.
How much does it cost?+
200 USD per month whichever course you choose. You can also pay 100 USD every 15 days or 50 USD per week. All prices are in US dollars wherever you live.
What is the refund policy?+
If the training is not right for you after the first session, you get a full refund. After that, payments already used for completed sessions are not refunded, but unused prepaid time can be refunded.
Is there a job guarantee?+
Yes. As long as you attend your sessions and complete the assignments and projects, I keep helping you with CV, LinkedIn, mock interviews and job applications until you are hired.
Can I join from another country or time zone?+
Yes. Students join from many countries. We pick session times that work for your time zone before we start.
10 / KEEP GOING
Related courses
6 months
Azure Data Engineer
The complete path: SQL, Python, ADF, ADLS Gen2, Databricks, Synapse and Event Hubs.
View course → 1.5 monthsPower BI Developer
Power Query, data modelling, DAX and dashboards people actually use.
View course → 3 monthsAzure Databricks Engineer
PySpark, Delta Lake, medallion architecture and Unity Catalog on Azure.
View course →START WHEN YOU ARE READY
Start the Microsoft Fabric Data Engineer course
Tell me your goals and your time zone. We plan your schedule together, and your first session can start this week.