AZ-900 Episode 12 | Database Services | Cosmos DB, SQL Database, Db for MySQL & PostgreSQL
VloĆŸit
- Äas pĆidĂĄn 31. 05. 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 - VÄda a technologie
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...
I practically substituted my TV programs for your channel. Best decision ever! Learning loads rapidly. Thanks man.
Haha! You rock!
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 !
This is the best Azure tutorial that I have found. At the right level of detail for me as a PM.
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!
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!
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!
O melhor curso que eu ja vi no youtube, estou impressionado com o nivel de produção đ
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
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 ;)
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 CZcams.
Fantastic, thank you! :)
Best Place to learn. All my azure learnings are from your videos. Thanks a lot.
Thanks! :) Glad to hear that :)
Was looking forward to this! Thanks Adam
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!
This playlist is super amazing đđ»đđ»â€ïž
Hey Adam, thanks for putting this content together and making it available for free.
My pleasure!
Very well explained Azure key services. Thanks Adam ! Your sessions are very clear
Great to hear! Thanks for watching :)
This is the best tutorial, Thank you very much Adam :)
Thank you Adam. Excellent video on database services
My pleasure!
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 :)
Absolutely magnificent...thank you very, very much!
Thanks Victor! :)
you explain everything so easy to understand
Thank you so much for creating and sharing these videos, easy to understand. đđ
My pleasure!
You are the best Adam!
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 :)
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 CZcams doesn't allow for updates.
Thanks for a great video!!
Its a very great course..Great clarity
Excellent online course. Better than paid course
Thank you Sir.
Thank you, Adam!
My pleasure!
Your videos are so awesome!
Thank you so much!
Always new content, Great
Glad you think so!
Much better than paid content . TY
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! đ
Great content Adam , following ur videos
I appreciate that!
hey, can i have the presentation slides you are previewing on the video please ?
that will help me a lot
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.
What app did you use to draw the schema?
Great work ..very much appreciated
My pleasure!
@@AdamMarczakYT I get the exam cleared with 745... You videos helped a lot..
Another beauty!
thank you very very very much, you help me a lot
Good job Adam. Thanks
My pleasure!
Thanks Adam .â€ïž
My pleasure! Thanks :)
thank you. Suscribed
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.
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.
Grazie!
Hello Adam, that's amazing session. I want to know which software u use for presentation for every session?
Thanks! It's just powerpoint :)
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 :)
Great
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).
How come cosmos db is described as "nosql" but you can use a sql API for it?
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.
would you consider creating a course for AZ-104 also?
I'll definitely think about 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.
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.
easy to understand
great to hear, thanks
did you only use this video , any practice test ?
â€ïž from India
thanks for poland! :)
đ
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
It is not one of the best . IT IS THE BEST !!!!!!!!!
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.
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.
Are these videos enough to give the AZ 900 exam?
Yes :)
I think there was a typo in the title :) Postgre
Ah! Fixed. Thanks.!
dont be a menace to south central, good pick :D
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.
Please create video for az104
you didn't say "stay tuned"...but i will!!!
Hehe, need to keep it fresh sometimes :) Thanks!!
SQL Data Warehouse is now Azure Synapse
Yes, correct, this is mentioned in a big data episode
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