AWS reStart 269-[DF]-Lab - Insert, Update, and Delete Data in a Database & Lab 270 - Anand K

269-DF-Lab - Insert, Update, and Delete Data in a Database

Scenario
The database operations team has created a relational database called world containing three tables: city, country, and country language. You have to validate the configuration of the database by running INSERT, UPDATE, and DELETE statements on the country table.

Lab overview and objectives
This lab demonstrates how to insert, update, delete, and import rows of data using structured query language (SQL).

After completing this lab, you will be able to:

Insert rows into a table
Update rows in a table
Delete rows from a table
Import rows from a database backup file

270-DF-Lab - Selecting Data from a Database
Selecting Data from a Database

Scenario
The database operations team has created a relational database named world containing three tables: city, country, and country language. Based on specific use cases defined in the lab exercise, your write a few queries using database operators and the SELECT statement.

Lab overview and objectives
This lab demonstrates how to use some common database operators and the SELECT statement.

After completing this lab, you should be able to:

Use the SELECT statement to query a database

Use the COUNT() function

Use the following operators to query a database:

=
WHERE
ORDER BY
AND