Introduction to SQL and Querying Datacamp

Here are two versions of a tablet taken from a database. Which tablet uses the correct naming format?

2

Which of the below scenarios describes a situation in which using SQL would be useful?

Large amounts of data about many different but related areas of a business are housed in a relational database

Now that you know more about how data is stored, it's time to test those skills! Select the statement about database storage that is false:

Servers are usually personal computers such as laptops

Understanding the organization of a database is an important first step when using SQL. Take a look at the database below. Which of the following statements correctly describes its organization?

This is a relational database containing three tables: employees, job_levels, and departments

Imagine that you are starting a new job and have just started getting to know your new employer's database. You know that it's important to know the data type-- such as VARCHAR, INT, or NUMERIC-- corresponding to each field in a table. Where could you find this information?

You can find this information by looking at a database schema

A unique identifier is a value that distinguishes a record from others in the same table. In the employees table, which fields do you believe is the most suitable choice for a unique identifier?

id