AZ-900 Episode 12 | Database Services | Cosmos DB, SQL Database, Db for MySQL & PostgreSQL
ฝัง
- เผยแพร่เมื่อ 27 ก.ค. 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...
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!
I practically substituted my TV programs for your channel. Best decision ever! Learning loads rapidly. Thanks man.
Haha! You rock!
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 !
O melhor curso que eu ja vi no youtube, estou impressionado com o nivel de produção 👏
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!
Adam, Thank you for all you have put in to produce this video. Your work is super
Was looking forward to this! Thanks Adam
My pleasure!
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 TH-cam.
Fantastic, thank you! :)
Thanks Adam, these videos are so easy to follow! You're the man! :)
Glad you like them!
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!
One of the best courses for Azure Fundamentals certification, thank you Adam for the videos.
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!
Thank you for help me to learning to AZ-900 as a free costs!
This playlist is super amazing 👏🏻👏🏻❤️
Very well explained Azure key services. Thanks Adam ! Your sessions are very clear
Great to hear! Thanks for watching :)
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 !!!!!
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 ;)
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!
This is the best tutorial, Thank you very much Adam :)
You are the man! Thanks for your work. I really appreciate it !
I appreciate that Filipe! Thanks for stopping by :)
Awesome video.. very easy to understand... Well structured and explained.. well done..
Absolutely magnificent...thank you very, very much!
Thanks Victor! :)
Thank you Adam. Excellent video on database services
My pleasure!
You are the best Adam!
you explain everything so easy to understand
Thank you so much for creating and sharing these videos, easy to understand. 😊😊
My pleasure!
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 :)
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!
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 TH-cam doesn't allow for updates.
Thanks for a great video!!
Always new content, Great
Glad you think so!
Its a very great course..Great clarity
Great content Adam , following ur videos
I appreciate that!
Thank you, Adam!
My pleasure!
Your videos are so awesome!
Thank you so much!
Much better than paid content . TY
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.
Excellent! 😊
Another beauty!
Great work ..very much appreciated
My pleasure!
@@AdamMarczakYT I get the exam cleared with 745... You videos helped a lot..
thank you very very very much, you help me a lot
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 Sir.
thank you. Suscribed
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.
thanks for helping me!
Happy to help!
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 :)
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.
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 :)
Thank You SIr'
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.
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).
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.
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.
hey, can i have the presentation slides you are previewing on the video please ?
that will help me a lot
Grazie!
Thank you #sir
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.
Great
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!
What app did you use to draw the schema?
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.
How come cosmos db is described as "nosql" but you can use a sql API for it?
easy to understand
great to hear, thanks
Hi Sir,
Your videos are very good
Could you please create videos on real projects
Will try :) 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.
I think there was a typo in the title :) Postgre
Ah! Fixed. Thanks.!
❤️ from India
thanks for poland! :)
Are these videos enough to give the AZ 900 exam?
Yes :)
did you only use this video , any practice test ?
dont be a menace to south central, good pick :D
Please create video for az104
👍
It is not one of the best . IT IS THE BEST !!!!!!!!!
SQL Data Warehouse is now Azure Synapse
Yes, correct, this is mentioned in a big data episode
you didn't say "stay tuned"...but i will!!!
Hehe, need to keep it fresh sometimes :) Thanks!!
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.
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.
AZURE Cosmos DB will be PAAS?
It is.
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