1
00:00:00,360 --> 00:00:03,640
In the previous videos,
we've used a library database and

2
00:00:03,640 --> 00:00:06,190
selected all information from a table.

3
00:00:06,190 --> 00:00:08,750
We've used specific
column names to sort and

4
00:00:08,750 --> 00:00:11,670
limit the columns of
information we want back.

5
00:00:11,670 --> 00:00:15,690
We've also used the AS keyword
to alias column names.

6
00:00:15,690 --> 00:00:18,700
These are all important tools
that you can use to retrieve

7
00:00:18,700 --> 00:00:23,390
results from a database to show
to users and generate reports.

8
00:00:23,390 --> 00:00:24,996
Here's something you might not know.

9
00:00:24,996 --> 00:00:28,540
You see all these keywords select,
as, and from?

10
00:00:28,540 --> 00:00:31,470
They can be all used in lowercase.

11
00:00:31,470 --> 00:00:35,440
Running this query has the same results,
but people use

12
00:00:35,440 --> 00:00:39,850
uppercase keywords to help you distinguish
the different parts of the query.

13
00:00:39,850 --> 00:00:45,750
The uppercase keywords make SQL more
readable and is an industry best practice.

14
00:00:45,750 --> 00:00:46,605
Let's switch it back.

15
00:00:46,605 --> 00:00:50,085
[SOUND] That's better.

16
00:00:50,085 --> 00:00:52,767
Now that we've reviewed
what we've learned so far,

17
00:00:52,767 --> 00:00:55,290
let's jump into a practice session.

18
00:00:55,290 --> 00:00:58,184
Launch the SQL Playground
associated with this video and

19
00:00:58,184 --> 00:01:00,730
we'll take a look at what we have here.

20
00:01:00,730 --> 00:01:04,140
This is a new database with new tables.

21
00:01:04,140 --> 00:01:08,530
Take a look at the database
schema section, and

22
00:01:08,530 --> 00:01:10,370
we have a couple of tables here.

23
00:01:10,370 --> 00:01:14,750
We have an actors table,
a movies table, and a reviews table.

24
00:01:14,750 --> 00:01:18,170
And we have the columns for
each of these tables.

25
00:01:18,170 --> 00:01:22,810
In each of these coding areas here,
there's a task for you to perform and

26
00:01:22,810 --> 00:01:24,140
practice what you've learned.

27
00:01:25,160 --> 00:01:29,250
These lines starting with
the double dash are comments.

28
00:01:29,250 --> 00:01:31,570
These don't get executed.

29
00:01:31,570 --> 00:01:36,310
Comments are used for
helping people document their SQL queries.

30
00:01:36,310 --> 00:01:41,200
In this case, I've left questions for
you to answer in SQL code.

31
00:01:41,200 --> 00:01:44,280
Once you're comfortable with
the basics of selecting,

32
00:01:44,280 --> 00:01:47,000
you can move on to the next
step in the course.

33
00:01:47,000 --> 00:01:50,160
If you're feeling rusty, you can
always come back again and practice.