1
00:00:02,150 --> 00:00:03,250
Now that we know

2
00:00:03,250 --> 00:00:07,150
that we probably need a database for most websites,

3
00:00:07,150 --> 00:00:10,450
and now that we also got a quick introduction

4
00:00:10,450 --> 00:00:14,590
into NoSQL and SQL database systems,

5
00:00:14,590 --> 00:00:16,830
it's time to dig a bit deeper.

6
00:00:16,830 --> 00:00:18,420
In this course section,

7
00:00:18,420 --> 00:00:23,160
we are going to dive a bit deeper into SQL database systems,

8
00:00:23,160 --> 00:00:27,280
and you're going to get a more thorough introduction to SQL,

9
00:00:27,280 --> 00:00:29,820
this language and a database system

10
00:00:29,820 --> 00:00:32,310
that's based on that language.

11
00:00:32,310 --> 00:00:35,950
Now, I will say that this is just an introduction,

12
00:00:35,950 --> 00:00:39,220
you could create an entire course on just SQL,

13
00:00:39,220 --> 00:00:41,790
and indeed, that is also what we did.

14
00:00:41,790 --> 00:00:44,160
We do have a complete SQL course,

15
00:00:44,160 --> 00:00:47,280
which I strongly recommend if you wanna dive deeper,

16
00:00:47,280 --> 00:00:51,530
and if you wanna learn all about SQL and SQL databases.

17
00:00:51,530 --> 00:00:53,550
But in this course section,

18
00:00:53,550 --> 00:00:56,180
you're going to get started with SQL,

19
00:00:56,180 --> 00:00:58,940
and you're specifically going to learn

20
00:00:58,940 --> 00:01:02,920
how SQL databases are actually designed,

21
00:01:02,920 --> 00:01:05,370
how you can set up your own SQL database,

22
00:01:05,370 --> 00:01:08,580
and how you can work with that database,

23
00:01:08,580 --> 00:01:13,080
you will learn how you can create tables and schemas

24
00:01:13,080 --> 00:01:14,140
in that database

25
00:01:14,140 --> 00:01:16,440
and how you can structure your data,

26
00:01:16,440 --> 00:01:18,240
and of course, you're going to learn

27
00:01:18,240 --> 00:01:20,900
how to perform CRUD operations,

28
00:01:20,900 --> 00:01:24,510
create, read, update, delete operations,

29
00:01:24,510 --> 00:01:26,990
against your database and the tables there,

30
00:01:26,990 --> 00:01:29,660
and therefore, by the end of this course section,

31
00:01:29,660 --> 00:01:31,990
you will have a thorough understanding

32
00:01:31,990 --> 00:01:35,780
of how SQL database systems generally work

33
00:01:35,780 --> 00:01:38,210
and how you can work with them.

34
00:01:38,210 --> 00:01:40,930
Now, one important note though,

35
00:01:40,930 --> 00:01:45,390
this course section is actually optional.

36
00:01:45,390 --> 00:01:47,610
Actually, every web developer

37
00:01:47,610 --> 00:01:50,910
should know some SQL basics at least,

38
00:01:50,910 --> 00:01:53,060
the same as true for NoSQL,

39
00:01:53,060 --> 00:01:58,060
but in this course, after these SQL sections,

40
00:01:58,140 --> 00:02:01,890
so this course section and the next course section

41
00:02:01,890 --> 00:02:04,670
where we will connect our SQL knowledge

42
00:02:04,670 --> 00:02:06,630
with some backend code,

43
00:02:06,630 --> 00:02:10,169
we actually will continue with NoSQL databases

44
00:02:10,169 --> 00:02:13,220
in the other examples of this course.

45
00:02:13,220 --> 00:02:15,500
So if you just wanna finish the course

46
00:02:15,500 --> 00:02:17,390
and follow along with the course,

47
00:02:17,390 --> 00:02:19,640
you actually don't necessarily need

48
00:02:19,640 --> 00:02:22,530
to go through these SQL sections right now,

49
00:02:22,530 --> 00:02:26,400
but as a web developer in general, you absolutely should.

50
00:02:26,400 --> 00:02:27,840
But if you're in a hurry right now

51
00:02:27,840 --> 00:02:29,430
and you just wanna go through the course

52
00:02:29,430 --> 00:02:30,840
as quickly as possible,

53
00:02:30,840 --> 00:02:34,780
you could skip this and the next course section.

54
00:02:34,780 --> 00:02:36,010
But with that, of course,

55
00:02:36,010 --> 00:02:37,970
the recommendation is to not skip it,

56
00:02:37,970 --> 00:02:42,110
and instead, let's dive into SQL and explore how it works

57
00:02:42,110 --> 00:02:43,603
from the next lecture on.