Conteúdo do Curso
Introdução à Computação em Nuvem
Introdução à Computação em Nuvem
Operações com Instância de Banco de Dados
This will be a short chapter where I'll show you that even the simplest SQL commands work perfectly fine with a cloud database. Let's, for example, create two tables that will store user phone numbers and a table that will store descriptions of various products.
To do this, open our MySQL Workbench, connect to our cloud database, and create a database for our tutorial:
Here’s the command to create a database:
Para criar a tabela product_descriptions
:
Além disso, vamos inserir alguns dados aleatórios nessas tabelas para que não fiquem vazias.
user_phones
:
product_descriptions
:
Thus, we've created a database and two tables in our cloud database. Now, anyone can connect to this database and retrieve the necessary data, or insert new data, and so on.
Let's check if everything is done correctly and retrieve all the information from the user_phones
and product_descriptions
tables:
Thus, we've created a database and two tables in our cloud database. Now, anyone can connect to this database and retrieve the necessary data, or insert new data, and so on.
Let's check if everything is done correctly and retrieve all the information from the user_phones
and product_descriptions
tables:
Thus, we've created a database and two tables in our cloud database. Now, anyone can connect to this database and retrieve the necessary data, or insert new data, and so on.
Let's check if everything is done correctly and retrieve all the information from the user_phones
and product_descriptions
tables:
And the second one:
We created the necessary database and also created and populated two tables in this database. We did this in order to connect to these databases from our EC2 instance in the next chapter, see that the data is stored in the cloud, and retrieve this data from the EC2 instance.
Obrigado pelo seu feedback!