AZ-900 Episode 12 | Database Services | Cosmos DB, SQL Database, Db for MySQL & PostgreSQL
HTML-код
- Опубликовано: 15 май 2024
- 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 
Наука
One of the best courses I've ever watched on the internet and it's completely free. So happy for having found it.
Glad to hear that, happy to help out!
Couldn’t agree more!
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.
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...
This is the best Azure tutorial that I have found. At the right level of detail for me as a PM.
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 !
I practically substituted my TV programs for your channel. Best decision ever! Learning loads rapidly. Thanks man.
Haha! You rock!
One of the best courses for Azure Fundamentals certification, thank you Adam for the videos.
Adam, Thank you for all you have put in to produce this video. Your work is super
Don't feel sleepy anymore while studying.. Wait Am i studying ??? Great videos.Thanks to you.
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!
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! :)
Thanks William! :D appreciated!
O melhor curso que eu ja vi no youtube, estou impressionado com o nivel de produção 👏
This playlist is super amazing 👏🏻👏🏻❤️
Was looking forward to this! Thanks Adam
My pleasure!
confused who gives 2 dislikes to this video. it is perfectly explained. well done Adam.
Hehe, me too! Thanks!
@@AdamMarczakYT We expect more course on Azure like Terraform, Azure architecture, DevOps.
@@AdamMarczakYT Amazon ;)
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 !!
Great job! Keep it up mate!
Thanks Adam, these videos are so easy to follow! You're the man! :)
Glad you like them!
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 RUclips.
Fantastic, thank you! :)
This is the best tutorial, Thank you very much Adam :)
Best Place to learn. All my azure learnings are from your videos. Thanks a lot.
Thanks! :) Glad to hear that :)
Hey Adam, thanks for putting this content together and making it available for free.
My pleasure!
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 !!!!!
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
Awesome! Stay tuned for more!
From September 15 onwards there is a new study guide . Would you mind covering those?
Love your video short, and easy to pick up the concepts quickly
Great to hear!
Very well explained Azure key services. Thanks Adam ! Your sessions are very clear
Great to hear! Thanks for watching :)
Awesome video.. very easy to understand... Well structured and explained.. well done..
You are the man! Thanks for your work. I really appreciate it !
I appreciate that Filipe! Thanks for stopping by :)
Thank you Adam. Excellent video on database services
My pleasure!
Absolutely magnificent...thank you very, very much!
Thanks Victor! :)
you explain everything so easy to understand
You are the best Adam!
Thank you so much for creating and sharing these videos, easy to understand. 😊😊
My pleasure!
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
Yep, thanks, this is covered in later episodes and mentioned several times throughout the series :) Unfortunately RUclips doesn't allow for updates.
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
Thanks a lot!
Thanks a lot... very clear, short and brief. Hope I would pass the exam easily
You've got this! 👊 I cover in my videos more than exam requires :)
Thanks for a great video!!
Always new content, Great
Glad you think so!
Thank you, Adam!
My pleasure!
Thank you Sir.
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.
Great content Adam , following ur videos
I appreciate that!
Its a very great course..Great clarity
Much better than paid content . TY
Great work ..very much appreciated
My pleasure!
@@AdamMarczakYT I get the exam cleared with 745... You videos helped a lot..
Another beauty!
Excellent! 😊
Your videos are so awesome!
Thank you so much!
thank you. Suscribed
Excellent online course. Better than paid course
Good job Adam. Thanks
My pleasure!
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.
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?
Database service is used for structured data.
Thanks Adam .❤️
My pleasure! Thanks :)
thank you very very very much, you help me a lot
Grazie!
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?
Thank you! If you want to learn more check all of the linked study materials :)
Thank You SIr'
thanks for helping me!
Happy to help!
Thank you #sir
demo demo demo :) amazing way of learning
Yea, demos help, it's even better if you practice. But for az-900 there is no need.
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 ❤️
Good luck on the exam :) Thanks for stopping by.
Don't kid with me anymore kid.
Hello Adam, that's amazing session. I want to know which software u use for presentation for every session?
Thanks! It's just powerpoint :)
hey, can i have the presentation slides you are previewing on the video please ?
that will help me a lot
Good quality as always, I'm guessing the next video will be released on Monday?
Next one is quite small. Azure Marketplace so I will try to get it by Thursday/Friday this week. Stay tuned.
Your videos are so clear!!!...Do you have also videos for other Azure Exams ?
Thanks Alessandro! Not yet, this one is my first to 'test out the waters' :)
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.
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
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).
would you consider creating a course for AZ-104 also?
I'll definitely think about it :)
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.
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!
@@AdamMarczakYT Sent you some via paypal!
@@funkymunky8787 Thank you! I appreciate it! God bless.
Great
What app did you use to draw the schema?
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.
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.
Azure Dataware house has been changed to synapses analytics services if I'm not wrong.
Azure Data Warehouse is now an SQL Pool used inside of Synapse Analytics, correct!
Hi Sir,
Your videos are very good
Could you please create videos on real projects
Will try :) thanks
easy to understand
great to hear, thanks
when will the new videos be available? I`m looking forward to this
Holiday season is done so more videos are coming soon! :) I should release more frequently now.
How come cosmos db is described as "nosql" but you can use a sql API for it?
How can I find pricing on querying those databases though?
Later in the service I cover Azure Pricing Calculator, you can just google for it, otherwise Azure has detailed pricing pages for each.
👍
❤️ from India
thanks for poland! :)
I think there was a typo in the title :) Postgre
Ah! Fixed. Thanks.!
Are these videos enough to give the AZ 900 exam?
Yes :)
Please create video for az104
dont be a menace to south central, good pick :D
It is not one of the best . IT IS THE BEST !!!!!!!!!
did you only use this video , any practice test ?
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?
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.
you didn't say "stay tuned"...but i will!!!
Hehe, need to keep it fresh sometimes :) Thanks!!
AZURE Cosmos DB will be PAAS?
It is.
SQL Data Warehouse is now Azure Synapse
Yes, correct, this is mentioned in a big data episode
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
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.
Me watching that Adam shows the IP from home 👁👄👁
to pass az900 exam do we really need to practice all the practical of creatinng vm and sql data base n all