1
00:00:02,160 --> 00:00:04,327
It's good that we learned about SQL

2
00:00:04,327 --> 00:00:07,090
and MySQL, specifically in the theory,

3
00:00:07,090 --> 00:00:09,530
and that we had a thorough look at how it works

4
00:00:09,530 --> 00:00:12,880
and how the query language looks like and is used,

5
00:00:12,880 --> 00:00:15,420
but of course, this is a course that wants

6
00:00:15,420 --> 00:00:17,870
to turn you into a web developer.

7
00:00:17,870 --> 00:00:20,430
Therefore you need to be able to apply

8
00:00:20,430 --> 00:00:24,250
what you learned about SQL in a website

9
00:00:24,250 --> 00:00:25,280
that you are building.

10
00:00:25,280 --> 00:00:29,080
So on the backend into NodeJS code of a website,

11
00:00:29,080 --> 00:00:31,300
you are building, for example.

12
00:00:31,300 --> 00:00:35,310
And therefore in this course section, we're going to explore

13
00:00:35,310 --> 00:00:39,010
how you can use your newly gained SQL knowledge

14
00:00:39,010 --> 00:00:42,710
and run those SQL query commands

15
00:00:42,710 --> 00:00:46,130
from inside your website backend code.

16
00:00:46,130 --> 00:00:47,980
So that you can build a website

17
00:00:47,980 --> 00:00:50,650
that interacts with a database.

18
00:00:50,650 --> 00:00:53,030
And for that in this course section,

19
00:00:53,030 --> 00:00:57,160
we're going to build a demo project, a little blog,

20
00:00:57,160 --> 00:01:00,880
and you're going to learn how you can connect

21
00:01:00,880 --> 00:01:04,530
to databases from inside your code

22
00:01:04,530 --> 00:01:09,310
so that you don't rely on MySQL workbench only,

23
00:01:09,310 --> 00:01:13,290
but that instead you can run queries from inside your code,

24
00:01:13,290 --> 00:01:16,450
which of course is what you need to do in order to interact

25
00:01:16,450 --> 00:01:19,860
with a database from inside your code.

26
00:01:19,860 --> 00:01:21,570
And we will have a look at

27
00:01:21,570 --> 00:01:26,270
how we can perform CRUD operations from inside our code.

28
00:01:26,270 --> 00:01:28,680
So how we can create, read, update,

29
00:01:28,680 --> 00:01:32,580
and delete items from a database.

30
00:01:32,580 --> 00:01:35,400
And last but not least in this course section,

31
00:01:35,400 --> 00:01:37,610
we are, of course, also going to see

32
00:01:37,610 --> 00:01:40,390
how we can fetch data from a database

33
00:01:40,390 --> 00:01:43,950
and then output that data in our templates.

34
00:01:43,950 --> 00:01:47,763
So how we can bring it onto the screen of our visitors.