AZ-900 Episode 12 | Database Services | Cosmos DB, SQL Database, Db for MySQL & PostgreSQL

Рет қаралды 279,922

Күн бұрын

Microsoft Azure Fundamental full course.
Skills Learned
- Describe the benefits and usage of
- Cosmos DB, Azure SQL Database,
- Azure Database for MySQL,
- Azure Database for PostgreSQL, and
- SQL Managed Instance
Study Materials: marczak.io/az-900/#ep12
* Episode Resources
* 📚 Study cheat sheet marczak.io/az-900/episode-12/...
* 🧠 Practice Test marczak.io/az-900/episode-12/...
* Study Guide
* Microsoft Azure: Microsoft Learn: Databases docs.microsoft.com/en-us/lear...
* Microsoft Azure: Azure Cosmos DB Overview azure.microsoft.com/en-us/ser...
* Microsoft Azure: Azure SQL Overview azure.microsoft.com/en-us/ser...
* Expand your knowledge - extra resources
* • Azure SQL Database Tut... - Azure SQL Database Tutorial | Relational databases in Azure
* • Azure Cosmos DB Tutori... - Azure Cosmos DB Tutorial | Globally distributed NoSQL database
* Microsoft Azure: Azure Cosmos DB Documentation docs.microsoft.com/en-us/azur...
* Microsoft Azure: Azure SQL Documentation docs.microsoft.com/en-us/azur...
00:00 Episode introduction
00:16 Episode objectives
00:47 Azure Cosmos DB
03:27 Azure SQL Database
05:50 Azure SQL Product Family
07:39 Azure SQL Database Demo
11:32 Database Services Summary
Want to connect?
- Blog marczak.io/
- Twitter / marczakio
- Facebook / marczakio
- LinkedIn / adam-marczak
- Site azure4everyone.com

Пікірлер: 154

@thiago189 3 жыл бұрын

One of the best courses I've ever watched on the internet and it's completely free. So happy for having found it.

@AdamMarczakYT 3 жыл бұрын

Glad to hear that, happy to help out!

@TheB1nary 2 жыл бұрын

Couldn’t agree more!

@brianb1907 2 жыл бұрын

This man is a hero! Best free online course I have ever seen. I am sure he is responsible for countless people becoming Azure certified.

@prvalva 2 жыл бұрын

One of the best and the easiest way to prepare ourselves for the Azure exam, checked many youtube videos but this one is one of the best... Thank you, Adam...

@samrahman6985 6 ай бұрын

This is the best Azure tutorial that I have found. At the right level of detail for me as a PM.

@llamadrama2256 3 жыл бұрын

Just wanted to say a big thanks for making this content available and for free! I found it by far the most engaging compared to other trainers and passed the exam today, Thanks to you! :)

@AdamMarczakYT 3 жыл бұрын

Thanks William! :D appreciated!

@abhisheksoni6012 Жыл бұрын

Thank you so much Adam for making these difficult-to-grasp concepts very easy to understand and interesting to learn. There are no words for your teaching skills. You are awesome. Thanks a lot Adam !

@lakshmiramalingam3759 3 жыл бұрын

Don't feel sleepy anymore while studying.. Wait Am i studying ??? Great videos.Thanks to you.

@AdamMarczakYT 3 жыл бұрын

I never feel like studying in Azure, I just have fun playing with it. I try to make my tutorials fun too! Glad you enjoyed it!

@vedbhargav6902 3 жыл бұрын

Thank You Adam !! Your course not only helped me to clear AZ900 exam but also helped me to gain lot of knowledge. Appreciate Your Work, Thank You Once Again !!

@AdamMarczakYT 3 жыл бұрын

Great job! Keep it up mate!

@andremacedo7398 2 жыл бұрын

O melhor curso que eu ja vi no youtube, estou impressionado com o nivel de produção 👏

@surbhidhawan9807 10 ай бұрын

One of the best courses for Azure Fundamentals certification, thank you Adam for the videos.

@damienluedtke9276 3 жыл бұрын

Thank you so much, prepping for my test next week and I wad getting stuck on the database components. You good sir are the best thing I have found on KZfaq.

@AdamMarczakYT 3 жыл бұрын

Fantastic, thank you! :)

@syedjunaid7846 3 жыл бұрын

Was looking forward to this! Thanks Adam

@AdamMarczakYT 3 жыл бұрын

My pleasure!

@KukuFamily 3 жыл бұрын

Best Place to learn. All my azure learnings are from your videos. Thanks a lot.

@AdamMarczakYT 3 жыл бұрын

Thanks! :) Glad to hear that :)

@SAMIURRAHNMANSHAIKH 3 жыл бұрын

confused who gives 2 dislikes to this video. it is perfectly explained. well done Adam.

