- Tools We'll be Using 3:57
- Your First SQL Statement 4:01
- Selecting All Information From a Table 5 objectives
- Retrieving Specific Columns of Information 2:53
- Retrieving Specific Columns of Information 5 objectives
- Categorizing Your Output with 'AS' 4:33
- Categorizing Your Output with 'AS' 4 objectives
- Review & Practice with SQL Playgrounds 1:50
- Getting Data From a Database Review 8 questions
Preview
Video Player
00:00
00:00
Review & Practice with SQL Playgrounds
1:50In this video, we'll review some of the concepts that we've covered in this stage and cover what you'll need to do to succeed in your practice session.
In the previous videos,
we've used a library database and
0:00
selected all information from a table.
0:03
We've used specific
column names to sort and
0:06
limit the columns of
information we want back.
0:08
We've also used the AS keyword
to alias column names.
0:11
These are all important tools
that you can use to retrieve
0:15
results from a database to show
to users and generate reports.
0:18
Here's something you might not know.
0:23
You see all these keywords select,
as, and from?
0:24
They can be all used in lowercase.
0:28
Running this query has the same results,
but people use
0:31
uppercase keywords to help you distinguish
the different parts of the query.
0:35
The uppercase keywords make SQL more
readable and is an industry best practice.
0:39
Let's switch it back.
0:45
[SOUND] That's better.
0:46
Now that we've reviewed
what we've learned so far,
0:50
let's jump into a practice session.
0:52
Launch the SQL Playground
associated with this video and
0:55
we'll take a look at what we have here.
0:58
This is a new database with new tables.
1:00
Take a look at the database
schema section, and
1:04
we have a couple of tables here.
1:08
We have an actors table,
a movies table, and a reviews table.
1:10
And we have the columns for
each of these tables.
1:14
In each of these coding areas here,
there's a task for you to perform and
1:18
practice what you've learned.
1:22
These lines starting with
the double dash are comments.
1:25
These don't get executed.
1:29
Comments are used for
helping people document their SQL queries.
1:31
In this case, I've left questions for
you to answer in SQL code.
1:36
Once you're comfortable with
the basics of selecting,
1:41
you can move on to the next
step in the course.
1:44
If you're feeling rusty, you can
always come back again and practice.
1:47