Let’s Get Certified: DP-800 | Opening Panel | SQL AI Developer Associate Overview

本站添加: 2026-06-02

[00:00:02]Hello everybody. Welcome. We're so happy to have everybody here today. My name is Philip Aurgess and I am really excited to present DP800 which is the new AI enabled uh SQL and uh I'm here to introduce myself and uh I'll have our other uh moderators um introduce themselves as well. And so we're just kick off with a 30-minut session where we have exam vouchers for you all. So, I'll give you further instructions as we go on kind of how to claim those and also just kind of the best sort of study practices so that you can um do great on it and pass that exam. Uh it's now in general availability. However, one of the compliance requirements is not that you pass it is there's a whole lot of other guidelines that we ask that you comply with, but we hope you pass and we'll give you every resource we have available for you to do so. But passing is actually not a requirement of the voucher. So, just so you're clear about that. Uh, so yeah, I'm going to just turn it over to my fellow moderators as I pull up our slide deck um to go ahead and introduce themselves and uh they'll be hanging out with me as we moderate our sessions and introduce our fantastic speakers throughout the event. Uh so, uh oh, I just lost one. All right, he'll be back. Usman, can I have you introduce yourself?

[00:01:22]>> Uh hello everyone. My name is Usman from Pakistan. I'm a new student ambassador for Microsoft and I'll be joining Philippa for today as a moderator.

[00:01:35]Fantastic. So yeah, we hope we hope to have a lively chat and we absolutely welcome everybody to um participate, ask your questions and we want to make this as interactive and fun as possible. We definitely enjoy having the opportunity to, you know, be part of these technical trainings and all learn together, but a a big part of it for me is making sure that we all have the opportunity to uh build community and and be in this together in this sort of technical learning journey that we're all on. I'm also in the process of studying for the SC500, which is now in beta, which is the security version of this, whereas today we'll be talking about uh SQL. Um, and a lot of it's actually very similar because you're really it you yes you should have good unstructure of you know respectively SQL and and security but really when you're applying all the AI tools and the AI enablement AI security it's actually very very much the same.

[00:02:34]So here we are. We've got our uh let's get certified DP800 and uh again I am your host and um one of today's moderators and my name is Philip Aurgis.

[00:02:46]I'm a recent graduate. I have uh been in grad school for five years now. I have three masters and two certificates and I'm proudly a Microsoft student ambassador at the senior level. I'm a women techmakers ambassador and I uh they love my ambassador programs. I'm also part of uh the fabric community.

[00:03:05]I'm a lead for a Microsoft fabric location intelligence and security user group. Um ah we have other people.

[00:03:13]Hello. Welcome. Welcome.

[00:03:16]>> Hello.

[00:03:16]>> So happy to have you here today.

[00:03:20]>> Great to be here.

[00:03:22]>> And we have a really uh we have an active audience here. So uh Usman, you've got work to do. Uh welcoming everybody in the chat. And um uh yeah, just really welcoming everybody to be as interactive as possible. I'm just going to look at the chat really quickly. Uh here we are. Okay, so we've got uh I've got sort of people saying hello everybody. Uh we've got uh hello from Portugal. Yeah, I just I love seeing familiar names, familiar and faces because this is definitely about building community. Um we've got Berlin.

[00:03:54]Well, actually one of our speakers um this today's event will be joining us from Berlin. Uh Pakistan, welcome. And we've got um our moderator Usman's from Pakistan, Angola. Latislau, you're you and Shalom are originally from Angola.

[00:04:09]Uh you're or you're you're Angolan. I can't say originally from you never you never lose your your national identity.

[00:04:18]Um uh more Pakistan. Welcome, welcome, welcome. So uh we've got Grace from Canada. Uh South Africa actually we um we our moderator is from South Africa actually. Perfect uh opportunity for uh for you to introduce yourself.

[00:04:35]Uh yes.

[00:04:37]>> Hi Philippa.

[00:04:39]>> Hello.

[00:04:39]>> Hi everyone. Um I am Mua. I'm from South Africa based in the Jobak Southeast region and I'll be your moderator for today.

[00:04:50]>> Fantastic. Uh so so excited to have like we've got about 50 people um joining which is fantastic. We've had over 250 people register. I'm going to give you uh so there is some like fine print of these exam vouchers. They're 100% off.