@AdamMarczakYT 3 жыл бұрын

Hehe, me too! Thanks!

@SAMIURRAHNMANSHAIKH 3 жыл бұрын

@@AdamMarczakYT We expect more course on Azure like Terraform, Azure architecture, DevOps.

@RyantheCanuckpirate Жыл бұрын

@@AdamMarczakYT Amazon ;)

@scotmarkieboy 3 жыл бұрын

Hey Adam, thanks for putting this content together and making it available for free.

@AdamMarczakYT 3 жыл бұрын

My pleasure!

@pereganranwei2153 2 жыл бұрын

Adam, Thank you for all you have put in to produce this video. Your work is super

@owenaustin4744 3 жыл бұрын

Thanks Adam, these videos are so easy to follow! You're the man! :)

@AdamMarczakYT 3 жыл бұрын

Glad you like them!

@OladipupoPopoola 3 жыл бұрын

I practically substituted my TV programs for your channel. Best decision ever! Learning loads rapidly. Thanks man.

@AdamMarczakYT 3 жыл бұрын

Haha! You rock!

@stratislivitsanos3312 3 жыл бұрын

hi Adam .... transferιng knowledge (training) is not an easy job , the way you do it is just perfect and not only for exams ..... of course when all this are totally free the less I can say is congrats !!!!!

@vibhaskashyap8247 3 жыл бұрын

Very well explained Azure key services. Thanks Adam ! Your sessions are very clear

@AdamMarczakYT 3 жыл бұрын

Great to hear! Thanks for watching :)

@susmizacharia3602 3 жыл бұрын

Love your videos.. hopefully more videos come in the next week so that the whole learning path is covered...I totally understand every point you tell and it really helps a lot

@AdamMarczakYT 3 жыл бұрын

Awesome! Stay tuned for more!

@susmizacharia3602 3 жыл бұрын

From September 15 onwards there is a new study guide . Would you mind covering those?

@lailam.mostafa1218 2 жыл бұрын

This playlist is super amazing 👏🏻👏🏻❤️

@wookieeMan06 2 жыл бұрын

Love your video short, and easy to pick up the concepts quickly

@AdamMarczakYT 2 жыл бұрын

Great to hear!

@roshanichaware6511 2 жыл бұрын

This is the best tutorial, Thank you very much Adam :)

@danihawkwow 3 жыл бұрын

Thank you Adam. Excellent video on database services

@AdamMarczakYT 3 жыл бұрын

My pleasure!

@frpmz1906 3 жыл бұрын

You are the man! Thanks for your work. I really appreciate it !

@AdamMarczakYT 3 жыл бұрын

I appreciate that Filipe! Thanks for stopping by :)

@chamumajety7431 2 жыл бұрын

Awesome video.. very easy to understand... Well structured and explained.. well done..

@bruchthal 3 жыл бұрын

Absolutely magnificent...thank you very, very much!

@AdamMarczakYT 3 жыл бұрын

Thanks Victor! :)

@badrmotayeb4833 3 жыл бұрын

thank you, this is my first comment, i like what you share with us it's very helpful and for now azure is for everyone !!! Big thanks

@AdamMarczakYT 3 жыл бұрын

Thanks a lot!

@toddace9 3 жыл бұрын

Thank you so much for creating and sharing these videos, easy to understand. 😊😊

@AdamMarczakYT 3 жыл бұрын

My pleasure!

@manjubsccs 3 жыл бұрын

Thanks a lot... very clear, short and brief. Hope I would pass the exam easily

@AdamMarczakYT 3 жыл бұрын

You've got this! 👊 I cover in my videos more than exam requires :)

@davidgates5189 Жыл бұрын

you explain everything so easy to understand

@VaibhavSrivastava-Vabnix 3 жыл бұрын

Very good explanation @Adam perfectly done. We do have some changes w.r.t SQL data warehouse at (6.47min). The name has been changed by Microsoft to Azure Synapse Analytics, whenever you get a chance please see if it can be updated. Always good to keep documentation up-to-date. I see you have updated the section with Azure Synapse in Episode 15

@AdamMarczakYT 3 жыл бұрын

Yep, thanks, this is covered in later episodes and mentioned several times throughout the series :) Unfortunately KZfaq doesn't allow for updates.

@timmusaka9577 Жыл бұрын

You are the best Adam!

@kalpanachauhan60 2 жыл бұрын

Its a very great course..Great clarity

@user-wl8le9ck4c Жыл бұрын

Excellent online course. Better than paid course

@Southpaw07 2 жыл бұрын

Much better than paid content . TY

@farshidjamali 3 жыл бұрын

Thank you, Adam!

@AdamMarczakYT 3 жыл бұрын

My pleasure!

@XTarik.TarikX 7 ай бұрын

Thank you Sir.

