1
00:00:00,230 --> 00:00:04,340
In this section, we're going to go over more of the SQL programming language.

2
00:00:04,340 --> 00:00:09,740
We're going to cover aggregate functions, join statements, and subqueries.

3
00:00:09,740 --> 00:00:16,370
Aggregate functions allow you to take multiple values in a set and resolve them to a single value,

4
00:00:16,370 --> 00:00:18,410
like a max or an average.

5
00:00:18,440 --> 00:00:24,830
Join statements take advantage of the relationships in a relational database and allow you to query

6
00:00:24,830 --> 00:00:27,410
multiple tables in a single query.

7
00:00:27,410 --> 00:00:36,080
Instance subqueries allow you to embed SQL statements within other SQL statements to further refine

8
00:00:36,080 --> 00:00:37,520
your query results.

9
00:00:37,520 --> 00:00:39,380
So let's get started.