SQL, Data Warehouse & Scheduling in Microsoft Fabric | DP-600 EXAM PREP (6 of 12)
ฝัง
- เผยแพร่เมื่อ 27 มิ.ย. 2024
- Free DP-600 study notes inside community: www.skool.com/microsoft-fabri...
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
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!
Thank you for this course, its a big help in preparing for the DP 600 exam!
Thanks for watching Ingo, I’m glad you’re finding it useful!
Tomorrow I will pass my exam. I hope I will get it 🎉
Thanks for the course
Best of luck! I hope you smash it 💪
🏎💨
You are dashing in like the F1 with the frequency of your videos, loving it❤
F64 actually 😉😂
@@LearnMicrosoftFabric 😂😂good one
Always looking forward to your videos. Thanks
Thanks for watching!!
👍
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
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?
1. Yes (but only for select statements/ read-only)
2. Highly unlikely
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.
Yes I don't think cursor commands are supported in Fabric Data Warehouse T-SQL. A workaround/ replacement might be possible, but it depends what you're using your cursor for
Can i use Power Automate to run a pipeline as I have done on adf before?
I haven't done this personally, but I have seen others talk about it, so I think it's possible!
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 !!
Yeh something like that! The goal is to enable re-use of our scripts for efficiency 👍 there’s lots of resources on the internet that go into more details about the differences between them/ when to use which, I didn’t spend much time talking about that on the video I’m afraid
✅
Thanks for watching!!