[00:05:05]There's no fee. They're free. We ask that you participate in the trainings.

[00:05:10]Uh we're going to drop the link in session Hey from England. Welcome Manchester. We're going to drop the link to register for your vouchers in session three. And the reason I'm dropping them in session three is I want to make sure that you have enough of a runway to understand what the topic is, what what the context is, what's going to be covered in the exam, and decide if you are ready to take it before June 15th or after June 15th. And as long as the everybody in our first group complies with all the guidelines, I will have more vouchers for everybody. So it's okay if you want to take it after June 15th. I should have enough for everybody here today. I know for everybody who's in the room right now, I have enough for all of you. Um, but I just need you to decide if you want to take it before or after June 15th. If you wish to take it before June 15th, you must register that voucher today. Today is actually the deadline. So, once you fill out that form, I will be turning right around and sending you your exam voucher. What I will ask for you to do is to send me a reply email back saying I got it or thank you, nothing more, just so that I know it went to the right person and and you got it. And if for any reason you change your mind and just reply back saying, "Hey, I need to return this." No problem. I can give it to someone else.

[00:06:23]Um, but please do that quickly because the ones I have today have to be registered today and you need to take this exam by uh June 15th. And again, if you wish to take it after June 15th, no problem. Just register your request and as long as everybody meets the guidelines, I will have more. So that's the kind of the rules of engagement. And the reason that the the compliance issues is they don't want you to sell it or give it away. So whoever is asking for it needs to be the person who takes the exam and they're given to us by the Microsoft fabric community. So they're asking you to take fabric only exams. So it's not gated when you go to register, but the request is that you only use these vouchers for fabric. Um voucher is absolutely free. There is no charge.

[00:07:07]It's 100% off. Uh there's yeah it's yours and you can use it for DP600, DB700 or DP800. So when you request your voucher today, you just decide if there's one of those exams you're ready to take uh before June 15th. If so, fantastic. Um put your request and I just ask you to you'll just check a box saying I'm ready to take whichever which of those three exams before June 15th.

[00:07:32]No problem. You must register it today.

[00:07:35]uh and you will get it within the hour of sending in your uh your request or you will say I want it after June 15th.

[00:07:44]No problem. Again, you can use it for 600, 700 or 800. And the reason we're going to um kick that to session three today is one, we want to give you enough lead time for you to make an educated informed decision of how prepared you feel you are to uh take it. Yes, the vouchers are given to me um because I wear two hats. I wear one hat as a Microsoft student ambassador and I've been very active in the uh Microsoft fabric community. I I seem to be one of the only people I've seen, although I'm encouraging other people like Lattislau and our friend Shalom Andre to get involved as well and any of you here in being spokespeople for the Ezri, which is a mapping software that I covered deeply in my studies um and and Microsoft and it's basically bringing geospatial and uh data science more closely together because oftentimes those are very siloed and so I've been very active um in the fabric community uh as an advocate of that integration and that partnership. And so I've been to the fabric conference. I regularly moderate um on the Microsoft reactor stage. I've spoken on the M Microsoft reactor stage in April and I'll be back again there in June. So as a just and I have a a fabric user group. So as that um they have trusted me um because I have done my best to remain compliant and I just ask you all to please keep the compliance because the more that we comply because they always give me the statistics back of who makes sure everybody registered for the right exam that the names matched and that um they were used in time. So as long as I maintain good statistics I will get more vouchers.

[00:09:24]Will there be courses in geospatial data engineering? I'm interested in that. Uh I love that. Please talk to me anytime all day about that. Not today. Um but absolutely that is my field. Um my studies, my master's degrees are across urban planning, uh geospatial intelligence and um cyber security. So those are all of my things. Uh and of course data science is right at the heart of everything. So let's turn our attention here. Uh Latislo, you're one of our illustrious speakers today.

[00:09:52]You're going to be leading two sessions.

[00:09:54]Can I have you introduce yourself?

[00:09:56]>> Uh yes. Yes, of course. Um, well, my name is Lad Landre. Um, I'm a Microsoft certified trainer and data engineer and excited. I'm also uh now a group uh fabric user group leader.

[00:10:13]>> Yes.

[00:10:14]>> Um, yes, me and Shalom.

