Quantcast

Start with 7 free days of training.

Gain instant access to our entire IT training library, free for your first week.
Train anytime on your desktop, tablet, or mobile devices.

The exam associated with this course was retired December 31, 2016. However, this course still retains value as a training resource....
The exam associated with this course was retired December 31, 2016. However, this course still retains value as a training resource.

Let Google know what you think of our training course with this survey.

This Google Cloud SQL course with Ben Finkel covers the exam objectives for the Google Qualified Cloud SQL Developer certification, and gets you up to speed on the Google Cloud Platform's super simple and easy-to-use RDBMS solution. CBT Nuggets is a Google Cloud Platform - Training Partner.

Recommended skills:
    Fundamental SQL skills Fundamental Java and/or Python programming skills

Recommended equipment:
    A machine running Windows, OSX, or Linux

Related certifications:
    Google Qualified Cloud SQL Developer

Related job functions:
    SQL Developer DevOps Cloud computing Data wizardry

Google's Cloud SQL product offers a fast and easy way to get an RDBMS spun up in the cloud. Based on the widely-popular MySQL technology, Cloud SQL allows developers and DBAs to quickly provision and manage instances of MySQL for all their database needs. Google's fully-managed back-end provides the security and disaster recovery features that today's data installations require. Google Qualified Developer is a new breed of developer-centric certifications for Google Cloud Platform products.

This course is for Google Cloud SQL and designed from Google's internal instructor-led course to prepare you for the exam. It's ideal for beginner or advanced IT professionals looking to add cloud-based RDBMS and MySQL skills and Google certified credentials to their resume.
 show less
1. What Is Google Cloud SQL? (7 min)
2. Getting Started with Google Cloud SQL (9 min)
3. Demo: Getting Started with GSQL (15 min)
4. Google Cloud SQL Instances (11 min)
5. Demo: Cloud SQL Instances (15 min)
6. Demo: Cloud SQL Instances Advanced (10 min)
7. Access and Authorization (7 min)
8. Demo: Access and Authorization (9 min)
9. Exporting and Importing Data (9 min)
10. Demo: Exporting and Importing Data (11 min)
11. Read Replication (8 min)
12. Demo: Read Replication (6 min)
13. Demo: Using MySQL Tools (6 min)
14. Demo: Using Python with Google Cloud SQL (9 min)
15. Demo: Using the REST API (12 min)
16. Demo: Using the Client Library (10 min)
17. Google Cloud Platform Qualified Developer (9 min)

What Is Google Cloud SQL?

00:00:00

What is Google Cloud SQL? Hello everybody. This is Ben Finkel. And in this Nugget, I'd like to take just a few moments to talk about what Google Cloud SQL is at a very high level-- what sort of features and functions it offers, what problems it attempts to solve, and why would you, as a DBA or programmer, want to use this product inside of the Google Cloud Platform suite.

00:00:21

So what is Google Cloud SQL? Well, at a very high 50,000 foot level, Google Cloud SQL is a part of the Google Cloud Platform suite of products. They call that GCP. And GCP exposes a ton of different software solutions that attempt to solve a lot of different problems in the Cloud computing space.

00:00:40

Google, themselves, lumps these products together in sort of large, loose, functional groups depending on the type of product they are. So they have a suite of products they consider the compute products. And this is things like Compute Engine, and App Engine, and Container Engine.

00:00:54

They also have a suite of services they expose, APIs, that you can relate to our call from your products. And these are inside of the Cloud. They are Google Pub/Sub, translate, prediction APIs-- a whole bunch more of the services. This is just a few of them.

00:01:07

They've got a big data solution, Google BigQuery. And that's used for analyzing huge amounts of data. And then, they have a suite of products that they refer to collectively as the storage products. And those are things like the Google Cloud Storage, the data store, and the one that we're interested in, Google Cloud SQL.

00:01:28

Google Cloud SQL, inside of this entire suite of products, is nothing more than MySQL instances on the Google Cloud Platform. So they've exposed a way to create virtual MySQL databases, relational databases, inside of the Google Cloud Platform. This is when you need a relational database inside of your Cloud Platform solution.

00:01:51

Google Cloud SQL is there for you. It's got your back. Google Cloud SQL is based on, of course, the SQL language. It's got a nice, familiar infrastructure, and it's MySQL. You've probably worked with MySQL before if you've worked in any relational database systems.

00:02:04

It's got a very flexible and low cost pricing mechanism. Through the Google Cloud Platform, you get security availability and durability on your MySQL instances and your Google Cloud SQL instances. You've also got easy migration, and you're not locked into the technology.

00:02:20

Databases can be backed up and restored, both within the platform, as well as outside of the platform. So you can get things onto MySQL easily. You can get them back out of MySQL easily. You've got a lot of control over your MySQL instances. You could log in through the GUI console or through the command line interface and manage your instances with a fair amount of control, which any DBA is going to need.

00:02:41

But this last point seems almost contradictory to the point I just made. They're also fully managed. You don't have to worry about things like replications, and backups, and disaster recovery. Google handles all that for you. Because it's on the Google Cloud Platform, they've got your bases covered.

00:02:58

Now there's lots of database options out there. Why would you want to choose MySQL? Well, here are a couple of good reasons. First of all, SQL, of course, is what MySQL is based on. And SQL is sort of the gold standard when it comes to querying languages for databases.

00:03:12

