I will summarize my thoughts after reading "Introduction to SQL for Business Professionals to Enhance Data Analysis Skills".

To join tables by using FetchXML, start your query by selecting a table with the entity element, as described in Query data using FetchXml. Use the link-entity element to describe the data from ...

Metric views create a semantic layer for your data, transforming tables and views into standardized business metrics. They define what to measure, how to aggregate it, and how to segment it. As a ...