SQL, Data Warehouse & Scheduling in Microsoft Fabric | DP-600 EXAM PREP (6 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 (6 of 12 in the series), we continue Section 2 of the DP-600 Study Guide: Prepare and Serve Data. We cover the following topics: - Create views, functions, and stored procedures - Add stored procedures, notebooks, and dataflows to a data pipeline - Schedule data pipelines - Schedule dataflows and notebooks This video is part of the DP-600 Exam Preparation series: https://www.youtube.com/playlist?list=PLug2zSFKZmV05ZJcmHemXxyJjPVXeQ2qS Timeline 0:00 Intro 1:13 Connecting to a Data Warehouse using SSMS 2:52 SQL Views 6:15 SQL Functions 10:09 SQL Stored Procedures 13:53 Stored procedure activity in Data Pipeline 16:39 Notebook activity in Data Pipeline 17:55 Dataflow activity in Data Pipeline 18:35 Scheduling Dataflows 19:33 Scheduling Notebooks 20:36 Scheduling Data Pipelines 22:19 Practice Questions 26:14 Outro and next steps #microsoftfabric #dp600 #powerbi