Demonstration: Getting Started with Cloud Storage and Cloud SQL - Storage in the Cloud | Coursera

For EnterpriseFor Students

Browse
Top Courses
Log In
Join for Free

Demonstration: Getting Started with Cloud Storage and Cloud SQL

Loading...

Google Cloud Platform Fundamentals: Core Infrastructure

4.7 (34,157 ratings) | 400K Students Enrolled

Course 1 of 5 in the SRE and DevOps Engineer with Google Cloud Specialization

Enroll for Free

This course introduces you to important concepts and terminology for working with Google Cloud Platform (GCP). You learn about, and compare, many of the computing and storage services available in Google Cloud Platform, including Google App Engine, Google Compute Engine, Google Kubernetes Engine, Google Cloud Storage, Google Cloud SQL, and BigQuery. You learn about important resource and policy management tools, such as the Google Cloud Resource Manager hierarchy and Google Cloud Identity and Access Management. Hands-on labs give you foundational skills for working with GCP. Note: •Google services are currently unavailable in China. New! CERTIFICATE COMPLETION CHALLENGE to unlock benefits from Coursera and Google Cloud Enroll and complete Cloud Engineering with Google Cloud or Cloud Architecture with Google Cloud Professional Certificate or Data Engineering with Google Cloud Professional Certificate before November 8, 2020 to receive the following benefits; => Google Cloud t-shirt, for the first 1,000 eligible learners to complete. While supplies last. > Exclusive access to Big => Interview ($950 value) and career coaching => 30 days free access to Qwiklabs ($50 value) to earn Google Cloud recognized skill badges by completing challenge quests

Skills You'll Learn

Google Compute Engine, Google App Engine (GAE), Google Cloud Platform, Cloud Computing

Reviews

4.7 (34,157 ratings)

5 stars
76.29%
4 stars
20.67%
3 stars
2.38%
2 stars
0.33%
1 star
0.30%

GF

Jan 29, 2017

Great course to introduce the specialization. It could be more robust, but it does the job and you are also provided with links for documents that will help you build on what you learn in the course.

EH

Jul 26, 2019

I really think this is a good way to get people that hasn't had interaction with GCP before on track, but it also is of really good use for regular users to discover more capabilities of the platform

From the lesson

Storage in the Cloud

Every application needs to store data. Different applications and workloads require different storage and database solutions. This module describes and differentiates among GCP's core storage options: Cloud Storage, Cloud SQL, Cloud Spanner, Cloud Datastore, and Google Bigtable.

Demonstration: Getting Started with Cloud Storage and Cloud SQL10:34

Taught By

Google Cloud Training

Try the Course for Free

Transcript

First we create a web server. In the GCP Console's Products and Services menu, I scroll down to Compute Engine, and choose VM instances. I'll create an instance. I'll name the instance: bloghost. And I'll leave it in the offered zone us-central1-a. I'll take the other defaults. And I'll configure the firewall to allow HTTP traffic in. I also want to add a startup script. This startup script will install a web server. I click Create, and the Virtual Machine instance is created for me. Notice its external IP address. We'll need that later. Now I'm going to make a Cloud Storage bucket using Cloud Shell. I enter the command: gsutil mb -l then I name the location in which I want the bucket to reside. In this case, the US Multi-Region. The name of my Cloud Storage bucket must be globally unique, and the easiest way to make sure of this is to name the bucket after my GCP Project ID, which is also globally unique. In the Cloud Shell, the environment variable $DEVSHELL_PROJECT_ID always contains my project ID. Now I've created my bucket. I'm going to copy a graphical image from another Cloud Storage bucket, this one called: cloud-training. Now I have the graphical image here in my directory, my-excellent-blog.png. Now I use the gsutil cp command again to upload it to my own Cloud Storage bucket. I can see the resulting file, both from the command line using: gsutil ls... ...and also from the GCP Console's Storage Browser. There's my bucket, and there's the object I created in the bucket. Recall that my VM instance is in zone us-central1-a. Now we'll create a Cloud SQL instance in the same zone. In the Products and Services menu, we scroll down to SQL. We choose MySQL for our database engine, Second Generation. We name our instance "blog-db" and we define a root password. We'll place this instance in the same zone as our Compute instance. When the database instance has been made, we click on its name to configure it. With my database instance finished provisioning, I can click on its name to configure it. I want to create a MySQL username called: blogdbuser. I'll define a password. Now I want to configure this database instance so that it can be only contacted from my Virtual Machine instance. So I need to go back to its entry in the VM instance's listing and capture its public IP address. There it is. We'll copy it. We return to our SQL instance, click on our instance name, and click Authorization. We wish to authorize a network consisting only of the desired VM instance. We'll name the network: web front end and insert the IP address of that instance followed by /32. Now our database instance is protected from broad internet access. Now I'm going to return to my Virtual Machine and configure it to use the resources we've set up. I'll log into it using SSH. I'm going to edit its PHP homepage. I've prepared a page that I can paste in. I'll fill in my database's IP address and password. Notice the comment. In a real blog, we would never store the MySQL password anywhere in the document root. Instead, we would store it in a separate configuration file somewhere else in the web server Virtual Machine. Now let's try it. We'll restart the web server daemon. Now we'll return to the GCP Console's VM instances list and attempt to view the homepage. Our database connection succeeded. If this were a real blog, we would now begin to load blog content into our SQL database. Now let's enhance our homepage by adding our graphical image to it. In the GCP Console, we'll navigate to the Storage Browser and create a public link to our graphical image. There's the image. We check the box: Share publicly. That gives us a hyperlink that we can clone. Now we return to our PHP homepage and add in an HTML reference to that image. Now let's return to our PHP homepage and refresh it. Our page now contains an image hosted in Google Cloud Storage.

