1
00:00:06,600 --> 00:00:09,240
- Hello again and welcome to Lesson 17.

2
00:00:09,240 --> 00:00:11,850
This is the final lesson in the course,

3
00:00:11,850 --> 00:00:14,130
and we're going to see how
to implement an application

4
00:00:14,130 --> 00:00:16,320
to access a relational database

5
00:00:16,320 --> 00:00:19,290
which is quite a nice
way to wrap things up.

6
00:00:19,290 --> 00:00:22,200
The database we're
going to access is MySQL

7
00:00:22,200 --> 00:00:24,180
and in case you don't have MySQL installed

8
00:00:24,180 --> 00:00:25,590
in your system already,

9
00:00:25,590 --> 00:00:28,713
I'm going to show how to run
MySQL in a Docker container.

10
00:00:30,060 --> 00:00:32,790
Once we've got the
Docker container running,

11
00:00:32,790 --> 00:00:36,120
we'll dive into the coding
details in the application.

12
00:00:36,120 --> 00:00:39,090
We'll review the overall
application structure first

13
00:00:39,090 --> 00:00:41,520
and then we'll see how
to connect the database,

14
00:00:41,520 --> 00:00:44,640
execute a simple SQL statement,

15
00:00:44,640 --> 00:00:47,160
execute the parametrized SQL statement,

16
00:00:47,160 --> 00:00:51,420
and then finally execute
the query to select data.

17
00:00:51,420 --> 00:00:54,930
To wrap up, we'll stop the MySQL container

18
00:00:54,930 --> 00:00:57,270
and remove the Docker
image from our system

19
00:00:57,270 --> 00:01:00,273
to return our system to its
original pristine condition.