Creating a Microsoft Azure SQL Database (SQL Server in the Cloud)

hello i'm philip burton of sqlserver101.com in this video which is taken from my new dp900 course we will be creating an azure account and then installing azure sql database with sample data on the cloud so for more information about my dp900 course please have a look at the description at the bottom of this video and now please enjoy so now let's get our free account and you can see an ad at the top azir.microsoft.com account free though you could just google it as your free credit and see what you get as well so let's click on that and you can see we have a start for free quite enticing button at the top so what is it you get you get 12 months of certain services 200 to be used in the first 30 days and 25 or more services which are always free and you can see what services are free for instance a virtual machine can be free for 750 hours so what's that that's about a month so free each month for 12 months however bear in mind that's not necessarily the same as storage so you'll find that there is i think storage down here but very minimal if there is but you also notice sql databases free for 250 gigabytes now there's a storage five gigabytes of file storage and five gigabytes or something that's called blob storage so we'll have a look at what those are as part of this course so it's worth getting now i should point out that if you go over any limits you will have to pay and unfortunately i can't be held responsible for any expenses that you have but i will be showing how to pause certain resources so when you pause it it doesn't necessarily cost you any money so i'm going to click start for free and you can see we're now at the sign up page so first of all i need to enter some details so there's a bit of waiting and you'll find this to be quite often a thing that happens unfortunately with microsoft azure there will be a fair bit of waiting now you don't actually have to do for this certification anything practical in microsoft azure you just need to learn about it however i do find that it's actually quite good to actually do and then you've got a better visual memory of what each of these particular services are so you can see it's inviting me to take an identity verification by card so yes and there's agreement yes i do want to agree to the subscription agreement offer details privacy statement worth reading i don't want microsoft to share my information with select partners though though it is interesting to get information about azure so i'll sign up so confirming your information so i'm just going to say not sure for my intended use and click submit there are feedback sent so we're now setting up the account and as i say it does take a bit of a while to do some things like setting up virtual machines setting up cosmos db databases and so forth but eventually you will get into the microsoft azure account and this is the quick start center so you could have a look at each of these if you want to find out how to create a web account deploy virtual machines set up a database and so forth however i'm going to actually ignore all of this and indeed there is another section take an online course so this is good but it's probably not focused for what we're doing in dp-900 i'll show you near the end of this course something by microsoft which is a lot more focused instead i'm going to click on this home button and this is where i will generally start each of these practical videos so as i say you don't actually have to do any of these practical things to get the certification but it probably helps if you know what's happening and i'm also generally going to expand this menu as well so you can see we can quickly get access to things like sql databases azure cosmos databases and other things so let's just take a quick look around microsoft azure so as i say this is a quick way of getting to common places like for instance cost management and billing so if you avoid how much things are going to cost well don't worry you've got information there you can click on all services so you're not just restricted to the little bits that you see so if i wanted to go to storage or databases they're all clickable there alternatively i could just click at the top and search for a particular resource so maybe i'm looking for an azure sql database and you can see it's now suggesting sql databases as a suggestion over here we have got a command line interface we'll use that later but very briefly the shell is not much used in the certification but you will require to know things about it over here we have got your directory and subscription so just information about what you want currently we're on the free trial then we've got notifications so what is currently happening so anything that happens if you set up anything you'll get a notification that is being set up and then it has been set up we have got various settings so where do you want to be is probably the biggest setting so do you want to start at home which i generally do or do you want to start on your own created dashboard so these are little elements that you pin to a dashboard what theme do you want that could be quite useful if for instance you need a dark theme or a high contrast theme question mark this gives you various helps and then let us know how you are getting gone and then right at the end we have your sign out button so this is a quick look around azure and in the next video we're going to start using azure we're going to install a new database with some sample data in this video we're going to create our very first service and this being the dp900 course we're going to create an azure sql database so i'm at the home tab which i've blown up quite a bit so everybody can see it if you're using a mobile device for instance and i'm going to go to sql databases now i could just click at the top in the search engine here and type in sql databases or i could click on this left hand side and click on sql databases so however you do let's go to sql databases and you can see we've got create sql database we've got add when we went at the beginning here if i hover over it you can see that there is a create button there as well lots of training now i'm not at this stage actually going to get involved with what an actual sql database is we're just going to create it and then use it and go from there so i'm going to click on add button here so we're in home sql databases so you can see the chain that we've got at the top it's called breadcrumbs so it shows where you are i've gone from home to sql databases and i can go back they're all hyperlinked so if i click on them they'll take me back a stage so i'm going to add a new sql database first of all we have to select your subscription while we only have the one subscription the free trial in this particular case and we also need a resource group so resource group is where all of the resources are going to go in this case the sql database and maybe some networking and storage as well now i don't have any resource group already set up so i'm going to create a new one so a good thing about resource groups as well is you could get rid of the entire resource group and that gets rid of all of the resources so even though we're going to be creating lots of different things in connection with an sql database if they're in a resource group and i get rid of the resource group i get rid of the escrow database and everything that it relies on so i'm going to call this sql database as my resource group click ok so you can see now new sql database now the database requires a name so can i call the database a and you can see that actually could work the database must not match special patterns so you can't probably call it database it's got to be up to 128 characters it can't return contain reserved words and no database with the same name exists on the server so we need a server so we're going to create that first so click on create new server so here we have our server name now the server name needs to be unique among the entirety of all sql servers so i can't just call it for instance server somebody will already have got that so i'm going to call this test sql database see if that's taken dp900 that won't be taken hopefully there we go so you can see that the server name test sql database dp900.database.windows.net that's what i can use to interact with it later so i need a admin login so i'm going to have my login as dp900 so you can see can't use things like admin administrator sa which is systems admin and so forth so i'm going to need a password and you can see it must be minimum of eight characters got to have three levels of the complexity so uppercase letters lowercase letters numbers and non-alphameric symbols so there we go that should be okay except i've used dp900 so let's just try this again hopefully that should be okay confirm the password and then a region so azir is all over the planet so i'm going to go for my local region which is uk south there's also uk west as well if i remember but i'll go for the self and click okay so i'm going to note down these details because i'll probably need it in the future so there's my server so now i can create a database and because it's got to be unique in the server it could be anything so i'm going to call it dp900 we'll have a look at elastic pools later we'll just say yes to the standard compute and storage now there's various tabs at the top and if i click on next i'll take me to the next tab networking i'm not going to do anything with it at the moment so choosing no access gives you defaults but i'm going to change them later additional settings i want to use some sample data so adventure works lt the lite version is going to be installed and click next tags i'll just ignore and then review and create so you can see the estimated cost about 14 pounds that's about 18 19 and you can see everything that i selected and click create so now we can see deployment is in progress so it is now actually creating it it's going to possibly take a few minutes so i'm just going to pause the video until it's done and while it's doing you'll notice there's a little line underneath the notifications and i can always click on the notifications to find out what's happening right so after a couple of minutes you can see deployment succeeded i can now go to the resource i can also pin it to the dashboard so i can create a dashboard which has got little elements from say a database or other things so i'll go click on go to resource here's my resource i am now going to use the query editor on the left hand side to write a query so you can see on the left hand side we've got various different options and tasks we can do so i'm going to click on the query editor so i need to log in with my password which i have previously created you can also use active directory authentication you can see there is a problem with a firewall we'll have a look at firewall problems as part of this course so i'm going to go into the firewall settings and i'm going to add my own internet protocol address in other words me so this is me i've clicked it twice accidentally so let's delete and then i'll save updating firewall rules successfully are done so now i can go back to the home i can go to my resource go back to query editor log in and we can see various tables views and stored procedures here and i am going to go select star from sales ot address run the query and there is the data now it's not just in microsoft azure online that i can use this i can also go to an external program such as sql server management studio ssms so i can type in my server name that i copied earlier my login and password details go to this particular database dp900 and say select star from a table and you can see now i have downloaded information that's on the cloud onto my own computer without actually using a browser but using a different client and i could do exactly the same thing in excel visual studio and other applications so in this video what we have done we've gone to microsoft azure we have created an sql database also known as an azure sql database we've given it sample data we have allowed our own ip address as part of the firewall we've given it username password and we have run a select statement so there's a lot of things here in this this one video that we've got to look at at various levels for some of you you'll know what a database is you'll know that it contains tables views and stored procedures you know how to create a select statement for others this might be the first time that you've actually got some potential hands-on experience with creating a database so i'm going to start from the very beginning now we've reached this stage so we've done a lot of running we've created this in pretty fast time now let's take this much more slowly and we'll start with the select statement well thank you very much for watching this video in my dp900 course i'll be going into much greater depth i will be describing query techniques for data using sql language i'll be looking at relational data workloads sql server and other azure relational databases before going on to semi-structured data for instance the cosmos db apis non-relational data offerings and much much more and at the end of the course with a little bit of practice and maybe going to the official measureup.com practice exam you could go for the official microsoft dp900 certification wouldn't that look good on your cv or resume well i hope you enjoyed this video if you did why not like it and then why not subscribe and click that bell that way you'll be informed of any new videos thank you for watching this and i'll see you in the next video you

Channel: SQL Server 101

Views: 11,022

Keywords: SQL Server, SQL Server Express, SQL Server 2019, Install SQL Server, Download SQL Server, Download SSMS, sql server installation, how to install sql, sql, install sql server 2019, install ssms, install microsoft sql, microsoft sql server, install t-sql, cloud sql, azure sql, sql azure, how to install sql on azure, dp-900, dp-900 certification, dp-900 exam, sql on the cloud, azure data, azure data fundamentals

Id: kMCNTLnna04

Length: 17min 35sec (1055 seconds)

Published: Wed Dec 30 2020