Explore our Catalog

Join for free and get personalized recommendations, updates and offers.

Top Online Courses

Finding Purpose & Meaning in Life
Understanding Medical Research
Japanese for Beginners
Introduction to Cloud Computing
Foundations of Mindfulness
Fundamentals of Finance
Machine Learning
Machine Learning Using Sas Viya
The Science of Well Being
Covid-19 Contact Tracing
AI for Everyone
Financial Markets
Introduction to Psychology
Getting Started with AWS
International Marketing
C++
Predictive Analytics & Data Mining
UCSD Learning How to Learn
Michigan Programming for Everybody
JHU R Programming
Google CBRS CPI Training

Top Online Specializations

Natural Language Processing (NLP)
AI for Medicine
Good with Words: Writing & Editing
Infections Disease Modeling
The Pronounciation of American English
Software Testing Automation
Deep Learning
Python for Everybody
Data Science
Business Foundations
Excel Skills for Business
Data Science with Python
Finance for Everyone
Communication Skills for Engineers
Sales Training
Career Brand Management
Wharton Business Analytics
Penn Positive Psychology
Washington Machine Learning
CalArts Graphic Design

Online Certificates

Professional Certificates
MasterTrack Certificates
Google IT Support
IBM Data Science
Google Cloud Data Engineering
IBM Applied AI
Google Cloud Architecture
IBM Cybersecurity Analyst
Google IT Automation with Python
IBM z/OS Mainframe Practitioner
UCI Applied Project Management
Instructional Design Certificate
Construction Engineering and Management Certificate
Big Data Certificate
Machine Learning for Analytics Certificate
Innovation Management & Entrepreneurship Certificate
Sustainabaility and Development Certificate
Social Work Certificate
AI and Machine Learning Certificate
Spatial Data Analysis and Visualization Certificate

Online Degree Programs

Computer Science Degrees
Business Degrees
Public Health Degrees
Data Science Degrees
Bachelor's Degrees
Bachelor of Computer Science
MS Electrical Engineering
Bachelor Completion Degree
MS Management
MS Computer Science
MPH
Accounting Master's Degree
MCIT
MBA Online
Master of Applied Data Science
Global MBA
Master's of Innovation & Entrepreneurship
MCS Data Science
Master's in Computer Science
Master's in Public Health

Coursera

About
Leadership
Careers
Catalog
Certificates
MasterTrack™ Certificates
Degrees
For Enterprise
For Government
For Campus
Coronavirus Response

Community

Learners
Partners
Developers
Beta Testers
Translators
Blog
Tech Blog

More

Terms
Privacy
Help
Accessibility
Press
Contact
Directory
Affiliates

Get it on Google Play

© 2020 Coursera Inc. All rights reserved.