Click here to navigate the course.

Drag the edges to resize the window.

In Projects, you can keep track of your progress as you go throught the tasks. Check each item as you complete it!

Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.

Relational Databases

SELECT * FROM celebs;

Nice work. In one line of code, you returned information from a relational database. We'll take a look at what this code means soon, for now let's focus on what relational databases are and how they are organized.

1. A relational database is a database that organizes information into one or more tables. Here the relational database contains one table.
2. A table is a collection of data organized into rows and columns. Tables are sometimes referred to as relations. Here the table is celebs.
3. A column is a set of data values of a particular type. Here id, name, and age are each columns.
4. A row is a single record in a table. The first row in the celebs table has:

  • An id of 1
  • A name of Justin Bieber
  • An age of 22

All data stored in a relational database is of a certain data type. Some of the most common data types are:

1. Integer, a positive or negative whole number
2. Text, a text string
3. Date, the date formatted as YYYY-MM-DD for the year, month, and day
4. Real, a decimal value


Now that you have an understanding of what relational databases are, let's take a closer look at SQL syntax.

Click Next to Continue.

Report a Bug
If you see a bug or any other issue with this page, please report it here.