SQL, Data Warehouse & Scheduling in Microsoft Fabric | DP-600 EXAM PREP (6 of 12)

Learn Microsoft Fabric with Will
Learn Microsoft Fabric with Will
5,714
0
Published 2024-05-02
Free DP-600 study notes inside community: www.skool.com/microsoft-fabric/classroom/6e52cd48?…

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:    • DP-600 Exam Preparation  

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
All Comments (13)
  • @LearnMicrosoftFabric
    Hey everyone - this marks the half-way point, we've covered lots of topics already, but we've got some big ones left to go! Please LIKE, leave a comment below and SHARE with colleagues who are also taking the exam - THANK YOU!
  • @IngoJobling
    Thank you for this course, its a big help in preparing for the DP 600 exam!
  • @tresorkaleto1481
    Tomorrow I will pass my exam. I hope I will get it 🎉 Thanks for the course
  • @VinayakKommana
    🏎💨 You are dashing in like the F1 with the frequency of your videos, loving it❤
  • @user-dy8xu7uj8k
    Hi Will, I have some complex "Scalar user defined functions" defined in MYSQL and I have to migrate them to fabric, but as of now fabric doesn't support creation of "Scalar user defined functions" in warehouse. In this scenario please let me know alternative options I can use. Thanks
  • @tech_explorer101
    Great video and extremely informative. I just have two questions regarding this content: 1. Is it possible to create stored procedures and functions in the SQL endpoint in a lakehouse? In your example, you use a data warehouse but could the same work be done in the SQL endpoint? 2. Regarding the scheduling of data pipelines, there is a new action called "Trigger" in preview. Would that be something one can get tested on since you didn't mention it in the video?
  • @user-dy8xu7uj8k
    Hi Will, Good Morning!, I have to convert the existing SQL server stored procedure into fabric environment, In my stored procedures there are CURSOR commands but fabric doesn't support CURSOR commands, in this case how do I proceed, is there any alternative.
  • @oumouratouannasow6190
    Hello great video. 👏 to resume can we say that views, functions and store procedures are just different kind of SQL queries that allow the user to save the query? And also I am confuse about when to use what. Thank you !!