[00:10:17]And yeah, I'm excited to talk about this section about the P800.

[00:10:23]>> Excellent. All right, so let's just run through the Excellent. And we and and this is the thing I just want to say part of what community creates is opportunities because I nudged you when I someone gave me the idea that oh I could have a user group and then I nudged you like hey you could have a user group too and so we all kind of grow together and learn together. Uh so we've got we've we've introduced our moderators myself I I I need help to make sure I pronounce your name properly.

[00:10:56]Li, it's >> nice. Thanks.

[00:11:06]>> Okay, we'll get there. And >> we'll get this.

[00:11:09]>> Okay. Excellent. Well, I'm so happy to have you all here and pleasure.

[00:11:15]>> Yes. So, yes, we're I see in the chat the voucher will be Yeah. When the reason it's it's in session three is one, I want to make sure you guys have enough lead time on what the topic is, what the content is to to make an educated decision if you are prepared to take this or DB600, DP700 um on or before June 15th. Um so where we were uh is a passive repository for structured data and now we have active intelligence. So your Excel, your SQL, your security are all different now.

[00:11:45]They are not the same.

[00:11:48]uh for example even within the uh Microsoft ecosystem the a which was the Azure 500 exam which was like can you administer an an Azure cloud environment is now being retired and turned over to the SC uh 500 which is the AI enabled security exam because it is a completely uh different environment and in previous sessions that we've done we've really seen that the biggest new threat threat vector is uh the machine identity. So, not just the um personal identities, but the fact that machines will now have access to all of these workflows. And I'm sure people have seen articles of of uh you know, the AI deleted my my entire cloud workspace. So, uh these these you know, so just as there's so much more that it can do to get data to process the data. We'll learn more about vectors and embeddings and the workflows and model context protocols and all the integration but it is not the SQL that anybody has just if you've uh whether you how depending on your level of familiarity with SQL um databases are such an important tool in data science um they're very learnable you just need practice so if you're new to this you're don't worry about it we're going to give you um lots of guidelines in terms of how to move forward in just learning your um your SQL but also understanding now how AI is creating this active intelligence that just absolutely changes the game. So now you've got sort of this one SQL philosophy, a unified architectural philosophy for AI enabled deployment and so now it's coming together where you've got your SQL server and your Azure SQL um to now have a TSQL AI integrated engine and it is incredibly powerful and that's what we're going to go through here today.

[00:13:39]So, by we we very much hope by the end of this session and all the follow-up resources that we send you, you will feel fully prepared to take and pass a DP 800 exam. And hopefully we also inspire you to take DB600, DB700. And of course, I'm a big advocate for security.

[00:13:55]So, there's always the SC 500, 300, 200, 100. Um, because I do feel more and more that these silos that existed between security and data are also collapsing.

[00:14:06]And I think every cyber security person needs to be using more data science and every data science ne person needs to be way more aware of uh of security especially in this um changing landscape.

[00:14:20]Uh so the DP800 blueprint three domains so you've got 100 minutes 700 you need a 700 score to pass. Um domain is design and develop database solutions is 35 to 40% of it. Uh domain two is secure, optimize and deploy always encrypted CI/CD SQL prompts is 35 to 40% of it.

[00:14:43]And uh domain uh three is implement AI capabilities, vector data, external models and uh and rag. So that's going to be 25 to 30% of it. And that's retrieval augmented generation. Uh and I don't need to be the only one presenting here. Uh last can I can I share the screen with you?

[00:15:07]Take us through today's event.

[00:15:12]>> Yes. Yes. Let me uh should I share my screen now?

[00:15:18]>> Uh you can share your screen or you can jump off of the slide that's in front of us.

[00:15:23]>> I will share my screen.

[00:15:36]Yeah, Lisa is going to lead us through sessions one and sessions five.

[00:15:47]>> Uh, right. I'm already sharing my screen.

[00:15:52]>> There you are.

[00:15:53]>> Okay.

[00:15:55]Uh, thank you. Thank you, Philippa.

[00:15:57]Let's go. Uh so we we are going to start with this um domain of the exam that is database design advanced TSQL and JSON. Uh that is one of the the domains of the exam that has the higher percentage along with the next one. Um so in this in this um section I'm going to focus a lot on when you should use uh the concepts for each use case not only learning the definitions of what is uh um how can you use JSON or what is a temporal table not only focusing on definition but when should you use that uh that concept of the exam. So then let me do this.

