Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Learn Operations with Database Instance | RDS Management
Introduction to Cloud Computing
course content

Course Content

Introduction to Cloud Computing

Introduction to Cloud Computing

1. Introduction to Cloud Technologies
2. AWS S3 Overview
3. EC2 Overview
4. RDS Management

book
Operations with Database Instance

I'll show you that even the simplest SQL commands work perfectly fine with a cloud database. For example, let's create two tables to store user phone numbers and another table to 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:

Now, use the following SQL queries to create the required tables.

To create the user_phones table:

To create the product_descriptions table:

Also, let's insert some random data into these tables so they aren't empty.

user_phones:

product_descriptions:

So, we've created a database and two tables in our cloud database. Now, anyone can connect to this database and retrieve the necessary data, insert new data, and so on.

Let's verify if everything was done correctly and fetch all the information from the user_phones and product_descriptions tables:

And the second one:

We created the required database and also created and populated two tables within this database. We did this 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.

Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 4. Chapter 4
We're sorry to hear that something went wrong. What happened?
some-alt