How long does it take to complete the program?

The program contains approximately 50 hours of content across five courses plus a career development module. Most learners complete the program in 3-4 months studying 4-5 hours per week, though self-paced access allows you to move faster or slower based on your schedule.

What will I get if I subscribe to this Certificate?

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Data Storage & Processing

Ends in 4 days! Save 40% on your access to 10,000+ programs and make a real impact in your career. Save now.

Data Storage & Processing

This course is part of Microsoft Fabric Analytics Engineer Professional Certificate

Instructor: Microsoft

Included with Learn more

Ask Coursera

11 modules

Gain insight into a topic and learn the fundamentals.

Advanced level

Recommended experience

8 hours to complete

Flexible schedule

Learn at your own pace

11 modules

Gain insight into a topic and learn the fundamentals.

Advanced level

Recommended experience

8 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

- Design automated pipelines that ingest, validate, and transform data at scale
- Capture and query real-time data with Eventstream and KQL

Details to know

Shareable certificate

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your Software Development expertise

This course is part of the Microsoft Fabric Analytics Engineer Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Microsoft

There are 11 modules in this course

Master the data storage patterns and processing techniques that power enterprise analytics in Microsoft Fabric. In this hands-on course, you’ll design scalable lakehouse solutions and build production-grade storage architectures that support performance, governance, and advanced analytics workloads.

You’ll implement a Medallion architecture in OneLake using bronze, silver, and gold layers, and register lineage in Microsoft Purview. You’ll ingest data into a Fabric Lakehouse using pipelines, Copy Jobs, and notebooks while selecting appropriate Delta table types. You’ll query data through the SQL Endpoint for analysis and use notebooks for programmatic access, then enforce consistency with time-travel queries and MERGE-based ACID transactions using Delta Lake. You’ll also optimize tables with OPTIMIZE, ZORDER, and VACUUM operations and design a Fabric Warehouse schema in T-SQL to support star-schema analytics and incremental loads. By the end, you’ll have practical experience building optimized Lakehouse and Warehouse solutions and the core data engineering skills required for enterprise Fabric implementations.

Implement the Medallion pattern with progressive data refinement from raw (bronze) to analytics-ready (gold).

What's included

2 videos2 readings1 assignment

Use Fabric lineage views to understand how Fabric items such as Lakehouses, notebooks, pipelines, semantic models, and reports connect across a Medallion architecture.

What's included

2 readings2 assignments

Compare ingestion methods (upload, pipelines, Copy Jobs, notebooks) and understand managed vs. unmanaged Delta table implications.

What's included

3 videos2 readings2 assignments

3 videosTotal 14 minutes

Choosing the Right Ingestion Path3 minutes
Ingestion Methods Explained - Part 16 minutes
Ingestion Methods Explained - Part 25 minutes

2 readingsTotal 30 minutes

Ingestion Patterns Quick Reference5 minutes
Hands-on Activity: Practice Multiple Ingestion Methods25 minutes

2 assignmentsTotal 14 minutes

Knowledge Check: Ingestion Methods and Delta Table Types4 minutes
Ingest Data into Lakehouse Assessment10 minutes

Master both SQL and programmatic approaches to reading Lakehouse data.

What's included

3 videos2 readings2 assignments

3 videosTotal 15 minutes

Two Paths to Your Data3 minutes
SQL Endpoint Deep Dive5 minutes
Notebook Data Access7 minutes

2 readingsTotal 25 minutes

SQL vs. Notebook Access Comparison5 minutes
Hands-on Activity: Query Data Both Ways20 minutes

2 assignmentsTotal 14 minutes

Knowledge Check: Reading Data with SQL Endpoint and Notebooks4 minutes
Read Data from Lakehouse Assessment10 minutes

Learn how ACID properties work in Delta Lake and implement transactional MERGE operations for upserts.

What's included

1 video2 readings1 assignment

Use Delta Lake's time-travel feature to query historical versions of tables for audit, debugging, and compliance.

What's included

2 videos2 readings3 assignments

2 videosTotal 7 minutes

The Power of Looking Back in Time3 minutes
Time-Travel Syntax and Capabilities4 minutes

2 readingsTotal 15 minutes

Time-Travel Patterns and Retention5 minutes
Hands-on Activity: Perform Time-Travel Audit10 minutes

3 assignmentsTotal 29 minutes

Hands-on Activity: Time-Travel Audit Report15 minutes
Knowledge Check: Time-Travel Queries for Historical Analysis4 minutes
Ensure Delta Consistency Assessment10 minutes

Diagnose performance problems in Delta tables and apply optimization techniques with measurable results.

What's included

3 videos2 readings1 assignment

Remove obsolete Delta files to control storage costs while preserving time-travel capability.

What's included

2 videos2 readings2 assignments

Create Fabric Warehouse schemas optimized for analytical queries using star-schema design patterns.

What's included

2 videos2 readings1 assignment

Understand mirroring options for near real-time replication from operational systems.

What's included

1 video3 readings2 assignments

Build and document a production-ready data storage and processing solution using Medallion architecture, Delta Lake optimization, and star-schema Warehouse design.

What's included

3 readings1 assignment

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Microsoft

368 Courses2,676,932 learners

Offered by

Microsoft

Explore more from Software Development

Microsoft
Real-Time Intelligence & Semantic Modeling
Course
Microsoft
Data Factory & Orchestration
Course
Microsoft
Fabric Foundations
Course
Microsoft
Launching Your Fabric Analytics Career
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions

This advanced-level program assumes foundational experience with data engineering and modeling concepts. You should have basic familiarity with programming concepts. Prior experience with Power BI or data warehousing is helpful but not required.

Yes. The program includes hands-on activities designed for execution in Microsoft Fabric. You'll need access to a Fabric-enabled workspace (available through Microsoft Fabric trials, organizational licenses, or pay-as-you-go capacity) to complete the practical exercises.

This program prepares you for roles such as Microsoft Fabric Analytics Engineer, Data Engineer, BI Developer, and Analytics Engineer. The skills align with CB2-level (skilled professional) positions requiring hands-on Fabric implementation experience. Completers will be well-positioned for Microsoft Fabric-related certifications including DP-600.

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.