Azure SQL Database Tutorial | Relational databases in Azure

Azure SQL Database is one of the key data storage solution for structured data in Azure. If you need to manage structured data via schema, constraints and relationships or you need to explore your data via rich query language then this might be the right service for you.
In this episode I give you introduction to what Azure SQL Database is and what are the key reasons to use relational databases. This video also shows what are the key drivers to choose the right pricing and performance models and a demo of creation, management and connecting to Azure SQL.
Want to connect?
- Blog marczak.io/
- Twitter / marczakio
- Facebook / marczakio
- LinkedIn / adam-marczak
- Site azure4everyone.com
Next steps for you after watching the video
1. Azure SQL Database documentation
- docs.microsoft.com/en-us/azur...
- docs.microsoft.com/en-us/azur...
2. Check self-paced labs on SQL Database
- docs.microsoft.com/en-us/lear...
3. Check how to load data to SQL database using ADF
- • Azure Data Factory Tut...

[@german-engineering1963]

I am so impressed with Mr. Marczak's educational videos. His approach to training is so easy to comprehend, and so well-prepared to meet the needs of professionals from all walks of life.

[@roostermaind6413]

Hello and OMG thank you. I can't believe someone is putting this much effort into high quality educational content and is so under-rated. I will absolutely smash through your channel, sir.
HAve a great day and keep up the good work!

[@AdamMarczakYT]

That is the 'comment of the week'. Thank you so much, you are too kind. :)

[@varnanthirugnanasambandan559]

Thank you so much. Really very helpful, the first one video on this topic I saw seems the best. Thanks again.

[@marcossamuel8764]

Great material! You are very straight to the point and does not go to dead ends! Please keep teaching!

[@jokelemmon]

I've actually spent weeks trying to find a good video to help me understand. Thank you so much for your videos!

[@AdamMarczakYT]

Great to hear! 😀

[@DaveVoyles]

You consistently have the best data tutorials out there. Very professional, succinct, and clear. Nice work.

[@AdamMarczakYT]

Thank you Dave! :)

[@deshantdevkota2563]

Such a well made video, been scratching my head over evrything when started learning Azure, your way of presentation makes it easier to learn things.

[@osmiridium]

Using this to study for an azure SQL position I'm interviewing for shortly.
Excellent video, thank you!

[@tonywinter6636]

Clear and simple introduction to SQL in Azure. Thanks for your effort producing such high quality content.

[@AdamMarczakYT]

My pleasure! 😁

[@vikramnanda2833]

Amazing video for starter who learn Azure SQL. You have explained it very clearly.
Thank you Adam!

[@Leming505]

Im new to Azure and I subscribed right away to your channel because your explainations are so clear and straight to the point, thank you Adam!!

[@AdamMarczakYT]

Fantastic, thanks Steve :)

[@jimmarnell8610]

Thank you Adam! I am an experience DBA with Oracle and other products but not setting with Azure. I know that you've saved me hours of frustration with your very clear walkthrough of the steps and considerations required. Thank you again! I am now subscribed.

[@AdamMarczakYT]

Glad to help Jim! I also had my first commercial project in Oracle so I know where you are coming from :)

[@johng5295]

Thanks in a million Adam. Great content second to none. "Great teachers are to find."

[@caketanshethia8838]

Brilliantly compiled content, easy to follow and understand. Thank you so much for sharing this knowledge Adam.

[@AdamMarczakYT]

My pleasure! Thanks for stopping by :)

[@RynAmelli84]

Hey Adam, I am new to the page man. I'm so glad I found your page your explanation of SQL databases & server integration is top notch. I am new to gaining this knowledge as I've just recently gained my Azure fund/& admin certs just from a bunch of studying. However, actually working with the Azure software in real time is super valuable for my career growth. I will be subscribing asap! Thanks for what you do here it's great info!

[@SandeepKumar-jw5gy]

The quality you put in and the way you explain are awesome.

[@AdamMarczakYT]

I appreciate that!

[@sumitvkrma]

This is the best channel if anyone needs to learn azure. Feels so lucky that I came to know about this channel.
Thank you so much Adam and lots of love from India 😊
Your videos are very informative and helpful, easy to understand, helped a lot.

[@AdamMarczakYT]

Happy to help! Thank you for the kind words!

[@antoniorivera6014]

Everything works as I expected!. Thank you for your teaching

[@TitansLacrosse34]

Extremely helpful - thank you as always Adam!

[@johnpace533]

