Using T-SQL to query data in Microsoft Fabric | DP-600 EXAM PREP (12 of 12)

IMPORTANT! As of 15th Nov 2024, the DP-600 study guide has CHANGED! For updated DP-600 study notes & discussion: https://www.skool.com/microsoft-fabric/about/ 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: https://www.youtube.com/playlist?list=PLug2zSFKZmV05ZJcmHemXxyJjPVXeQ2qS 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