Welcome to the second practical demonstration on using Google Cloud Platform services. This video will focus on using GCP storage products with the web console and the command line. We're going to do a couple of things. First, we'll just do a quick survey of the different products in the console, so you can kind of see what it looks like. Then we'll actually go ahead and create some storage. First, we'll create cloud storage buckets using the web console and the command line, and then after that, we'll go ahead and create a Cloud SQL database instance and configure it with some specific settings.

So first, let's just look around the console generally. You can see here on the left- hand side, we have the storage section. So we have BigTable, we have Datastore and Firestore, and Filestore, SQL, Spanner, Memorystore. Here in storage, this is for all of the cloud storage products, including Nearline and Coldline and the different, you know, depending on archival and access patterns. And then we have a Filestore, which is kind of the NAS version of that, a network-attached storage version of that. So this is basically where things are, you can click around a little bit and see, you know, for example, BigTable, you know, we don't have any instances running now but you can run through the Create Instance wizard to actually see what that looks like. We can do that with all of them. I mean, they're all pretty straightforward here in the console. We're not going to create everything now but we can kind of see how things look.

So let's move on. Ok, so now let's go ahead and actually create a sample bucket in Cloud Storage using the command line. Now, we're going to use the Cloud Shell. You click on this icon here in the top right to get it to work. I already have it running. Be aware, again, the first time you click on it, it might take some time to come up.

So as you recall, you have your tools already installed in this little environment that uses new gcloud command line. We should get some output there. And what we're actually going to use is gsutil, the other command line tool. And so, to create a bucket, we're gonna do gsutil make bucket and then we have to give it a URL for the bucket. We'll do gs:// we'll just call it cool-cloudacademy-bucket. And if I'm entering that command it'll go ahead and it'll create our storage bucket, and we can go into the storage UI here. Oh sorry, that's SQL, we want to go to Cloud Storage here and we should be able to see our bucket right there, cool-cloudacademy-bucket.

Now, this is one way to create a bucket. You'll see here that because we didn't add any arguments, it created a bucket with all the defaults. So by default it's multiple regions in the United States, you know, public access is per object, there's no lifecycle enable, there's a whole lot of default things here, and so what we might want to do is change some of that and to show you some of the different options you have, what I'm gonna do is use the web console and create another bucket.

So you go here, we click Create a bucket, and we're going to give it a name. We'll call it cool-cloudacademy-bucket2, and then, there's a number of options we can add. So there's some estimates here, we can put for a storage size of data retrieval, if we want to worry about that, click continue. We can decide if we want multi-region or single region. We can decide if we want to do Nearline or Coldline for longer-term archival. Access control model on how, what permissions we want to set. We're gonna stick with most of the defaults here but really just showing all the options here. We can add labels, tags, essentially. Then, when we're done we just click Create and once again, we'll see the bucket come right up.

So go to our storage dashboard and then it is: cool bucket2. And now the last thing we're gonna do is we're gonna create an actual database instance in the console using the Cloud SQL dashboard, so we go into Storage here. A lot of different options for storage as mentioned. We just click on SQL and we're gonna create an instance, there's an option here as well to migrate data. You see again one of the first choices we make is do we want to use MySQL or PostgreSQL and we'll go for this will go with MySQL as our flavor. And then, once this comes up, we have some options here. Sample, we'll just call it sample1. We can set a root password, you know something bad, don't do that. Some regions, zones, our database version, and then once we're ready, just click Create, and just like that, we will have our instance. We have a database instance ready to go. So the instance ID will come up and some other details, but it is really, really quite simple. We can do this same thing with the command line. But now you should have a general understanding of how to create storage and databases using Google Cloud using the console or the command line. So thanks for sticking around.