In the next 2 years this channel will reach 10 million subscribers. Good stuff man!

[@AdamMarczakYT]

Hah! I wish :) But thanks for watching and letting me know you enjoyed it, things like this make it all worth it. See you around John.

[@anithar739]

Appreciate your efforts,look forward to make use of it.Thank you.

[@vinayayinapurapu]

as simple and neat as it could be. Good intro to Azure SQL.

[@marsrover7952]

Hey Adam, great videos, one of the best channels, excellent production and content.

[@AdamMarczakYT]

Wow, thanks! :) again!

[@aamiradeeb2488]

Hey Adam, great videos, one of the best channels, excellent production and content
love from India

[@AdamMarczakYT]

Awesome, thank you!

[@nishant_thite]

Wow.. very simplistic, yet very informative! Thanks for creating n sharing this 👏🏼

[@AdamMarczakYT]

My pleasure 😊

[@subhanishaik7310]

marvelous job done by you with incredible talent..i learnt alot with this 28mins video....always rocks

[@anaisbiolley5639]

Really great video! Outstanding quality educational content! Congrats to Adam.

[@AdamMarczakYT]

Much appreciated!

[@HarderStylesOfCanada]

Thanks for the excellent overview bro!

[@krishansharma2469]

Wonderful explanation!! Please share more related advanced exam preparation q/a videos. Thanks.

[@rashmisamanta9932]

Very Simple and Clear Tutorial for Azure SQL Database. really appreciated

[@AdamMarczakYT]

Glad it was helpful! :)

[@TheSuperStarO]

Keep up the good content! Subscribed.

[@petrodyak]

Thanks, Adam for the really good videos about Azure!
It helped me at the beginning of the path of learning Azure. As a result, I had passed an exam AZ-900.

[@AdamMarczakYT]

Fantastic! Great job my friend 🙂 👊 what next goal do you have on your Azure journey?

[@petrodyak]

@@AdamMarczakYT I want to pass exam DP-200.
Is it a harder exam then AZ-900?

[@AdamMarczakYT]

Well definitely DP-200 because is specialized. AZ-900 is just introductionary.

[@priyankaduggal]

@@AdamMarczakYT Hey Adam.Thanks for the simple to understand videos.It compels me to watch your videos in my free time rather than spending time on docial media😀.Do you have any videos for DP 200?

[@Eddietechpromos]

Bro your tutorial is super cool i swear

[@harishmathanan3596]

Clear and concise, thank you Adam.

[@AdamMarczakYT]

Glad you think so!

[@NIYANTAjmp]

Very deep illustration of concept.
Thank you

[@AdamMarczakYT]

Glad you liked it!

[@mohammadhoque51]

Thank you so much for such a wonderful video. I have watched many videos but after watching yours, I realized that just wasted times watching those.

[@AdamMarczakYT]

Thanks! This is so nice to hear :)

[@skdogra2010]

excellent demo ...covered all basic thing beautifully....thanks and keep posting

[@AdamMarczakYT]

Thank you, I will :)

[@VIJAYPATEL-qm8zk]

Thank you Adam. you have posted such a quality tutorial.

[@AdamMarczakYT]

Glad it was helpful!

[@mcopat]

Excelent video.
Thanks for helped me to make my first SQL in Azure

[@AdamMarczakYT]

Great to hear!

[@akshat8trivedi]

Amazing content Adam. "Home" to Azure learning.😉
Keep going

[@AdamMarczakYT]

Thanks! 😃

[@yashpatel9550]

Thank you so much adam....you are amazing.....been trying to connect with my django app......finally its done....

[@AdamMarczakYT]

It's always a great pleasure to connect new technologies for see them run together. Good luck on your project, it sounds interesting! Thanks for watching!

[@lodoss118]

Amazing content, very easy to understand, great instructor

[@AdamMarczakYT]

Much appreciated!

[@shivprasadgurjar487]

Very good Adam, nice explanation!

[@AdamMarczakYT]

Thanks! 😃

[@robinjhunter]

Great video. Really clear. Thank you very much

[@AArora81]

Really effective! Thanks for sharing the knowledge. 'big fan of your channel.

[@AdamMarczakYT]

Much appreciated!

[@CyberPro-arun]

I am a MCT certified trainer and trained around the globe for Microsoft technology and honestly I took screenshots from your videos to discuss topics in my session as some time MS Official PPTs are not enough to teach students. Thanks Brother Adam..... as a Trainer I give my Salute to you for amazing explanation and most valuable is your slow pitch otherwise I seen most of people speak too fast... good luck for future

