In the previous videos, we've used a library database and

selected all information from a table.

We've used specific column names to sort and

limit the columns of information we want back.

We've also used the AS keyword to alias column names.

These are all important tools that you can use to retrieve

results from a database to show to users and generate reports.

Here's something you might not know.

You see all these keywords select, as, and from?

They can be all used in lowercase.

Running this query has the same results, but people use

uppercase keywords to help you distinguish the different paths of the query.

The uppercase keywords make SQL more readable and is an industry best practice.

Let's switch it back.

[SOUND] That's better.

Now that we've reviewed what we've learned so far,

let's jump into a practice session.

Launch the SQL Playground associated with this video and

we'll take a look at what we have here.

This is a new database with new tables.

Take a look at the database schema section, and

we have a couple of tables here.

We have an actor's table, a movies table, and a reviews table.

And we have the columns for each of these tables.

In each of these coding areas here, there's a task for you to perform and

practice what you've learned.

These lines starting with the double dash are comments.

These don't get executed.

Comments are used for helping people document their SQL queries.

In this case, I've left questions for you to answer in SQL code.

Once you're comfortable with the basics of selecting,

you can move on to the next step in the course.

If you're feeling rusty, you can always come back again and practice.