@amarnadhgunakala2901 3 жыл бұрын

Always new content, Great

@AdamMarczakYT 3 жыл бұрын

Glad you think so!

@rooklyngreen6657 2 жыл бұрын

Thanks for a great video!!

@pankajkumar-wt2ro 3 жыл бұрын

Great content Adam , following ur videos

@AdamMarczakYT 3 жыл бұрын

I appreciate that!

@kimberlywinegard7471 3 жыл бұрын

Your videos are so awesome!

@AdamMarczakYT 3 жыл бұрын

Thank you so much!

@p.c2750 3 жыл бұрын

Good job Adam. Thanks

@AdamMarczakYT 3 жыл бұрын

My pleasure!

@idougy18091809 Жыл бұрын

Another beauty!

@junisee51 3 жыл бұрын

Thanks Adam .❤️

@AdamMarczakYT 3 жыл бұрын

My pleasure! Thanks :)

@ryukenkars123 2 жыл бұрын

really intersting video , i think i gotta make a review of all for now cuz im starting to loose some points cuz too many info and all is abstract so not easy for me as noob on pc or server till now.

@ea9739 Жыл бұрын

thank you very very very much, you help me a lot

@gusinthecloud 3 жыл бұрын

thank you. Suscribed

@maitrikpatel1984 3 жыл бұрын

Great work ..very much appreciated

@AdamMarczakYT 3 жыл бұрын

My pleasure!

@maitrikpatel1984 3 жыл бұрын

@@AdamMarczakYT I get the exam cleared with 745... You videos helped a lot..

@mosampatel7059 Жыл бұрын

Excellent! 😊

@CosmeJunior 3 жыл бұрын

demo demo demo :) amazing way of learning

@AdamMarczakYT 3 жыл бұрын

Yea, demos help, it's even better if you practice. But for az-900 there is no need.

@vivekpalawesome5717 Жыл бұрын

Thank You SIr'

@ok2921 2 жыл бұрын

Good day from Nigeria Mr. Adam marczak, i have really being enjoying your teaching God bless you : Please Azure storage account belongs to which (a) Pass (b) Iaas (c) Saas. thank you waiting for rightful answer.

@PawanKumar-tu6ti 3 жыл бұрын

thanks for helping me!

@AdamMarczakYT 3 жыл бұрын

Happy to help!

@nikhilnist 3 жыл бұрын

Hi Adam! Thanks for the wonderful videos. It helps a lot. I had a question: What is difference between Storage service and Database service in azure Is both used for storing data?

@jurijdevelopment1241 Жыл бұрын

Database service is used for structured data.

@sarthakkasliwal2925 3 жыл бұрын

I am waiting for completion of this awesome course sir for giving my certification exam🤩.... Hope i will be able to give exam soon😂 Kidding...thanks for awesome videos nd sharing your knowledge ❤️

@AdamMarczakYT 3 жыл бұрын

Good luck on the exam :) Thanks for stopping by.

@TheTariqibnziyad 3 жыл бұрын

Don't kid with me anymore kid.

@lorenzocastagno1305 2 жыл бұрын

Grazie!

@limitlessharmonyy 2 жыл бұрын

Thank you #sir

@pahelereviewtodekho4225 3 жыл бұрын

Hi Adam, this is Hiren and I am planning to do certification so watching all the videos. I found these videos very informative and you nicely prepared. In this video 12, can you please also provide more details on Databse for PostgreSQL, SQL Managed instance and SQL on VM?

@AdamMarczakYT 3 жыл бұрын

Thank you! If you want to learn more check all of the linked study materials :)

@darjichirag235 Жыл бұрын

Great

@BasemAtia1 2 жыл бұрын

hey, can i have the presentation slides you are previewing on the video please ? that will help me a lot

@ericksonjosephsantos1964 3 жыл бұрын

would you consider creating a course for AZ-104 also?

@AdamMarczakYT 3 жыл бұрын

I'll definitely think about it :)

@satyasamant9828 3 жыл бұрын

Hello Adam, that's amazing session. I want to know which software u use for presentation for every session?

@AdamMarczakYT 3 жыл бұрын

Thanks! It's just powerpoint :)

@AlessandroAmbrogi78 3 жыл бұрын

Your videos are so clear!!!...Do you have also videos for other Azure Exams ?

@AdamMarczakYT 3 жыл бұрын

Thanks Alessandro! Not yet, this one is my first to 'test out the waters' :)

@AlessandroAmbrogi78 3 жыл бұрын

Adam Marczak - Azure for Everyone IMHO i think that you should prepare other videos because your videos are simple but effective and so the success is guaranteed;i cheer for you.Thanks.

@deveshgudway 3 жыл бұрын

Hi Adam ! One small question .. how can there be views if there are no tables in the database ?? At 10:07 Like your work .... You have made learning azure slightly easy