[@AdamMarczakYT]

Thanks Arun. Please note that my materials are free and they should not be used for commercial paid training without attribution and copyright notice including branding logo. Thanks for stopping by!

[@raspberrypops9025]

Thank you! I learned a lot from this video! I wish I had watched this before my technical interview. Maybe I could have given a better answer to the questions thrown at me

[@manojjoshi1102]

Great job...!! Excellent explanation.

[@AdamMarczakYT]

Glad it was helpful!

[@niloo195]

Thanks alot Adam! That was really helpful.

[@AdamMarczakYT]

Glad it was helpful! Thanks :)

[@danielguillermopericosanch9103]

Amazing video bro, I come from AWS and I'm starting loving Azure.

[@AdamMarczakYT]

Thanks and welcome aboard!

[@alexanderzharkov6953]

Very informative. My gratitude

[@simbakali]

Best of the best. Thank you sir.

[@AHMEDALDAFAAE1]

Thank you Adam. It is a wonderful video

[@AdamMarczakYT]

Glad you liked it!

[@citizenearth3324]

Simply Awesome . Great and high skill effort. Thanks much

[@AdamMarczakYT]

You are most welcome

[@kochetovalex]

Hello Adam,
Thank a lot for the content!

[@AdamMarczakYT]

My pleasure!

[@karlduckett]

Great video! Thanks for creating this guide!

[@karlduckett]

Are these database considered secure from the outset- without having to do anything else to ensure the data is safe?

[@AdamMarczakYT]

Thank you Karl :)

[@AdamMarczakYT]

It actually depends on the security requirements. Some will have to be set up but a lot including encryption and firewall are set by default.
Read more here: docs.microsoft.com/en-us/azure/sql-database/sql-database-security-overview

[@Faisal.Software]

Thanks for sharing, really helped a lot and wishing you all the best ~~~

[@AdamMarczakYT]

Thank you! You too!

[@DataCafe4u]

Precisely explained 👌

[@chrismcclure4264]

Fantastic video. Never stop creating content. You're doing god's work

[@AdamMarczakYT]

Thanks Chris for the kind words! Appreciated!

[@premandonis9129]

Brilliant, the content is so very useful, keep it up.

[@AdamMarczakYT]

Thanks, will do!

[@Cmart6444]

Awesome video, I really liked it alot

[@bigfarmerUK]

Thanks Adam. Very useful & clear explanation & good hands-on examples. Like your style!!
BTW, you can register servers in SQL Server Management Studio (SSMS) which will save server connection & login details.

[@AdamMarczakYT]

Yea, I forgot to mention that. But I think they still prompt you to log in when you close SSMS when using Azure AD integrated with MFA option. But I love that It also nicely integrates with data studio recently :) Thank you :)

[@bigfarmerUK]

@@AdamMarczakYT Your video was very helpful in my study for DP-900 Azure Data Fundamentals study. Just passed exam today. Thanks again 👍

[@jactoneondidha4696]

Precise explanation. Thank you

[@AdamMarczakYT]

Glad it was helpful!

[@anilbabu5500]

Simply amazing, thank you so much. Would be great if you can make a video on Azure data studio

[@AdamMarczakYT]

Great suggestion! I added it to the list of potential topics for future.

[@mohammedshetaya3590]

more than excellent this actually helped me

[@AdamMarczakYT]

Glad to hear that :)

[@lifelession8693]

Excellent content!

[@tejasbhatt1820]

Amazing ... Just what I wanted

[@benyang6546]

so touching for an excellent video

[@mahalivikram4758]

Great vedio...! Thank you so much Adam...

[@AdamMarczakYT]

Thank you! :)

[@shobhanganta8578]

Very Informative for beginners

[@AdamMarczakYT]

Glad you think so!

[@MrKlhot]

Thanks for the tutorials , Wonderful presentation.If possible can you show how to create users and setting permissions for different groups like on premises

[@AdamMarczakYT]

You should check this. It explains the process pretty nicely docs.microsoft.com/en-us/azure/azure-sql/database/logins-create-manage

[@vlad_w47fk19]

Verry good explanations ,keep up the good work.

[@Sergio-td7mn]

As always, great video!

[@AdamMarczakYT]

Thanks again!

[@mohanedabdulle299]

Thanks sir, you make my study easy.
Many thnks

[@AdamMarczakYT]

It's my pleasure