[00:16:56]It's a bit like this. All right. Uh so we going to talk about specialized table types. Um and we're going to see how should you decide on which type of table to use.

[00:17:11]And also whenever possible, we're going to do a live demo on SQL Server so you guys can see what I'm talking in in action. We're going to see also some JSON functions, regular expressions and fuse matching and some programmability objects. And at the end just say a little bit that how we can use AI assisted dev. And I'm not going to say about the exam tips cuz this we're going to keep for the last section.

[00:17:45]Um and so for this content to be delivered uh as I was saying uh my name is Ladis Landre and I'm focusing on data and analytics solutions and I'm a Microsoft certified trainer and currently I work for Axions as a data engineer with fabric.

[00:18:05]Um so all right enough of me let's go to the exam. But uh one thing that I like to focus that's how I uh designed this section is uh when we studying for the exam we should have the exam mindset not only knowing the definitions of stuff but also thinking how Microsoft uh approaches the exam and how we should do also in in enterprise scenarios and this mindset is we're not going to focus on what does a J value return you can know this all right a value return a scalar string a number or boolean but no we're going to focus more if a developer needs to extract a price from a JSON column store as a number which function should you use so it's JSON value and it makes completely sense because in work you never going to have this kind of questions what does a variable return but you have a scenario that you have to solve and you have to decide which function you you use and so this is the what I call the the exam mindset and our section is going will go around this kind of approach again another one is like what is a temporal table we don't think like that we ever almost all the time we think like if your company needs uh immutable and tempor evident out records you should use a ledger table and we're going to see this temporal table and ledger table in the slightly demos.

[00:19:43]Uh all right and this is about the specialized table types. We have these table types available now on SQL server on um Azure SQL 2 and we have the temporal table that is automatic row history via period. When you want to check the state of the table in previous uh pre period of time you use a temporal table. When you want your table to be auditable uh you use a ledger. When you have complex relationships, you use a graph.

[00:20:20]And I'm going to this like slightly because you can always go deeper, but it's always better to have this kind of keywords matching when you are studying for this. I want to audit my table. I know it's ledger. I have complex relationships, graph tables. I have JSON values. Then I'll use a JSON column. Uh the table is not on my database. is another source like a azour blob storage or using external. I want to see the state of my of my table in like one week ago temporal table.

[00:20:59]But also um we have this decision guide.

[00:21:05]Uh and if you need to query a data as it exist at a specific point in time definitely you use a temporal table because we have this for system time as of and then after the after it you're going to put the time that you want to query your table. Uh if you need a temper like whenever you need um to audit your table for compliance a ledger table and ledger table can be append only or updatable. There are tables that you're going to create as ledger that you can never change. You can only insert append the values and there is also the tables that you're going to update but you always want to know who updated like need to track who changed the data and what changed over time.

[00:21:56]Then you're going to use a ledger table.

[00:21:57]>> Okay.

[00:21:59]>> Yes.

[00:21:59]>> I'm going to cut you off because this is so good. But this is just the preview.

[00:22:04]We're just in the opening panel. You've got a whole session one ahead of us. So, I just want to make sure people are just getting that this is a taste of what's ahead of you and I'm so excited for it.

[00:22:13]>> So, I don't want to have you give away your whole session. I just want them to know that we've got an amazing panel of speakers um joining us and we're so excited about all of them. So, uh Lisla, that is fantastic. And I'm just going to cut you off there because I think you're getting way into your content which is spectacular. But I don't want to make sure we don't give away the the whole store on that because we've got a whole two sessions with you that we're really super excited about that are just going to be coming up here in just six minutes. We'll start that. But as you can see, we've got fantastic speakers, excellent moderators that I'm so excited to sort of welcome uh with me today. So just to run through our speakers and our sessions. So Lisa, you're going to be um leading us through session one just starting here in a few minutes. Um and we're going to focus on that database design, advanced TSQL, and JSON. And I will say that having done the beta version of the DP800, I do not have my results yet. Uh but I do know that J the um the JSON um and all of its functionality shows up a lot on the exam and you're definitely going to want to know how to do those drag and drops. Um and then we continue and Yousef will be joining us uh and he will be talking in session two on securing, optimizing and deploying database solutions. And then we um have Deir. He will be leading both sessions three and four um for vector search embedding and indexing followed by rag workflows and external rest endpoints and then let us allow back uh for our um data API builder MCP integration and exam strategy. Now this is kind of a a and so as some of you know we as uh some of us are Microsoft student ambassadors and we have uh certain guidelines there for qualifying events and one of them is that we run them on teams. So, we uh had done a version of this event. Uh and we did it in uh earlier in the day that just I'm Pacific time, so for me it was 6:00 a.m.

