Power Query M topics
12 short topics in SQL and Relational Databases. Each one is a single focused exercise with a clear piece of evidence at the end.
12 topics, one exercise each.
Work through them in order, or jump to the one you need.
These are draft topic outlines (draft; instructor review pending). Full lessons follow after review; ask Ajay if you need a topic sooner.
- 01
Query expression syntax
Demonstrate query expression syntax in a focused Power Query M example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 02
Data selection and projection
Demonstrate data selection and projection in a focused Power Query M example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 03
Predicates and filtering
Demonstrate predicates and filtering in a focused Power Query M example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 04
Grouping and aggregation
Demonstrate grouping and aggregation in a focused Power Query M example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 05
Ordering and result windows
Demonstrate ordering and result windows in a focused Power Query M example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 06
Combining data sources
Demonstrate combining data sources in a focused Power Query M example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 07
Null and missing-value behavior
Demonstrate null and missing-value behavior in a focused Power Query M example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 08
Reusable query parameters
Demonstrate reusable query parameters in a focused Power Query M example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 09
Query composition and subexpressions
Demonstrate query composition and subexpressions in a focused Power Query M example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 10
Query execution and optimization reasoning
Demonstrate query execution and optimization reasoning in a focused Power Query M example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 11
Query result validation
Demonstrate query result validation in a focused Power Query M example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 12
Query integration with applications
Demonstrate query integration with applications in a focused Power Query M example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course →
Learn the same ideas beyond Power Query M.
These courses share topics with this one, so you can compare how each language or tool handles the same concept.
More in Markup configuration and query languages.
You have the curiosity.
Let’s turn it into capability.
Start with a practical workshop or bring a specific question to Ajay.