Why is that? Well, SQL is super easy to learn. It's powerful. There's an incredibly wide and vast knowledge base out there regarding SQL. And it's time tested. It's been around since maybe the late '70s. So using a SQL power database just makes a lot of sense.

00:03:29

When it comes RDBMSs, they're pretty much all SQL based. And you're going to want a good SQL database in order to be your RDBMS for whatever particular solution you might be implementing. The other reason to use MySQL is because it's the world's most popular open source SQL database.

00:03:47

MySQL is a big deal. And, like I said a moment ago, you've probably worked in it before. And even if you haven't, you're going to find yourself very familiar with MySQL. It is so popular. It's so easy to use, and there's a ton of different third party libraries, connectivity tools-- all sorts of different things you can do with it.

00:04:05

It also means that your migration paths here are going to be really easy and open. You can work in a development environment on your local machine running MySQL, and very quickly and easily migrate it up to a production MySQL database. So you're going to find a lot of benefit to working with the MySQL database standard inside of Google Cloud SQL.

00:04:23

Some of the key features of Google Cloud SQL-- we talked about them briefly few minutes ago, but just to highlight some of the important ones, it uses the open MySQL 5.5 standard. That means that you are going to be instantly familiar with and comfortable with working on Google Cloud SQL.

00:04:39

Nothing's going to seem unusual. You're going to be able use MySQL connectivity tools locally in your desktop to connect up to your remote cloud based Google Cloud SQL instances. You're going to be able to use libraries inside of Python, or Java, or C, or .NET, or whatever programing language you're working in.

00:04:53

In order to connect to your Google Cloud SQL instances, you're just going to use the MySQL wire protocol. Everything about the Google Cloud SQL standard is open and available for you to use. You also get to rely on what we'll call Google level security.

00:05:09

And it's important to remember that all of this is running inside of Google's data centers on Google's networks and on their infrastructure. You are getting 100% of the security that you would get from anything inside of Google on your Cloud SQL instances.

00:05:24

They're isolated. Data is encrypted. When it's written to the disks, you don't have to worry about that. All of your information is highly secure inside of the Google network, and you can rely on Google's proven track record for the security of your systems and of your databases.

00:05:41

Now it's also going to be very accessible. There's going to be a web client that you can use in order to administer your instances, administer your databases, and set your backups, your restores, your replication rules, all sorts of interesting stuff, including really outlandish things like we'll talk about a second, where you integrate with other Cloud platform products.

00:05:59

There's also a command line utility that you can use to connect up and run your MySQL tools, as well as a variety of third party desktop applications that you may or may not be familiar with. But, you know what, there's a lot of them out there. Lastly, the fourth key feature we want to talk about, is its integration with the Google Cloud Platform in general.

00:06:19

You're probably not just running a database on its own. Google Cloud SQL integrates easily with many of the products that are already in the Google Cloud Platform, itself. So you can have your Cloud SQL instance actually follow along from region to region or zone to zone with a Google App Engine instance, as those things migrate through zones.

00:06:39

Same thing with Google Compute Engine, you can attach or SQL instances to your Compute Engine instances and make sure that there's always low latency, high availability connection between your database in your application front end. Plus, you can work with all the different storage options out there-- Container Engine, et cetera, to get data in and out of MySQL or Google Cloud SQL, and making sure that you always have a really good, tight, close knit integration with all the products inside of the Google Cloud Platform.

00:07:07

That concludes this Nugget on what is Google Cloud SQL. We covered briefly what Google Cloud SQL is, how it's part of the Google Cloud Platform. One of the storage options that they offer-- specifically, it's the RDBMS storage option. And it basically boils down to virtual SQL instances available inside of the Cloud.

00:07:24

We looked at some of the features and functionality and talked about how Google Cloud SQL interrelates with all of the GCP products. I hope this has been informative for you, and I'd like to thank you for viewing.

Getting Started with Google Cloud SQL

Demo: Getting Started with GSQL

Google Cloud SQL Instances

Demo: Cloud SQL Instances

Demo: Cloud SQL Instances Advanced

Access and Authorization

Demo: Access and Authorization

Exporting and Importing Data

Demo: Exporting and Importing Data

Read Replication

Demo: Read Replication

Demo: Using MySQL Tools

Demo: Using Python with Google Cloud SQL

Demo: Using the REST API

Demo: Using the Client Library

Google Cloud Platform Qualified Developer

Please help us improve by sharing your feedback on training courses and videos. For customer service questions, please contact our support team. The views expressed in comments reflect those of the author and not of CBT Nuggets. We reserve the right to remove comments that do not adhere to our community standards.

comments powered by Disqus
Intermediate 3 hrs 17 videos

COURSE RATING

Training Features


Practice Exams
These practice tests help you review your knowledge and prepare you for exams.

Virtual Lab
Use a virtual environment to reinforce what you are learning and get hands-on experience.

Offline Training
Our iOS and Android mobile apps offer the ability to download videos and train anytime, anywhere offline.

Accountability Coaching
Develop and maintain a study plan with one-to-one assistance from coaches.

Supplemental Files
Files/materials that supplement the video training.

Speed Control
Play videos at a faster or slower pace.

Bookmarks
Included in this course
Pick up where you left off watching a video.

Notes
Included in this course
Jot down information to refer back to at a later time.

Closed Captions
Follow what the trainers are saying with ease.
Ben Finkel
Nugget trainer since 2014