[@dinamik967]

Now I know something how to use SQL. Thanks

[@arulmouzhiezhilarasan8518]

Good video with great content Adam! I was having some doubt reg when to use single/managed instance,elastic pools, server-less, dtu/vcore based etc before., by seeing this video, i can understand those now theoretically. Can you show 1 real scenario practically by creating databases under each of those options to differentiate between scenarios when to use which option. Viewers Request!

[@AdamMarczakYT]

Glad it was helpful! Added your idea to the list of potential topics. Thanks!

[@100xloading]

Awesome video Adam, thanks :)

[@AdamMarczakYT]

My pleasure!

[@ganeshprasad6600]

Thanks Adam, Great job

[@AdamMarczakYT]

Thanks!

[@johnyleandromaringutierrez8708]

Thank you high quality content!!!

[@kenjia.busybee8192]

Hi Adam,
thank you for the video. I was being able to follow thru.
Here is my only constructive advice:
when you picked the Active directory user, I was kind of lost since I didn't create one.
At the point, if you point out to follow your AD video, that would be easier for get that setup.
Your videos would help me to speed up my Azure learning
again thank you
Kenji

[@samcityplus]

Adam just rekindle my hope

[@tabindahayat3492]

Hey Adam! The content is amazingly awesome! Very effectively compiled and narrated! ❤️❤️❤️ Also, I wanted to ask that what if I create a SQL database in Azure VM? May I achieve this with sql in azure Vm?

[@AdamMarczakYT]

There is an option Azure SQL on VM, you can use that. But the question is, why? :)

[@sau002]

Very detailed. Thank you.

[@AdamMarczakYT]

Thanks :)

[@jemschaudhary5922]

Great Video! Thanks :)

[@MicahJohns]

Thanks so much for making this video

[@AdamMarczakYT]

No problem 😊

[@dianaa4804]

Thank you so much for this!!! :)

[@AdamMarczakYT]

You're so welcome!

[@richardtermaat47]

Another great video!

[@AdamMarczakYT]

Thanks a bunch! :)

[@Meyssam.Molaye]

Thank you Adam

[@user-pp6tv9jh6g]

thank you Adam!

[@vktop2]

Nice video well explained, I have a question, can I make a backup of an Elastic pool database from Azure data studio?

[@sickandarnavab4891]

Very nice and easy to learn.
]

[@AdamMarczakYT]

Glad you think so!

[@krissloan6563]

Great content as usual! Will you do an AZ-104 course?

[@shivanisrivastava4752]

Hi Adam, I recently started following you and already love the way you explain things, clearly displays that you have deep knowledge ! I was wondering if you have made a detailed video on Azure Data Studio for if you have could you please provide the link here please, thanks :)

[@AdamMarczakYT]

Awesome, thank you! Data Studio is surely interesting topic so I might cover that in future. It's still pretty new tool so there isn't that much to make a full tutorial on it. :)

[@yeabmyy]

Unbelievable!! 🙏

[@atmakuripullarao782]

it is really good and please add failover scenario as well

[@AdamMarczakYT]

Good idea, I'll might do a video on that in the future ;)

[@Adam-gp3ij]

Best Tutorial ever! Thank you

[@AdamMarczakYT]

Glad you liked it! Thanks!

[@murthyrvs4683]

Hi Adam , As I say everytime your videos on azure are to the next level ..thanks a lot for the wonderful knowledge you are helping us with.
I have one question , Can you please let me know the difference between vcore and dtu in azure.. May be am looking at a real time simple scenario which can give me a complete picture.

[@AdamMarczakYT]

hey Murthy, Thanks! DTU is old pricing model, a lot of clients didn't like that they couldn't specify amount of virtual cores. Also in vCore you can scale storage independently of compute power, which in case of DTU you paid for certain allocated storage and if you needed more storage you needed to upgrade DTU. New vCore machines also have more powerful tiers.

[@manojbhatia9433]

Once again....A Big Thank you..

[@AdamMarczakYT]

My pleasure!

[@chkn2007v]

Amazing..Thank you!!

[@AdamMarczakYT]

Glad you liked it!

[@27sosite73]

good!
thank you!

[@WoahNowAreYouOkay]

Thanks for the video. I am confused though about the user account switches. So in Azure Data Studio I should never use the login I made when setting up the server? Why? I also can't figure out how to add another account as an active directory admin, and I am confused as to why I have to do that. It seems to function fine when I use the initial login info. Any info would be greatly appreciated.