@AdamMarczakYT 3 жыл бұрын

There are no user created views. But there is always one default view which returns firewall rules from system tables (system tables are not shown in the browser view as they are on different master db).

@syedjunaid7846 3 жыл бұрын

Good quality as always, I'm guessing the next video will be released on Monday?

@AdamMarczakYT 3 жыл бұрын

Next one is quite small. Azure Marketplace so I will try to get it by Thursday/Friday this week. Stay tuned.

@rutujatoradmal379 3 жыл бұрын

easy to understand

@AdamMarczakYT 3 жыл бұрын

great to hear, thanks

@jesper7605 2 жыл бұрын

How come cosmos db is described as "nosql" but you can use a sql API for it?

@funkymunky8787 3 жыл бұрын

Can I pay for this somehow? These videos are amazing - much better than PluralSight and Udemy which I have also watched - and I want to support you.

@AdamMarczakYT 3 жыл бұрын

Heya, thank you kindly for supporting me on my journey! :) If you really want you can use PayPal www.paypal.me/marczakio or Patreon www.patreon.com/marczakio but I appreciate you being here anyway :) Thank you!

@funkymunky8787 3 жыл бұрын

@@AdamMarczakYT Sent you some via paypal!

@AdamMarczakYT 3 жыл бұрын

@@funkymunky8787 Thank you! I appreciate it! God bless.

@imsteven3044 2 жыл бұрын

What app did you use to draw the schema?

@dotnetcodesnippets 3 жыл бұрын

❤️ from India

@AdamMarczakYT 3 жыл бұрын

thanks for poland! :)

@ViktorPonomarov 4 ай бұрын

👍

@BartNoble 3 жыл бұрын

How can I find pricing on querying those databases though?

@AdamMarczakYT 3 жыл бұрын

Later in the service I cover Azure Pricing Calculator, you can just google for it, otherwise Azure has detailed pricing pages for each.

@gauravagarwal750 3 жыл бұрын

Azure Dataware house has been changed to synapses analytics services if I'm not wrong.

@AdamMarczakYT 3 жыл бұрын

Azure Data Warehouse is now an SQL Pool used inside of Synapse Analytics, correct!

@emiliosolis3671 3 жыл бұрын

when will the new videos be available? I`m looking forward to this

@AdamMarczakYT 3 жыл бұрын

Holiday season is done so more videos are coming soon! :) I should release more frequently now.

@Rahul-or9hr 3 жыл бұрын

Hi Sir, Your videos are very good Could you please create videos on real projects

@AdamMarczakYT 3 жыл бұрын

Will try :) thanks

@sumanthdixit1203 3 жыл бұрын

As usual, your videos give me a clear understanding of the concepts. is it possible if you could release the videos, earlier, than having to wait.? Just a request.

@AdamMarczakYT 3 жыл бұрын

Thanks! Unfortunately we had Holiday period so I didn't have that much time lately but hopefully I can go back to releasing couple videos per week to catch up! :) Unfortunately I can't share my materials earlier as I didn't finish the course yet.

@utsavsharma9765 2 жыл бұрын

It is not one of the best . IT IS THE BEST !!!!!!!!!

@syedjunaid7846 3 жыл бұрын

I think there was a typo in the title :) Postgre

@AdamMarczakYT 3 жыл бұрын

Ah! Fixed. Thanks.!

@muhammadadilkhan6007 3 жыл бұрын

Are these videos enough to give the AZ 900 exam?

@AdamMarczakYT 3 жыл бұрын

Yes :)

@MeijaJanis 2 жыл бұрын

dont be a menace to south central, good pick :D

@mrbrooks56 3 ай бұрын

did you only use this video , any practice test ?

@limitlessharmonyy 2 жыл бұрын

Please create video for az104

@kapa2220 3 жыл бұрын

Test question: "Which services in Azure allow for storing of strctured data." Why Cosmos DB don't ALLOW to store structured data? Also the last question: "Which of the following services allow customers to store semi-structured datasets in Azure." Azure SQLs also allow to store semi-structured data - why not?

@AdamMarczakYT 3 жыл бұрын

Because Cosmos DB is not a structured database. It's semi-structured, you can't enforce schema on the data nor create relationships. As to Azure SQL, it allows storing JSON as a column value but in general it's a structured database. Thanks for this I will rephrase the question a little.

@mayurganesh2469 3 жыл бұрын

CosmosDB is Paas right? Those who don't know anything think about Database it's really had to follow. If you can explain more related to Az900

@AdamMarczakYT 3 жыл бұрын

It is PaaS, correct. Thanks for the feedback. If you want to learn more about those databases feel free to check my Azure SQL tutorial and Azure Cosmos DB tutorial.