Su base de datos de SQL en la nube

Loading...

来自 Google Cloud 的课程

Google Cloud Platform Big Data and Machine Learning Fundamentals en Español

84 个评分

Google Cloud

Google Cloud Platform Big Data and Machine Learning Fundamentals en Español

84 个评分

Este curso acelerado on demand de 1 semana de duración presenta a los participantes las funciones de macrodatos y aprendizaje automático de Google Cloud Platform (GCP). Ofrece una descripción general breve de Google Cloud Platform y profundiza en las funciones de procesamiento de datos. Al final del curso, los participantes podrán realizar lo siguiente: • Identificar el propósito y el valor de los productos clave de Google Cloud Platform relacionados con los macrodatos y el aprendizaje automático • Usar CloudSQL y Cloud Dataproc para migrar cargas de trabajo existentes de MySQL y Hadoop/Pig/Spark/Hive a Google Cloud Platform • Utilizar BigQuery y Cloud Datalab para realizar análisis interactivos de datos • Elegir entre Cloud SQL, BigTable y Datastore • Entrenar y usar una red neuronal mediante TensorFlow • Elegir entre diferentes productos de procesamiento de datos en Google Cloud Platform Para inscribirse en este curso, los participantes deben tener aproximadamente un (1) año de experiencia en uno o más de los siguientes: • Un lenguaje de consultas común, como SQL • Actividades de extracción, transformación y carga • Modelado de datos • Aprendizaje automático o estadísticas • Programación en Python Notas sobre la cuenta de Google: • Necesitará una cuenta de Google o de Gmail y una tarjeta de crédito o una cuenta bancaria para registrarse en la prueba gratuita de Google Cloud Platform (los servicios de Google no están disponibles en China en la actualidad). • Si es un cliente de Google Cloud Platform con una dirección de facturación de la Unión Europea (UE) o de Rusia, lea la información general sobre el IVA que se encuentra aquí: https://cloud.google.com/billing/docs/resources/vat-overview • Encontrará más Preguntas frecuentes sobre la prueba gratuita de Google Cloud Platform aquí: https://cloud.google.com/free/?hl=es-419 Looking for the English version of this course? Check out https://www.coursera.org/learn/gcp-big-data-ml-fundamentals/ このコースの日本語版をお探しですか？https://www.coursera.org/learn/gcp-big-data-ml-fundamentals-jp/

从本节课中

Módulo 3: Data Analysis on the Cloud

En este módulo, presentaremos los casos de uso más comunes de Big Data que Google administrará por usted. Se trata de las actividades que la industria lleva a cabo más a menudo en la actualidad y para las que ofrecemos una migración sencilla a la nube.

Su base de datos de SQL en la nube5:15

与讲师见面

Google Cloud Training

So let's start off by looking at how to do a relational database in the cloud.

Okay, so as we mentioned, the data that we have is relatively small,

a few hundred gigabytes maybe, maximum.

So that's the kind of thing that Cloud SQL handles perfectly well.

So we would use Cloud SQL.

The capacity of a gigabyte is fine for a relational offering.

You use it like a relational database.

You do selects, you do inserts.

You do updates, you use deletes.

And you can update an individual field.

So that's what Cloud SQL is.

Later on we'll look at other access patterns that you could use if you needed

to go at larger scale or

we want to basically deal with objects rather than relational data.

What if we need to deal with high throughput?

What if we need to deal with petabytes of data and

still get very quick, timely responses?

But right now based on our access pattern of relatively small data that

we want to use in a very familiar way, Cloud SQL is great service.

So Cloud SQL is essentially MySQL.

MySQL is an open source database and

Cloud SQL is Google-managed MySQL.

At this point you've got to be wondering,

wait a minute, in the last chapter we looked at Cloud Launcher.

And if I wanted to run WordPress on Google, I could just go to Cloud Launcher

and get a Compute Engine VM that's pre-installed with WordPress ready to go.

Why can't I do that with MySQL?

Why does Google have to manage MySQL?

Isn't it just getting a Compute Engine VM and installing MySQL on it?

Well, not quite.

By having Google Cloud manage MySQL, we get a few extra benefits.

First benefit, flexible pricing.

One of the things that you could do is to say, well, I have this database and

it's going to be used only between 9 and 5.

So between 5 and 9 just passivate the database.

And then so you don't have to pay for it when it's passivated, so that's great.

So and that's something that you can just have Cloud SQL do for you.

You don't have to write any extra infrastructure handling to passivate

the database when you're not using it.

So this is particularly useful for things like tester databases.

A database that needs to be run only when a unit test is running.

If a unit test isn't running, we don't need the database,

we don't have to use it.

Second advantage, it's familiar.

It's MySQL and so every workload that you have that uses MySQL,

it's a prime candidate to run on Cloud SQL.

But we're talking about the advantages that running it on

Google can give your relational database workloads.

So first of all, is that flexible pricing.

You don't have to pay for a machine if you aren't using it.

And this is particularly useful for machines that aren't used 24/7.

Secondly, Google manages the backups so you can just go to Cloud SQL and

say I would like you to back up this database every Thursday at 2:00 AM and

it will happen.

Thirdly, you can connect to it from anywhere.

It's on the Cloud so

you don't have to worry about your company firewalls and things like that.

You have a database that needs to be connectable from anywhere.

This is a good solution for it.

You get automatic replication if you need to.

You also get very fast connections from GCE,

Google Compute Engine, and GAE, Google App Engine.

Why is that?

Well, because Cloud SQL is on a machine that lives in Google Cloud,

and all these things are also in Google Cloud.

So as long as you're running these apps in the same region,

they get to take advantage of Google's petabit per

second interconnect networking.

And that by section bandwidth off 1 petabit per second.

So that's extremely, extremely fast.

And so you get really fast connections between MySQL and

other applications that are running on Google Cloud.

And finally, not the least, is this idea

that you have Google Security taking care of your instances.

So you're not at the mercy of a randomly rotating set of security people.

You basically have it being secured by people who do it

as their job day in and day out.

探索我们的目录

免费加入并获得个性化推荐、更新和优惠。

Coursera 致力于普及全世界最好的教育，它与全球一流大学和机构合作提供在线课程。

© 2018 Coursera Inc. 保留所有权利。

通过 App Store 下载

通过 Google Play 获取