[00:24:14]But I did that because it just makes a time that's more friendly to our colleagues um in South Asia. Uh so I do know there are many people here from South Asia joining us today. It's a little later for you, but uh it's it's kind of the middle of my morning um here where I am in California. And uh and so with that we are now kind of coming back um for session two with a a a new mix of speakers and some returning speakers. So I will say having heard both Demir and Lattis loud sessions on Thursday uh of last week uh they're really inspiring and very informative and educational.

[00:24:48]Um, I really hope I passed my DP 800, but I am actually I have full confidence that if I didn't, after now having taken these two event sessions and our post uh event resources, I am good to go. And I'm very confident you will be too.

[00:25:03]Uh, and so that was uh that's kind of what I just wanted to sort of just say that uh I also wanted to bring it to the YouTube stage because to me it just makes um just another I'm wanting to uh just kind of be more public and I think the teams are great but just they don't live um beyond the event time as well and I don't think they they replay on YouTube as well. So that's why I'm really grateful to our speakers and moderators here to could come to join us so that this this content can have um a longer life. And if you're enjoying this content, please um drop a like. It helps the algorithm.

[00:25:38]And uh and yes, hello everybody in the chat. Love, you know, please feel free to be as engaged in the chat as you'd like to be. Um we're seeing questions about vouchers. Uh and just I see some answers have come in there as well. Um we're going to drop that link for you to request your voucher in the third session. and when we do uh uh so yes to be clear the ex any exam that you're going to take um in from the DP series is in US dollars it's $165 that is the price for the exam um because of our relationship with Microsoft fabric and it may not be a forever thing but for now they keep giving me tanches of vouchers and as long as I compliantly deploy those vouchers and you all stay compliant you get a 100% free voucher.

[00:26:26]So, you'll get 100% off of that $165.

[00:26:28]So, I'm essentially handing you $165.

[00:26:31]I'm not asking for anything but your compliance and your best efforts to uh to learn and engage and be part of our community. Uh so, there there is no there's no sales pitch other than thank you for being part of our community and for taking the time to be here and to learn with us. Uh and so that's why I want that's why I asked for those guidelines and the go compliance. That's why I asked for you to return a response on the email I send you with the voucher code because I've essentially handed you $165 and I ask that you say yes, got it, thanks. Because if I don't get that, I will then hand it to somebody else if I don't get a response within a, you know, a a disclosed amount of time. Um, similarly, the vouchers I have right now expire today. They must be registered and they must be taken by June 15th. If everybody I give them to follows the rules, I'll have more vouchers. So, if you request a voucher to be taken after June 15th, I will have more vouchers for you. So, that's why it's really important that you all follow the rules because you all help each other um so that I can get more vouchers. Uh and so that's hopefully answers the question.

[00:27:36]With that, we are ready for our next session. We do ask you all to jump from session to session um because that way it just makes for cleaner replays and uh each of the the speakers kind of gets their own dedicated session. Uh and with that uh we are all going to head over to Latis session. Um I've just dropped the link. Um you can also follow the playlist. It's all all the links are in Luma. Um actually I can even add the playlist there. I don't think I've added that yet. Um but I also if you're register I would encourage everybody to register for the Luma. If you're not if you've jumped on here and you're not part of the Luma event. I'm going to go ahead and real quickly just drop that link in. If you register, then you'll get all the updated updates and notices.

[00:28:19]And that's actually also where you're going to get your um that's where going to be dropping the voucher links are going to come to you through Luma. Um so that's it. And um so I put the Luma link in there. I put the next uh link in the next um live session. And uh let us know and everyone else we will see you uh for session one in just one moment. Thanks everyone.