Published On May 25, 2024
Free DP-600 study notes inside community: https://www.skool.com/microsoft-fabri...
In this video (11 of 12 in the series), we cover the following sections of the DP-600 study guide:
Implement descriptive and diagnostic analytics
Integrate prescriptive and predictive analytics into a visual or report
Profile data
This video is part of the DP-600 Exam Preparation series: • DP-600 Exam Preparation
Timeline
0:00 Intro
1:18 Ways to access the T-SQL engine in Fabric
2:43 XMLA Endpoint
3:17 T-SQL: some possible topics for the exam
4:10 Create Table As Select (CTAS)
5:47 Viewing our data
6:17 Grouping and Aggregates
7:13 WHERE & HAVING
9:40 JOINS
10:10 Common Table Expressions (CTEs)
12:49 LEAD and LAG
15:57 ROW_NUMBER() and partitions
17:36 Subqueries
18:49 T-SQL Visual Query Editor
23:10 Practice Questions
31:49 Thank YOU!
#microsoftfabric #dp600 #powerbi